> Code change related to creating partial indexes targeted to improve this query: gitlab-org/gitlab!60942 (merged) This is a band-aid solution until we break apart pending/running job information into a table separate from ci_builds.

Damn, it seems a few of their (outages|degradation) centers around poor index management. I would think PG has better tooling to support surfacing that silliness, but I freely admit I'm not a DBA

Good timing, the pipelines seem to recover in this moment: https://gitlab.com/gitlab-com/gl-infra/production/-/issues/4...