explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbQa

Settings
# exclusive inclusive rows x rows loops node
1. 4.873 7.339 ↑ 1.0 12,256 1

Bitmap Heap Scan on stock_bis (cost=268.66..5,107.33 rows=12,511 width=16) (actual time=2.546..7.339 rows=12,256 loops=1)

  • Recheck Cond: ((vin_id > 400) AND (vin_id < 500))
  • Heap Blocks: exact=222
2. 2.466 2.466 ↑ 1.0 12,256 1

Bitmap Index Scan on idx_stock_id_bis (cost=0.00..265.54 rows=12,511 width=0) (actual time=2.466..2.466 rows=12,256 loops=1)

  • Index Cond: ((vin_id > 400) AND (vin_id < 500))