Skip to content

Add index to ci_trigger_requests for commit_id

Stan Hu requested to merge sh-add-index-to-ci-trigger-requests into master

https://gitlab.com/gitlab-org/gitlab-ce/pipelines.json makes a number of unindexed slow queries. This index should speed things up.

For example:

Ci::TriggerRequest Exists (48.1ms)  SELECT  1 AS one FROM "ci_trigger_requests" WHERE "ci_trigger_requests"."commit_id" = $1 LIMIT 1  [["commit_id", 6382637]]

Merge request reports