explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mtXD : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.249 ↓ 1.2 5 1

Sort (cost=54.72..54.73 rows=4 width=70) (actual time=0.249..0.249 rows=5 loops=1)

  • Sort Key: ((pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT'::text)), (((c.oid)::regclass)::text)
  • Sort Method: quicksort Memory: 25kB
2. 0.118 0.236 ↓ 1.2 5 1

Nested Loop (cost=4.55..54.68 rows=4 width=70) (actual time=0.149..0.236 rows=5 loops=1)

3. 0.043 0.043 ↓ 1.2 5 1

Index Scan using pg_inherits_parent_index on pg_inherits i (cost=0.27..21.44 rows=4 width=4) (actual time=0.038..0.043 rows=5 loops=1)

  • Index Cond: (inhparent = '16469'::oid)
4. 0.045 0.075 ↑ 1.0 1 5

Bitmap Heap Scan on pg_class c (cost=4.28..8.30 rows=1 width=470) (actual time=0.015..0.015 rows=1 loops=5)

  • Recheck Cond: (oid = i.inhrelid)
  • Heap Blocks: exact=5
5. 0.030 0.030 ↑ 1.0 1 5

Bitmap Index Scan on pg_class_oid_index (cost=0.00..4.28 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=5)

  • Index Cond: (oid = i.inhrelid)