Queries

Total Time	Average Time	Calls
8,454 min 93%	296,448 ms	1,711 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: 14484293 Row progression: 14484293, 1448429 Row estimates - created_at (>): 1448429 - created_at (<): 1448429 - email (null): 3296142 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
243 min 3%	5 ms	2,856,057 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: 14484293 Row progression: 14484293, 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`
86 min 0.9%	1,828 ms	2,819 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"`
48 min 0.5%	1,017 ms	2,823 postgres
`DELETE FROM "user" WHERE "id"=$1` `Covered by index on (id) Rows: 1388391 Row progression: 1388391, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - auth_id - email`
44 min 0.5%	944 ms	2,814 admin
`DELETE FROM ONLY "public"."files" WHERE $1 OPERATOR(pg_catalog.=) "user_id"`
22 min 0.2%	0 ms	2,871,502 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)`
12 min 0.1%	1 ms	1,363,194 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: 14484293 Row progression: 14484293, 1 Row estimates - task_id (=): 1 - user_id (=): 991 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
11 min 0.1%	0 ms	93,136,411 postgres
`SELECT pg_advisory_unlock_all()`
11 min 0.1%	0 ms	1,496,302 postgres
`UPDATE "upload" SET "task_id"=$1,"config"=$2 WHERE "id"=$3` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 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`
11 min 0.1%	0 ms	9,774,765 postgres
`SELECT $3 FROM "upload" WHERE "user_id"=$1 LIMIT $2` `Covered by index on (user_id, created_at DESC) Rows: 14484293 Row progression: 14484293, 991 Row estimates - user_id (=): 991 Existing indexes - id PRIMARY - id WHERE config IS NOT NULL - task_id - task_id - user_id, created_at - user_id, created_at DESC`
8 min < 0.1%	0 ms	1,623,541 postgres
`INSERT INTO "files" ("id","created_at","filename_path","user_id") VALUES ($1,$2,$3,$4)`
8 min < 0.1%	0 ms	1,375,190 postgres
`UPDATE "upload" SET "task_id"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 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	1,803,387 postgres
`SELECT COUNT(*) FROM "files" WHERE "filename_path"=$1` `Covered by index on (filename_path) Rows: 9347806 Row progression: 9347806, 1 Row estimates - filename_path (=): 1 Existing indexes - id PRIMARY - filename_path`
4 min < 0.1%	7 ms	38,718 postgres
`UPDATE "upload" SET "config"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 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	1,858,870 postgres
`UPDATE "user" SET "recurring_credit"=$1,"credit"=$2 WHERE "auth_id"=$3 AND "email"=$4` `Covered by index on (auth_id) Rows: 1388391 Row progression: 1388391, 1 Row estimates - auth_id (=): 1 - email (=): 1 Existing indexes - id PRIMARY - auth_id - email`
3 min < 0.1%	17 ms	9,895 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: 14484293 Row progression: 14484293, 991, 99 Row estimates - user_id (=): 991 - created_at (>=): 1448429 - created_at (<): 1448429 - status (=): 2896859 - 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`
2 min < 0.1%	536 ms	257 readonly_user
SELECT coalesce(json_agg("root" ), '[]' ) AS "root" FROM (SELECT row_to_json((SELECT "_e" FROM (SELECT "_root.base"."user_id" AS "user_id", "_root.or.user"."user" AS "user" ) AS "_e" ) ) AS "root" FROM (SELECT * FROM "public"."upload" WHERE (("public"."upload"."created_at") >= (($2)::timestamptz)) ) AS "_root.base" LEFT OUTER JOIN LATERAL (SELECT row_to_json((SELECT "_e" FROM (SELECT "_root.or.user.base"."id" AS "id", "_root.or.user.base"."email" AS "email" ) AS "_e" ) ) AS "user" FROM (SELECT * FROM "public"."user" WHERE (("_root.base"."user_id") = ("id")) LIMIT 1 ) AS "_root.or.user.base" ) AS "_root.or.user" ON ('true') ) AS "_root"
2 min < 0.1%	533 ms	251 readonly_user
`SELECT json_build_object('aggregate', json_build_object('count', COUNT() ) ) AS "root" FROM (SELECT 1 FROM (SELECT FROM "public"."upload" WHERE ((("public"."upload"."status") = ANY(($2)::text[])) AND (("public"."upload"."created_at") >= (($3)::timestamptz))) ) AS "_root.base" ) AS "_root"`
2 min < 0.1%	0 ms	3,001,515 admin
`SELECT $2 FROM ONLY "public"."user" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x`
2 min < 0.1%	42 ms	2,814 admin
`DELETE FROM ONLY "public"."configuration" WHERE $1 OPERATOR(pg_catalog.=) "user_id"`
2 min < 0.1%	39 ms	2,654 postgres
`SELECT "description","user_id","name","settings","id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	39 ms	2,543 postgres
`SELECT "settings","description","id","upload_type","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	39 ms	2,493 postgres
`SELECT "user_id","upload_type","settings","id","name","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	39 ms	2,399 postgres
`SELECT "id","settings","user_id","name","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	39 ms	2,347 postgres
`SELECT "user_id","name","upload_type","id","settings","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	39 ms	2,385 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	38 ms	2,392 postgres
`SELECT "name","user_id","description","settings","upload_type","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
2 min < 0.1%	38 ms	2,369 postgres
`SELECT "name","upload_type","description","id","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	1 ms	138,129 postgres
`UPDATE "upload" SET "user_id"=$1,"email"=$2 WHERE "id"=$3` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 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%	6 ms	11,764 postgres
`Update Upload set config= $1 where id = uuid($2)` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 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%	39 ms	1,688 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,616 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	1,582 postgres
`SELECT "name","settings","id","description","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,484 postgres
`SELECT "upload_type","description","id","settings","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,485 postgres
`SELECT "settings","user_id","name","id","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	0 ms	239,202 postgres
`INSERT INTO "user" ("auth_id","email","recurring_credit","credit","created_at","meta") VALUES ($1,$2,$3,$4,$5,$6) RETURNING "id"`
1 min < 0.1%	6 ms	10,206 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%	38 ms	1,478 postgres
`SELECT "name","settings","upload_type","description","id","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,441 postgres
`SELECT "id","user_id","settings","name","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	1,409 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	4 ms	15,243 postgres
`SELECT "id" "id","paddle_email" "paddle_email","product_id" "product_id","paddle_order_id" "paddle_order_id","product_name" "product_name","created_at" "created_at" FROM "singlepayment" WHERE "user_id"=$1 ORDER BY "created_at" DESC` Details `CREATE INDEX CONCURRENTLY ON singlepayment (user_id)` `Rows: 9911 Row progression: 9911, 1 Row estimates - user_id (=): 1 - created_at (sort): 1 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	1,387 postgres
`SELECT "name","upload_type","settings","user_id","description","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	1,318 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,282 postgres
`SELECT "upload_type","description","settings","id","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,269 postgres
`SELECT "settings","upload_type","user_id","id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,244 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,243 postgres
`SELECT "id","upload_type","description","settings","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,228 postgres
`SELECT "id","user_id","upload_type","settings","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,154 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,161 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,139 postgres
`SELECT "id","name","upload_type","description","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	1,139 postgres
`SELECT "name","settings","description","id","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	40 ms	1,106 postgres
`SELECT "name","description","id","user_id","settings","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	38 ms	1,145 postgres
`SELECT "id","upload_type","description","name","settings","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	4 ms	11,764 postgres
`Select config from Upload where id = uuid($1)` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 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%	0 ms	275,017 postgres
`UPDATE "user" SET "meta"=$1 WHERE "id"=$2` `Covered by index on (id) Rows: 1388391 Row progression: 1388391, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - auth_id - email`
1 min < 0.1%	38 ms	1,030 postgres
`SELECT "id","upload_type","user_id","settings","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	991 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	2 ms	18,023 postgres
`SELECT "key_id" "key_id","description" "description","created_at" "created_at","last_used_at" "last_used_at" FROM "key" WHERE "user_id"=$1 ORDER BY "created_at" DESC` Details `CREATE INDEX CONCURRENTLY ON key (user_id)` `Rows: 3940 Row progression: 3940, 1 Row estimates - user_id (=): 1 - created_at (sort): 1 Existing indexes - id PRIMARY - hashed_api_key UNIQUE - key_id UNIQUE`
1 min < 0.1%	149 ms	251 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"."created_at" AS "created_at" ) AS "_e" ) ) AS "root" FROM (SELECT * FROM "public"."user" WHERE (("public"."user"."created_at") >= (($2)::timestamptz)) ) AS "_root.base" ) AS "_root"`
1 min < 0.1%	38 ms	913 postgres
`SELECT "id","upload_type","user_id","name","settings","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	40 ms	876 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	0 ms	378,998 postgres
`UPDATE "user" SET "auth_id"=$1,"email"=$2,"recurring_credit"=$3,"credit"=$4,"created_at"=$5,"meta"=$6 WHERE "id"=$7` `Covered by index on (id) Rows: 1388391 Row progression: 1388391, 1 Row estimates - id (=): 1 Existing indexes - id PRIMARY - auth_id - email`
1 min < 0.1%	38 ms	891 postgres
`SELECT "name","user_id","upload_type","settings","description","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	875 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	877 postgres
`SELECT "upload_type","settings","id","user_id","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	134 ms	251 readonly_user
`SELECT json_build_object($3, json_build_object($4, COUNT() ) ) AS "root" FROM (SELECT $5 FROM (SELECT FROM "public"."user" WHERE (("public"."user"."created_at") >= (($2)::timestamptz)) ) AS "_root.base" ) AS "_root"`
1 min < 0.1%	40 ms	818 postgres
`SELECT "upload_type","id","name","user_id","settings","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	813 postgres
`SELECT "upload_type","user_id","id","description","name","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	806 postgres
`SELECT "upload_type","name","id","settings","description","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	794 postgres
`SELECT "upload_type","name","user_id","settings","description","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	40 ms	762 postgres
`SELECT "user_id","settings","id","name","description","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
1 min < 0.1%	39 ms	772 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	2 ms	15,243 postgres
`SELECT "id" "id","paddle_subscription_id" "paddle_subscription_id","paddle_plan_id" "paddle_plan_id","paddle_status" "paddle_status","paddle_next_bill_date" "paddle_next_bill_date","paddle_cancelled_at" "paddle_cancelled_at","created_at" "created_at","paddle_user_id" "paddle_user_id" FROM "subscription" WHERE "user_id"=$1 ORDER BY "created_at" DESC` Details `CREATE INDEX CONCURRENTLY ON subscription (user_id)` `Rows: 4112 Row progression: 4112, 1 Row estimates - user_id (=): 1 - created_at (sort): 1 Existing indexes - id PRIMARY`
0 min < 0.1%	38 ms	761 postgres
`SELECT "name","id","upload_type","settings","user_id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	39 ms	741 postgres
`SELECT "settings","description","name","id","upload_type","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	724 postgres
`SELECT "name","upload_type","id","description","user_id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	39 ms	736 postgres
`SELECT "description","upload_type","user_id","id","settings","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	38 ms	723 postgres
`SELECT "user_id","name","id","upload_type","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	661 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	659 postgres
`SELECT "id","user_id","settings","upload_type","description","name" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	39 ms	657 postgres
`SELECT "settings","name","id","user_id","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	619 postgres
`SELECT "id","user_id","name","settings","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	588 postgres
`SELECT "upload_type","id","description","settings","name","user_id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	39 ms	555 postgres
`SELECT "name","settings","user_id","id","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	0 ms	186,585 postgres
`UPDATE "user" SET "recurring_credit"=$1 WHERE "auth_id"=$2 AND "email"=$3` `Covered by index on (auth_id) Rows: 1388391 Row progression: 1388391, 1 Row estimates - auth_id (=): 1 - email (=): 1 Existing indexes - id PRIMARY - auth_id - email`
0 min < 0.1%	39 ms	515 postgres
`SELECT "user_id","name","id","description","settings","upload_type" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	483 postgres
`SELECT "settings","name","user_id","id","upload_type","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	41 ms	449 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	444 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	4 ms	4,752 postgres
`SELECT "ended_at","edits","id","export_links","source","user_id","created_at","task_id","length_audio","audio_samples","status","statistics","audio_links","timeline_links","email","config" FROM "upload" WHERE "id"=$1 AND "user_id"=$2 LIMIT $3` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 1 Row estimates - id (=): 1 - user_id (=): 991 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%	40 ms	428 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	418 postgres
`SELECT "name","id","description","user_id","upload_type","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	410 postgres
`SELECT "upload_type","user_id","id","name","description","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	414 postgres
`SELECT "settings","name","upload_type","user_id","id","description" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	3 ms	4,905 postgres
`SELECT "created_at","length_audio","timeline_links","export_links","audio_samples","task_id","edits","audio_links","source","user_id","ended_at","config","id","statistics","status","email" FROM "upload" WHERE "id"=$1 AND "user_id"=$2 LIMIT $3` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 1 Row estimates - id (=): 1 - user_id (=): 991 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%	39 ms	409 postgres
`SELECT "user_id","name","description","upload_type","id","settings" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	3 ms	4,710 postgres
`SELECT "user_id","statistics","email","export_links","created_at","audio_links","timeline_links","audio_samples","ended_at","config","source","id","length_audio","edits","status","task_id" FROM "upload" WHERE "id"=$1 AND "user_id"=$2 LIMIT $3` `Covered by index on (id) Rows: 14484293 Row progression: 14484293, 1 Row estimates - id (=): 1 - user_id (=): 991 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%	40 ms	390 postgres
`SELECT "upload_type","user_id","settings","name","description","id" FROM "configuration" WHERE "user_id"=$1` Details `CREATE INDEX CONCURRENTLY ON configuration (user_id)` `Rows: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`
0 min < 0.1%	40 ms	393 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: 93990 Row progression: 93990, 2 Row estimates - user_id (=): 2 Existing indexes - id PRIMARY`