explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RgOx : Optimization for: plan #Ei2e

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 430.002 103,712.272 ↓ 19.1 19,110 1

Hash Left Join (cost=112,622.62..254,950.53 rows=1,000 width=99) (actual time=973.860..103,712.272 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.003 849.344 ↓ 0.0 0 1

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

4. 0.000 849.341 ↓ 0.0 0 1

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

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

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

6. 0.085 849.333 ↓ 0.0 0 1

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

  • Sort Key: ((scheduled_tasks.details ->> 'unit_space_id'::text)), scheduled_tasks.start_on
  • Sort Method: quicksort Memory: 25kB
7. 849.248 849.248 ↓ 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=849.248..849.248 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. 505.544 102,432.920 ↓ 19.1 19,110 1

Nested Loop Left Join (cost=417.37..142,681.50 rows=1,000 width=308) (actual time=124.397..102,432.920 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. 45.077 101,680.129 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=250.87..142,190.28 rows=1,000 width=256) (actual time=112.474..101,680.129 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,983.789 101,616.033 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=249.74..141,732.63 rows=1,000 width=224) (actual time=112.012..101,616.033 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,578,175
12. 42.790 92,684.299 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=142.87..141,467.51 rows=1,000 width=192) (actual time=78.120..92,684.299 rows=19,019 loops=1)

13. 47.827 5,306.261 ↓ 19.0 19,019 1

Nested Loop Left Join (cost=14.00..12,558.45 rows=1,000 width=137) (actual time=71.492..5,306.261 rows=19,019 loops=1)

14. 53.428 161.342 ↓ 19.0 19,019 1

Hash Left Join (cost=1.77..290.45 rows=1,000 width=73) (actual time=70.966..161.342 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. 14.656 37.143 ↓ 19.0 19,019 1

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

16. 1.187 12.246 ↓ 209.0 209 1

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

17. 1.460 8.551 ↓ 209.0 209 1

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

18. 2.911 2.911 ↓ 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.057..2.911 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.180 4.180 ↑ 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.020..0.020 rows=1 loops=209)

  • Index Cond: ((cid = 235) AND (id = us.property_unit_id))
  • Filter: (property_id = 719,642)
20. 2.508 2.508 ↑ 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.012..0.012 rows=1 loops=209)

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

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

22. 1.740 70.771 ↓ 6,552.0 6,552 1

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

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 423kB
23. 69.031 69.031 ↓ 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=67.423..69.031 rows=6,552 loops=1)

  • Filter: (cid = 235)
24. 570.570 5,097.092 ↑ 1.0 1 19,019

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

25. 247.247 4,526.522 ↓ 2.0 12 19,019

Nested Loop Left Join (cost=6.99..12.20 rows=6 width=8) (actual time=0.201..0.238 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. 133.133 722.722 ↓ 1.8 11 19,019

Nested Loop (cost=0.57..4.62 rows=6 width=16) (actual time=0.017..0.038 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.008..0.008 rows=1 loops=19,019)

  • Index Cond: (property_id = us.property_id)
  • Filter: (cid = us.cid)
28. 437.437 437.437 ↓ 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.023 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. 266.266 3,556.553 ↓ 5.0 5 209,209

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

30. 1,426.425 3,290.287 ↓ 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.120..0.173 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. 76.076 1,863.862 ↓ 0.0 0 19,019

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

32. 209.209 209.209 ↓ 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.011..0.011 rows=76 loops=19,019)

  • Index Cond: (property_id = us.property_id)
33. 1,578.577 1,578.577 ↓ 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.083..0.083 rows=1,296 loops=19,019)

  • Index Cond: (cid = us.cid)
34. 342.342 87,335.248 ↑ 1.0 1 19,019

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

35. 140.413 86,992.906 ↓ 4.0 4 19,019

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

36. 175.539 86,479.393 ↓ 4.0 4 19,019

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

37. 2,149.147 86,079.994 ↓ 4.0 4 19,019

Bitmap Heap Scan on rate_associations ra (cost=106.25..123.78 rows=1 width=20) (actual time=4.463..4.526 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. 114.114 83,930.847 ↓ 0.0 0 19,019

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

39. 399.399 399.399 ↑ 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.021..0.021 rows=231 loops=19,019)

  • Index Cond: (property_id = pf.property_id)
40. 83,417.334 83,417.334 ↓ 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.386..4.386 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,916.092 2,947.945 ↓ 2,081.0 2,081 19,019

Materialize (cost=106.87..237.62 rows=1 width=48) (actual time=0.001..0.155 rows=2,081 loops=19,019)

44. 12.537 31.853 ↓ 2,081.0 2,081 1

Nested Loop (cost=106.87..237.62 rows=1 width=48) (actual time=3.200..31.853 rows=2,081 loops=1)

45. 2.711 13.073 ↓ 2,081.0 2,081 1

Nested Loop (cost=106.45..235.29 rows=1 width=36) (actual time=3.137..13.073 rows=2,081 loops=1)

46. 1.252 6.200 ↓ 2,081.0 2,081 1

Hash Join (cost=106.30..235.11 rows=1 width=28) (actual time=3.083..6.200 rows=2,081 loops=1)

  • Hash Cond: (ocus_1.organization_contract_id = oc.id)
47. 1.953 1.953 ↑ 1.1 2,121 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.055..1.953 rows=2,121 loops=1)

  • Index Cond: (cid = 235)
  • Filter: (deleted_on IS NULL)
  • Rows Removed by Filter: 375
48. 0.080 2.995 ↓ 273.0 273 1

Hash (cost=106.01..106.01 rows=1 width=28) (actual time=2.995..2.995 rows=273 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
49. 0.938 2.915 ↓ 273.0 273 1

Merge Join (cost=25.05..106.01 rows=1 width=28) (actual time=0.296..2.915 rows=273 loops=1)

  • Merge Cond: (lsw_1.property_id = oc.property_id)
  • Join Filter: ((oc.id = lsw_1.organization_contract_id) AND (oc.lease_start_window_id = lsw_1.id))
  • Rows Removed by Join Filter: 5,050
50. 1.440 1.440 ↓ 3.3 532 1

Index Scan using idx_lease_start_windows_property_id on lease_start_windows lsw_1 (cost=0.29..588.86 rows=159 width=24) (actual time=0.021..1.440 rows=532 loops=1)

  • Filter: ((deleted_on IS NULL) AND (is_active IS TRUE) AND (cid = 235) AND (lease_term_type_id = 2))
  • Rows Removed by Filter: 1,411
51. 0.375 0.537 ↓ 19.9 5,219 1

Sort (cost=24.76..25.42 rows=262 width=24) (actual time=0.236..0.537 rows=5,219 loops=1)

  • Sort Key: oc.property_id
  • Sort Method: quicksort Memory: 46kB
52. 0.162 0.162 ↓ 1.0 273 1

Seq Scan on organization_contracts oc (cost=0.00..14.24 rows=262 width=24) (actual time=0.019..0.162 rows=273 loops=1)

  • Filter: ((organization_contract_status_type_id = ANY ('{1,2}'::integer[])) AND (cid = 235))
  • Rows Removed by Filter: 154
53. 4.162 4.162 ↑ 1.0 1 2,081

Index Scan using pk_organizations on organizations o (cost=0.14..0.18 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=2,081)

  • Index Cond: ((cid = 235) AND (id = oc.organization_id))
54. 6.243 6.243 ↑ 1.0 1 2,081

Index Scan using idx_customers_id on customers c_1 (cost=0.42..2.33 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=2,081)

  • Index Cond: (id = o.customer_id)
  • Filter: (cid = 235)
55. 18.576 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.057 0.443 ↓ 7.0 7 1

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

57. 0.018 0.218 ↓ 7.0 7 1

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

  • Filter: ((COALESCE(ms.maintenance_status_type_id, 0) <> 3) AND (COALESCE(ms.maintenance_status_type_id, 0) <> 4))
58. 0.151 0.151 ↓ 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.063..0.151 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.049 0.049 ↑ 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.007..0.007 rows=1 loops=7)

  • Index Cond: (mr.maintenance_status_id = id)
  • Filter: ((cid = 235) AND (mr.cid = cid))
60. 0.168 0.168 ↑ 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.024 rows=1 loops=7)

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

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

62. 2.191 11.554 ↓ 25.2 126 1

Hash Left Join (cost=166.50..316.21 rows=5 width=72) (actual time=1.762..11.554 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.193 7.941 ↓ 25.2 126 1

Nested Loop Left Join (cost=2.67..152.08 rows=5 width=100) (actual time=0.279..7.941 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.158 7.370 ↓ 25.2 126 1

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

65. 0.199 6.708 ↓ 126.0 126 1

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

66. 0.180 5.879 ↓ 126.0 126 1

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

67. 0.267 4.691 ↓ 126.0 126 1

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

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

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

69. 0.679 0.679 ↓ 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.050..0.679 rows=134 loops=1)

  • Index Cond: ((property_id = 719,642) AND (lease_status_type_id = ANY ('{3,4,5}'::integer[])))
  • Filter: (cid = 235)
70. 2.010 2.010 ↑ 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.014..0.015 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.512 1.512 ↑ 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.012..0.012 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.504 0.504 ↑ 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.004..0.004 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.607 1.422 ↓ 1.0 2,496 1

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

  • Buckets: 4,096 Batches: 1 Memory Usage: 149kB
77. 0.815 0.815 ↓ 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.024..0.815 rows=2,496 loops=1)

  • Index Cond: (cid = 235)
78. 0.001 849.350 ↓ 0.0 0 1

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

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

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

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