Include other columns in index for pending builds
What does this MR do?
Follow-up with #327142 (comment 567707927) - we extend the existing partial index to also include id, project_id
information. The intent is to turn this into an index-only scan whenever possible, so we would reduce the amount of data read from the heap. This still has to check visibility, which can still be a problem.
- Before (prod): https://explain.depesz.com/s/odKD
- After (dblab using hypopg): https://explain.depesz.com/s/ahr8
For the query, see #327142 (closed).
Does this MR meet the acceptance criteria?
Conformity
-
📋 Does this MR need a changelog?-
I have included a changelog entry. -
I have not included a changelog entry because _____.
-
-
Documentation (if required) -
Code review guidelines -
Merge request performance guidelines -
Style guides -
Database guides -
Separation of EE specific content
Edited by Andreas Brandl