Queries

Total Time	Average Time	Calls
442 min 51%	250,135 ms	106 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: 15354502 Row progression: 15354502, 1535450 Row estimates - created_at (>): 1535450 - created_at (<): 1535450 - email (null): 3459881 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
344 min 40%	10,611 ms	1,947 readonly_user
SELECT json_build_object($6, json_build_object($7, COUNT() ) ) AS "root" FROM (SELECT $8 FROM (SELECT FROM "public"."upload" WHERE ((("public"."upload"."status") = ANY(($2)::text[])) AND (EXISTS (SELECT $9 FROM "public"."user" AS "__be_0_user" WHERE (((("__be_0_user"."id") = ("public"."upload"."user_id")) AND ($10)) AND (($11) AND (((("__be_0_user"."email") IS NOT NULL) AND ((("__be_0_user"."email") <> (($3)::text)) AND ($12))) AND (((((("__be_0_user"."credit") > (($4)::integer)) AND ($13)) AND ($14)) OR ((((("__be_0_user"."recurring_credit") > (($5)::integer)) AND ($15)) AND ($16)) OR ($17))) AND ($18))))) ))) ) AS "_root.base" ) AS "_root"
10 min 1%	5 ms	115,505 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: 15354502 Row progression: 15354502, 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`
7 min 0.8%	215 ms	1,973 readonly_user
SELECT json_build_object($7, json_build_object($8, COUNT() ) ) AS "root" FROM (SELECT $9 FROM (SELECT FROM "public"."upload" WHERE ((("public"."upload"."status") = ANY(($2)::text[])) AND ((("public"."upload"."created_at") >= (($3)::timestamptz)) AND (EXISTS (SELECT $10 FROM "public"."user" AS "__be_0_user" WHERE (((("__be_0_user"."id") = ("public"."upload"."user_id")) AND ($11)) AND (($12) AND (((("__be_0_user"."email") IS NOT NULL) AND ((("__be_0_user"."email") <> (($4)::text)) AND ($13))) AND (((((("__be_0_user"."credit") > (($5)::integer)) AND ($14)) AND ($15)) OR ((((("__be_0_user"."recurring_credit") > (($6)::integer)) AND ($16)) AND ($17)) OR ($18))) AND ($19))))) )))) ) AS "_root.base" ) AS "_root"
5 min 0.6%	1,216 ms	236 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"`
3 min 0.4%	3 ms	65,464 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: 15354502 Row progression: 15354502, 1 Row estimates - task_id (=): 1 - user_id (=): 1016 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.3%	1,157 ms	139 postgres
`DELETE FROM "user" WHERE "id"=$1` `Covered by index on (id) Rows: 1504177 Row progression: 1504177, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - auth_id - email`
2 min 0.3%	1,068 ms	139 admin
`DELETE FROM ONLY "public"."files" WHERE $1 OPERATOR(pg_catalog.=) "user_id"`
1 min 0.2%	117 ms	770 postgres
`SELECT stats.key AS key, SUM((stats.value)::numeric) AS total FROM upload u CROSS JOIN LATERAL jsonb_each(COALESCE(u.config->$4, $5::jsonb)) AS stats(key, value) WHERE u.user_id = $1 AND u.status = $6 AND u.created_at >= $2 AND u.created_at < $3 AND jsonb_typeof(stats.value) = $7 GROUP BY stats.key`
1 min 0.1%	1 ms	115,406 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)`
1 min 0.1%	1,494 ms	37 readonly_user
SELECT coalesce(json_agg("root" ), $3 ) AS "root" FROM (SELECT row_to_json((SELECT "_e" FROM (SELECT "_root.base"."id" AS "id", "_root.base"."email" AS "email", "_root.base"."auth_id" AS "auth_id", "_root.base"."meta" AS "meta", "_root.base"."credit" AS "credit", "_root.base"."recurring_credit" AS "recurring_credit", "_root.base"."created_at" AS "created_at", "_root.ar.root.subscriptions_aggregate"."subscriptions_aggregate" AS "subscriptions_aggregate", "_root.ar.root.singlepayments_aggregate"."singlepayments_aggregate" AS "singlepayments_aggregate", "_root.ar.root.uploads_aggregate"."uploads_aggregate" AS "uploads_aggregate" ) AS "_e" ) ) AS "root" FROM (SELECT * FROM "public"."user" WHERE (("public"."user"."email") ILIKE (($2)::text)) LIMIT $4 ) AS "_root.base" LEFT OUTER JOIN LATERAL (SELECT json_build_object($5, json_build_object($6, COUNT() ) ) AS "singlepayments_aggregate" FROM (SELECT $7 FROM (SELECT FROM "public"."singlepayment" WHERE (("_root.base"."id") = ("user_id")) ) AS "_root.ar.root.singlepayments_aggregate.base" ) AS "_root.ar.root.singlepayments_aggregate" ) AS "_root.ar.root.singlepayments_aggregate" ON ($8) LEFT OUTER JOIN LATERAL (SELECT json_build_object($9, json_build_object($10, COUNT() ) ) AS "subscriptions_aggregate" FROM (SELECT $11 FROM (SELECT FROM "public"."subscription" WHERE (("_root.base"."id") = ("user_id")) ) AS "_root.ar.root.subscriptions_aggregate.base" ) AS "_root.ar.root.subscriptions_aggregate" ) AS "_root.ar.root.subscriptions_aggregate" ON ($12) LEFT OUTER JOIN LATERAL (SELECT json_build_object($13, json_build_object($14, COUNT() ) ) AS "uploads_aggregate" FROM (SELECT $15 FROM (SELECT FROM "public"."upload" WHERE (("_root.base"."id") = ("user_id")) ) AS "_root.ar.root.uploads_aggregate.base" ) AS "_root.ar.root.uploads_aggregate" ) AS "_root.ar.root.uploads_aggregate" ON ($16) ) AS "_root"
1 min < 0.1%	0 ms	4,984,237 postgres
`SELECT pg_advisory_unlock_all()`
1 min < 0.1%	0 ms	388,654 postgres
`SELECT $3 FROM "upload" WHERE "user_id"=$1 LIMIT $2` `Covered by index on (user_id, created_at DESC) Rows: 15354502 Row progression: 15354502, 1016 Row estimates - user_id (=): 1016 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
0 min < 0.1%	0 ms	52,834 postgres
`UPDATE "upload" SET "task_id"=$1,"config"=$2 WHERE "id"=$3` `Covered by index on (id) Rows: 15354502 Row progression: 15354502, 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`
0 min < 0.1%	0 ms	62,569 postgres
`UPDATE "upload" SET "task_id"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 15354502 Row progression: 15354502, 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`
0 min < 0.1%	0 ms	56,836 postgres
`INSERT INTO "files" ("id","created_at","filename_path","user_id") VALUES ($1,$2,$3,$4)`
0 min < 0.1%	19 ms	913 postgres
`SELECT "id" "id","created_at" "created_at","ended_at" "ended_at","status" "status","length_audio" "length_audio","task_id" "task_id","audio_links" "audio_links","config" "config" FROM "upload" WHERE "user_id"=$1 AND "created_at">=$2 ORDER BY "created_at" ASC` `Covered by index on (user_id, created_at) Rows: 15354502 Row progression: 15354502, 1016, 102 Row estimates - user_id (=): 1016 - created_at (>=): 1535450 - 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`
0 min < 0.1%	73 ms	198 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 AND "created_at"<$5 ORDER BY "created_at" DESC LIMIT $6` `Covered by index on (user_id, created_at) Rows: 15354502 Row progression: 15354502, 1016, 102 Row estimates - user_id (=): 1016 - created_at (>=): 1535450 - created_at (<): 1535450 - status (=): 3070900 - 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`
0 min < 0.1%	5 ms	2,792 postgres
`UPDATE "upload" SET "config"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 15354502 Row progression: 15354502, 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`
0 min < 0.1%	0 ms	83,851 postgres
`UPDATE "user" SET "recurring_credit"=$1,"credit"=$2 WHERE "auth_id"=$3 AND "email"=$4` `Covered by index on (auth_id) Rows: 1504177 Row progression: 1504177, 1 Row estimates - auth_id (=): 1 - email (=): 1 Existing indexes - id PRIMARY - auth_id - email`
0 min < 0.1%	0 ms	62,556 postgres
`SELECT COUNT(*) FROM "files" WHERE "filename_path"=$1` `Covered by index on (filename_path) Rows: 8058223 Row progression: 8058223, 1 Row estimates - filename_path (=): 1 Existing indexes - id PRIMARY - filename_path`
0 min < 0.1%	16 ms	572 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: 15354502 Row progression: 15354502, 1016, 102 Row estimates - user_id (=): 1016 - created_at (>=): 1535450 - created_at (<): 1535450 - status (=): 3070900 - 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`
0 min < 0.1%	12 ms	770 postgres
SELECT date_trunc($4, u.created_at) AS bucket, COUNT(*) AS total_uploads, SUM(u.length_audio) AS total_credits, SUM(CASE WHEN COALESCE(u.source, u.config->>$5, (u.config->$6->>$7), $8) = $9 THEN $10 ELSE $11 END) AS ui_uploads, SUM(CASE WHEN COALESCE(u.source, u.config->>$12, (u.config->$13->>$14), $15) = $16 THEN u.length_audio ELSE $17 END) AS ui_credits, SUM(CASE WHEN COALESCE(u.source, u.config->>$18, (u.config->$19->>$20), $21) = $22 THEN $23 ELSE $24 END) AS api_uploads, SUM(CASE WHEN COALESCE(u.source, u.config->>$25, (u.config->$26->>$27), $28) = $29 THEN u.length_audio ELSE $30 END) AS api_credits FROM upload u WHERE u.user_id = $1 AND u.status = $31 AND u.created_at >= $2 AND u.created_at < $3 GROUP BY bucket ORDER BY bucket ASC
0 min < 0.1%	60 ms	139 admin
`DELETE FROM ONLY "public"."configuration" WHERE $1 OPERATOR(pg_catalog.=) "user_id"`
0 min < 0.1%	60 ms	112 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	64 ms	104 postgres
WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / $2 / $3) AS total_minutes, ((total_plan_time + total_exec_time) / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /pghero/
0 min < 0.1%	60 ms	109 postgres
`SELECT "upload_type","user_id","id","description","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	110 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	103 postgres
`SELECT "name","user_id","settings","upload_type","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	102 postgres
`SELECT "description","id","name","user_id","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	101 postgres
`SELECT "upload_type","settings","user_id","id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	98 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	96 postgres
`SELECT "name","description","user_id","settings","id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	0 ms	126,700 admin
`SELECT $2 FROM ONLY "public"."user" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x`
0 min < 0.1%	60 ms	97 postgres
`SELECT "description","id","upload_type","user_id","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	96 postgres
`SELECT "user_id","settings","id","name","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	63 ms	90 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	96 postgres
`SELECT "id","upload_type","settings","description","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	94 postgres
`SELECT "description","settings","name","upload_type","user_id","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	91 postgres
`SELECT "settings","id","name","upload_type","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	92 postgres
`SELECT "name","description","id","settings","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	92 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	93 postgres
`SELECT "upload_type","settings","name","description","user_id","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	89 postgres
`SELECT "name","id","settings","upload_type","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	87 postgres
`SELECT "id","upload_type","name","description","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	88 postgres
`SELECT "description","name","id","upload_type","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	57 ms	92 postgres
`SELECT "user_id","name","settings","id","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	88 postgres
`SELECT "settings","upload_type","description","name","user_id","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	86 postgres
`SELECT "settings","user_id","description","name","upload_type","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	88 postgres
`SELECT "id","user_id","description","upload_type","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	89 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	86 postgres
`SELECT "id","settings","name","description","upload_type","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	86 postgres
`SELECT "upload_type","id","name","description","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	85 postgres
`SELECT "description","id","settings","upload_type","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	84 postgres
`SELECT "upload_type","settings","user_id","name","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	87 postgres
`SELECT "name","settings","upload_type","user_id","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	84 postgres
`SELECT "description","upload_type","id","name","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	84 postgres
`SELECT "upload_type","id","settings","name","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	62 ms	81 postgres
`SELECT "name","user_id","upload_type","settings","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	83 postgres
`SELECT "settings","upload_type","user_id","name","description","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	83 postgres
`SELECT "id","settings","upload_type","description","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	86 postgres
`SELECT "settings","name","description","id","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	6 ms	850 postgres
`Update Upload set config= $1 where id = uuid($2)` `Covered by index on (id) Rows: 15354502 Row progression: 15354502, 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`
0 min < 0.1%	63 ms	78 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	80 postgres
`SELECT "name","settings","description","upload_type","id","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	80 postgres
`SELECT "id","description","name","upload_type","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	80 postgres
`SELECT "user_id","description","upload_type","id","name","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	81 postgres
`SELECT "id","description","user_id","settings","name","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	82 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: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	82 postgres
`SELECT "description","upload_type","id","settings","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	79 postgres
`SELECT "description","user_id","upload_type","name","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	78 postgres
`SELECT "user_id","settings","name","id","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	80 postgres
`SELECT "description","user_id","name","id","settings","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	78 postgres
`SELECT "name","id","user_id","upload_type","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	80 postgres
`SELECT "settings","name","upload_type","id","user_id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	78 postgres
`SELECT "upload_type","settings","id","description","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	77 postgres
`SELECT "upload_type","description","settings","name","user_id","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	80 postgres
`SELECT "description","settings","user_id","upload_type","name","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	79 postgres
`SELECT "id","name","upload_type","user_id","settings","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	79 postgres
`SELECT "settings","upload_type","description","id","user_id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	76 postgres
`SELECT "id","settings","description","user_id","name","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	76 postgres
`SELECT "settings","name","description","id","upload_type","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	75 postgres
`SELECT "settings","id","description","name","upload_type","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	63 ms	72 postgres
`SELECT "description","id","name","settings","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	74 postgres
`SELECT "upload_type","user_id","name","description","settings","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	76 postgres
`SELECT "id","user_id","settings","description","name","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	74 postgres
`SELECT "upload_type","id","settings","name","user_id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	76 postgres
`SELECT "user_id","upload_type","name","settings","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	74 postgres
`SELECT "description","name","id","upload_type","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	73 postgres
`SELECT "user_id","upload_type","description","settings","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	72 postgres
`SELECT "description","id","name","upload_type","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	73 postgres
`SELECT "name","id","upload_type","description","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	72 postgres
`SELECT "user_id","id","settings","upload_type","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	73 postgres
`SELECT "description","user_id","name","id","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	59 ms	74 postgres
`SELECT "name","settings","description","upload_type","user_id","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	76 postgres
`SELECT "id","name","settings","upload_type","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	58 ms	75 postgres
`SELECT "user_id","id","description","settings","name","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	61 ms	72 postgres
`SELECT "settings","description","user_id","upload_type","id","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	72 postgres
`SELECT "upload_type","settings","name","description","id","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	60 ms	72 postgres
`SELECT "settings","upload_type","id","user_id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 99783 Row progression: 99783, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`