Skip to content

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

image

Frequency report https://log.gprd.gitlab.net/goto/3f4e18b4ac7b682c7bd55abae3efca42

Related issue gitlab-com/gl-infra/production#4016 (comment 533082530)

Edited by Fabien Catteau