explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bRD5

Settings
# exclusive inclusive rows x rows loops node
1. 0.675 12,385.041 ↑ 9.8 58 1

GroupAggregate (cost=3,044.76..3,066.13 rows=569 width=16) (actual time=12,383.992..12,385.041 rows=58 loops=1)

  • Group Key: bsv_id
2. 3.227 12,384.366 ↓ 3.3 1,884 1

Sort (cost=3,044.76..3,046.19 rows=573 width=16) (actual time=12,383.920..12,384.366 rows=1,884 loops=1)

  • Sort Key: bsv_id
  • Sort Method: quicksort Memory: 137kB
3. 4,626.791 12,381.139 ↓ 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=8,035.675..12,381.139 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.155 7,754.348 ↓ 0.0 0 1

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

5. 143.433 143.433 ↓ 13.4 94 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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