Query Performance Investigation - Query ID 7446962358028474195 (project_mirror_data update)
Description
This query is frequently reported as top 15 in total time taken during the monitoring period. The queries were taken from this report https://gitlab.com/gitlab-com/gl-infra/infrastructure/-/snippets/2090600#postgres-checkup_K003
UPDATE "project_mirror_data"
SET "status" = $1, "last_update_scheduled_at" = $2
WHERE "project_mirror_data"."id" = $3
Frequency report https://log.gprd.gitlab.net/goto/3f4e18b4ac7b682c7bd55abae3efca42
Related issue gitlab-com/gl-infra/production#4016 (comment 533082530)
Edited by Fabien Catteau