Add index to ci_trigger_requests for commit_id
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
Activity
Filter activity
Please register or sign in to reply