Queries

Total Time	Average Time	Calls
11,608 min 80%	740,139 ms	941 postgres
WITH target AS ( SELECT u.id FROM upload u WHERE u.created_at < now() - interval $1 AND u.config IS NOT NULL AND ( u.config ? $2 OR u.config ? $3 OR u.config ? $4 OR u.config ? $5 OR u.config ? $6 OR u.config ? $7 OR u.config ? $8 OR u.config ? $9 OR u.config ? $10 OR u.config ? $11 OR u.config ? $12 OR u.config ? $13 OR u.config ? $14 OR u.config ? $15 OR u.config ? $16 OR u.config ? $17 OR u.config ? $18 OR u.config ? $19 ) ORDER BY u.id FOR UPDATE SKIP LOCKED LIMIT $20 ), computed AS ( SELECT u.id, CASE WHEN jsonb_typeof(u.config -> $21) = $22 THEN jsonb_set( ( u.config - $23 - $24 - $25 - $26 - $27 - $28 - $29 - $30 - $31 - $32 - $33 - $34 - $35 - $36 - $37 - $38 - $39 - $40 ), $41, ( SELECT jsonb_agg( track_elem - $42 - $43 - $44 - $45 - $46 - $47 - $48 - $49 - $50 - $51 - $52 - $53 - $54 - $55 - $56 - $57 - $58 - $59 - $60 - $61 - $62 - $63 - $64 - $65 - $66 - $67 - $68 - $69 - $70 - $71 - $72 - $73 - $74 - $75 - $76 - $77 - $78 - $79 - $80 - $81 - $82 - $83 - $84 - $85 - $86 - $87 - $88 - $89 ) FROM jsonb_array_elements(u.config -> $90) AS track_elem ), $91 ) ELSE u.config - $92 - $93 - $94 - $95 - $96 - $97 - $98 - $99 - $100 - $101 - $102 - $103 - $104 - $105 - $106 - $107 - $108 - $109 END AS new_config FROM upload u JOIN target t ON t.id = u.id ) UPDATE upload u SET config = c.new_config FROM computed c WHERE u.id = c.id AND u.config IS DISTINCT FROM c.new_config `Covered by index on (id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - id (=): 1 - config (=): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
2,503 min 17%	288,781 ms	520 postgres
`SELECT config AS config FROM upload WHERE email IS NULL AND created_at < NOW() - INTERVAL $1 AND created_at > NOW() - INTERVAL $2` Details `CREATE INDEX CONCURRENTLY ON upload (created_at)` `Rows: 12738224 Row progression: 12738224, 1273823 Row estimates - created_at (>): 1273823 - created_at (<): 1273823 - email (null): 2865676 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
114 min 0.8%	5 ms	1,331,817 postgres
`Update Upload set status= $1, audio_links= $2, statistics = $3, ended_at= $4::timestamp, config= $5, edits= $6, export_links= $7 where id = uuid($8)` `Covered by index on (id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
94 min 0.6%	1,889 ms	2,975 readonly_user
`SELECT json_build_object($5, json_build_object($6, COUNT(), $7, $8 ), $9, coalesce($10, (bool_or($11))::text ) ) AS "root" FROM (SELECT $12 FROM (SELECT FROM "public"."upload" WHERE (((("public"."upload"."created_at") < (($2)::timestamptz)) AND (("public"."upload"."created_at") >= (($3)::timestamptz))) AND (("public"."upload"."source") ILIKE (($4)::text))) ) AS "_root.base" ) AS "_root"`
36 min 0.2%	1,917 ms	1,124 readonly_user
`SELECT json_build_object($5, json_build_object($6, COUNT() ) ) AS "root" FROM (SELECT $7 FROM (SELECT FROM "public"."upload" WHERE (((("public"."upload"."created_at") < (($2)::timestamptz)) AND (("public"."upload"."created_at") >= (($3)::timestamptz))) AND (("public"."upload"."source") ILIKE (($4)::text))) ) AS "_root.base" ) AS "_root"`
21 min 0.1%	1,054 ms	1,186 postgres
`DELETE FROM "user" WHERE "id"=$1` `Covered by index on (id) Rows: 1255527 Row progression: 1255527, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - auth_id - email`
19 min 0.1%	983 ms	1,181 admin
`DELETE FROM ONLY "public"."files" WHERE $1 OPERATOR(pg_catalog.=) "user_id"`
10 min < 0.1%	0 ms	1,332,739 postgres
`INSERT INTO "upload" ("id","email","created_at","ended_at","statistics","edits","config","export_links","audio_links","timeline_links","audio_samples","length_audio","status","task_id","source","user_id") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16)`
5 min < 0.1%	0 ms	696,973 postgres
`UPDATE "upload" SET "task_id"=$1,"config"=$2 WHERE "id"=$3` `Covered by index on (id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
5 min < 0.1%	0 ms	40,802,237 postgres
`SELECT pg_advisory_unlock_all()`
5 min < 0.1%	0 ms	627,753 postgres
`SELECT "status" "status","config" "config" FROM "upload" WHERE "task_id"=$1 AND "user_id"=$2 LIMIT $3` `Covered by index on (task_id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - task_id (=): 1 - user_id (=): 882 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
5 min < 0.1%	0 ms	4,408,478 postgres
`SELECT $3 FROM "upload" WHERE "user_id"=$1 LIMIT $2` `Covered by index on (user_id, created_at DESC) Rows: 12738224 Row progression: 12738224, 882 Row estimates - user_id (=): 882 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
4 min < 0.1%	0 ms	762,614 postgres
`INSERT INTO "files" ("id","created_at","filename_path","user_id") VALUES ($1,$2,$3,$4)`
4 min < 0.1%	0 ms	635,760 postgres
`UPDATE "upload" SET "task_id"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
3 min < 0.1%	0 ms	843,800 postgres
`SELECT COUNT(*) FROM "files" WHERE "filename_path"=$1` `Covered by index on (filename_path) Rows: 8582294 Row progression: 8582294, 1 Row estimates - filename_path (=): 1 Existing indexes - id PRIMARY - filename_path`
3 min < 0.1%	37 ms	4,228 postgres
`SELECT "upload_type","user_id","settings","id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	36 ms	2,964 postgres
`SELECT "upload_type","user_id","settings","description","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	35 ms	2,935 postgres
`SELECT "upload_type","user_id","name","description","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	36 ms	2,770 postgres
`SELECT "settings","upload_type","name","id","user_id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	36 ms	2,628 postgres
`SELECT "name","id","settings","user_id","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	36 ms	2,600 postgres
`SELECT "settings","id","name","description","upload_type","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	0 ms	858,851 postgres
`UPDATE "user" SET "recurring_credit"=$1,"credit"=$2 WHERE "auth_id"=$3 AND "email"=$4` `Covered by index on (auth_id) Rows: 1255527 Row progression: 1255527, 1 Row estimates - auth_id (=): 1 - email (=): 1 Existing indexes - id PRIMARY - auth_id - email`
2 min < 0.1%	36 ms	2,532 postgres
`SELECT "user_id","settings","upload_type","description","name","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,428 postgres
`SELECT "id","settings","name","upload_type","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,468 postgres
`SELECT "user_id","id","name","upload_type","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,337 postgres
`SELECT "user_id","upload_type","name","id","settings","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,331 postgres
`SELECT "name","user_id","description","id","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,334 postgres
`SELECT "description","user_id","settings","name","id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	2,349 postgres
`SELECT "user_id","name","id","settings","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,312 postgres
`SELECT "id","description","upload_type","name","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	2,254 postgres
`SELECT "id","user_id","name","description","settings","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,216 postgres
`SELECT "description","name","id","settings","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,079 postgres
`SELECT "settings","name","id","user_id","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,074 postgres
`SELECT "upload_type","settings","user_id","description","name","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	2,012 postgres
`SELECT "upload_type","id","settings","user_id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	2,010 postgres
`SELECT "description","id","upload_type","user_id","name","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,865 postgres
`SELECT "user_id","description","upload_type","settings","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	15 ms	4,515 postgres
`SELECT "id" "id","source" "source","config" "config","created_at" "created_at","length_audio" "length_audio" FROM "upload" WHERE "user_id"=$1 AND "status"=$2 AND "created_at">=$3 AND "created_at"<$4 ORDER BY "created_at" DESC LIMIT $5` `Covered by index on (user_id, created_at) Rows: 12738224 Row progression: 12738224, 882, 88 Row estimates - user_id (=): 882 - created_at (>=): 1273823 - created_at (<): 1273823 - status (=): 2547645 - created_at (sort): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
1 min < 0.1%	36 ms	1,849 postgres
`SELECT "user_id","name","upload_type","description","settings","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,881 postgres
`SELECT "name","upload_type","settings","user_id","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,717 postgres
`SELECT "upload_type","name","user_id","description","settings","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,775 postgres
`SELECT "settings","upload_type","user_id","description","name","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,610 postgres
`SELECT "user_id","name","upload_type","id","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,596 postgres
`SELECT "name","upload_type","description","user_id","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	0 ms	1,375,583 admin
`SELECT $2 FROM ONLY "public"."user" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x`
1 min < 0.1%	37 ms	1,504 postgres
`SELECT "upload_type","description","user_id","settings","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,471 postgres
`SELECT "user_id","name","id","description","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,453 postgres
`SELECT "description","user_id","name","upload_type","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,455 postgres
`SELECT "upload_type","id","description","settings","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,423 postgres
`SELECT "user_id","upload_type","settings","description","name","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,393 postgres
`SELECT "user_id","settings","upload_type","description","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,424 postgres
`SELECT "upload_type","description","name","user_id","settings","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,389 postgres
`SELECT "settings","user_id","id","name","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,409 postgres
`SELECT "id","description","user_id","upload_type","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,423 postgres
`SELECT "id","upload_type","settings","name","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,353 postgres
`SELECT "user_id","id","description","upload_type","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,376 postgres
`SELECT "id","settings","user_id","upload_type","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,382 postgres
`SELECT "user_id","id","upload_type","description","name","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,325 postgres
`SELECT "name","id","upload_type","description","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,341 postgres
`SELECT "name","upload_type","description","user_id","settings","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,324 postgres
`SELECT "user_id","id","name","settings","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,269 postgres
`SELECT "user_id","id","upload_type","name","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,181 admin
`DELETE FROM ONLY "public"."configuration" WHERE $1 OPERATOR(pg_catalog.=) "user_id"`
1 min < 0.1%	35 ms	1,274 postgres
`SELECT "user_id","settings","description","name","upload_type","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,195 postgres
`SELECT "user_id","name","upload_type","settings","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	7 ms	6,594 postgres
`UPDATE "upload" SET "config"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
1 min < 0.1%	36 ms	1,189 postgres
`SELECT "description","id","user_id","settings","upload_type","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,188 postgres
`SELECT "name","user_id","id","description","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,143 postgres
`SELECT "name","settings","user_id","description","id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,161 postgres
`SELECT "name","id","settings","upload_type","user_id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,162 postgres
`SELECT "settings","upload_type","id","description","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	35 ms	1,151 postgres
`SELECT "settings","user_id","upload_type","id","name","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,123 postgres
`SELECT "description","name","settings","user_id","id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,079 postgres
`SELECT "description","name","settings","upload_type","id","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,077 postgres
`SELECT "user_id","settings","upload_type","id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,057 postgres
`SELECT "description","name","user_id","settings","id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,062 postgres
`SELECT "upload_type","id","settings","user_id","name","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	1,041 postgres
`SELECT "name","description","settings","id","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,066 postgres
`SELECT "description","settings","upload_type","id","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,034 postgres
`SELECT "name","upload_type","user_id","settings","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	960 postgres
`SELECT "description","settings","id","upload_type","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	1,008 postgres
`SELECT "name","description","id","upload_type","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	948 postgres
`SELECT "upload_type","name","id","description","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	994 postgres
`SELECT "upload_type","description","name","user_id","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	934 postgres
`SELECT "id","upload_type","user_id","name","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	960 postgres
`SELECT "name","settings","user_id","upload_type","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	934 postgres
`SELECT "upload_type","description","id","name","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	921 postgres
`SELECT "id","upload_type","description","user_id","name","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	920 postgres
`SELECT "description","user_id","upload_type","id","name","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	1 ms	60,715 postgres
`UPDATE "upload" SET "user_id"=$1,"email"=$2 WHERE "id"=$3` `Covered by index on (id) Rows: 12738224 Row progression: 12738224, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
1 min < 0.1%	38 ms	857 postgres
`SELECT "id","name","description","upload_type","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	858 postgres
`SELECT "user_id","description","id","upload_type","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	861 postgres
`SELECT "upload_type","name","description","user_id","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	854 postgres
`SELECT "id","upload_type","settings","user_id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	892 postgres
`SELECT "settings","id","user_id","description","name","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	809 postgres
`SELECT "settings","user_id","upload_type","description","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	36 ms	833 postgres
`SELECT "description","name","upload_type","settings","user_id","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	37 ms	824 postgres
`SELECT "user_id","description","name","id","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	38 ms	783 postgres
`SELECT "upload_type","settings","name","user_id","description","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	37 ms	783 postgres
`SELECT "user_id","description","settings","upload_type","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 83960 Row progression: 83960, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`