explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d9v1

Settings
# exclusive inclusive rows x rows loops node
1. 10.317 10.701 ↑ 11.0 4 1

HashAggregate (cost=26.25..29.22 rows=44 width=284) (actual time=10.692..10.701 rows=4 loops=1)

  • Group Key: c.oid, n.nspname, c.relname
2. 0.062 0.384 ↑ 11.0 4 1

Hash Right Join (cost=18.78..25.48 rows=44 width=136) (actual time=0.365..0.384 rows=4 loops=1)

  • Hash Cond: (i.indrelid = c.oid)
3. 0.040 0.040 ↑ 1.3 138 1

Seq Scan on pg_index i (cost=0.00..5.80 rows=180 width=8) (actual time=0.005..0.040 rows=138 loops=1)

4. 0.005 0.282 ↑ 11.0 4 1

Hash (cost=18.23..18.23 rows=44 width=132) (actual time=0.282..0.282 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.033 0.277 ↑ 11.0 4 1

Hash Join (cost=1.13..18.23 rows=44 width=132) (actual time=0.077..0.277 rows=4 loops=1)

  • Hash Cond: (c.relnamespace = n.oid)
6. 0.200 0.200 ↓ 1.0 92 1

Seq Scan on pg_class c (cost=0.00..16.70 rows=88 width=72) (actual time=0.016..0.200 rows=92 loops=1)

  • Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
  • Rows Removed by Filter: 258
7. 0.011 0.044 ↑ 1.5 2 1

Hash (cost=1.09..1.09 rows=3 width=68) (actual time=0.043..0.044 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
8. 0.033 0.033 ↑ 1.5 2 1

Seq Scan on pg_namespace n (cost=0.00..1.09 rows=3 width=68) (actual time=0.024..0.033 rows=2 loops=1)

  • Filter: ((nspname <> ALL ('{pg_catalog,information_schema}'::name[])) AND (nspname !~ '^pg_toast'::text))
  • Rows Removed by Filter: 4
Planning time : 0.935 ms
Execution time : 10.883 ms