explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3G5e

Settings
# exclusive inclusive rows x rows loops node
1. 0.699 15,749.158 ↑ 2.8 58 1

GroupAggregate (cost=5,679.01..5,685.20 rows=165 width=16) (actual time=15,748.082..15,749.158 rows=58 loops=1)

  • Group Key: appointmen0_.bsv_id
2. 3.219 15,748.459 ↓ 11.4 1,884 1

Sort (cost=5,679.01..5,679.42 rows=165 width=16) (actual time=15,748.022..15,748.459 rows=1,884 loops=1)

  • Sort Key: appointmen0_.bsv_id
  • Sort Method: quicksort Memory: 137kB
3. 5.355 15,745.240 ↓ 11.4 1,884 1

Nested Loop Left Join (cost=1,498.26..5,672.93 rows=165 width=16) (actual time=9,434.527..15,745.240 rows=1,884 loops=1)

  • Filter: ((appointmen1_.id IS NULL) OR ((appointmen1_.appointmentbookingstatus)::text <> 'BOOKED'::text))
4. 4,500.454 13,627.921 ↓ 3.3 1,884 1

Bitmap Heap Scan on aps_appointment_slot appointmen0_ (cost=1,497.70..3,018.51 rows=573 width=24) (actual time=9,417.032..13,627.921 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
5. 0.108 9,127.467 ↓ 0.0 0 1

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

6. 0.174 0.174 ↓ 13.4 94 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=116.404..116.404 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))
105. 2,111.964 2,111.964 ↓ 0.0 0 1,884

Index Scan using ix_apb_aps_id on apb_appointment_booking appointmen1_ (cost=0.56..4.60 rows=1 width=24) (actual time=1.121..1.121 rows=0 loops=1,884)

  • Index Cond: (appointmen0_.id = aps_id)