Query Performance Investigation - SELECT $1 AS one FROM "container_repositories" WHERE "container_repositories"."project_id" = $2 AND "container_repositories"."name" = $3 LIMIT $4
Description
As the name implies, the purpose of the template is to detail underperforming queries for further investigation.
immediate attention cc @gitlab-org/database-team
and reach out in the #g_database slack channel
SQL Statement
SELECT $1 AS one FROM "container_repositories"
WHERE "container_repositories"."project_id" = $2
AND "container_repositories"."name" = $3 LIMIT $4
Requested Data points
Please provide as many of these fields as possible when submitting a query performance report.
- Queries per observation period - 308
- Query ID - -1076156467362618095
This query comes up frequently as a top statement by total calls during Database performance peak observation periods. https://gitlab.com/search?group_id=1112072&project_id=1304532&repository_ref=&scope=notes&search=1076156467362618095&snippets=false