explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vpXK

Settings
# exclusive inclusive rows x rows loops node
1. 0.307 194.158 ↑ 2.8 58 1

GroupAggregate (cost=5,679.01..5,685.20 rows=165 width=16) (actual time=193.655..194.158 rows=58 loops=1)

  • Group Key: appointmen0_.bsv_id
2. 1.714 193.851 ↓ 11.4 1,884 1

Sort (cost=5,679.01..5,679.42 rows=165 width=16) (actual time=193.607..193.851 rows=1,884 loops=1)

  • Sort Key: appointmen0_.bsv_id
  • Sort Method: quicksort Memory: 137kB
3. 1.632 192.137 ↓ 11.4 1,884 1

Nested Loop Left Join (cost=1,498.26..5,672.93 rows=165 width=16) (actual time=53.245..192.137 rows=1,884 loops=1)

  • Filter: ((appointmen1_.id IS NULL) OR ((appointmen1_.appointmentbookingstatus)::text <> 'BOOKED'::text))
4. 129.589 175.433 ↓ 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=53.149..175.433 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))
  • 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.071 45.844 ↓ 0.0 0 1

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

6. 0.532 0.532 ↓ 13.4 94 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((bsv_id = 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'
68. 0.828 0.828 ↓ 38.3 268 1

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

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((bsv_id = 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'
80. 0.650 0.650 ↓ 43.6 305 1

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

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

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

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

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

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

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

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

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

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

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

  • Index Cond: ((bsv_id = 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'
91. 0.340 0.340 ↓ 17.9 125 1

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

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

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

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

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

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

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

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

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

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

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

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

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

Bitmap Index Scan on ix_aps_bsv_date (cost=0.00..14.98 rows=7 width=0) (actual time=0.395..0.395 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'
105. 15.072 15.072 ↓ 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=0.008..0.008 rows=0 loops=1,884)

  • Index Cond: (appointmen0_.id = aps_id)