explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aEc8

Settings
# exclusive inclusive rows x rows loops node
1. 0.666 11,031.143 ↑ 9.8 58 1

GroupAggregate (cost=3,044.76..3,066.13 rows=569 width=16) (actual time=11,030.097..11,031.143 rows=58 loops=1)

  • Group Key: bsv_id
2. 3.079 11,030.477 ↓ 3.3 1,884 1

Sort (cost=3,044.76..3,046.19 rows=573 width=16) (actual time=11,030.025..11,030.477 rows=1,884 loops=1)

  • Sort Key: bsv_id
  • Sort Method: quicksort Memory: 137kB
3. 4,236.022 11,027.398 ↓ 3.3 1,884 1

Bitmap Heap Scan on aps_appointment_slot appointmen0_ (cost=1,497.70..3,018.51 rows=573 width=16) (actual time=7,021.153..11,027.398 rows=1,884 loops=1)

  • Recheck Cond: (((bsv_id = 7264118) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 5122064) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264134) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7916283) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264126) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7775828) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7259837) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7926966) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7510924) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7259610) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7259867) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264230) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7259861) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7259879) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7922738) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263898) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263902) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263918) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7794243) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264310) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7415489) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263914) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264246) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264282) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264302) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264290) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7915023) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264294) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264238) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263942) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7270952) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7637508) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7847067) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7415473) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7930521) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263934) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7847059) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7263930) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7924266) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7924314) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271063) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7918286) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264270) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7917071) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7930525) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7415481) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7930656) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271019) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7842342) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7915024) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7930655) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7920413) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7790496) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7270960) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7921733) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271039) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7842338) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7264526) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271182) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7921207) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7270978) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7270995) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7415461) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7415477) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7274313) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7922508) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7920404) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7923256) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271208) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7444203) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7924222) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7756093) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271214) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7921206) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7270946) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7925470) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271170) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7842350) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7842354) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7930518) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7917013) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7925574) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7930519) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7270890) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7920400) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7756087) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7918130) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7925575) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271144) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271150) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7925471) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7925469) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7842346) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7922363) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7916421) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7916612) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7919897) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7271176) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)) OR ((bsv_id = 7444211) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text)))
  • Filter: ((reservation_expiry < '18-OCT-18 00:00:00'::timestamp without time zone) AND ((request_priority_name)::text = 'ROUTINE'::text))
  • Rows Removed by Filter: 12041
  • Heap Blocks: exact=4818
4. 0.126 6,791.376 ↓ 0.0 0 1

BitmapOr (cost=1,497.70..1,497.70 rows=667 width=0) (actual time=6,791.376..6,791.376 rows=0 loops=1)

5. 37.875 37.875 ↓ 13.4 94 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=37.875..37.875 rows=94 loops=1)

  • Index Cond: ((bsv_id = 7264118) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
6. 142.533 142.533 ↓ 78.4 549 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=142.533..142.533 rows=549 loops=1)

  • Index Cond: ((bsv_id = 5122064) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
7. 55.804 55.804 ↓ 5.6 39 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=55.804..55.804 rows=39 loops=1)

  • Index Cond: ((bsv_id = 7264134) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
8. 18.841 18.841 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=18.841..18.841 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7916283) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
9. 113.979 113.979 ↓ 31.7 222 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=113.979..113.979 rows=222 loops=1)

  • Index Cond: ((bsv_id = 7264126) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
10. 67.701 67.701 ↓ 15.4 108 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=67.701..67.701 rows=108 loops=1)

  • Index Cond: ((bsv_id = 7775828) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
11. 385.448 385.448 ↓ 120.4 843 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=385.448..385.448 rows=843 loops=1)

  • Index Cond: ((bsv_id = 7259837) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
12. 20.220 20.220 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=20.220..20.220 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7926966) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
13. 92.181 92.181 ↓ 18.3 128 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=92.181..92.181 rows=128 loops=1)

  • Index Cond: ((bsv_id = 7510924) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
14. 46.938 46.938 ↓ 5.9 41 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=46.938..46.938 rows=41 loops=1)

  • Index Cond: ((bsv_id = 7259610) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
15. 34.658 34.658 ↓ 3.9 27 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=34.658..34.658 rows=27 loops=1)

  • Index Cond: ((bsv_id = 7259867) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
16. 54.390 54.390 ↓ 18.6 130 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=54.390..54.390 rows=130 loops=1)

  • Index Cond: ((bsv_id = 7264230) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
17. 102.420 102.420 ↓ 8.6 60 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=102.420..102.420 rows=60 loops=1)

  • Index Cond: ((bsv_id = 7259861) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
18. 30.340 30.340 ↑ 3.5 2 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=30.340..30.340 rows=2 loops=1)

  • Index Cond: ((bsv_id = 7259879) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
19. 91.426 91.426 ↓ 33.0 231 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=91.426..91.426 rows=231 loops=1)

  • Index Cond: ((bsv_id = 7922738) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
20. 69.769 69.769 ↓ 53.4 374 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=69.769..69.769 rows=374 loops=1)

  • Index Cond: ((bsv_id = 7263898) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
21. 41.178 41.178 ↓ 18.1 127 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=41.178..41.178 rows=127 loops=1)

  • Index Cond: ((bsv_id = 7263902) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
22. 109.288 109.288 ↓ 19.0 133 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=109.288..109.288 rows=133 loops=1)

  • Index Cond: ((bsv_id = 7263918) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
23. 119.134 119.134 ↓ 32.0 224 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=119.134..119.134 rows=224 loops=1)

  • Index Cond: ((bsv_id = 7794243) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
24. 26.903 26.903 ↓ 7.1 50 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=26.903..26.903 rows=50 loops=1)

  • Index Cond: ((bsv_id = 7264310) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
25. 79.691 79.691 ↓ 16.6 116 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=79.691..79.691 rows=116 loops=1)

  • Index Cond: ((bsv_id = 7415489) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
26. 121.882 121.882 ↓ 35.1 246 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=121.882..121.882 rows=246 loops=1)

  • Index Cond: ((bsv_id = 7263914) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
27. 149.362 149.362 ↓ 39.3 275 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=149.362..149.362 rows=275 loops=1)

  • Index Cond: ((bsv_id = 7264246) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
28. 91.462 91.462 ↓ 39.1 274 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=91.462..91.462 rows=274 loops=1)

  • Index Cond: ((bsv_id = 7264282) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
29. 192.150 192.150 ↓ 41.1 288 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=192.150..192.150 rows=288 loops=1)

  • Index Cond: ((bsv_id = 7264302) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
30. 98.277 98.277 ↓ 24.1 169 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=98.277..98.277 rows=169 loops=1)

  • Index Cond: ((bsv_id = 7264290) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
31. 54.639 54.639 ↓ 19.0 133 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=54.639..54.639 rows=133 loops=1)

  • Index Cond: ((bsv_id = 7915023) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
32. 47.435 47.435 ↓ 5.0 35 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=47.435..47.435 rows=35 loops=1)

  • Index Cond: ((bsv_id = 7264294) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
33. 10.996 10.996 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=10.996..10.996 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7264238) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
34. 155.308 155.308 ↓ 34.6 242 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=155.308..155.308 rows=242 loops=1)

  • Index Cond: ((bsv_id = 7263942) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
35. 80.673 80.673 ↓ 29.7 208 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=80.673..80.673 rows=208 loops=1)

  • Index Cond: ((bsv_id = 7270952) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
36. 125.339 125.339 ↓ 24.3 170 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=125.339..125.339 rows=170 loops=1)

  • Index Cond: ((bsv_id = 7637508) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
37. 17.865 17.865 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=17.865..17.865 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7847067) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
38. 305.882 305.882 ↓ 97.3 681 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=305.882..305.882 rows=681 loops=1)

  • Index Cond: ((bsv_id = 7415473) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
39. 238.493 238.493 ↓ 88.9 622 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=238.493..238.493 rows=622 loops=1)

  • Index Cond: ((bsv_id = 7930521) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
40. 13.671 13.671 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=13.671..13.671 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7263934) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
41. 80.929 80.929 ↓ 32.0 224 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=80.929..80.929 rows=224 loops=1)

  • Index Cond: ((bsv_id = 7847059) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
42. 211.585 211.585 ↓ 60.1 421 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=211.585..211.585 rows=421 loops=1)

  • Index Cond: ((bsv_id = 7263930) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
43. 34.696 34.696 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=34.696..34.696 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7924266) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
44. 13.903 13.903 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=13.903..13.903 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7924314) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
45. 28.924 28.924 ↓ 11.0 77 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=28.924..28.924 rows=77 loops=1)

  • Index Cond: ((bsv_id = 7271063) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
46. 31.609 31.609 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=31.609..31.609 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7918286) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
47. 76.860 76.860 ↓ 11.7 82 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=76.860..76.860 rows=82 loops=1)

  • Index Cond: ((bsv_id = 7264270) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
48. 16.240 16.240 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=16.240..16.240 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7917071) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
49. 53.933 53.933 ↓ 17.6 123 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=53.933..53.933 rows=123 loops=1)

  • Index Cond: ((bsv_id = 7930525) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
50. 122.295 122.295 ↓ 48.0 336 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=122.295..122.295 rows=336 loops=1)

  • Index Cond: ((bsv_id = 7415481) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
51. 77.503 77.503 ↓ 24.4 171 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=77.503..77.503 rows=171 loops=1)

  • Index Cond: ((bsv_id = 7930656) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
52. 107.120 107.120 ↓ 32.6 228 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=107.120..107.120 rows=228 loops=1)

  • Index Cond: ((bsv_id = 7271019) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
53. 65.989 65.989 ↓ 23.7 166 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=65.989..65.989 rows=166 loops=1)

  • Index Cond: ((bsv_id = 7842342) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
54. 86.230 86.230 ↓ 13.1 92 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=86.230..86.230 rows=92 loops=1)

  • Index Cond: ((bsv_id = 7915024) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
55. 29.577 29.577 ↓ 5.7 40 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=29.577..29.577 rows=40 loops=1)

  • Index Cond: ((bsv_id = 7930655) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
56. 36.071 36.071 ↓ 5.7 40 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=36.071..36.071 rows=40 loops=1)

  • Index Cond: ((bsv_id = 7920413) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
57. 39.809 39.809 ↓ 11.6 81 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=39.809..39.809 rows=81 loops=1)

  • Index Cond: ((bsv_id = 7790496) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
58. 190.250 190.250 ↓ 69.9 489 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=190.250..190.250 rows=489 loops=1)

  • Index Cond: ((bsv_id = 7270960) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
59. 35.740 35.740 ↓ 3.1 22 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=35.740..35.740 rows=22 loops=1)

  • Index Cond: ((bsv_id = 7921733) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
60. 43.979 43.979 ↓ 26.9 188 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=43.979..43.979 rows=188 loops=1)

  • Index Cond: ((bsv_id = 7271039) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
61. 67.598 67.598 ↓ 10.0 70 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=67.598..67.598 rows=70 loops=1)

  • Index Cond: ((bsv_id = 7842338) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
62. 190.686 190.686 ↓ 80.0 560 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=190.686..190.686 rows=560 loops=1)

  • Index Cond: ((bsv_id = 7264526) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
63. 33.446 33.446 ↓ 1.9 13 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=33.446..33.446 rows=13 loops=1)

  • Index Cond: ((bsv_id = 7271182) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
64. 24.449 24.449 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=24.449..24.449 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7921207) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
65. 24.976 24.976 ↓ 9.0 63 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=24.976..24.976 rows=63 loops=1)

  • Index Cond: ((bsv_id = 7270978) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
66. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7270995) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
67. 105.753 105.753 ↓ 38.3 268 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=105.753..105.753 rows=268 loops=1)

  • Index Cond: ((bsv_id = 7415461) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
68. 207.139 207.139 ↓ 74.0 518 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=207.139..207.139 rows=518 loops=1)

  • Index Cond: ((bsv_id = 7415477) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
69. 31.730 31.730 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=31.730..31.730 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7274313) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
70. 47.543 47.543 ↓ 33.6 235 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=47.543..47.543 rows=235 loops=1)

  • Index Cond: ((bsv_id = 7922508) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
71. 10.384 10.384 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=10.384..10.384 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7920404) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
72. 33.427 33.427 ↓ 10.0 70 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=33.427..33.427 rows=70 loops=1)

  • Index Cond: ((bsv_id = 7923256) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
73. 14.890 14.890 ↑ 7.0 1 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=14.890..14.890 rows=1 loops=1)

  • Index Cond: ((bsv_id = 7271208) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
74. 41.686 41.686 ↓ 14.0 98 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=41.686..41.686 rows=98 loops=1)

  • Index Cond: ((bsv_id = 7444203) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
75. 25.308 25.308 ↓ 8.7 61 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=25.308..25.308 rows=61 loops=1)

  • Index Cond: ((bsv_id = 7924222) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
76. 83.568 83.568 ↓ 22.4 157 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=83.568..83.568 rows=157 loops=1)

  • Index Cond: ((bsv_id = 7756093) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
77. 20.191 20.191 ↓ 6.1 43 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=20.191..20.191 rows=43 loops=1)

  • Index Cond: ((bsv_id = 7271214) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
78. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7921206) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
79. 91.434 91.434 ↓ 43.6 305 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=91.434..91.434 rows=305 loops=1)

  • Index Cond: ((bsv_id = 7270946) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
80. 29.503 29.503 ↓ 5.9 41 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=29.503..29.503 rows=41 loops=1)

  • Index Cond: ((bsv_id = 7925470) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
81. 34.416 34.416 ↓ 12.3 86 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=34.416..34.416 rows=86 loops=1)

  • Index Cond: ((bsv_id = 7271170) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
82. 56.428 56.428 ↓ 18.7 131 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=56.428..56.428 rows=131 loops=1)

  • Index Cond: ((bsv_id = 7842350) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
83. 48.253 48.253 ↓ 16.9 118 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=48.253..48.253 rows=118 loops=1)

  • Index Cond: ((bsv_id = 7842354) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
84. 6.098 6.098 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=6.098..6.098 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7930518) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
85. 46.994 46.994 ↓ 8.7 61 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=46.994..46.994 rows=61 loops=1)

  • Index Cond: ((bsv_id = 7917013) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
86. 34.803 34.803 ↓ 9.1 64 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=34.803..34.803 rows=64 loops=1)

  • Index Cond: ((bsv_id = 7925574) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
87. 9.916 9.916 ↓ 6.1 43 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=9.916..9.916 rows=43 loops=1)

  • Index Cond: ((bsv_id = 7930519) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
88. 99.429 99.429 ↓ 49.9 349 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=99.429..99.429 rows=349 loops=1)

  • Index Cond: ((bsv_id = 7270890) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
89. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7920400) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
90. 52.235 52.235 ↓ 17.9 125 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=52.235..52.235 rows=125 loops=1)

  • Index Cond: ((bsv_id = 7756087) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
91. 74.871 74.871 ↓ 27.0 189 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=74.871..74.871 rows=189 loops=1)

  • Index Cond: ((bsv_id = 7918130) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
92. 27.797 27.797 ↓ 7.7 54 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=27.797..27.797 rows=54 loops=1)

  • Index Cond: ((bsv_id = 7925575) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
93. 81.144 81.144 ↓ 3.9 27 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=81.144..81.144 rows=27 loops=1)

  • Index Cond: ((bsv_id = 7271144) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
94. 34.508 34.508 ↓ 9.3 65 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=34.508..34.508 rows=65 loops=1)

  • Index Cond: ((bsv_id = 7271150) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
95. 48.639 48.639 ↓ 20.1 141 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=48.639..48.639 rows=141 loops=1)

  • Index Cond: ((bsv_id = 7925471) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
96. 28.360 28.360 ↓ 7.6 53 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=28.360..28.360 rows=53 loops=1)

  • Index Cond: ((bsv_id = 7925469) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
97. 38.983 38.983 ↓ 10.1 71 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=38.983..38.983 rows=71 loops=1)

  • Index Cond: ((bsv_id = 7842346) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
98. 17.433 17.433 ↓ 1.6 11 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=17.433..17.433 rows=11 loops=1)

  • Index Cond: ((bsv_id = 7922363) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
99. 17.155 17.155 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=17.155..17.155 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7916421) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
100. 23.328 23.328 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=23.328..23.328 rows=0 loops=1)

  • Index Cond: ((bsv_id = 7916612) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
101. 45.528 45.528 ↓ 12.3 86 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=45.528..45.528 rows=86 loops=1)

  • Index Cond: ((bsv_id = 7919897) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
102. 15.165 15.165 ↑ 1.0 7 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=15.165..15.165 rows=7 loops=1)

  • Index Cond: ((bsv_id = 7271176) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))
103. 38.609 38.609 ↓ 17.1 120 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=38.609..38.609 rows=120 loops=1)

  • Index Cond: ((bsv_id = 7444211) AND (start_date >= '18-OCT-18 00:00:00'::timestamp without time zone) AND (start_date < '31-MAR-20 00:00:00'::timestamp without time zone) AND ((status)::text = 'AVAILABLE'::text))