Foreign keys for ci_pipelines are not indexed on PostgreSQL
For example, when running this query:
DELETE FROM "ci_pipelines" WHERE "ci_pipelines"."id" = ? AND "ci_pipelines"."lock_version" IS NULL
We need to verify foreign keys when removing data, this leads to PostgreSQL performing a sequence scan on related rows to validate this. On average this takes around 5 seconds, sometimes much longer. To work around this we need to index the following columns:
ci_pipelines.auto_canceled_by_id
ci_builds.auto_canceled_by_id