explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AvDU

Settings
# exclusive inclusive rows x rows loops node
1. 1.500 4,247,216.702 ↓ 51.2 3,586 1

Sort (cost=844,086.99..844,087.17 rows=70 width=117) (actual time=4,247,216.279..4,247,216.702 rows=3,586 loops=1)

  • Sort Key: sub_query1.date
  • Sort Method: quicksort Memory: 377kB
  • Buffers: shared hit=3121480095 read=4322 dirtied=2, temp read=11285 written=11287
2.          

CTE eligible_ar_codes

3. 0.003 0.035 ↓ 0.0 0 1

Nested Loop (cost=0.7..7.96 rows=1 width=12) (actual time=0.035..0.035 rows=0 loops=1)

  • Buffers: shared hit=11
4. 0.003 0.030 ↑ 1.0 2 1

Nested Loop (cost=0.55..7.07 rows=2 width=16) (actual time=0.027..0.03 rows=2 loops=1)

  • Buffers: shared hit=9
5. 0.019 0.019 ↑ 1.0 2 1

Index Scan using idx_property_late_fees_property_id on property_late_fee_formulas plff (cost=0.28..2.43 rows=2 width=8) (actual time=0.018..0.019 rows=2 loops=1)

  • Index Cond: (plff.property_id = 518720)
  • Filter: (plff.cid = 2342)
  • Buffers: shared hit=3
6. 0.008 0.008 ↑ 1.0 1 2

Index Scan using idx_late_fee_formulas on late_fee_formulas lff_1 (cost=0.28..2.31 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: (lff_1.id = plff.late_fee_formula_id)
  • Filter: ((NOT lff_1.is_disabled) AND (lff_1.cid = 2342))
  • Buffers: shared hit=6
7. 0.002 0.002 ↓ 0.0 0 2

Index Scan using idx_late_fee_formula_ar_codes_late_fee_formula_id on late_fee_formula_ar_codes lffac (cost=0.15..0.41 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: (lffac.late_fee_formula_id = lff_1.id)
  • Filter: (lffac.cid = 2342)
  • Buffers: shared hit=2
8.          

CTE property_holiday_list

9. 0.000 0.013 ↓ 0.0 0 1

Nested Loop (cost=0.14..3.62 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=1
10. 0.013 0.013 ↓ 0.0 0 1

Index Scan using idx_property_holidays_property_id on property_holidays ph (cost=0.14..1.8 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (ph.property_id = 518720)
  • Filter: (ph.cid = 2342)
  • Buffers: shared hit=1
11. 0.000 0.000 ↓ 0.0 0 0

Seq Scan on company_holidays ch (cost=0..1.79 rows=1 width=12) (never executed)

  • Filter: ((ch.date >= '04/07/2019'::date) AND (ch.date <= '06/05/2019'::date) AND (ch.cid = 2342))
12.          

CTE eligible_property_preferences

13. 0.081 0.081 ↓ 2.0 2 1

Index Scan using uk_property_preferences_cid_property_id_key on property_preferences property_preferences (cost=0.41..3.88 rows=1 width=53) (actual time=0.062..0.081 rows=2 loops=1)

  • Index Cond: ((property_preferences.cid = 2342) AND (property_preferences.property_id = 518720) AND ((property_preferences.key)::text = ANY ('{ENABLED_LATE_FEES,CHARGE_LATE_FEES_FOR_EVICTING_LEASES}'::text[])))
  • Buffers: shared hit=11
14.          

CTE eligible_days

15. 0.307 0.307 ↓ 1.0 60 1

Index Only Scan using uk_days_date on days days_2 (cost=0.29..3.8 rows=59 width=16) (actual time=0.015..0.307 rows=60 loops=1)

  • Index Cond: ((days_2.date >= '04/07/2019 00:00:00'::timestamp without time zone) AND (days_2.date <= '06/05/2019 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=3
16.          

CTE eligible_late_fee_batch_details

17. 0.392 0.392 ↓ 0.0 0 1

Index Scan using idx_late_fee_batch_details_property_id on late_fee_batch_details late_fee_batch_details (cost=0.42..509.99 rows=59 width=192) (actual time=0.392..0.392 rows=0 loops=1)

  • Index Cond: (late_fee_batch_details.property_id = 518720)
  • Filter: ((late_fee_batch_details.post_date >= '04/07/2019'::date) AND (late_fee_batch_details.post_date <= '06/05/2019'::date) AND (late_fee_batch_details.cid = 2342))
  • Buffers: shared hit=3 read=36
18.          

CTE property_waive_late_fees

19. 0.000 0.000 ↓ 0.0 0 1

CTE Scan on eligible_late_fee_batch_details lfbd_1 (cost=0..4.42 rows=1 width=20) (actual time=0..0 rows=0 loops=1)

  • Filter: ((lfbd_1.post_date >= '04/07/2019'::date) AND (lfbd_1.post_date <= '06/05/2019'::date) AND (lfbd_1.cid = 2342) AND (lfbd_1.property_id = 518720) AND (lfbd_1.late_fee_action_type_id = 2) AND (lfbd_1.is_expired = 0))
20. 11.968 4,247,215.202 ↓ 51.2 3,586 1

Merge Join (cost=290,746.06..843,551.17 rows=70 width=117) (actual time=4,245,611.98..4,247,215.202 rows=3,586 loops=1)

  • Buffers: shared hit=3121480095 read=4322 dirtied=2, temp read=11285 written=11287
21. 195.195 3,649.736 ↑ 467.5 5,977 1

Aggregate (cost=284,043.31..745,503.9 rows=2,794,476 width=16) (actual time=2,212.143..3,649.736 rows=5,977 loops=1)

  • Filter: (sum(art.transaction_amount) > '0'::numeric)
  • Buffers: shared hit=109678 read=1443 dirtied=1, temp read=11285 written=11287
22. 0.000 3,454.541 ↑ 6.6 371,705 1

Gather Merge (cost=284,043.31..623,883.98 rows=2,463,956 width=48) (actual time=2,206.324..3,454.541 rows=371,705 loops=1)

  • Buffers: shared hit=331638 read=4107 dirtied=1, temp read=33674 written=33680
23. 2,096.433 9,730.236 ↑ 9.9 123,902 3

Aggregate (cost=283,043.29..338,482.3 rows=1,231,978 width=48) (actual time=2,189.88..3,243.412 rows=123,902 loops=3)

  • Buffers: shared hit=331638 read=4107 dirtied=1, temp read=33674 written=33680
24. 5,113.608 7,633.803 ↓ 2.3 2,873,870 3

Sort (cost=283,043.29..286,123.23 rows=1,231,978 width=21) (actual time=2,189.866..2,544.601 rows=2,873,870 loops=3)

  • Sort Key: art.lease_id, days.date
  • Sort Method: external merge Disk: 90280kB
  • Buffers: shared hit=331638 read=4107 dirtied=1, temp read=33674 written=33680
25. 1,005.169 2,520.195 ↓ 2.3 2,873,870 3

Nested Loop (cost=0.72..158,413.04 rows=1,231,978 width=21) (actual time=0.159..840.065 rows=2,873,870 loops=3)

  • Buffers: shared hit=331610 read=4107 dirtied=1
26. 285.762 285.762 ↑ 1.2 51,219 3

Index Scan using idx_ar_transactions_periods_join on ar_transactions art (cost=0.43..49,371.72 rows=62,643 width=17) (actual time=0.07..95.254 rows=51,219 loops=3)

  • Index Cond: ((art.cid = 2342) AND (art.property_id = 518720))
  • Filter: (NOT art.is_deleted)
  • Buffers: shared hit=24242 read=4106 dirtied=1
27. 1,229.264 1,229.264 ↓ 2.8 56 153,658

Index Only Scan using uk_days_date on days days (cost=0.29..1.14 rows=20 width=8) (actual time=0.004..0.008 rows=56 loops=153,658)

  • Index Cond: ((days.date >= art.post_date) AND (days.date >= '04/07/2019 00:00:00'::timestamp without time zone) AND (days.date <= '06/05/2019 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=307368 read=1
28. 4.548 4,243,553.498 ↓ 81,777.0 81,777 1

Materialize (cost=6,702.75..6,702.85 rows=1 width=117) (actual time=4,243,351.124..4,243,553.498 rows=81,777 loops=1)

  • Buffers: shared hit=3121370417 read=2879 dirtied=1
29. 173.082 4,243,548.950 ↓ 3,608.0 3,608 1

Aggregate (cost=6,702.75..6,702.82 rows=1 width=117) (actual time=4,243,351.121..4,243,548.95 rows=3,608 loops=1)

  • Filter: CASE WHEN (NOT sub_query1.base_charge_on_amount_due) THEN (sum(sub_query1.transaction_amount) > '0'::numeric) ELSE (sum(sub_query1.transaction_amount_due) > '0'::numeric) END
  • Buffers: shared hit=3121370417 read=2879 dirtied=1
30. 220.908 4,243,375.868 ↓ 412,542.0 412,542 1

Sort (cost=6,702.75..6,702.75 rows=1 width=117) (actual time=4,243,350.873..4,243,375.868 rows=412,542 loops=1)

  • Sort Key: sub_query1.lease_id, sub_query1.late_fee_formula_id, sub_query1.date, sub_query1.base_charge_on_amount_due
  • Sort Method: quicksort Memory: 44518kB
  • Buffers: shared hit=3121370417 read=2879 dirtied=1
31. 157.029 4,243,154.960 ↓ 412,542.0 412,542 1

Subquery Scan on sub_query1 (cost=6,702.56..6,702.74 rows=1 width=117) (actual time=4,242,380.344..4,243,154.96 rows=412,542 loops=1)

  • Filter: (NOT (SubPlan 7))
  • Buffers: shared hit=3121370412 read=2879 dirtied=1
32. 534.881 4,242,997.931 ↓ 412,542.0 412,542 1

Aggregate (cost=6,702.56..6,702.67 rows=1 width=143) (actual time=4,242,380.338..4,242,997.931 rows=412,542 loops=1)

  • Buffers: shared hit=3121370412 read=2879 dirtied=1
33. 2,106.266 4,242,463.050 ↓ 669,470.0 669,470 1

Sort (cost=6,702.56..6,702.56 rows=1 width=52) (actual time=4,242,380.323..4,242,463.05 rows=669,470 loops=1)

  • Sort Key: li.lease_id, at.id, at.transaction_amount, lfbd.late_fee_formula_id, at.ar_trigger_id, lff.id, ac.waive_late_fees, at.ar_code_type_id, at.post_date, days_1.date, lff.base_charge_on_amount_due
  • Sort Method: quicksort Memory: 112430kB
  • Buffers: shared hit=3121370412 read=2879 dirtied=1
34. 233.801 4,240,356.784 ↓ 669,470.0 669,470 1

Nested Loop (cost=4.36..6,702.55 rows=1 width=52) (actual time=19.692..4,240,356.784 rows=669,470 loops=1)

  • Buffers: shared hit=3121370406 read=2879 dirtied=1
35. 245.601 4,240,122.983 ↓ 669,470.0 669,470 1

Nested Loop (cost=4.36..6,702.45 rows=1 width=53) (actual time=19.677..4,240,122.983 rows=669,470 loops=1)

  • Buffers: shared hit=3121370405 read=2879 dirtied=1
36. 783.095 4,239,877.382 ↓ 669,470.0 669,470 1

Nested Loop (cost=4.36..6,698.57 rows=1 width=57) (actual time=19.283..4,239,877.382 rows=669,470 loops=1)

  • Buffers: shared hit=3121370402 read=2843 dirtied=1
37. 423.152 4,236,206.493 ↓ 412,542.0 412,542 1

Nested Loop (cost=2.97..6,695.07 rows=1 width=57) (actual time=19.216..4,236,206.493 rows=412,542 loops=1)

  • Filter: CASE WHEN (pp1.value = '0'::text) THEN ((l.termination_list_type_id <> 1) OR (l.termination_list_type_id IS NULL)) ELSE true END
  • Buffers: shared hit=3118463113 read=1031 dirtied=1
38. 188.744 4,235,783.341 ↓ 412,542.0 412,542 1

Nested Loop (cost=2.97..6,694.96 rows=1 width=65) (actual time=19.212..4,235,783.341 rows=412,542 loops=1)

  • Buffers: shared hit=3118463113 read=1031 dirtied=1
39. 0.000 4,235,182.055 ↓ 412,542.0 412,542 1

Nested Loop (cost=2.67..6,694.5 rows=1 width=69) (actual time=19.203..4,235,182.055 rows=412,542 loops=1)

  • Buffers: shared hit=3118050571 read=1031 dirtied=1
40. 329.792 4,234,778.883 ↓ 412,542.0 412,542 1

Nested Loop (cost=2.67..6,694.4 rows=1 width=69) (actual time=19.117..4,234,778.883 rows=412,542 loops=1)

  • Buffers: shared hit=3118050560 read=1031 dirtied=1
41. 400.430 4,233,624.007 ↓ 412,542.0 412,542 1

Nested Loop (cost=2.4..6,694.09 rows=1 width=72) (actual time=19.1..4,233,624.007 rows=412,542 loops=1)

  • Buffers: shared hit=3116812934 read=1031 dirtied=1
42. 477,527.021 4,232,398.493 ↓ 412,542.0 412,542 1

Nested Loop (cost=2.13..6,691.75 rows=1 width=72) (actual time=19.075..4,232,398.493 rows=412,542 loops=1)

  • Buffers: shared hit=3115575308 read=1031 dirtied=1
43. 433,120.083 2,551,971.164 ↓ 601,450,154.0 601,450,154 1

Nested Loop (cost=1.7..6,687.96 rows=1 width=89) (actual time=18.3..2,551,971.164 rows=601,450,154 loops=1)

  • Buffers: shared hit=171699613 read=930
44. 0.461 0.461 ↓ 60.0 60 1

CTE Scan on eligible_days days_1 (cost=0..3.83 rows=1 width=16) (actual time=0.017..0.461 rows=60 loops=1)

  • Filter: ((days_1.date >= '04/07/2019 00:00:00'::timestamp without time zone) AND (days_1.date <= '06/05/2019 00:00:00'::timestamp without time zone))
  • Buffers: shared hit=3
45. 1,542,344.400 2,118,850.620 ↓ 1,018,071.1 28,505,992 60

Nested Loop (cost=1.7..6,682.73 rows=28 width=87) (actual time=0.346..35,314.177 rows=28,505,992 loops=60)

  • Buffers: shared hit=171699610 read=930
46. 2,183.460 14,117.940 ↓ 153,658.0 153,658 60

Nested Loop (cost=1.7..6,624.02 rows=1 width=73) (actual time=0.1..235.299 rows=153,658 loops=60)

  • Buffers: shared hit=5748970 read=930
47. 71.820 2,382.300 ↓ 3,883.0 3,883 60

Nested Loop (cost=1.27..6,623.08 rows=1 width=32) (actual time=0.042..39.705 rows=3,883 loops=60)

  • Buffers: shared hit=1920005 read=95
48. 164.400 1,378.560 ↓ 3,883.0 3,883 60

Nested Loop (cost=0.85..6,622.57 rows=1 width=28) (actual time=0.034..22.976 rows=3,883 loops=60)

  • Buffers: shared hit=986166 read=34
49. 282.000 282.000 ↓ 1.1 3,884 60

Index Scan using idx_leases_property_id on leases l (cost=0.42..1,215.47 rows=3,566 width=24) (actual time=0.025..4.7 rows=3,884 loops=60)

  • Index Cond: (l.property_id = 518720)
  • Filter: ((l.cid = 2342) AND (l.occupancy_type_id <> ALL ('{5,7,8}'::integer[])))
  • Buffers: shared hit=85510 read=20
50. 932.160 932.160 ↑ 1.0 1 233,040

Index Only Scan using idx_lease_customers_cid_lease_id_customer_id_lease_status_type_ on lease_customers lc (cost=0.42..1.52 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=233,040)

  • Index Cond: ((lc.cid = 2342) AND (lc.lease_id = l.id) AND (lc.customer_id = l.primary_customer_id))
  • Buffers: shared hit=900656 read=14
51. 931.920 931.920 ↑ 1.0 1 232,980

Index Scan using idx_lease_details_lease_id on lease_details ld (cost=0.42..0.48 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=232,980)

  • Index Cond: (ld.lease_id = lc.lease_id)
  • Filter: ((ld.cid = 2342) AND (ld.dont_charge_late_fees = 0))
  • Buffers: shared hit=933839 read=61
52. 9,552.180 9,552.180 ↓ 20.0 40 232,980

Index Scan using idx_ar_transactions_allocations_join on ar_transactions at (cost=0.43..0.87 rows=2 width=41) (actual time=0.005..0.041 rows=40 loops=232,980)

  • Index Cond: ((at.cid = 2342) AND (at.property_id = 518720) AND (at.lease_id = lc.lease_id))
  • Filter: ((NOT at.is_deleted) AND CASE WHEN ((at.ar_code_type_id = ANY ('{2,5,6,4,3,9,8}'::integer[])) OR ((at.ar_code_type_id = 7) AND (NOT at.is_deposit_credit))) THEN (NOT at.is_temporary) ELSE true END)
  • Buffers: shared hit=3828965 read=835
53. 562,388.280 562,388.280 ↑ 1.0 552 9,219,480

Seq Scan on late_fee_formulas lff (cost=0..35.94 rows=552 width=24) (actual time=0.001..0.061 rows=552 loops=9,219,480)

  • Filter: (lff.cid = 2342)
  • Buffers: shared hit=165950640
54. 1,202,900.308 1,202,900.308 ↓ 2.0 2 601,450,154

Index Scan using idx_lease_intervals_major_composite on lease_intervals li (cost=0.42..0.54 rows=1 width=16) (actual time=0.002..0.002 rows=2 loops=601,450,154)

  • Index Cond: ((li.cid = 2342) AND (li.lease_id = lc.lease_id))
  • Filter: (li.lease_status_type_id <> 2)
  • Buffers: shared hit=2943875684 read=101 dirtied=1
55.          

SubPlan (forNested Loop)

56. 0.000 0.000 ↓ 0.0 0 0

Bitmap Heap Scan on late_fee_formula_ar_codes late_fee_formula_ar_codes (cost=2.65..3.68 rows=1 width=4) (never executed)

57. 0.000 0.000 ↓ 0.0 0 0

BitmapAnd (cost=2.65..2.65 rows=1 width=0) (never executed)

58. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on idx_late_fee_formula_ar_codes_late_fee_formula_id (cost=0..1.2 rows=6 width=0) (never executed)

  • Index Cond: (late_fee_formula_ar_codes.late_fee_formula_id = lff.id)
59. 0.000 0.000 ↓ 0.0 0 0

Bitmap Index Scan on pk_late_fee_formula_ar_codes (cost=0..1.2 rows=6 width=0) (never executed)

  • Index Cond: (late_fee_formula_ar_codes.cid = lff.cid)
60. 0.000 0.000 ↓ 0.0 0 412,542

CTE Scan on eligible_ar_codes eac (cost=0..0.07 rows=1 width=4) (actual time=0..0 rows=0 loops=412,542)

  • Filter: ((eac.parent_late_fee_formula_id = lff.id) AND (eac.cid = lff.cid))
  • Buffers: shared hit=11
61. 825.084 825.084 ↑ 1.0 1 412,542

Index Scan using idx_property_gl_settings_cid_property_id_activate_po_posting on property_gl_settings pgs (cost=0.27..2.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=412,542)

  • Index Cond: ((pgs.cid = 2342) AND (pgs.property_id = 518720))
  • Filter: pgs.activate_standard_posting
  • Buffers: shared hit=1237626
62. 825.084 825.084 ↑ 1.0 1 412,542

Index Scan using pk_ar_codes on ar_codes ac (cost=0.28..0.32 rows=1 width=9) (actual time=0.002..0.002 rows=1 loops=412,542)

  • Index Cond: ((ac.cid = 2342) AND (ac.id = at.ar_code_id))
  • Buffers: shared hit=1237626
63. 412.542 412.542 ↑ 1.0 1 412,542

CTE Scan on eligible_property_preferences pp (cost=0..0.07 rows=1 width=8) (actual time=0..0.001 rows=1 loops=412,542)

  • Filter: ((pp.cid = 2342) AND (pp.property_id = 518720) AND ((pp.key)::text = 'ENABLED_LATE_FEES'::text) AND (pp.value = '1'::text))
  • Buffers: shared hit=11
64. 0.000 412.542 ↓ 0.0 0 412,542

Nested Loop (cost=0.3..0.42 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=412,542)

  • Buffers: shared hit=412542
65. 412.542 412.542 ↓ 0.0 0 412,542

Index Scan using idx_repayments_property_id on repayments r (cost=0.15..0.19 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=412,542)

  • Index Cond: ((r.cid = 2342) AND (r.property_id = at.property_id) AND (r.property_id = 518720))
  • Filter: r.is_active
  • Buffers: shared hit=412542
66. 0.000 0.000 ↓ 0.0 0 0

Index Scan using uk_repayment_ar_transactions_cid_ar_transaction_id on repayment_ar_transactions rat (cost=0.15..0.2 rows=1 width=16) (never executed)

  • Index Cond: ((rat.cid = 2342) AND (rat.ar_transaction_id = at.id))
  • Filter: (rat.property_id = 518720)
67. 0.000 0.000 ↑ 1.0 1 412,542

CTE Scan on eligible_property_preferences pp1 (cost=0..0.07 rows=1 width=40) (actual time=0..0 rows=1 loops=412,542)

  • Filter: ((pp1.cid = 2342) AND (pp1.property_id = 518720) AND ((pp1.key)::text = 'CHARGE_LATE_FEES_FOR_EVICTING_LEASES'::text))
68. 412.542 2,887.794 ↑ 7.0 2 412,542

Bitmap Heap Scan on ar_allocations aa (cost=1.39..2.95 rows=14 width=21) (actual time=0.007..0.007 rows=2 loops=412,542)

  • Filter: ((NOT aa.is_deleted) AND (aa.cid = 2342) AND (aa.cid = at.cid))
  • Buffers: shared hit=2907289 read=1812
69. 412.542 2,475.252 ↓ 0.0 0 412,542

BitmapOr (cost=1.39..1.39 rows=14 width=0) (actual time=0.006..0.006 rows=0 loops=412,542)

  • Buffers: shared hit=2479394 read=551
70. 1,237.626 1,237.626 ↑ 2.0 1 412,542

Bitmap Index Scan on idx_ar_allocations_charge_ar_transaction_id (cost=0..0.65 rows=2 width=0) (actual time=0.003..0.003 rows=1 loops=412,542)

  • Index Cond: (at.id = aa.charge_ar_transaction_id)
  • Buffers: shared hit=1240499 read=172
71. 825.084 825.084 ↑ 12.0 1 412,542

Bitmap Index Scan on idx_ar_allocations_credit_ar_transaction_id (cost=0..0.73 rows=12 width=0) (actual time=0.002..0.002 rows=1 loops=412,542)

  • Index Cond: (at.id = aa.credit_ar_transaction_id)
  • Buffers: shared hit=1238895 read=379
72. 0.000 0.000 ↓ 0.0 0 669,470

CTE Scan on eligible_late_fee_batch_details lfbd (cost=0..3.83 rows=1 width=20) (actual time=0..0 rows=0 loops=669,470)

  • Filter: ((lfbd.cid = 2342) AND (lfbd.late_fee_action_type_id = 1))
  • Buffers: shared hit=3 read=36
73. 0.000 0.000 ↓ 0.0 0 669,470

CTE Scan on property_holiday_list phl (cost=0..0.06 rows=1 width=8) (actual time=0..0 rows=0 loops=669,470)

  • Filter: (phl.cid = 2342)
  • Buffers: shared hit=1
74.          

SubPlan (forSubquery Scan)

75. 0.000 0.000 ↓ 0.0 0 412,542

CTE Scan on property_waive_late_fees pwlf (cost=0..0.07 rows=1 width=4) (actual time=0..0 rows=0 loops=412,542)

  • Filter: ((pwlf.late_fee_formula_id = sub_query1.late_fee_formula_id) AND (pwlf.cid = sub_query1.cid) AND (pwlf.post_date = sub_query1.date) AND (pwlf.lease_id = sub_query1.lease_id))