explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ei2e

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 380.126 96,354.016 ↓ 19.1 19,110 1

Hash Left Join (cost=112,762.84..255,749.10 rows=1,000 width=99) (actual time=484.454..96,354.016 rows=19,110 loops=1)

  • Hash Cond: ((us.cid = est.cid) AND (us.property_id = est.property_id) AND (us.id = est.unit_space_id))
  • Join Filter: (((generate_series.generate_series)::date >= est.start_date) AND ((generate_series.generate_series)::date <= (est.end_date)::date))
2.          

CTE exclusion_scheduled_task

3. 0.002 388.482 ↓ 0.0 0 1

Nested Loop Left Join (cost=112,203.12..112,205.21 rows=1 width=64) (actual time=388.482..388.482 rows=0 loops=1)

4. 0.001 388.480 ↓ 0.0 0 1

Subquery Scan on st (cost=112,202.84..112,202.91 rows=1 width=60) (actual time=388.480..388.480 rows=0 loops=1)

  • Filter: ((st.end_date IS NOT NULL) AND (st.prior_scheduled_task_id IS NULL))
5. 0.005 388.479 ↓ 0.0 0 1

WindowAgg (cost=112,202.84..112,202.90 rows=1 width=100) (actual time=388.479..388.479 rows=0 loops=1)

6. 0.011 388.474 ↓ 0.0 0 1

Sort (cost=112,202.84..112,202.85 rows=1 width=675) (actual time=388.474..388.474 rows=0 loops=1)

  • Sort Key: ((scheduled_tasks.details ->> 'unit_space_id'::text)), scheduled_tasks.start_on
  • Sort Method: quicksort Memory: 25kB
7. 388.463 388.463 ↓ 0.0 0 1

Index Scan using pk_scheduled_tasks on scheduled_tasks (cost=0.42..112,202.83 rows=1 width=675) (actual time=388.462..388.463 rows=0 loops=1)

  • Index Cond: (cid = 235)
  • Filter: ((property_id = 719,642) AND (schedule_type_id = 11))
  • Rows Removed by Filter: 317,823
8. 0.000 0.000 ↓ 0.0 0

Index Scan using uk_unit_space_exclusions_cid_property_id_unit_exclusion_reason_ on unit_space_exclusions use (cost=0.28..2.30 rows=1 width=16) (never executed)

  • Index Cond: ((st.cid = cid) AND (st.property_id = property_id) AND (st.unit_exclusion_reason_type_id = unit_exclusion_reason_type_id))
9. 459.997 95,585.403 ↓ 19.1 19,110 1

Nested Loop Left Join (cost=557.59..143,480.07 rows=1,000 width=308) (actual time=95.880..95,585.403 rows=19,110 loops=1)

  • Join Filter: ((cl.cid = us.cid) AND (cl.property_id = us.property_id) AND (cl.unit_space_id = us.id) AND ((generate_series.generate_series)::date >= COALESCE(li.lease_start_date, (generate_series.generate_series)::date)) AND ((generate_series.generate_series)::date <= COALESCE(li.lease_end_date, (generate_series.generate_series)::date)))
  • Rows Removed by Join Filter: 2,394,029
10. 37.881 94,897.178 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=391.09..142,988.85 rows=1,000 width=256) (actual time=84.925..94,897.178 rows=19,019 loops=1)

  • Join Filter: ((mr.cid = us.cid) AND (mr.property_id = us.property_id) AND (mr.unit_space_id = us.id) AND ((generate_series.generate_series)::date >= COALESCE((mrd.scheduled_start_datetime)::date, (generate_series.generate_series)::date)) AND ((generate_series.generate_series)::date <= COALESCE((mrd.scheduled_end_datetime)::date, (generate_series.generate_series)::date)))
  • Rows Removed by Join Filter: 133,133
11. 5,567.702 94,840.278 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=389.96..142,531.20 rows=1,000 width=224) (actual time=84.564..94,840.278 rows=19,019 loops=1)

  • Join Filter: ((oc.cid = us.cid) AND (ocus_1.unit_space_id = us.id) AND ((generate_series.generate_series)::date >= lsw_1.start_date) AND ((generate_series.generate_series)::date <= lsw_1.end_date))
  • Rows Removed by Join Filter: 39,597,194
12. 46.370 86,705.011 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=142.87..141,467.51 rows=1,000 width=192) (actual time=76.512..86,705.011 rows=19,019 loops=1)

13. 42.100 4,876.941 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=14.00..12,558.45 rows=1,000 width=137) (actual time=70.694..4,876.941 rows=19,019 loops=1)

14. 51.668 156.167 ↓ 19.0 19,019 1

Hash Left Join (cost=1.77..290.45 rows=1,000 width=73) (actual time=70.322..156.167 rows=19,019 loops=1)

  • Hash Cond: ((us.cid = laus.cid) AND (us.id = laus.unit_space_id) AND ((generate_series.generate_series)::date = laus.move_in_date))
15. 13.253 34.405 ↓ 19.0 19,019 1

Nested Loop (cost=0.87..277.05 rows=1,000 width=61) (actual time=0.167..34.405 rows=19,019 loops=1)

16. 1.272 11.329 ↓ 209.0 209 1

Nested Loop (cost=0.87..257.04 rows=1 width=53) (actual time=0.119..11.329 rows=209 loops=1)

17. 1.280 7.758 ↓ 209.0 209 1

Nested Loop (cost=0.58..255.59 rows=1 width=41) (actual time=0.085..7.758 rows=209 loops=1)

18. 2.089 2.089 ↓ 3.2 209 1

Index Scan using idx_unit_spaces_company_property_id on unit_spaces us (cost=0.29..111.76 rows=66 width=37) (actual time=0.046..2.089 rows=209 loops=1)

  • Index Cond: ((cid = 235) AND (property_id = 719,642))
  • Filter: ((deleted_on IS NULL) AND (occupancy_type_id <> 2))
  • Rows Removed by Filter: 47
19. 4.389 4.389 ↑ 1.0 1 209

Index Scan using pk_property_units on property_units pu (cost=0.29..2.18 rows=1 width=16) (actual time=0.021..0.021 rows=1 loops=209)

  • Index Cond: ((cid = 235) AND (id = us.property_unit_id))
  • Filter: (property_id = 719,642)
20. 2.299 2.299 ↑ 1.0 1 209

Index Scan using pk_property_floorplans on property_floorplans pf (cost=0.28..1.45 rows=1 width=12) (actual time=0.011..0.011 rows=1 loops=209)

  • Index Cond: ((cid = 235) AND (id = us.property_floorplan_id))
21. 9.823 9.823 ↑ 11.0 91 209

Function Scan on generate_series (cost=0.01..10.01 rows=1,000 width=8) (actual time=0.001..0.047 rows=91 loops=209)

22. 1.733 70.094 ↓ 6,552.0 6,552 1

Hash (cost=0.88..0.88 rows=1 width=24) (actual time=70.094..70.094 rows=6,552 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 423kB
23. 68.361 68.361 ↓ 6,552.0 6,552 1

Function Scan on load_available_unit_spaces laus (cost=0.25..0.88 rows=1 width=24) (actual time=66.752..68.361 rows=6,552 loops=1)

  • Filter: (cid = 235)
24. 532.532 4,678.674 ↑ 1.0 1 19,019

Aggregate (cost=12.23..12.25 rows=1 width=64) (actual time=0.246..0.246 rows=1 loops=19,019)

25. 361.361 4,146.142 ↓ 2.0 12 19,019

Nested Loop Left Join (cost=6.99..12.20 rows=6 width=8) (actual time=0.184..0.218 rows=12 loops=19,019)

  • Join Filter: ((lt_1.lease_term_type_id = 2) AND (lt_1.cid = lsw_2.cid) AND (lsw_2.property_id = pcs.property_id) AND (lt_1.id = lsw_2.lease_term_id))
  • Rows Removed by Join Filter: 50
26. 95.095 646.646 ↓ 1.8 11 19,019

Nested Loop (cost=0.57..4.62 rows=6 width=16) (actual time=0.016..0.034 rows=11 loops=19,019)

27. 152.152 152.152 ↑ 1.0 1 19,019

Index Scan using idx_property_charge_settings_property_id on property_charge_settings pcs (cost=0.28..2.30 rows=1 width=12) (actual time=0.007..0.008 rows=1 loops=19,019)

  • Index Cond: (property_id = us.property_id)
  • Filter: (cid = us.cid)
28. 399.399 399.399 ↓ 11.0 11 19,019

Index Scan using idx_lease_terms_master on lease_terms lt_1 (cost=0.29..2.30 rows=1 width=16) (actual time=0.006..0.021 rows=11 loops=19,019)

  • Index Cond: ((cid = us.cid) AND (lease_term_structure_id = pcs.lease_term_structure_id))
  • Filter: (deleted_on IS NULL)
  • Rows Removed by Filter: 2
29. 114.114 3,138.135 ↓ 5.0 5 209,209

Materialize (cost=6.42..7.45 rows=1 width=16) (actual time=0.011..0.015 rows=5 loops=209,209)

30. 1,312.311 3,024.021 ↓ 5.0 5 19,019

Bitmap Heap Scan on lease_start_windows lsw_2 (cost=6.42..7.44 rows=1 width=16) (actual time=0.110..0.159 rows=5 loops=19,019)

  • Recheck Cond: ((property_id = us.property_id) AND (cid = us.cid))
  • Filter: ((deleted_on IS NULL) AND (is_active IS TRUE) AND (end_date >= (generate_series.generate_series)::date))
  • Rows Removed by Filter: 71
  • Heap Blocks: exact=494,494
31. 57.057 1,711.710 ↓ 0.0 0 19,019

BitmapAnd (cost=6.42..6.42 rows=1 width=0) (actual time=0.090..0.090 rows=0 loops=19,019)

32. 190.190 190.190 ↓ 9.5 76 19,019

Bitmap Index Scan on idx_lease_start_windows_property_id (cost=0.00..1.34 rows=8 width=0) (actual time=0.010..0.010 rows=76 loops=19,019)

  • Index Cond: (property_id = us.property_id)
33. 1,464.463 1,464.463 ↓ 3.8 1,296 19,019

Bitmap Index Scan on idx_lease_start_window_cid_structure_dates (cost=0.00..4.83 rows=339 width=0) (actual time=0.077..0.077 rows=1,296 loops=19,019)

  • Index Cond: (cid = us.cid)
34. 304.304 81,781.700 ↑ 1.0 1 19,019

Aggregate (cost=128.87..128.89 rows=1 width=67) (actual time=4.300..4.300 rows=1 loops=19,019)

35. 83.356 81,477.396 ↓ 4.0 4 19,019

Nested Loop Left Join (cost=106.82..128.84 rows=1 width=20) (actual time=4.201..4.284 rows=4 loops=19,019)

36. 137.501 81,020.940 ↓ 4.0 4 19,019

Nested Loop Left Join (cost=106.53..126.10 rows=1 width=24) (actual time=4.193..4.260 rows=4 loops=19,019)

37. 1,939.938 80,659.579 ↓ 4.0 4 19,019

Bitmap Heap Scan on rate_associations ra (cost=106.25..123.78 rows=1 width=20) (actual time=4.184..4.241 rows=4 loops=19,019)

  • Recheck Cond: ((property_id = pf.property_id) AND (cid = pf.cid))
  • Filter: ((ar_origin_id = ANY ('{2,3,6}'::integer[])) AND (ar_cascade_reference_id = CASE WHEN (ar_cascade_id = 4) THEN us.id WHEN (ar_cascade_id = 3) THEN us.unit_type_id WHEN (ar_cascade_id = 2) THEN pf.id WHEN (ar_cascade_id = 1) THEN us.property_id ELSE NULL::integer END))
  • Rows Removed by Filter: 227
  • Heap Blocks: exact=551,551
38. 95.095 78,719.641 ↓ 0.0 0 19,019

BitmapAnd (cost=106.25..106.25 rows=17 width=0) (actual time=4.139..4.139 rows=0 loops=19,019)

39. 380.380 380.380 ↑ 1.2 231 19,019

Bitmap Index Scan on idx_rate_associations_property_id (cost=0.00..3.55 rows=284 width=0) (actual time=0.020..0.020 rows=231 loops=19,019)

  • Index Cond: (property_id = pf.property_id)
40. 78,244.166 78,244.166 ↓ 6.6 64,692 19,019

Bitmap Index Scan on pk_rate_associations (cost=0.00..102.45 rows=9,871 width=0) (actual time=4.114..4.114 rows=64,692 loops=19,019)

  • Index Cond: (cid = pf.cid)
41. 223.860 223.860 ↓ 0.0 0 74,620

Index Only Scan using pk_amenities on amenities a (cost=0.28..2.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=74,620)

  • Index Cond: ((cid = ra.cid) AND (cid = pf.cid) AND (id = ra.ar_origin_reference_id))
  • Heap Fetches: 3,458
42. 373.100 373.100 ↑ 1.0 1 74,620

Index Scan using pk_specials on specials s (cost=0.28..2.33 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=74,620)

  • Index Cond: ((cid = ra.cid) AND (cid = pf.cid) AND (id = ra.ar_origin_reference_id))
  • Filter: ((NOT coupon_code_required) AND show_on_website AND is_active AND (deleted_on IS NULL) AND (special_type_id <> 5) AND (special_recipient_id = 2) AND ((generate_series.generate_series)::date >= COALESCE(start_date, (generate_series.generate_series)::date)) AND ((generate_series.generate_series)::date <= COALESCE(end_date, (generate_series.generate_series)::date)))
  • Rows Removed by Filter: 0
43. 2,560.638 2,567.565 ↓ 83.3 2,082 19,019

Materialize (cost=247.09..376.25 rows=25 width=48) (actual time=0.001..0.135 rows=2,082 loops=19,019)

44. 0.715 6.927 ↓ 83.3 2,082 1

Hash Join (cost=247.09..376.13 rows=25 width=48) (actual time=5.195..6.927 rows=2,082 loops=1)

  • Hash Cond: (ocus_1.organization_contract_id = oc.id)
45. 1.056 1.056 ↑ 1.1 2,122 1

Index Scan using pk_organization_contract_unit_spaces on organization_contract_unit_spaces ocus_1 (cost=0.28..120.48 rows=2,281 width=12) (actual time=0.031..1.056 rows=2,122 loops=1)

  • Index Cond: (cid = 235)
  • Filter: (deleted_on IS NULL)
  • Rows Removed by Filter: 374
46. 0.195 5.156 ↓ 68.2 273 1

Hash (cost=246.76..246.76 rows=4 width=48) (actual time=5.156..5.156 rows=273 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 79kB
47. 1.782 4.961 ↓ 68.2 273 1

Nested Loop (cost=6.61..246.76 rows=4 width=48) (actual time=0.168..4.961 rows=273 loops=1)

48. 0.293 1.814 ↓ 21.0 273 1

Nested Loop (cost=6.19..216.49 rows=13 width=32) (actual time=0.126..1.814 rows=273 loops=1)

49. 0.143 0.429 ↓ 1.6 273 1

Hash Join (cost=5.90..20.84 rows=175 width=28) (actual time=0.102..0.429 rows=273 loops=1)

  • Hash Cond: (oc.organization_id = o.id)
50. 0.206 0.206 ↓ 1.0 273 1

Seq Scan on organization_contracts oc (cost=0.00..14.24 rows=262 width=20) (actual time=0.017..0.206 rows=273 loops=1)

  • Filter: ((organization_contract_status_type_id = ANY ('{1,2}'::integer[])) AND (cid = 235))
  • Rows Removed by Filter: 154
51. 0.026 0.080 ↓ 1.1 133 1

Hash (cost=4.34..4.34 rows=125 width=12) (actual time=0.080..0.080 rows=133 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
52. 0.054 0.054 ↓ 1.1 133 1

Seq Scan on organizations o (cost=0.00..4.34 rows=125 width=12) (actual time=0.016..0.054 rows=133 loops=1)

  • Filter: (cid = 235)
  • Rows Removed by Filter: 62
53. 1.092 1.092 ↑ 1.0 1 273

Index Scan using pk_lease_start_windows on lease_start_windows lsw_1 (cost=0.29..1.12 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=273)

  • Index Cond: ((cid = 235) AND (id = oc.lease_start_window_id))
  • Filter: ((deleted_on IS NULL) AND (is_active IS TRUE))
54. 1.365 1.365 ↑ 1.0 1 273

Index Scan using idx_customers_id on customers c_1 (cost=0.42..2.33 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=273)

  • Index Cond: (id = o.customer_id)
  • Filter: (cid = 235)
55. 18.671 19.019 ↓ 7.0 7 19,019

Materialize (cost=1.13..417.65 rows=1 width=60) (actual time=0.000..0.001 rows=7 loops=19,019)

56. 0.049 0.348 ↓ 7.0 7 1

Nested Loop (cost=1.13..417.65 rows=1 width=60) (actual time=0.102..0.348 rows=7 loops=1)

57. 0.011 0.124 ↓ 7.0 7 1

Nested Loop Left Join (cost=0.70..415.19 rows=1 width=16) (actual time=0.056..0.124 rows=7 loops=1)

  • Filter: ((COALESCE(ms.maintenance_status_type_id, 0) <> 3) AND (COALESCE(ms.maintenance_status_type_id, 0) <> 4))
58. 0.085 0.085 ↓ 7.0 7 1

Index Scan using idx_maintenance_requests_property_id on maintenance_requests mr (cost=0.43..412.88 rows=1 width=20) (actual time=0.042..0.085 rows=7 loops=1)

  • Index Cond: (property_id = 719,642)
  • Filter: ((parent_maintenance_request_id IS NULL) AND (deleted_on IS NULL) AND (cid = cid) AND (cid = 235) AND (maintenance_request_type_id = 1))
  • Rows Removed by Filter: 5
59. 0.028 0.028 ↑ 1.0 1 7

Index Scan using idx_maintenance_statuses_id on maintenance_statuses ms (cost=0.27..2.30 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=7)

  • Index Cond: (mr.maintenance_status_id = id)
  • Filter: ((cid = 235) AND (mr.cid = cid))
60. 0.175 0.175 ↑ 1.0 1 7

Index Scan using idx_maintenance_request_details_maintenance_request_id on maintenance_request_details mrd (cost=0.43..2.45 rows=1 width=20) (actual time=0.024..0.025 rows=1 loops=7)

  • Index Cond: (maintenance_request_id = mr.id)
61. 217.490 228.228 ↓ 25.2 126 19,019

Materialize (cost=166.50..316.24 rows=5 width=72) (actual time=0.000..0.012 rows=126 loops=19,019)

62. 2.016 10.738 ↓ 25.2 126 1

Hash Left Join (cost=166.50..316.21 rows=5 width=72) (actual time=1.560..10.738 rows=126 loops=1)

  • Hash Cond: ((cl.cid = ocus.cid) AND (cl.unit_space_id = ocus.unit_space_id) AND (lsw.organization_contract_id = ocus.organization_contract_id))
63. 0.116 7.368 ↓ 25.2 126 1

Nested Loop Left Join (cost=2.67..152.08 rows=5 width=100) (actual time=0.166..7.368 rows=126 loops=1)

  • Join Filter: ((lt.cid = lsw.cid) AND (lsw.property_id = cl.property_id) AND (lt.id = lsw.lease_term_id))
  • Rows Removed by Join Filter: 1
64. 0.234 6.874 ↓ 25.2 126 1

Nested Loop (cost=2.38..150.44 rows=5 width=96) (actual time=0.162..6.874 rows=126 loops=1)

65. 0.172 6.262 ↓ 126.0 126 1

Nested Loop Left Join (cost=2.10..150.13 rows=1 width=88) (actual time=0.142..6.262 rows=126 loops=1)

66. 0.144 5.460 ↓ 126.0 126 1

Nested Loop Left Join (cost=1.68..147.68 rows=1 width=86) (actual time=0.125..5.460 rows=126 loops=1)

67. 0.180 4.308 ↓ 126.0 126 1

Nested Loop (cost=1.26..145.26 rows=1 width=82) (actual time=0.100..4.308 rows=126 loops=1)

  • Join Filter: ((cl.id = li.lease_id) AND (cl.active_lease_interval_id = li.id))
68. 0.274 2.742 ↓ 126.0 126 1

Nested Loop (cost=0.84..144.74 rows=1 width=70) (actual time=0.069..2.742 rows=126 loops=1)

69. 0.726 0.726 ↓ 4.5 134 1

Index Scan using idx_cached_leases_property_id_lease_status_type_id on cached_leases cl (cost=0.42..71.09 rows=30 width=54) (actual time=0.035..0.726 rows=134 loops=1)

  • Index Cond: ((property_id = 719,642) AND (lease_status_type_id = ANY ('{3,4,5}'::integer[])))
  • Filter: (cid = 235)
70. 1.742 1.742 ↑ 1.0 1 134

Index Scan using idx_cached_applications_lease_interval_id on cached_applications ca (cost=0.42..2.45 rows=1 width=24) (actual time=0.013..0.013 rows=1 loops=134)

  • Index Cond: (lease_interval_id = cl.active_lease_interval_id)
  • Filter: ((cid = 235) AND (cl.id = lease_id) AND (cl.unit_space_id = unit_space_id))
  • Rows Removed by Filter: 0
71. 1.386 1.386 ↑ 1.0 1 126

Index Scan using idx_lease_intervals on lease_intervals li (cost=0.42..0.50 rows=1 width=28) (actual time=0.011..0.011 rows=1 loops=126)

  • Index Cond: (id = ca.lease_interval_id)
  • Filter: ((cid = 235) AND (ca.lease_id = lease_id))
72. 1.008 1.008 ↑ 1.0 1 126

Index Scan using idx_lease_unit_spaces_lease_id on lease_unit_spaces lus (cost=0.42..2.41 rows=1 width=16) (actual time=0.007..0.008 rows=1 loops=126)

  • Index Cond: (cl.id = lease_id)
  • Filter: ((cid = 235) AND (cl.cid = cid) AND (unit_space_id = cl.unit_space_id))
73. 0.630 0.630 ↑ 1.0 1 126

Index Scan using idx_customers_id on customers c (cost=0.42..2.44 rows=1 width=10) (actual time=0.005..0.005 rows=1 loops=126)

  • Index Cond: (cl.primary_customer_id = id)
  • Filter: ((cid = 235) AND (cl.cid = cid))
74. 0.378 0.378 ↑ 1.0 1 126

Index Scan using pk_lease_terms on lease_terms lt (cost=0.29..0.31 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=126)

  • Index Cond: ((cid = 235) AND (id = li.lease_term_id))
75. 0.378 0.378 ↑ 1.0 1 126

Index Scan using pk_lease_start_windows on lease_start_windows lsw (cost=0.29..0.31 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=126)

  • Index Cond: ((cid = 235) AND (id = li.lease_start_window_id))
  • Filter: ((deleted_on IS NULL) AND (is_active IS TRUE) AND (property_id = 719,642))
76. 0.631 1.354 ↓ 1.0 2,496 1

Hash (cost=120.48..120.48 rows=2,477 width=16) (actual time=1.354..1.354 rows=2,496 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 149kB
77. 0.723 0.723 ↓ 1.0 2,496 1

Index Scan using pk_organization_contract_unit_spaces on organization_contract_unit_spaces ocus (cost=0.28..120.48 rows=2,477 width=16) (actual time=0.017..0.723 rows=2,496 loops=1)

  • Index Cond: (cid = 235)
78. 0.002 388.487 ↓ 0.0 0 1

Hash (cost=0.03..0.03 rows=1 width=32) (actual time=388.487..388.487 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
79. 388.485 388.485 ↓ 0.0 0 1

CTE Scan on exclusion_scheduled_task est (cost=0.00..0.03 rows=1 width=32) (actual time=388.485..388.485 rows=0 loops=1)

  • Filter: ((cid = 235) AND (property_id = 719,642))