Elasticsearch query has ~60% of total_time in Postgres workload on the master
Elasticsearch query is consuming a lot of the master's resources. Below is a new K003 from postgres-checkup.
We discussed some time ago that it may be problematic to move it to replicas. However, it would be good to decrease its frequency -- I suppose, it's not normal that it's so frequent (~60 times per second).
Additionally, it may be a good idea to check it in Prometheus, queryid: 721572605.
K003 Top-50 Queries by total_time
Observations
Data collected: 2020-04-24 11:33:33 -0700 PDT
Current database: gitlabhq_production
patroni-11-db-gprd.c.gitlab-production.internal
)
Master (Start: 2020-04-24T18:18:10.378186+00:00
End: 2020-04-24T18:33:14.672609+00:00
Period seconds: 904.29442
Period age: 00:15:04.294423
Error (calls): 0.00 (0.00%)
Error (total time): 0.00 (0.00%)
The list is limited to 50 items.
# (query id) |
Query | Calls | ▼ Total time | Rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied | shared_blks_written | blk_read_time | blk_write_time | kcache_reads | kcache_writes | kcache_user_time_ms | kcache_system_time |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 (721572605) |
SELECT ? AS one FROM ((SELECT "projects".* FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."id" IN (SELECT "elasticsearch_indexed_namespaces"."namespace_id" FROM "elasticsearch_indexed_namespaces")) UNION ( SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces")) UNION (SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (SELECT "elasticsearch_indexed_projects"."project_id" FROM "elasticsearch_indexed_projects"))) projects WHERE "projects"."id" = ? LIMIT ? /*application:web,controller:issues, action:update,correlation_id:RQWmpUShIS9*/ |
55,910 61.83/sec 1.00/call 0.41% |
2,997,465.71 ms 3314.701 ms/sec 53.612 ms/call 58.68% |
7,361 8.14/sec 0.13/call 0.00% |
1,396,729,032 blks 1.55M blks/sec 24.99K blks/call 67.39% |
3 blks 0.00 blks/sec 0.00 blks/call 0.00% |
586 blks 0.65 blks/sec 0.01 blks/call 0.05% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0.05 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
2 (777048128) |
WITH RECURSIVE "namespaces_cte" AS ((SELECT "namespaces"."id", "members"."access_level" FROM "namespaces" INNER JOIN "members" ON "namespaces"."id" = "members"."source_id" WHERE "members"."type" = ? AND "members"."source_type" = ? AND "namespaces"."type" = ? AND "members"."user_id" = ? AND "members"."requested_at" IS NULL) UNION ( SELECT "namespaces"."id", LEAST( "members"."access_level", "group_group_links"."group_access") AS access_level FROM "namespaces" INNER JOIN "group_group_links" ON "group_group_links"."shared_group_id" = "namespaces"."id" INNER JOIN "members" ON "group_group_links"."shared_with_group_id" = "members"."source_id" AND "members"."source_type" = ? AND "members"."requested_at" IS NULL AND "members"."user_id" = ? WHERE "namespaces"."type" = ?) UNION (SELECT "namespaces"."id", GREATEST("members"."access_level", "namespaces_cte"."access_level") AS access_level FROM "namespaces" INNER JOIN "namespaces_cte" ON "namespaces_cte"."id" = "namespaces"."parent_id" LEFT OUTER JO... |
9,208 10.18/sec 1.00/call 0.07% |
477,371.14 ms 527.893 ms/sec 51.843 ms/call 9.34% |
67,289,170 74.42K/sec 7.31K/call 41.70% |
290,809,044 blks 321.59K blks/sec 31.59K blks/call 14.03% |
1,397 blks 1.54 blks/sec 0.15 blks/call 0.12% |
165 blks 0.18 blks/sec 0.02 blks/call 0.01% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
250.24 ms 0.277 ms/sec 0.027 ms/call 0.07% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
3 (1608875156) |
SELECT (CASE WHEN (SELECT count( *) FROM "ci_builds" WHERE "ci_builds"."stage_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)))=( SELECT count(*) FROM "ci_builds" WHERE "ci_builds"."stage_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)) AND ("ci_builds"."status" IN (?))) AND (SELECT count(*) > ? FROM "ci_builds" WHERE "ci_builds"."stage_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND "ci_builds"."allow_failure" = ? AND "ci_builds"."status" IN (?, ?)) THEN ? WHEN (SELECT count( *) FROM "ci_builds" WHERE "ci_builds"."stage_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)))=( SELECT count(*) FROM "ci_builds" WHERE "ci_builds"."stage_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR... |
41,680 46.09/sec 1.00/call 0.30% |
153,953.81 ms 170.247 ms/sec 3.694 ms/call 3.01% |
2,041,446 2.26K/sec 48.98/call 1.27% |
85,515,421 blks 94.57K blks/sec 2.06K blks/call 4.13% |
101 blks 0.11 blks/sec 0.00 blks/call 0.01% |
659 blks 0.73 blks/sec 0.02 blks/call 0.06% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
55.87 ms 0.062 ms/sec 0.001 ms/call 0.02% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
4 (3502758514) |
SELECT (CASE WHEN (SELECT count( *) FROM "ci_builds" WHERE "ci_builds"."commit_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)))=( SELECT count(*) FROM "ci_builds" WHERE "ci_builds"."commit_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)) AND ("ci_builds"."status" IN (?))) AND (SELECT count(*) > ? FROM "ci_builds" WHERE "ci_builds"."commit_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND "ci_builds"."allow_failure" = ? AND "ci_builds"."status" IN (?, ?)) THEN ? WHEN (SELECT count( *) FROM "ci_builds" WHERE "ci_builds"."commit_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)))=( SELECT count(*) FROM "ci_builds" WHERE "ci_builds"."commit_id" = ? AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure =... |
48,321 53.44/sec 1.00/call 0.35% |
109,067.46 ms 120.611 ms/sec 2.257 ms/call 2.14% |
4,647,384 5.14K/sec 96.18/call 2.88% |
75,030,536 blks 82.98K blks/sec 1.56K blks/call 3.62% |
240 blks 0.27 blks/sec 0.00 blks/call 0.02% |
167 blks 0.18 blks/sec 0.00 blks/call 0.01% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
112.21 ms 0.124 ms/sec 0.002 ms/call 0.03% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
5 (1372870422) |
INSERT INTO "notes" ("note", "noteable_type", "author_id", "created_at", "updated_at", "project_id", "noteable_id", "system", "discussion_id", "note_html", "cached_markdown_version") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING "id" /*application:web, controller:issues,action:move,correlation_id:e0JLwRPf9z8*/ |
4,350 4.81/sec 1.00/call 0.03% |
78,801.04 ms 87.141 ms/sec 18.115 ms/call 1.54% |
4,350 4.81/sec 1.00/call 0.00% |
578,624 blks 639.86 blks/sec 133.02 blks/call 0.03% |
110,819 blks 122.55 blks/sec 25.48 blks/call 9.46% |
147,998 blks 163.66 blks/sec 34.02 blks/call 12.93% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
71,506.36 ms 79.074 ms/sec 16.438 ms/call 20.27% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
6 (473577831) |
SELECT "taggings".* FROM "taggings" WHERE "taggings"."taggable_id" = ? AND "taggings"."taggable_type" = ? |
423,456 468.27/sec 1.00/call 3.10% |
68,877.38 ms 76.167 ms/sec 0.163 ms/call 1.35% |
939,705 1.04K/sec 2.22/call 0.58% |
2,000,862 blks 2.22K blks/sec 4.73 blks/call 0.10% |
56,574 blks 62.56 blks/sec 0.13 blks/call 4.83% |
532 blks 0.59 blks/sec 0.00 blks/call 0.05% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
54,470.51 ms 60.235 ms/sec 0.129 ms/call 15.44% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
7 (3220074313) |
UPDATE "project_mirror_data" SET "status" = ?, "last_update_started_at" = ? WHERE "project_mirror_data"."id" = ? /*application:sidekiq,correlation_id:AickxNWagO4, jid:08f4a839f7110c03da6a0a0f,job_class:RepositoryUpdateMirrorWorker*/ |
28,843 31.90/sec 1.00/call 0.21% |
62,936.38 ms 69.597 ms/sec 2.182 ms/call 1.23% |
28,843 31.90/sec 1.00/call 0.02% |
949,623 blks 1.06K blks/sec 32.92 blks/call 0.05% |
2 blks 0.00 blks/sec 0.00 blks/call 0.00% |
691 blks 0.76 blks/sec 0.02 blks/call 0.06% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0.01 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
8 (3670659708) |
SELECT "project_authorizations"."project_id", "project_authorizations"."access_level" FROM "project_authorizations" WHERE "project_authorizations"."user_id" = ? /*application:sidekiq,correlation_id:eg6JsVqmEca, jid:2f6d283fc0f9abe9850f5fa6,job_class:AuthorizedProjectsWorker*/ |
9,208 10.18/sec 1.00/call 0.07% |
59,206.68 ms 65.473 ms/sec 6.430 ms/call 1.16% |
67,277,874 74.40K/sec 7.31K/call 41.69% |
12,701,667 blks 14.05K blks/sec 1.38K blks/call 0.61% |
17,747 blks 19.63 blks/sec 1.93 blks/call 1.51% |
592 blks 0.65 blks/sec 0.06 blks/call 0.05% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
1,135.43 ms 1.256 ms/sec 0.123 ms/call 0.32% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
9 (860089102) |
SELECT (CASE WHEN (SELECT count( *) FROM "ci_builds" WHERE "ci_builds"."type" IN (?, ?, ?) AND "ci_builds"."commit_id" = ? AND (stage_idx < ?) AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)))=( SELECT count(*) FROM "ci_builds" WHERE "ci_builds"."type" IN (?, ?, ?) AND "ci_builds"."commit_id" = ? AND (stage_idx < ?) AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND (allow_failure = ? OR status IN (?,?,?,?,?,?,?,?)) AND ("ci_builds"."status" IN (?))) AND (SELECT count(*) > ? FROM "ci_builds" WHERE "ci_builds"."type" IN (?, ?, ?) AND "ci_builds"."commit_id" = ? AND (stage_idx < ?) AND ("ci_builds"."retried" = ? OR "ci_builds"."retried" IS NULL) AND "ci_builds"."allow_failure" = ? AND "ci_builds"."status" IN (?, ?)) THEN ? WHEN (SELECT count( *) FROM "ci_builds" WHERE "ci_builds"."type" IN (?, ?, ?) AND "ci_builds"."commit_id" = ? AND (stage_idx < ?) AND ("ci_builds"."retried" = ? OR "ci_builds"."ret... |
29,189 32.28/sec 1.00/call 0.21% |
51,875.99 ms 57.366 ms/sec 1.777 ms/call 1.02% |
2,157,804 2.39K/sec 73.93/call 1.34% |
33,095,858 blks 36.60K blks/sec 1.14K blks/call 1.60% |
11 blks 0.01 blks/sec 0.00 blks/call 0.00% |
233 blks 0.26 blks/sec 0.01 blks/call 0.02% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
5.87 ms 0.006 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
10 (680777484) |
SELECT "clusters".* FROM "clusters" WHERE "clusters"."cluster_type" = ? AND "clusters"."enabled" = ? AND (environment_scope IN (?, ?) OR ? LIKE REPLACE(REPLACE( REPLACE(environment_scope, ?, ?), ?, ?), ?, ?) ) ORDER BY CASE environment_scope WHEN ? THEN ? WHEN ? THEN ? ELSE ? END DESC LIMIT ? /*application:sidekiq, correlation_id:bvofJc4TK5,jid:b8b0be776caf5dfdcf592c4f, job_class:PostReceive*/ |
2,120 2.34/sec 1.00/call 0.02% |
40,577.90 ms 44.872 ms/sec 19.141 ms/call 0.79% |
0 0.00/sec 0.00/call 0.00% |
24,799,763 blks 27.43K blks/sec 11.70K blks/call 1.20% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
11 (1322179629) |
UPDATE "ci_builds" SET "status" = ?, "updated_at" = ?, "lock_version" = ? WHERE "ci_builds"."type" = ? AND ("ci_builds"."lock_version" = ? OR "ci_builds"."lock_version" IS NULL) AND "ci_builds"."id" = ? /*application:sidekiq,correlation_id:ZJ1MSNSUGe7, jid:e91096f8aefb9c6eb08d6366,job_class:PipelineProcessWorker*/ |
167,545 185.28/sec 1.00/call 1.23% |
39,516.96 ms 43.699 ms/sec 0.236 ms/call 0.77% |
3,890 4.30/sec 0.02/call 0.00% |
1,328,665 blks 1.47K blks/sec 7.93 blks/call 0.06% |
1,220 blks 1.35 blks/sec 0.01 blks/call 0.10% |
5,148 blks 5.69 blks/sec 0.03 blks/call 0.45% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
118.03 ms 0.131 ms/sec 0.001 ms/call 0.03% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
12 (3258414343) |
UPDATE "ci_builds" SET "runner_id" = ?, "status" = ?, "started_at" = ?, "updated_at" = ?, "lock_version" = ? WHERE "ci_builds"."type" = ? AND "ci_builds"."lock_version" = ? AND "ci_builds"."id" = ? |
51,807 57.29/sec 1.00/call 0.38% |
38,768.45 ms 42.871 ms/sec 0.748 ms/call 0.76% |
12,382 13.69/sec 0.24/call 0.01% |
1,476,268 blks 1.64K blks/sec 28.50 blks/call 0.07% |
3,546 blks 3.92 blks/sec 0.07 blks/call 0.30% |
11,863 blks 13.12 blks/sec 0.23 blks/call 1.04% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
655.26 ms 0.725 ms/sec 0.013 ms/call 0.19% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
13 (2817433262) |
SELECT "notification_settings"."user_id" FROM "notification_settings" WHERE "notification_settings"."source_type" = ? AND "notification_settings"."source_id" = ? AND "notification_settings"."level" = ? |
6,648 7.35/sec 1.00/call 0.05% |
29,769.80 ms 32.920 ms/sec 4.478 ms/call 0.58% |
4,418,649 4.89K/sec 664.66/call 2.74% |
12,688,200 blks 14.04K blks/sec 1.91K blks/call 0.61% |
1,035 blks 1.14 blks/sec 0.16 blks/call 0.09% |
2 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
475.05 ms 0.525 ms/sec 0.071 ms/call 0.13% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
14 (1427145140) |
SELECT "deployments".* FROM "deployments" INNER JOIN "environments" ON "environments"."id" = "deployments"."environment_id" WHERE "deployments"."project_id" = ? AND "deployments"."status" = ? AND "environments"."name" = ? AND "deployments"."id" != ? ORDER BY "deployments"."id" DESC LIMIT ? /*application:sidekiq,correlation_id:hJPaLm2RBN2, jid:3e7bf765eb54723d20283a1d,job_class:Deployments::FinishedWorker*/ |
1,094 1.21/sec 1.00/call 0.01% |
28,549.82 ms 31.571 ms/sec 26.097 ms/call 0.56% |
1,021 1.13/sec 0.93/call 0.00% |
2,471,485 blks 2.74K blks/sec 2.26K blks/call 0.12% |
55,364 blks 61.22 blks/sec 50.61 blks/call 4.73% |
295 blks 0.33 blks/sec 0.27 blks/call 0.03% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
14,052.78 ms 15.540 ms/sec 12.845 ms/call 3.98% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
15 (2555545475) |
SELECT "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT ? |
516,714 571.40/sec 1.00/call 3.78% |
27,175.34 ms 30.051 ms/sec 0.053 ms/call 0.53% |
516,360 571.01/sec 1.00/call 0.32% |
2,210,736 blks 2.45K blks/sec 4.28 blks/call 0.11% |
197 blks 0.22 blks/sec 0.00 blks/call 0.02% |
159 blks 0.18 blks/sec 0.00 blks/call 0.01% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
11.46 ms 0.013 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
16 (1386283669) |
SELECT ? AS one FROM ((SELECT "ci_runners".* FROM "ci_runners" INNER JOIN "ci_runner_projects" ON "ci_runner_projects"."runner_id" = "ci_runners"."id" WHERE "ci_runner_projects"."project_id" = ?) UNION ALL (SELECT "ci_runners".* FROM "ci_runners" INNER JOIN "ci_runner_namespaces" ON "ci_runner_namespaces"."runner_id" = "ci_runners"."id" INNER JOIN "namespaces" ON "namespaces"."id" = "ci_runner_namespaces"."namespace_id" AND "namespaces"."type" = ? WHERE "namespaces"."id" IN (WITH RECURSIVE "base_and_ancestors" AS ((SELECT "namespaces".* FROM "namespaces" INNER JOIN "projects" ON "projects"."namespace_id" = "namespaces"."id" WHERE "namespaces"."type" = ? AND "projects"."id" = ?) UNION ( SELECT "namespaces".* FROM "namespaces", "base_and_ancestors" WHERE "namespaces"."type" = ? AND "namespaces"."id" = "base_and_ancestors"."parent_id")) SELECT "namespaces"."id" FROM "base_and_ancestors" AS "namespaces")) UNION ALL (SELECT "ci_runners".* FROM "ci_runners" WHERE "ci_runners"."runner_type" =... |
327,648 362.32/sec 1.00/call 2.40% |
26,759.96 ms 29.592 ms/sec 0.082 ms/call 0.52% |
327,648 362.32/sec 1.00/call 0.20% |
7,264,639 blks 8.04K blks/sec 22.17 blks/call 0.35% |
5 blks 0.01 blks/sec 0.00 blks/call 0.00% |
42 blks 0.05 blks/sec 0.00 blks/call 0.00% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
3.52 ms 0.004 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
17 (2753256024) |
UPDATE "issues" SET "updated_at" = ? WHERE "issues"."id" = ? /*application:sidekiq, correlation_id:3qO50DJvwp,jid:49b19a3af34a08934d891e71, job_class:ProcessCommitWorker*/ |
968 1.07/sec 1.00/call 0.01% |
25,277.15 ms 27.952 ms/sec 26.113 ms/call 0.49% |
968 1.07/sec 1.00/call 0.00% |
382,422 blks 422.90 blks/sec 395.06 blks/call 0.02% |
87,013 blks 96.22 blks/sec 89.89 blks/call 7.43% |
134,051 blks 148.24 blks/sec 138.48 blks/call 11.71% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
20,628.50 ms 22.812 ms/sec 21.310 ms/call 5.85% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
18 (477030104) |
SELECT "users".* FROM "users" INNER JOIN "project_authorizations" ON "users"."id" = "project_authorizations"."user_id" WHERE "project_authorizations"."project_id" = ? /*application:sidekiq,correlation_id:E6sDTLnOS91, jid:da20f1bc97d274011645af1e,job_class:MergeWorker*/ |
8,028 8.88/sec 1.00/call 0.06% |
25,097.30 ms 27.753 ms/sec 3.126 ms/call 0.49% |
744,885 823.72/sec 92.79/call 0.46% |
3,707,087 blks 4.10K blks/sec 461.77 blks/call 0.18% |
45,123 blks 49.90 blks/sec 5.62 blks/call 3.85% |
1,204 blks 1.33 blks/sec 0.15 blks/call 0.11% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
6,074.31 ms 6.717 ms/sec 0.757 ms/call 1.72% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
19 (2632052184) |
SELECT "clusters".* FROM "clusters" WHERE "clusters"."cluster_type" = ? AND "clusters"."enabled" = ? AND "clusters"."environment_scope" = ? ORDER BY "clusters"."id" ASC LIMIT ? /*application:web,correlation_id:nVcLFgEpLn8*/ |
1,353 1.50/sec 1.00/call 0.01% |
24,920.77 ms 27.558 ms/sec 18.419 ms/call 0.49% |
0 0.00/sec 0.00/call 0.00% |
16,148,055 blks 17.86K blks/sec 11.94K blks/call 0.78% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
20 (2829976684) |
SELECT ? AS one FROM "projects" WHERE "projects"."namespace_id" IN (WITH RECURSIVE "base_and_descendants" AS ((SELECT "namespaces".* FROM "namespaces" WHERE "namespaces"."type" = ? AND "namespaces"."id" = ?) UNION ( SELECT "namespaces".* FROM "namespaces", "base_and_descendants" WHERE "namespaces"."type" = ? AND "namespaces"."parent_id" = "base_and_descendants"."id")) SELECT "id" FROM "base_and_descendants" AS "namespaces") AND (EXISTS (SELECT ? FROM "project_authorizations" WHERE "project_authorizations"."user_id" = ? AND (project_authorizations.project_id = projects.id)) OR projects.visibility_level IN (?,?)) LIMIT ? |
17,272 19.10/sec 1.00/call 0.13% |
23,787.09 ms 26.305 ms/sec 1.377 ms/call 0.47% |
13,509 14.94/sec 0.78/call 0.01% |
12,091,765 blks 13.38K blks/sec 700.08 blks/call 0.58% |
831 blks 0.92 blks/sec 0.05 blks/call 0.07% |
63 blks 0.07 blks/sec 0.00 blks/call 0.01% |
0 blks 0.00 blks/sec 0.00 blks/call 0.00% |
149.45 ms 0.165 ms/sec 0.009 ms/call 0.04% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 bytes 0.00 bytes/sec 0.00 bytes/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
0.00 ms 0.000 ms/sec 0.000 ms/call 0.00% |
Edited by Nikolay Samokhvalov