ci_builds.user_id is used for filtering but is not indexed
For example:
UPDATE "ci_builds" SET "user_id" = ? WHERE "ci_builds"."type" IN (?) AND "ci_builds"."user_id" = ?
Here ci_builds.user_id
is used for filtering, but this column is not indexed. This can lead to this query taking a long time to complete.