Skip to content
Snippets Groups Projects

Add index to ci_trigger_requests for commit_id

Merged 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

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
  • Loading
Please register or sign in to reply
Loading