explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pGeV

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 0.141 ↓ 0.0 0 1

Sort (cost=61.17..61.19 rows=10 width=70) (actual time=0.140..0.141 rows=0 loops=1)

  • Sort Key: ((pg_get_expr(c.relpartbound, c.oid) = 'DEFAULT'::text)), (((c.oid)::regclass)::text)
  • Sort Method: quicksort Memory: 17kB
2. 0.040 0.066 ↓ 0.0 0 1

Hash Join (cost=14.91..61.00 rows=10 width=70) (actual time=0.066..0.066 rows=0 loops=1)

  • Hash Cond: (c.oid = i.inhrelid)
3. 0.017 0.017 ↑ 863.0 1 1

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

4. 0.002 0.009 ↓ 0.0 0 1

Hash (cost=14.79..14.79 rows=10 width=4) (actual time=0.008..0.009 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
5. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on pg_inherits i (cost=4.23..14.79 rows=10 width=4) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (inhparent = '208947'::oid)
6. 0.004 0.004 ↓ 0.0 0 1

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