This adds specific indexes to speed up the query mentioned in
https://gitlab.com/gitlab-org/gitlab-ce/issues/50763 and to avoid
statement timeouts.

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/50763.