explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GLKd

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.005 ↓ 0.0 0 1

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

  • Recheck Cond: (b = 10)
  • Buffers: shared hit=1
2. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: (b = 10)
  • Buffers: shared hit=1
Planning time : 0.099 ms
Execution time : 0.031 ms