explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IV79 : Optimization for: plan #4ZBl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.741 14,679.760 ↑ 8.4 82 1

Nested Loop (cost=1,001.00..3,416,928.62 rows=689 width=266) (actual time=13,847.914..14,679.760 rows=82 loops=1)

2. 0.344 14,575.929 ↑ 3.9 122 1

Nested Loop (cost=1,000.71..3,414,928.88 rows=471 width=116) (actual time=13,835.813..14,575.929 rows=122 loops=1)

  • Join Filter: (r.lender_standard <> lm.standard)
  • Rows Removed by Join Filter: 88
3. 141.808 14,569.705 ↑ 2.2 210 1

Gather (cost=1,000.43..3,412,999.96 rows=472 width=172) (actual time=13,831.786..14,569.705 rows=210 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.070 14,427.897 ↑ 2.8 70 3 / 3

Nested Loop (cost=0.43..3,411,952.76 rows=197 width=172) (actual time=13,881.270..14,427.897 rows=70 loops=3)

5. 14,105.514 14,105.514 ↑ 52.0 1 3 / 3

Parallel Seq Scan on fnmloan b (cost=0.00..573,169.97 rows=52 width=82) (actual time=13,839.475..14,105.514 rows=1 loops=3)

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

Append (cost=0.43..54,332.96 rows=25,902 width=106) (actual time=62.666..483.470 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.70 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.99 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.73 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.76 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.43 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.61 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,722.20 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,227.01 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.26 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.22 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.52 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.39 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.14 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.49 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.50 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.82 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.67 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.64 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.49 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.60 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.06 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.36 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.34 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.54 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.20 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.08 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.57 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.23 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.17 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.43 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.42 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. 322.280 322.280 ↑ 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.84 rows=261 width=99) (actual time=62.652..483.420 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.39 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.53 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.62 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.45 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,295.00 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,807.15 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.99 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.60 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.67 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.94 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.36 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.23 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. 5.880 5.880 ↑ 1.0 1 210

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

  • Index Cond: (lender = b.seller)
  • Heap Fetches: 0
59. 103.090 103.090 ↑ 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.844..0.845 rows=1 loops=122)

  • Index Cond: (lender = r.mortgage_lender)
  • Heap Fetches: 0
Planning time : 42.176 ms
Execution time : 14,689.078 ms