explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M7o1

Settings
# exclusive inclusive rows x rows loops node
1. 0.664 37.988 ↑ 9.8 58 1

GroupAggregate (cost=3,044.76..3,066.13 rows=569 width=16) (actual time=36.956..37.988 rows=58 loops=1)

  • Group Key: bsv_id
  • Planning time: 25.536 ms
  • Execution time: 42.071 ms
2. 1.572 37.324 ↓ 3.3 1,884 1

Sort (cost=3,044.76..3,046.19 rows=573 width=16) (actual time=36.901..37.324 rows=1,884 loops=1)

  • Sort Key: bsv_id
  • Sort Method: quicksort Memory: 137kB
3. 20.909 35.752 ↓ 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=17.058..35.752 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.021 14.843 ↓ 0.0 0 1

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

5. 0.144 0.144 ↓ 13.4 94 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.144..0.144 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. 0.529 0.529 ↓ 78.4 549 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.529..0.529 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. 0.063 0.063 ↓ 5.6 39 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.063..0.063 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. 0.024 0.024 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.024..0.024 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. 0.238 0.238 ↓ 31.7 222 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.238..0.238 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. 0.098 0.098 ↓ 15.4 108 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.098..0.098 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. 0.693 0.693 ↓ 120.4 843 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.693..0.693 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. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.015..0.015 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. 0.146 0.146 ↓ 18.3 128 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.146..0.146 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. 0.100 0.100 ↓ 5.9 41 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.100..0.100 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. 0.100 0.100 ↓ 3.9 27 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.100..0.100 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. 0.118 0.118 ↓ 18.6 130 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.118..0.118 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. 0.163 0.163 ↓ 8.6 60 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.163..0.163 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. 0.026 0.026 ↑ 3.5 2 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.026..0.026 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. 0.216 0.216 ↓ 33.0 231 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.216..0.216 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. 0.311 0.311 ↓ 53.4 374 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.311..0.311 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. 0.124 0.124 ↓ 18.1 127 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.124..0.124 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. 0.131 0.131 ↓ 19.0 133 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.131..0.131 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. 0.224 0.224 ↓ 32.0 224 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.224..0.224 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. 0.068 0.068 ↓ 7.1 50 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.068..0.068 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. 0.122 0.122 ↓ 16.6 116 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.122..0.122 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. 0.233 0.233 ↓ 35.1 246 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.233..0.233 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. 0.252 0.252 ↓ 39.3 275 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.252..0.252 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. 0.214 0.214 ↓ 39.1 274 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.214..0.214 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. 0.366 0.366 ↓ 41.1 288 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.366..0.366 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. 0.125 0.125 ↓ 24.1 169 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.125..0.125 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. 0.146 0.146 ↓ 19.0 133 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.146..0.146 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. 0.087 0.087 ↓ 5.0 35 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.087..0.087 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. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.022..0.022 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. 0.383 0.383 ↓ 34.6 242 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.383..0.383 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. 0.199 0.199 ↓ 29.7 208 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.199..0.199 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. 0.147 0.147 ↓ 24.3 170 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.147..0.147 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. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.012..0.012 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. 0.699 0.699 ↓ 97.3 681 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.699..0.699 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. 0.566 0.566 ↓ 88.9 622 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.566..0.566 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. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.013..0.013 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. 0.171 0.171 ↓ 32.0 224 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.171..0.171 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. 0.576 0.576 ↓ 60.1 421 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.576..0.576 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. 0.015 0.015 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.015..0.015 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. 0.010 0.010 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.010..0.010 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. 0.082 0.082 ↓ 11.0 77 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.082..0.082 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. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.014..0.014 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. 0.134 0.134 ↓ 11.7 82 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.134..0.134 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. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.014..0.014 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. 0.109 0.109 ↓ 17.6 123 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.109..0.109 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. 0.296 0.296 ↓ 48.0 336 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.296..0.296 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. 0.182 0.182 ↓ 24.4 171 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.182..0.182 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. 0.236 0.236 ↓ 32.6 228 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.236..0.236 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. 0.155 0.155 ↓ 23.7 166 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.155..0.155 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. 0.129 0.129 ↓ 13.1 92 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.129..0.129 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. 0.065 0.065 ↓ 5.7 40 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.065..0.065 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. 0.053 0.053 ↓ 5.7 40 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.053..0.053 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. 0.088 0.088 ↓ 11.6 81 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.088..0.088 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. 0.443 0.443 ↓ 69.9 489 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.443..0.443 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. 0.082 0.082 ↓ 3.1 22 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.082..0.082 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. 0.198 0.198 ↓ 26.9 188 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.198..0.198 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. 0.083 0.083 ↓ 10.0 70 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.083..0.083 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. 0.552 0.552 ↓ 80.0 560 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.552..0.552 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. 0.066 0.066 ↓ 1.9 13 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.066..0.066 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. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.011..0.011 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. 0.095 0.095 ↓ 9.0 63 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.095..0.095 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.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.008..0.008 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. 0.262 0.262 ↓ 38.3 268 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.262..0.262 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. 0.486 0.486 ↓ 74.0 518 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.486..0.486 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. 0.028 0.028 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.028..0.028 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. 0.260 0.260 ↓ 33.6 235 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.260..0.260 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. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.011..0.011 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. 0.074 0.074 ↓ 10.0 70 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.074..0.074 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. 0.030 0.030 ↑ 7.0 1 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.030..0.030 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. 0.093 0.093 ↓ 14.0 98 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.093..0.093 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. 0.079 0.079 ↓ 8.7 61 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.079..0.079 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. 0.165 0.165 ↓ 22.4 157 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.165..0.165 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. 0.052 0.052 ↓ 6.1 43 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.052..0.052 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.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.007..0.007 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. 0.253 0.253 ↓ 43.6 305 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.253..0.253 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. 0.047 0.047 ↓ 5.9 41 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.047..0.047 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. 0.121 0.121 ↓ 12.3 86 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.121..0.121 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. 0.140 0.140 ↓ 18.7 131 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.140..0.140 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. 0.103 0.103 ↓ 16.9 118 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.103..0.103 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. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.011..0.011 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. 0.054 0.054 ↓ 8.7 61 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.054..0.054 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. 0.066 0.066 ↓ 9.1 64 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.066..0.066 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. 0.066 0.066 ↓ 6.1 43 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.066..0.066 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. 0.303 0.303 ↓ 49.9 349 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.303..0.303 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.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.009..0.009 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. 0.115 0.115 ↓ 17.9 125 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.115..0.115 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. 0.188 0.188 ↓ 27.0 189 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.188..0.188 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. 0.061 0.061 ↓ 7.7 54 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.061..0.061 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. 0.166 0.166 ↓ 3.9 27 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.166..0.166 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. 0.060 0.060 ↓ 9.3 65 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.060..0.060 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. 0.111 0.111 ↓ 20.1 141 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.111..0.111 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. 0.055 0.055 ↓ 7.6 53 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.055..0.055 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. 0.084 0.084 ↓ 10.1 71 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.084..0.084 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. 0.024 0.024 ↓ 1.6 11 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.024..0.024 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. 0.014 0.014 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.014..0.014 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. 0.012 0.012 ↓ 0.0 0 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.012..0.012 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. 0.078 0.078 ↓ 12.3 86 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.078..0.078 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. 0.027 0.027 ↑ 1.0 7 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.027..0.027 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. 0.123 0.123 ↓ 17.1 120 1

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.123..0.123 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))