explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kT6y : sss

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

Sort (cost=61.17..61.19 rows=10 width=70) (actual rows= loops=)

  • Output: ((c.oid)::regclass), (pg_get_expr(c.relpartbound, c.oid)), c.relkind, ((pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT'::text)), (((c.oid)::regclass)::text)
  • Sort Key: ((pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT'::text)), (((c.oid)::regclass)::text)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.91..61.00 rows=10 width=70) (actual rows= loops=)

  • Output: (c.oid)::regclass, pg_get_expr(c.relpartbound, c.oid), c.relkind, (pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT'::text), ((c.oid)::regclass)::text
  • Hash Cond: (c.oid = i.inhrelid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on pg_catalog.pg_class c (cost=0.00..42.63 rows=863 width=37) (actual rows= loops=)

  • Output: c.oid, c.relpartbound, c.relkind
4. 0.000 0.000 ↓ 0.0

Hash (cost=14.79..14.79 rows=10 width=4) (actual rows= loops=)

  • Output: i.inhrelid
5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on pg_catalog.pg_inherits i (cost=4.23..14.79 rows=10 width=4) (actual rows= loops=)

  • Output: i.inhrelid
  • Recheck Cond: (i.inhparent = '208947'::oid)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on pg_inherits_parent_index (cost=0.00..4.23 rows=10 width=0) (actual rows= loops=)