explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3PTh

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=3,904.47..18,724.50 rows=1,117 width=7) (actual rows= loops=)

  • Workers Planned: 3
2. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on bookings (cost=2,904.47..17,612.80 rows=360 width=7) (actual rows= loops=)

  • Recheck Cond: (total_amount < '20000'::numeric)
  • Filter: ((book_date)::date = '2017-08-14'::date)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on b_amount_idx (cost=0.00..2,904.19 rows=223,435 width=0) (actual rows= loops=)

  • Index Cond: (total_amount < '20000'::numeric)