# Result: 4ZBl

Settings

### Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.262 6,102.244 ↑ 8.5 82 1

(cost=1,001.00..3,416,849.56 rows=698 width=266) (actual time=6,093.126..6,102.244 rows=82 loops=1)

2. 0.000 6,101.128 ↑ 3.9 122 1

(cost=1,000.71..3,414,824.32 rows=477 width=116) (actual time=6,093.078..6,101.128 rows=122 loops=1)

• Join Filter: (r.lender_standard <> lm.standard)
• Rows Removed by Join Filter: 88
3. 46.809 6,098.297 ↑ 2.3 210 1

Gather (cost=1,000.43..3,412,870.02 rows=478 width=172) (actual time=6,093.032..6,098.297 rows=210 loops=1)

• Workers Planned: 2
• Workers Launched: 2
4. 0.037 6,051.488 ↑ 2.8 70 3 / 3

(cost=0.43..3,411,822.22 rows=199 width=172) (actual time=5,642.924..6,051.488 rows=70 loops=3)

5. 6,051.161 6,051.161 ↑ 52.0 1 3 / 3

Parallel Seq Scan on fnmloan b (cost=0.00..573,185.38 rows=52 width=82) (actual time=5,642.805..6,051.161 rows=1 loops=3)

• Filter: ((tpoflag = 'C'::text) AND (cusip = '3140Q9L35'::text))
• Rows Removed by Filter: 4,060,660
6. 0.019 0.290 ↑ 246.7 105 2 / 3

(cost=0.43..54,330.15 rows=25,902 width=106) (actual time=0.149..0.435 rows=105 loops=2)

7. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ak_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ak r (cost=0.43..123.79 rows=59 width=110) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
8. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_al_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_al r_1 (cost=0.44..444.67 rows=193 width=99) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
9. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ar_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ar r_2 (cost=0.43..338.97 rows=168 width=100) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
10. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_az_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_az r_3 (cost=0.57..1,967.62 rows=976 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
11. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ca_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ca r_4 (cost=0.57..8,862.27 rows=4,432 width=108) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
12. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_co_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_co r_5 (cost=0.56..1,324.36 rows=602 width=105) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
13. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ct_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ct r_6 (cost=0.44..859.59 rows=430 width=103) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
14. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_de_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_de r_7 (cost=0.43..134.73 rows=57 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
15. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_fl_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_fl r_8 (cost=0.57..4,721.94 rows=2,292 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
16. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ga_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ga r_9 (cost=0.56..1,226.94 rows=530 width=103) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
17. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_hi_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_hi r_10 (cost=0.43..341.24 rows=156 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
18. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ia_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ia r_11 (cost=0.43..461.19 rows=231 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
19. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_id_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_id r_12 (cost=0.43..281.51 rows=137 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
20. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_il_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_il r_13 (cost=0.57..2,481.28 rows=1,188 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
21. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_in_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_in r_14 (cost=0.44..806.09 rows=387 width=105) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
22. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ks_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ks r_15 (cost=0.43..260.21 rows=139 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
23. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ky_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ky r_16 (cost=0.43..447.47 rows=225 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
24. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_la_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_la r_17 (cost=0.43..347.48 rows=162 width=103) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
25. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ma_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ma r_18 (cost=0.56..2,164.76 rows=1,076 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
26. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_md_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_md r_19 (cost=0.56..1,427.61 rows=669 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
27. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_me_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_me r_20 (cost=0.43..223.63 rows=103 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
28. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_mi_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_mi r_21 (cost=0.56..1,664.40 rows=811 width=103) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
29. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_mn_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_mn r_22 (cost=0.44..680.57 rows=311 width=105) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
30. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_mo_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_mo r_23 (cost=0.56..1,058.01 rows=506 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
31. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ms_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ms r_24 (cost=0.43..229.35 rows=120 width=102) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
32. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_mt_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_mt r_25 (cost=0.43..160.32 rows=79 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
33. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_nc_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_nc r_26 (cost=0.56..1,341.46 rows=607 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
34. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_nd_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_nd r_27 (cost=0.43..89.19 rows=44 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
35. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ne_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ne r_28 (cost=0.43..319.22 rows=151 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
36. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_nh_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_nh r_29 (cost=0.43..236.06 rows=106 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
37. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_nj_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_nj r_30 (cost=0.56..1,451.51 rows=628 width=105) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
38. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_nm_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_nm r_31 (cost=0.43..319.20 rows=160 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
39. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_nv_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_nv r_32 (cost=0.44..809.12 rows=395 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
40. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ny_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ny r_33 (cost=0.56..1,126.35 rows=528 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
41. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_oh_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_oh r_34 (cost=0.57..2,313.31 rows=1,110 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
42. 0.271 0.271 ↑ 2.5 105 2 / 3

Index Scan using recorder_ok_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ok r_35 (cost=0.44..532.81 rows=261 width=99) (actual time=0.133..0.407 rows=105 loops=2)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
• Rows Removed by Filter: 24
43. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_or_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_or r_36 (cost=0.44..993.34 rows=474 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
44. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_pa_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_pa r_37 (cost=0.56..2,094.43 rows=978 width=105) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
45. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ri_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ri r_38 (cost=0.43..356.59 rows=173 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
46. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_sc_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_sc r_39 (cost=0.44..546.42 rows=240 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
47. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_sd_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_sd r_40 (cost=0.43..54.45 rows=27 width=111) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
48. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_tn_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_tn r_41 (cost=0.56..1,294.94 rows=607 width=102) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
49. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_tx_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_tx r_42 (cost=0.57..2,806.99 rows=1,278 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
50. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_ut_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_ut r_43 (cost=0.44..716.96 rows=337 width=109) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
51. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_va_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_va r_44 (cost=0.44..999.55 rows=459 width=105) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
52. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_vt_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_vt r_45 (cost=0.43..35.68 rows=17 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
53. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_wa_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_wa r_46 (cost=0.56..1,661.82 rows=786 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
54. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_wi_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_wi r_47 (cost=0.44..779.31 rows=364 width=104) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
55. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_wv_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_wv r_48 (cost=0.43..139.22 rows=70 width=107) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
56. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_wy_state_mortgage_amount_rounded_expected_pay_date_idx on recorder_wy r_49 (cost=0.43..80.64 rows=39 width=102) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
57. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using recorder_default_state_mortgage_amount_rounded_expected_pay_idx on recorder_default r_50 (cost=0.43..62.07 rows=24 width=106) (never executed)

• Index Cond: ((state = b.state) AND (mortgage_amount_rounded = b.origloanamt) AND (expected_pay_date >= (b.firstpaymtdt - '1 mon'::interval)) AND (expected_pay_date <= (b.firstpaymtdt + '1 mon'::interval)))
• Filter: ((mortgage_term IS NULL) OR (((mortgage_term)::integer)::numeric = b.origterm))
58. 7.770 7.770 ↑ 1.0 1 210

Index Only Scan using lender_map_lender_standard_idx on lender_map lm (cost=0.28..4.08 rows=1 width=49) (actual time=0.037..0.037 rows=1 loops=210)

• Index Cond: (lender = b.seller)
• Heap Fetches: 0
59. 0.854 0.854 ↑ 1.0 1 122

Index Only Scan using correspondent_lenders_lender_standard_idx on correspondent_lenders cl (cost=0.28..4.09 rows=1 width=20) (actual time=0.006..0.007 rows=1 loops=122)

• Index Cond: (lender = r.mortgage_lender)
• Heap Fetches: 0
Planning time Execution time : 22.372 ms : 6,113.575 ms