Query Performance Investigation - Query ID 7164302182213446947 (ci_builds update)
Description
This query is frequently reported as top 10 in total time taken during the monitoring period.
UPDATE "ci_builds" SET "runner_id" = $1, "status" = $2, "started_at" = $3, "processed" = $4, "updated_at" = $5, "lock_version" = $6
WHERE "ci_builds"."id" = $7 AND "ci_builds"."lock_version" = $8
--application:web,correlation_id:01EW6S3VZ2BA0M8EMEQTD0VARM/
The above query didn't yield results in elastic however this similar query did.
UPDATE "ci_builds"
SET "status" = $1, "finished_at" = $2, "processed" = $3, "updated_at" = $4, "lock_version" = $5
WHERE "ci_builds"."id" = $6
AND "ci_builds"."lock_version" = $7
https://log.gprd.gitlab.net/goto/46a22b3e3242c85341e9c638be37d909
https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/issues/12687
Edited by Craig Gomes