Query Performance Investigation - Query ID 3702556811119412000 (approver_groups and namespaces tables)
Description
This query is listed as a top 50 queries by total time over a 30 minute monitoring period in this report https://console.postgres.ai/gitlab/gitlab_production/reports/425/files/113266/md#postgres-checkup_K003
SELECT "approver_groups".*
FROM
"approver_groups" INNER JOIN "namespaces"
ON "namespaces"."id" = "approver_groups"."group_id"
AND "namespaces"."type" = $1
WHERE
"approver_groups"."target_id" =
$2 AND "approver_groups"."target_type"
= $3 AND "namespaces"."type" =
$4 AND ("namespaces"."visibility_level"
IN ($5, $6) OR EXISTS ( SELECT $7
FROM (SELECT "namespaces".*
FROM
((WITH "direct_groups" AS (SELECT
"namespaces".* FROM ((SELECT "namespaces".*
FROM "namespaces" INNER JOIN "members"
ON "namespaces"."id" = "members"."source_id"
WHERE "members"."type" = $8 AND
"members"."source_type" = $9 AND
"namespaces"."type" = $10 AND "members"."user_id"
= $11 AND "members"."requested_at"
IS NULL AND (access_level >= $12))
UNION
(
SELECT namespaces.*
FROM "projects"
INNER JOIN "project_authorizations"
ON "projects"."id" = "project_authorizations"."project_id"
INNER JOIN "namespaces"
endpoint_id:/api/:version/projects/:id/approvers
Data points
Calls
- "4,219
- 2.22/sec
- 1.00/call
- 0.06%"
Total Time
- 84,424.34 ms
- 44.448 ms/sec
- 20.011 ms/call
- 4.36%