PgHero
No long running queries
Connections healthy 52
Vacuuming healthy
No columns near integer overflow (3 unreadable sequences)
No invalid indexes or constraints
1 duplicate index
2 suggested indexes
73 slow queries

Duplicate Indexes

These indexes exist, but aren’t needed. Remove them for faster writes. 

rails generate migration remove_unneeded_indexes

And paste

remove_index :upload, name: "upload_task_id_idx1", column: :task_id
Details
On upload 
upload_task_id_idx1 (task_id)
is covered by 
upload_task_id_idx (task_id)

Suggested Indexes

Add indexes to speed up queries. 

rails generate migration add_suggested_indexes

And paste

commit_db_transaction
add_index :configuration, [:user_id], algorithm: :concurrently
add_index :upload, [:created_at], algorithm: :concurrently
Details
CREATE INDEX CONCURRENTLY ON configuration (user_id)
 
Rows: 93990
Row progression: 93990, 2

Row estimates
- user_id (=): 2

Existing indexes
- id PRIMARY

to speed up

Total Time Average Time Calls
2 min < 0.1% 39 ms 2,646 postgres 
SELECT "description","user_id","name","settings","id","upload_type" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 39 ms 2,543 postgres 
SELECT "settings","description","id","upload_type","name","user_id" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 39 ms 2,493 postgres 
SELECT "user_id","upload_type","settings","id","name","description" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 39 ms 2,399 postgres 
SELECT "id","settings","user_id","name","upload_type","description" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 39 ms 2,347 postgres 
SELECT "user_id","name","upload_type","id","settings","description" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 39 ms 2,385 postgres 
SELECT "settings","user_id","upload_type","description","id","name" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 38 ms 2,390 postgres 
SELECT "name","user_id","description","settings","upload_type","id" FROM "configuration" WHERE "user_id"=$1
2 min < 0.1% 38 ms 2,369 postgres 
SELECT "name","upload_type","description","id","settings","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,688 postgres 
SELECT "user_id","id","upload_type","description","name","settings" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,616 postgres 
SELECT "name","settings","upload_type","user_id","id","description" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,582 postgres 
SELECT "name","settings","id","description","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,484 postgres 
SELECT "upload_type","description","id","settings","name","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,485 postgres 
SELECT "settings","user_id","name","id","description","upload_type" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,478 postgres 
SELECT "name","settings","upload_type","description","id","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,440 postgres 
SELECT "id","user_id","settings","name","upload_type","description" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,409 postgres 
SELECT "name","description","id","settings","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,387 postgres 
SELECT "name","upload_type","settings","user_id","description","id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,318 postgres 
SELECT "settings","upload_type","description","id","user_id","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,282 postgres 
SELECT "upload_type","description","settings","id","name","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,269 postgres 
SELECT "settings","upload_type","user_id","id","description","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,244 postgres 
SELECT "user_id","id","settings","upload_type","description","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,243 postgres 
SELECT "id","upload_type","description","settings","name","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,228 postgres 
SELECT "id","user_id","upload_type","settings","description","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,154 postgres 
SELECT "id","settings","user_id","upload_type","description","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,161 postgres 
SELECT "description","name","id","upload_type","settings","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,139 postgres 
SELECT "id","name","upload_type","description","settings","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 1,139 postgres 
SELECT "name","settings","description","id","user_id","upload_type" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,145 postgres 
SELECT "id","upload_type","description","name","settings","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 40 ms 1,105 postgres 
SELECT "name","description","id","user_id","settings","upload_type" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 1,030 postgres 
SELECT "id","upload_type","user_id","settings","description","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 991 postgres 
SELECT "description","user_id","upload_type","name","id","settings" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 40 ms 876 postgres 
SELECT "name","user_id","settings","upload_type","id","description" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 909 postgres 
SELECT "id","upload_type","user_id","name","settings","description" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 38 ms 891 postgres 
SELECT "name","user_id","upload_type","settings","description","id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 875 postgres 
SELECT "settings","name","upload_type","id","user_id","description" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 877 postgres 
SELECT "upload_type","settings","id","user_id","description","name" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 40 ms 818 postgres 
SELECT "upload_type","id","name","user_id","settings","description" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 813 postgres 
SELECT "upload_type","user_id","id","description","name","settings" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 806 postgres 
SELECT "upload_type","name","id","settings","description","user_id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 794 postgres 
SELECT "upload_type","name","user_id","settings","description","id" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 40 ms 762 postgres 
SELECT "user_id","settings","id","name","description","upload_type" FROM "configuration" WHERE "user_id"=$1
1 min < 0.1% 39 ms 772 postgres 
SELECT "name","description","id","upload_type","settings","user_id" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 38 ms 761 postgres 
SELECT "name","id","upload_type","settings","user_id","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 39 ms 741 postgres 
SELECT "settings","description","name","id","upload_type","user_id" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 724 postgres 
SELECT "name","upload_type","id","description","user_id","settings" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 39 ms 736 postgres 
SELECT "description","upload_type","user_id","id","settings","name" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 38 ms 723 postgres 
SELECT "user_id","name","id","upload_type","description","settings" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 659 postgres 
SELECT "upload_type","description","settings","name","user_id","id" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 651 postgres 
SELECT "id","user_id","settings","upload_type","description","name" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 39 ms 657 postgres 
SELECT "settings","name","id","user_id","upload_type","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 619 postgres 
SELECT "id","user_id","name","settings","upload_type","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 588 postgres 
SELECT "upload_type","id","description","settings","name","user_id" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 39 ms 555 postgres 
SELECT "name","settings","user_id","id","upload_type","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 39 ms 515 postgres 
SELECT "user_id","name","id","description","settings","upload_type" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 483 postgres 
SELECT "settings","name","user_id","id","upload_type","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 41 ms 441 postgres 
SELECT "id","name","upload_type","user_id","settings","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 444 postgres 
SELECT "user_id","name","id","description","upload_type","settings" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 428 postgres 
SELECT "id","upload_type","settings","name","description","user_id" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 418 postgres 
SELECT "name","id","description","user_id","upload_type","settings" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 410 postgres 
SELECT "upload_type","user_id","id","name","description","settings" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 414 postgres 
SELECT "settings","name","upload_type","user_id","id","description" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 39 ms 409 postgres 
SELECT "user_id","name","description","upload_type","id","settings" FROM "configuration" WHERE "user_id"=$1
0 min < 0.1% 40 ms 390 postgres 
SELECT "upload_type","user_id","settings","name","description","id" FROM "configuration" WHERE "user_id"=$1
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 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

to speed up

Total Time Average Time Calls
8,450 min 93% 296,481 ms 1,710 postgres 
SELECT config AS config
        FROM upload
        WHERE email IS NULL AND created_at < NOW() - INTERVAL $1
        AND created_at > NOW() - INTERVAL $2

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time Average Time Calls
8,450 min 93% 296,481 ms 1,710 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
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"
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% 42 ms 2,814 admin 
DELETE FROM ONLY "public"."configuration" WHERE $1 OPERATOR(pg_catalog.=) "user_id"
2 min < 0.1% 39 ms 2,646 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,390 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% 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% 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,440 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% 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% 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% 40 ms 1,105 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,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% 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% 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% 38 ms 909 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% 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% 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 659 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 651 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% 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 441 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% 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% 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% 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