Inverse pipeline for its build associations (!37478) · Merge requests · GitLab.org / GitLab · GitLab

Igor Drozdov requested to merge id-inverse-pipeline-build into master Jul 21, 2020

What does this MR do?

We have multiple N+1s on https://gitlab.com/gitlab-org/gitlab/-/pipelines. In order to verify that we have this problem

Visit https://gitlab.com/gitlab-org/gitlab/-/pipelines
Open Performance bar (type pb)
Open the list of SQL requests
Cmd + F in order to open browser's search bar
Search for SELECT "ci_pipelines

This current merge requests inverses pipeline for its build associations, so when a build calls .pipeline it doesn't perform an SQL request.

Other N+1s are going to be fixed in separate merge requests.