explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cyK2

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=28.46..32.98 rows=67 width=284) (actual rows= loops=)

  • Group Key: c.oid, n.nspname, c.relname
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=20.53..27.28 rows=67 width=136) (actual rows= loops=)

  • Hash Cond: (i.indrelid = c.oid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on pg_index i (cost=0.00..5.80 rows=180 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=19.69..19.69 rows=67 width=132) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.13..19.69 rows=67 width=132) (actual rows= loops=)

  • Hash Cond: (c.relnamespace = n.oid)
6. 0.000 0.000 ↓ 0.0

Seq Scan on pg_class c (cost=0.00..17.97 rows=134 width=72) (actual rows= loops=)

  • Filter: (relkind = ANY ('{r,t,m}'::"char"[]))
7. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=3 width=68) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on pg_namespace n (cost=0.00..1.09 rows=3 width=68) (actual rows= loops=)

  • Filter: ((nspname <> ALL ('{pg_catalog,information_schema}'::name[])) AND (nspname !~ '^pg_toast'::text))