explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sfB

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.035 ↑ 9.9 35 1

Bitmap Heap Scan on gm_tombala.cc_bet_items (cost=10.68..1,376.37 rows=346 width=4) (actual time=0.025..0.035 rows=35 loops=1)

  • Output: 1
  • Recheck Cond: (cc_bet_items.bid = 13809920)
  • Heap Blocks: exact=3
2. 0.014 0.014 ↑ 9.6 36 1

Bitmap Index Scan on hidx__bet_items__bid (cost=0.00..10.59 rows=346 width=0) (actual time=0.014..0.014 rows=36 loops=1)

  • Index Cond: (cc_bet_items.bid = 13809920)
Planning time : 0.076 ms
Execution time : 0.056 ms