Create index on vulnerability_occurrence_pipelines to speed up Vulnerability Report
Why are we doing this work
When triaging gitlab-com/gl-infra/production#5744 (closed) the Database Team suggested introducing an index on vulnerability_occurrence_pipelines
to speed up one particular query.
This should speed up one of the involved queries significantly.
Implementation plan
-
database Create a post-deployment migration that adds (occurrence_id, id DESC)
index onvulnerability_occurrence_pipelines
Edited by Michał Zając