explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kVVk

Settings
# exclusive inclusive rows x rows loops node
1. 5,542.231 7,294.830 ↓ 1.4 89,824 1

Sort (cost=30,485.23..30,648.58 rows=65,339 width=32) (actual time=7,267.986..7,294.830 rows=89,824 loops=1)

  • Sort Key: ((((n.nspname)::text || '.'::text) || (c.relname)::text))
  • Sort Method: quicksort Memory: 13428kB
2. 331.995 1,752.599 ↓ 1.4 89,824 1

Hash Left Join (cost=30.94..25,259.53 rows=65,339 width=32) (actual time=5.097..1,752.599 rows=89,824 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
3. 181.852 1,415.744 ↓ 1.4 89,824 1

Hash Join (cost=1.29..24,403.45 rows=65,339 width=68) (actual time=0.163..1,415.744 rows=89,824 loops=1)

  • Hash Cond: (c.relowner = pg_authid.oid)
4. 1,233.831 1,233.831 ↓ 1.4 89,824 1

Seq Scan on pg_class c (cost=0.00..24,174.72 rows=65,339 width=72) (actual time=0.029..1,233.831 rows=89,824 loops=1)

  • Filter: (relkind = ANY ('{r,""}'::"char"[]))
  • Rows Removed by Filter: 336247
5. 0.031 0.061 ↓ 1.1 14 1

Hash (cost=1.13..1.13 rows=13 width=4) (actual time=0.060..0.061 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.030 0.030 ↓ 1.1 14 1

Seq Scan on pg_authid (cost=0.00..1.13 rows=13 width=4) (actual time=0.011..0.030 rows=14 loops=1)

7. 1.414 4.860 ↓ 2.0 940 1

Hash (cost=23.73..23.73 rows=473 width=68) (actual time=4.860..4.860 rows=940 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 100kB
8. 3.446 3.446 ↓ 2.0 940 1

Seq Scan on pg_namespace n (cost=0.00..23.73 rows=473 width=68) (actual time=0.021..3.446 rows=940 loops=1)

Planning time : 4.964 ms
Execution time : 7,315.903 ms