explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8BGq

Settings
# exclusive inclusive rows x rows loops node
1. 39.896 3,068.858 ↑ 3,952,786.1 11,574 1

Unique (cost=33,213,195,171.78..49,339,910,411.03 rows=45,749,546,778 width=1,599) (actual time=3,026.773..3,068.858 rows=11,574 loops=1)

2.          

CTE max_transition_events

3. 11.064 70.450 ↓ 1.1 13,736 1

Sort (cost=3,226.34..3,256.98 rows=12,257 width=20) (actual time=66.396..70.450 rows=13,736 loops=1)

  • Sort Key: loan_status_transition_events.loan_application_id
  • Sort Method: quicksort Memory: 1458kB
4. 27.404 59.386 ↓ 1.1 13,736 1

HashAggregate (cost=2,240.80..2,394.01 rows=12,257 width=20) (actual time=41.857..59.386 rows=13,736 loops=1)

  • Group Key: loan_status_transition_events.loan_application_id, loan_status_transition_events.to_status
5. 31.982 31.982 ↑ 1.1 15,358 1

Seq Scan on loan_status_transition_events (cost=0.00..2,115.50 rows=16,706 width=20) (actual time=0.045..31.982 rows=15,358 loops=1)

  • Filter: ((NOT removed_from_path) AND (to_status = ANY ('{3,4,7,8,39,50,10,43}'::integer[])))
  • Rows Removed by Filter: 77410
6.          

CTE min_transition_events

7. 12.766 61.860 ↑ 1.0 8,894 1

Finalize GroupAggregate (cost=2,356.09..2,539.89 rows=9,292 width=20) (actual time=46.159..61.860 rows=8,894 loops=1)

  • Group Key: loan_status_transition_events_1.loan_application_id, loan_status_transition_events_1.to_status
8. 8.517 49.094 ↓ 1.4 9,192 1

Sort (cost=2,356.09..2,373.01 rows=6,765 width=20) (actual time=46.128..49.094 rows=9,192 loops=1)

  • Sort Key: loan_status_transition_events_1.loan_application_id, loan_status_transition_events_1.to_status
  • Sort Method: quicksort Memory: 1103kB
9. 19.918 40.577 ↓ 1.4 9,192 1

Gather (cost=1,181.56..1,925.71 rows=6,765 width=20) (actual time=35.491..40.577 rows=9,192 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
10. 4.580 20.659 ↑ 1.5 4,596 2 / 2

Partial HashAggregate (cost=1,171.56..1,239.21 rows=6,765 width=20) (actual time=19.302..20.659 rows=4,596 loops=2)

  • Group Key: loan_status_transition_events_1.loan_application_id, loan_status_transition_events_1.to_status
11. 16.079 16.079 ↑ 1.3 5,152 2 / 2

Parallel Seq Scan on loan_status_transition_events loan_status_transition_events_1 (cost=0.00..1,120.82 rows=6,765 width=20) (actual time=0.058..16.079 rows=5,152 loops=2)

  • Filter: ((NOT removed_from_path) AND (to_status = ANY ('{32,35,8,49,50}'::integer[])))
  • Rows Removed by Filter: 41232
12.          

CTE misc_section

13. 46.819 87.178 ↓ 1.0 48,853 1

Sort (cost=5,083.59..5,205.60 rows=48,804 width=76) (actual time=70.014..87.178 rows=48,853 loops=1)

  • Sort Key: fv.loan_application_id
  • Sort Method: quicksort Memory: 8406kB
14. 24.233 40.359 ↓ 1.0 48,853 1

Hash Join (cost=3.73..1,283.05 rows=48,804 width=76) (actual time=0.294..40.359 rows=48,853 loops=1)

  • Hash Cond: (fv.loan_extra_dates_field_definition_id = sf.loan_extra_dates_field_definition_id)
15. 15.906 15.906 ↓ 1.0 48,853 1

Seq Scan on loan_extra_dates_field_values fv (cost=0.00..608.26 rows=48,804 width=20) (actual time=0.038..15.906 rows=48,853 loops=1)

  • Filter: (NOT is_removed)
  • Rows Removed by Filter: 70
16. 0.035 0.220 ↓ 1.1 51 1

Hash (cost=3.15..3.15 rows=47 width=80) (actual time=0.220..0.220 rows=51 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
17. 0.049 0.185 ↓ 1.1 51 1

Hash Join (cost=1.59..3.15 rows=47 width=80) (actual time=0.128..0.185 rows=51 loops=1)

  • Hash Cond: (sf.loan_extra_dates_field_definition_id = fd.id)
18. 0.054 0.092 ↓ 1.1 51 1

Hash Join (cost=0.34..1.24 rows=47 width=40) (actual time=0.059..0.092 rows=51 loops=1)

  • Hash Cond: (sf.loan_extra_dates_section_id = s.id)
19. 0.019 0.019 ↓ 1.1 51 1

Seq Scan on loan_extra_dates_section_fields sf (cost=0.00..0.67 rows=47 width=16) (actual time=0.011..0.019 rows=51 loops=1)

20. 0.010 0.019 ↑ 1.0 6 1

Hash (cost=0.26..0.26 rows=6 width=40) (actual time=0.019..0.019 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.009 0.009 ↑ 1.0 6 1

Seq Scan on loan_extra_dates_sections s (cost=0.00..0.26 rows=6 width=40) (actual time=0.008..0.009 rows=6 loops=1)

22. 0.016 0.044 ↓ 1.1 51 1

Hash (cost=0.67..0.67 rows=47 width=40) (actual time=0.044..0.044 rows=51 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
23. 0.028 0.028 ↓ 1.1 51 1

Seq Scan on loan_extra_dates_field_definitions fd (cost=0.00..0.67 rows=47 width=40) (actual time=0.009..0.028 rows=51 loops=1)

24.          

CTE reo_info

25. 6.213 9.407 ↓ 1.1 5,023 1

HashAggregate (cost=137.55..184.96 rows=4,741 width=16) (actual time=7.150..9.407 rows=5,023 loops=1)

  • Group Key: owned_properties.loan_application_id
26. 3.194 3.194 ↑ 1.0 6,474 1

Seq Scan on owned_properties (cost=0.00..105.18 rows=6,474 width=8) (actual time=0.023..3.194 rows=6,474 loops=1)

  • Filter: (NOT is_removed)
  • Rows Removed by Filter: 1484
27.          

CTE form_free

28. 0.044 0.129 ↑ 11.8 17 1

Unique (cost=0.15..5.74 rows=200 width=40) (actual time=0.026..0.129 rows=17 loops=1)

29. 0.085 0.085 ↑ 1.0 308 1

Index Only Scan using loan_form_free_callbacks_loan_application_idx on loan_form_free_callbacks (cost=0.15..4.97 rows=308 width=40) (actual time=0.025..0.085 rows=308 loops=1)

  • Heap Fetches: 0
30.          

CTE quality_bypass_info

31. 32.819 150.413 ↑ 1.4 2,376 1

HashAggregate (cost=4,769.33..4,820.10 rows=3,385 width=232) (actual time=146.821..150.413 rows=2,376 loops=1)

  • Group Key: l_1.id, ((b_1.last_name || ', '::text) || b_1.first_name), ls.id
32. 5.145 117.594 ↓ 1.6 5,350 1

Hash Left Join (cost=4,066.09..4,295.43 rows=3,385 width=122) (actual time=101.855..117.594 rows=5,350 loops=1)

  • Hash Cond: (l_1.id = qs.loan_application_id)
  • Filter: ((NOT qs.is_removed) OR (qs.is_removed IS NULL))
33. 2.106 110.081 ↓ 1.0 3,441 1

Hash Left Join (cost=3,979.34..4,169.21 rows=3,385 width=90) (actual time=99.432..110.081 rows=3,441 loops=1)

  • Hash Cond: (l_1.id = qr.loan_application_id)
34. 1.249 104.208 ↑ 1.4 2,376 1

Hash Join (cost=3,868.66..4,024.48 rows=3,385 width=37) (actual time=95.613..104.208 rows=2,376 loops=1)

  • Hash Cond: (latm.customer_care_member_id = tm1.id)
35. 2.501 102.692 ↑ 1.4 2,376 1

Hash Right Join (cost=3,859.98..3,980.37 rows=3,385 width=45) (actual time=95.324..102.692 rows=2,376 loops=1)

  • Hash Cond: (reo.loan_application_id = l_1.id)
36. 12.056 12.056 ↓ 1.1 5,023 1

CTE Scan on reo_info reo (cost=0.00..94.82 rows=4,741 width=16) (actual time=7.155..12.056 rows=5,023 loops=1)

37. 1.677 88.135 ↑ 1.4 2,376 1

Hash (cost=3,817.66..3,817.66 rows=3,385 width=37) (actual time=88.135..88.135 rows=2,376 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 204kB
38. 2.247 86.458 ↑ 1.4 2,376 1

Nested Loop (cost=2,120.64..3,817.66 rows=3,385 width=37) (actual time=56.319..86.458 rows=2,376 loops=1)

39. 7.010 74.707 ↑ 1.4 2,376 1

Hash Join (cost=2,120.35..2,717.31 rows=3,385 width=45) (actual time=56.288..74.707 rows=2,376 loops=1)

  • Hash Cond: (b_1.id = l_1.primary_borrower_id)
40. 11.447 11.447 ↓ 1.0 26,781 1

Seq Scan on borrowers b_1 (cost=0.00..463.38 rows=26,598 width=21) (actual time=0.010..11.447 rows=26,781 loops=1)

41. 1.040 56.250 ↑ 1.4 2,376 1

Hash (cost=2,078.03..2,078.03 rows=3,385 width=40) (actual time=56.250..56.250 rows=2,376 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 200kB
42. 6.131 55.210 ↑ 1.4 2,376 1

Hash Join (cost=1,700.49..2,078.03 rows=3,385 width=40) (actual time=44.255..55.210 rows=2,376 loops=1)

  • Hash Cond: (latm.loan_application_id = lad_1.loan_application_id)
43. 4.885 4.885 ↓ 1.0 20,597 1

Seq Scan on loan_application_team_members latm (cost=0.00..267.31 rows=20,191 width=32) (actual time=0.009..4.885 rows=20,597 loops=1)

44. 1.167 44.194 ↑ 1.5 2,376 1

Hash (cost=1,657.34..1,657.34 rows=3,452 width=56) (actual time=44.194..44.194 rows=2,376 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 237kB
45. 4.273 43.027 ↑ 1.5 2,376 1

Hash Join (cost=1,277.79..1,657.34 rows=3,452 width=56) (actual time=32.860..43.027 rows=2,376 loops=1)

  • Hash Cond: (pi.loan_application_id = lad_1.loan_application_id)
46. 5.954 5.954 ↑ 1.0 18,104 1

Seq Scan on property_information pi (cost=0.00..272.33 rows=18,133 width=16) (actual time=0.009..5.954 rows=18,104 loops=1)

47. 1.056 32.800 ↑ 1.6 2,376 1

Hash (cost=1,228.79..1,228.79 rows=3,920 width=40) (actual time=32.800..32.800 rows=2,376 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 200kB
48. 4.293 31.744 ↑ 1.6 2,376 1

Hash Join (cost=861.43..1,228.79 rows=3,920 width=40) (actual time=21.498..31.744 rows=2,376 loops=1)

  • Hash Cond: (lt_1.loan_application_id = lad_1.loan_application_id)
49. 6.042 6.042 ↑ 1.0 18,493 1

Seq Scan on loan_terms lt_1 (cost=0.00..254.36 rows=18,496 width=8) (actual time=0.010..6.042 rows=18,493 loops=1)

50. 0.940 21.409 ↑ 1.8 2,376 1

Hash (cost=806.88..806.88 rows=4,364 width=32) (actual time=21.409..21.409 rows=2,376 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 213kB
51. 3.223 20.469 ↑ 1.8 2,376 1

Hash Join (cost=548.52..806.88 rows=4,364 width=32) (actual time=13.071..20.469 rows=2,376 loops=1)

  • Hash Cond: (lad_1.loan_application_id = l_1.id)
52. 4.259 4.259 ↑ 1.0 12,546 1

Seq Scan on loan_application_dates lad_1 (cost=0.00..167.67 rows=12,547 width=8) (actual time=0.011..4.259 rows=12,546 loops=1)

53. 0.864 12.987 ↑ 3.0 2,376 1

Hash (cost=458.99..458.99 rows=7,162 width=24) (actual time=12.986..12.987 rows=2,376 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 194kB
54. 4.208 12.123 ↑ 3.0 2,376 1

Hash Join (cost=1.03..458.99 rows=7,162 width=24) (actual time=0.094..12.123 rows=2,376 loops=1)

  • Hash Cond: (l_1.loan_status_id = ls.id)
55. 7.859 7.859 ↓ 1.0 20,605 1

Seq Scan on loan_applications l_1 (cost=0.00..309.12 rows=20,592 width=24) (actual time=0.013..7.859 rows=20,605 loops=1)

56. 0.020 0.056 ↓ 1.6 26 1

Hash (cost=0.83..0.83 rows=16 width=8) (actual time=0.056..0.056 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
57. 0.036 0.036 ↓ 1.6 26 1

Seq Scan on loan_status ls (cost=0.00..0.83 rows=16 width=8) (actual time=0.020..0.036 rows=26 loops=1)

  • Filter: (application_received AND (is_active OR is_closed_deal) AND (id <> ALL ('{6,43,39}'::bigint[])))
  • Rows Removed by Filter: 27
58. 9.504 9.504 ↑ 1.0 1 2,376

Index Only Scan using addresses_pkey on addresses a (cost=0.29..0.32 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2,376)

  • Index Cond: (address_id = pi.address_id)
  • Heap Fetches: 1475
59. 0.040 0.267 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=8) (actual time=0.267..0.267 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
60. 0.091 0.227 ↓ 1.0 149 1

Hash Join (cost=3.23..6.84 rows=148 width=8) (actual time=0.135..0.227 rows=149 loops=1)

  • Hash Cond: (tm1.person_id = prs1.id)
61. 0.059 0.059 ↓ 1.0 149 1

Seq Scan on team_members tm1 (cost=0.00..1.88 rows=148 width=16) (actual time=0.030..0.059 rows=149 loops=1)

62. 0.031 0.077 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=8) (actual time=0.077..0.077 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
63. 0.046 0.046 ↑ 1.0 117 1

Seq Scan on persons prs1 (cost=0.00..1.77 rows=117 width=8) (actual time=0.010..0.046 rows=117 loops=1)

64. 1.056 3.767 ↑ 1.0 2,676 1

Hash (cost=76.93..76.93 rows=2,699 width=61) (actual time=3.767..3.767 rows=2,676 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 204kB
65. 1.234 2.711 ↑ 1.0 2,676 1

Hash Left Join (cost=3.23..76.93 rows=2,699 width=61) (actual time=0.136..2.711 rows=2,676 loops=1)

  • Hash Cond: (qr.reviewer_login_id = prs.login_id)
66. 1.383 1.383 ↑ 1.0 2,676 1

Seq Scan on quality_reviews qr (cost=0.00..36.59 rows=2,699 width=37) (actual time=0.018..1.383 rows=2,676 loops=1)

67. 0.049 0.094 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=40) (actual time=0.094..0.094 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
68. 0.045 0.045 ↑ 1.0 117 1

Seq Scan on persons prs (cost=0.00..1.77 rows=117 width=40) (actual time=0.011..0.045 rows=117 loops=1)

69. 1.155 2.368 ↓ 1.0 3,448 1

Hash (cost=44.00..44.00 rows=3,420 width=21) (actual time=2.368..2.368 rows=3,448 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 221kB
70. 1.213 1.213 ↓ 1.0 3,448 1

Seq Scan on quality_schedules qs (cost=0.00..44.00 rows=3,420 width=21) (actual time=0.012..1.213 rows=3,448 loops=1)

71.          

CTE fico_scores

72. 20.068 44.050 ↓ 1.0 11,094 1

GroupAggregate (cost=0.29..853.54 rows=11,080 width=12) (actual time=0.055..44.050 rows=11,094 loops=1)

  • Group Key: credit_scores.loan_application_id
73. 23.982 23.982 ↓ 1.0 15,823 1

Index Scan using credit_scores_loan_application_idx on credit_scores (cost=0.29..466.15 rows=15,805 width=20) (actual time=0.029..23.982 rows=15,823 loops=1)

74.          

CTE all_appraisals

75. 3.327 12.800 ↓ 1.0 2,802 1

WindowAgg (cost=422.18..478.16 rows=2,799 width=41) (actual time=8.728..12.800 rows=2,802 loops=1)

76. 2.102 9.473 ↓ 1.0 2,802 1

Sort (cost=422.18..429.18 rows=2,799 width=33) (actual time=8.725..9.473 rows=2,802 loops=1)

  • Sort Key: aa.loan_application_id, aa.ordered_local_date DESC
  • Sort Method: quicksort Memory: 315kB
77. 3.191 7.371 ↓ 1.0 2,802 1

WindowAgg (cost=205.95..261.93 rows=2,799 width=33) (actual time=3.620..7.371 rows=2,802 loops=1)

78. 2.033 4.180 ↓ 1.0 2,802 1

Sort (cost=205.95..212.95 rows=2,799 width=25) (actual time=3.615..4.180 rows=2,802 loops=1)

  • Sort Key: aa.loan_application_id, aa.ordered_local_date
  • Sort Method: quicksort Memory: 299kB
79. 2.147 2.147 ↓ 1.0 2,802 1

Seq Scan on appraisals aa (cost=0.00..45.70 rows=2,799 width=25) (actual time=0.026..2.147 rows=2,802 loops=1)

  • Filter: (NOT is_removed)
  • Rows Removed by Filter: 11
80.          

CTE team

81. 55.657 185.819 ↓ 1.0 20,605 1

Hash Left Join (cost=59.66..3,706.60 rows=20,592 width=232) (actual time=1.854..185.819 rows=20,605 loops=1)

  • Hash Cond: (tm_ma.person_id = p_ma.id)
82. 10.321 130.084 ↓ 1.0 20,605 1

Hash Left Join (cost=56.43..2,021.92 rows=20,592 width=400) (actual time=1.737..130.084 rows=20,605 loops=1)

  • Hash Cond: (lat.customer_care_member_id = tm_ma.id)
83. 11.746 119.677 ↓ 1.0 20,605 1

Hash Left Join (cost=52.70..1,802.68 rows=20,592 width=400) (actual time=1.643..119.677 rows=20,605 loops=1)

  • Hash Cond: (lat.received_member_id = tm_re.id)
84. 7.335 107.658 ↓ 1.0 20,605 1

Hash Left Join (cost=44.01..1,580.65 rows=20,592 width=344) (actual time=1.363..107.658 rows=20,605 loops=1)

  • Hash Cond: (lat.closer_member_id = tm_cl.id)
85. 7.297 100.083 ↓ 1.0 20,605 1

Hash Left Join (cost=35.33..1,471.96 rows=20,592 width=288) (actual time=1.116..100.083 rows=20,605 loops=1)

  • Hash Cond: (lat.secondary_member_id = tm_s.id)
86. 7.936 92.550 ↓ 1.0 20,605 1

Hash Left Join (cost=26.64..1,369.56 rows=20,592 width=232) (actual time=0.871..92.550 rows=20,605 loops=1)

  • Hash Cond: (lat.processor_member_id = tm_pr.id)
87. 8.557 84.376 ↓ 1.0 20,605 1

Hash Left Join (cost=17.95..1,245.42 rows=20,592 width=176) (actual time=0.622..84.376 rows=20,605 loops=1)

  • Hash Cond: (lat.underwriter_member_id = tm_u.id)
88. 8.445 75.544 ↓ 1.0 20,605 1

Hash Left Join (cost=9.26..1,118.68 rows=20,592 width=120) (actual time=0.338..75.544 rows=20,605 loops=1)

  • Hash Cond: (lat.quality_review_id = tm_q.id)
89. 23.265 66.825 ↓ 1.0 20,605 1

Merge Left Join (cost=0.57..1,018.57 rows=20,592 width=64) (actual time=0.053..66.825 rows=20,605 loops=1)

  • Merge Cond: (la_1.id = lat.loan_application_id)
90. 14.042 14.042 ↓ 1.0 20,605 1

Index Only Scan using loan_applications_pkey on loan_applications la_1 (cost=0.29..349.35 rows=20,592 width=8) (actual time=0.035..14.042 rows=20,605 loops=1)

  • Heap Fetches: 9242
91. 29.518 29.518 ↓ 1.0 20,597 1

Index Scan using loan_application_team_members_unique_per_loan on loan_application_team_members lat (cost=0.29..365.35 rows=20,191 width=64) (actual time=0.013..29.518 rows=20,597 loops=1)

92. 0.059 0.274 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.274..0.274 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
93. 0.086 0.215 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.126..0.215 rows=149 loops=1)

  • Hash Cond: (tm_q.person_id = p_q.id)
94. 0.037 0.037 ↓ 1.0 149 1

Seq Scan on team_members tm_q (cost=0.00..1.88 rows=148 width=16) (actual time=0.018..0.037 rows=149 loops=1)

95. 0.040 0.092 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.092..0.092 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
96. 0.052 0.052 ↑ 1.0 117 1

Seq Scan on persons p_q (cost=0.00..1.77 rows=117 width=72) (actual time=0.010..0.052 rows=117 loops=1)

97. 0.064 0.275 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.275..0.275 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
98. 0.070 0.211 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.131..0.211 rows=149 loops=1)

  • Hash Cond: (tm_u.person_id = p_u.id)
99. 0.028 0.028 ↓ 1.0 149 1

Seq Scan on team_members tm_u (cost=0.00..1.88 rows=148 width=16) (actual time=0.006..0.028 rows=149 loops=1)

100. 0.070 0.113 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.113..0.113 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
101. 0.043 0.043 ↑ 1.0 117 1

Seq Scan on persons p_u (cost=0.00..1.77 rows=117 width=72) (actual time=0.005..0.043 rows=117 loops=1)

102. 0.038 0.238 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.238..0.238 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
103. 0.088 0.200 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.095..0.200 rows=149 loops=1)

  • Hash Cond: (tm_pr.person_id = p_pr.id)
104. 0.034 0.034 ↓ 1.0 149 1

Seq Scan on team_members tm_pr (cost=0.00..1.88 rows=148 width=16) (actual time=0.008..0.034 rows=149 loops=1)

105. 0.039 0.078 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.078..0.078 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
106. 0.039 0.039 ↑ 1.0 117 1

Seq Scan on persons p_pr (cost=0.00..1.77 rows=117 width=72) (actual time=0.005..0.039 rows=117 loops=1)

107. 0.048 0.236 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.236..0.236 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
108. 0.079 0.188 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.093..0.188 rows=149 loops=1)

  • Hash Cond: (tm_s.person_id = p_s.id)
109. 0.032 0.032 ↓ 1.0 149 1

Seq Scan on team_members tm_s (cost=0.00..1.88 rows=148 width=16) (actual time=0.006..0.032 rows=149 loops=1)

110. 0.041 0.077 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.077..0.077 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
111. 0.036 0.036 ↑ 1.0 117 1

Seq Scan on persons p_s (cost=0.00..1.77 rows=117 width=72) (actual time=0.005..0.036 rows=117 loops=1)

112. 0.060 0.240 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.240..0.240 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
113. 0.077 0.180 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.092..0.180 rows=149 loops=1)

  • Hash Cond: (tm_cl.person_id = p_cl.id)
114. 0.026 0.026 ↓ 1.0 149 1

Seq Scan on team_members tm_cl (cost=0.00..1.88 rows=148 width=16) (actual time=0.005..0.026 rows=149 loops=1)

115. 0.036 0.077 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.077..0.077 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
116. 0.041 0.041 ↑ 1.0 117 1

Seq Scan on persons p_cl (cost=0.00..1.77 rows=117 width=72) (actual time=0.005..0.041 rows=117 loops=1)

117. 0.052 0.273 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.272..0.273 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
118. 0.084 0.221 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.131..0.221 rows=149 loops=1)

  • Hash Cond: (tm_re.person_id = p_re.id)
119. 0.025 0.025 ↓ 1.0 149 1

Seq Scan on team_members tm_re (cost=0.00..1.88 rows=148 width=16) (actual time=0.006..0.025 rows=149 loops=1)

120. 0.053 0.112 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.112..0.112 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
121. 0.059 0.059 ↑ 1.0 117 1

Seq Scan on persons p_re (cost=0.00..1.77 rows=117 width=72) (actual time=0.025..0.059 rows=117 loops=1)

122. 0.039 0.086 ↓ 1.0 149 1

Hash (cost=1.88..1.88 rows=148 width=16) (actual time=0.085..0.086 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
123. 0.047 0.047 ↓ 1.0 149 1

Seq Scan on team_members tm_ma (cost=0.00..1.88 rows=148 width=16) (actual time=0.008..0.047 rows=149 loops=1)

124. 0.044 0.078 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.078..0.078 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
125. 0.034 0.034 ↑ 1.0 117 1

Seq Scan on persons p_ma (cost=0.00..1.77 rows=117 width=72) (actual time=0.005..0.034 rows=117 loops=1)

126.          

CTE ltv_dti

127. 16.312 641.511 ↓ 35.4 13,316 1

Subquery Scan on a_1 (cost=31,114.95..33,558.33 rows=376 width=28) (actual time=546.567..641.511 rows=13,316 loops=1)

  • Filter: (a_1.rn = 1)
  • Rows Removed by Filter: 61292
128. 56.448 625.199 ↑ 1.0 74,608 1

WindowAgg (cost=31,114.95..32,618.57 rows=75,181 width=36) (actual time=546.551..625.199 rows=74,608 loops=1)

129. 90.543 568.751 ↑ 1.0 74,608 1

Sort (cost=31,114.95..31,302.90 rows=75,181 width=28) (actual time=546.536..568.751 rows=74,608 loops=1)

  • Sort Key: loan_tolerance_snapshot_items.loan_application_id, loan_tolerance_snapshot_items.last_updated_date DESC
  • Sort Method: quicksort Memory: 8901kB
130. 30.156 478.208 ↑ 1.0 74,608 1

Gather (cost=10.00..25,026.01 rows=75,181 width=28) (actual time=8.140..478.208 rows=74,608 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
131. 448.052 448.052 ↑ 1.3 24,869 3 / 3

Parallel Seq Scan on loan_tolerance_snapshot_items (cost=0.00..17,497.91 rows=31,325 width=28) (actual time=0.087..448.052 rows=24,869 loops=3)

  • Filter: (tolerance_property_id = 4)
  • Rows Removed by Filter: 678633
132.          

CTE excl_addr

133. 0.013 18.149 ↓ 11.0 11 1

Nested Loop (cost=0.72..1,017.50 rows=1 width=29) (actual time=1.951..18.149 rows=11 loops=1)

134. 0.315 18.092 ↓ 11.0 11 1

Nested Loop (cost=0.58..1,017.24 rows=1 width=37) (actual time=1.938..18.092 rows=11 loops=1)

135. 1.026 11.819 ↓ 1.1 993 1

Nested Loop (cost=0.29..724.59 rows=874 width=32) (actual time=0.044..11.819 rows=993 loops=1)

136. 6.821 6.821 ↑ 1.0 993 1

Seq Scan on loan_applications la_2 (cost=0.00..360.60 rows=993 width=16) (actual time=0.021..6.821 rows=993 loops=1)

  • Filter: (loan_status_id = 23)
  • Rows Removed by Filter: 19612
137. 3.972 3.972 ↑ 1.0 1 993

Index Scan using property_information_loan_application_idx on property_information pri_1 (cost=0.29..0.36 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=993)

  • Index Cond: (loan_application_id = la_2.id)
  • Filter: ((NOT is_removed) AND (NOT is_removed))
138. 5.958 5.958 ↓ 0.0 0 993

Index Scan using addresses_pkey on addresses addr_1 (cost=0.29..0.32 rows=1 width=37) (actual time=0.006..0.006 rows=0 loops=993)

  • Index Cond: (address_id = pri_1.address_id)
  • Filter: ((pri_1.loan_application_id = loan_application_id) AND (lower(street_address) ~~ '%tbd%'::text))
  • Rows Removed by Filter: 1
139. 0.044 0.044 ↑ 1.0 1 11

Index Only Scan using loan_status_pkey on loan_status lon (cost=0.14..0.26 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=11)

  • Index Cond: (id = 23)
  • Heap Fetches: 11
140.          

CTE mi

141. 3.136 33.507 ↓ 181.7 9,992 1

Subquery Scan on a_2 (cost=884.29..1,402.23 rows=55 width=48) (actual time=10.633..33.507 rows=9,992 loops=1)

  • Filter: (a_2.rn = 1)
  • Rows Removed by Filter: 916
142. 16.246 30.371 ↓ 1.0 10,908 1

WindowAgg (cost=884.29..1,265.93 rows=10,904 width=56) (actual time=10.627..30.371 rows=10,908 loops=1)

143. 9.761 14.125 ↓ 1.0 10,908 1

Sort (cost=884.29..911.55 rows=10,904 width=20) (actual time=10.596..14.125 rows=10,908 loops=1)

  • Sort Key: mortgage_insurances.loan_application_id, mortgage_insurances.last_updated_date DESC
  • Sort Method: quicksort Memory: 1046kB
144. 4.364 4.364 ↓ 1.0 10,908 1

Seq Scan on mortgage_insurances (cost=0.00..153.04 rows=10,904 width=20) (actual time=0.015..4.364 rows=10,908 loops=1)

145.          

CTE last_pro

146. 1.137 47.691 ↓ 177.0 3,893 1

Subquery Scan on a_3 (cost=1,747.68..1,934.38 rows=22 width=88) (actual time=37.614..47.691 rows=3,893 loops=1)

  • Filter: (a_3.rn = 1)
  • Rows Removed by Filter: 601
147. 7.627 46.554 ↓ 1.0 4,494 1

WindowAgg (cost=1,747.68..1,879.47 rows=4,393 width=88) (actual time=37.609..46.554 rows=4,494 loops=1)

148. 4.928 38.927 ↓ 1.0 4,494 1

Sort (cost=1,747.68..1,758.66 rows=4,393 width=144) (actual time=37.583..38.927 rows=4,494 loops=1)

  • Sort Key: ltm.loan_application_id, ltmu.last_updated_date DESC
  • Sort Method: quicksort Memory: 549kB
149. 2.245 33.999 ↓ 1.0 4,494 1

Hash Left Join (cost=537.07..1,481.88 rows=4,393 width=144) (actual time=14.140..33.999 rows=4,494 loops=1)

  • Hash Cond: (ltmu.processor_member_id_new = tm_pr_1.id)
150. 1.415 31.472 ↓ 1.0 4,494 1

Hash Left Join (cost=528.38..1,453.58 rows=4,393 width=88) (actual time=13.832..31.472 rows=4,494 loops=1)

  • Hash Cond: (ltmu.processor_member_id_old = tm_pr_old.id)
151. 3.309 29.721 ↓ 1.0 4,494 1

Hash Join (cost=519.70..1,427.96 rows=4,393 width=32) (actual time=13.469..29.721 rows=4,494 loops=1)

  • Hash Cond: (ltmu.updated_id = ltm.id)
152. 13.170 13.170 ↓ 1.0 4,494 1

Seq Scan on loan_application_team_members_updates ltmu (cost=0.00..847.79 rows=4,411 width=32) (actual time=0.039..13.170 rows=4,494 loops=1)

  • Filter: (processor_member_id_new IS NOT NULL)
  • Rows Removed by Filter: 58425
153. 6.243 13.242 ↓ 1.0 20,597 1

Hash (cost=267.31..267.31 rows=20,191 width=16) (actual time=13.242..13.242 rows=20,597 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1222kB
154. 6.999 6.999 ↓ 1.0 20,597 1

Seq Scan on loan_application_team_members ltm (cost=0.00..267.31 rows=20,191 width=16) (actual time=0.012..6.999 rows=20,597 loops=1)

155. 0.090 0.336 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.336..0.336 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
156. 0.107 0.246 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.130..0.246 rows=149 loops=1)

  • Hash Cond: (tm_pr_old.person_id = p_pr_old.id)
157. 0.044 0.044 ↓ 1.0 149 1

Seq Scan on team_members tm_pr_old (cost=0.00..1.88 rows=148 width=16) (actual time=0.016..0.044 rows=149 loops=1)

158. 0.046 0.095 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.095..0.095 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
159. 0.049 0.049 ↑ 1.0 117 1

Seq Scan on persons p_pr_old (cost=0.00..1.77 rows=117 width=72) (actual time=0.010..0.049 rows=117 loops=1)

160. 0.062 0.282 ↓ 1.0 149 1

Hash (cost=6.84..6.84 rows=148 width=72) (actual time=0.282..0.282 rows=149 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
161. 0.102 0.220 ↓ 1.0 149 1

Hash Left Join (cost=3.23..6.84 rows=148 width=72) (actual time=0.126..0.220 rows=149 loops=1)

  • Hash Cond: (tm_pr_1.person_id = p_pr_1.id)
162. 0.027 0.027 ↓ 1.0 149 1

Seq Scan on team_members tm_pr_1 (cost=0.00..1.88 rows=148 width=16) (actual time=0.008..0.027 rows=149 loops=1)

163. 0.047 0.091 ↑ 1.0 117 1

Hash (cost=1.77..1.77 rows=117 width=72) (actual time=0.091..0.091 rows=117 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
164. 0.044 0.044 ↑ 1.0 117 1

Seq Scan on persons p_pr_1 (cost=0.00..1.77 rows=117 width=72) (actual time=0.010..0.044 rows=117 loops=1)

165.          

CTE tf_flag

166. 14.821 14.821 ↑ 1.0 20,595 1

Index Scan using affiliated_business_details_loan_and_business_idx on affiliated_business_details (cost=0.29..595.00 rows=20,698 width=9) (actual time=0.018..14.821 rows=20,595 loops=1)

  • Index Cond: (business_type = 2)
167.          

CTE qc_details

168. 1.565 173.983 ↑ 1.0 1,519 1

Unique (cost=7,351.65..7,436.74 rows=1,547 width=376) (actual time=170.526..173.983 rows=1,519 loops=1)

169. 8.795 172.418 ↑ 1.0 1,519 1

Sort (cost=7,351.65..7,355.52 rows=1,547 width=376) (actual time=170.525..172.418 rows=1,519 loops=1)

  • Sort Key: loan_deficiencies.loan_application_id, (max(loan_deficiencies.response_submitted_date)), (max(CASE WHEN (loan_deficiencies.severity_type = ANY ('{2,3,4,5}'::integer[])) THEN loan_deficiencies.severity_type ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = 2) THEN 1 ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = 3) THEN 1 ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = ANY ('{4,5}'::integer[])) THEN 1 ELSE NULL::integer END)), (string_agg((COALESCE((loan_deficiencies.severity_type)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg(COALESCE(loan_deficiencies.description, '-'::text), 'newline'::text)), (string_agg((COALESCE((loan_deficiencies.deficiency_category_type)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg((COALESCE((loan_deficiencies.deficiency_subcategory_type)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg((COALESCE((loan_deficiencies.area_of_responsibility_type)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg((COALESCE((prs1_1.last_name)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg((COALESCE((loan_deficiencies.responsible_party_comments)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg((COALESCE((loan_deficiencies.initial_reviewer_comments)::character varying, '-'::character varying))::text, 'newline'::text)), (string_agg((COALESCE((loan_deficiencies.reporting_result_type)::character varying, '-'::character varying))::text, 'newline'::text)), (count(CASE WHEN (loan_deficiencies.severity_type = ANY ('{2,3,4,5}'::integer[])) THEN 1 ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = 6) THEN 1 ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = 7) THEN 1 ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = 8) THEN 1 ELSE NULL::integer END)), (count(CASE WHEN (loan_deficiencies.severity_type = ANY ('{6,7,8}'::integer[])) THEN 1 ELSE NULL::integer END)), (max(CASE WHEN (loan_deficiencies.severity_type = ANY ('{6,7,8}'::integer[])) THEN loan_deficiencies.severity_type ELSE NULL::integer END))
  • Sort Method: quicksort Memory: 4326kB
170. 65.198 163.623 ↑ 1.0 1,519 1

GroupAggregate (cost=5,750.96..7,269.70 rows=1,547 width=376) (actual time=92.589..163.623 rows=1,519 loops=1)

  • Group Key: loan_deficiencies.loan_application_id
171. 18.149 98.425 ↑ 1.1 12,423 1

Sort (cost=5,750.96..5,783.59 rows=13,053 width=508) (actual time=92.461..98.425 rows=12,423 loops=1)

  • Sort Key: loan_deficiencies.loan_application_id
  • Sort Method: quicksort Memory: 4372kB
172. 25.664 80.276 ↑ 1.1 12,423 1

Gather (cost=13.23..4,858.65 rows=13,053 width=508) (actual time=9.943..80.276 rows=12,423 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
173. 5.179 54.612 ↑ 1.3 4,141 3 / 3

Hash Join (cost=3.23..3,543.35 rows=5,439 width=508) (actual time=0.395..54.612 rows=4,141 loops=3)

  • Hash Cond: (loan_deficiencies.responsible_party_login_id = prs1_1.login_id)
174. 49.315 49.315 ↑ 1.2 4,400 3 / 3

Parallel Seq Scan on loan_deficiencies (cost=0.00..3,465.11 rows=5,498 width=484) (actual time=0.045..49.315 rows=4,400 loops=3)

  • Filter: (severity_type IS NOT NULL)
  • Rows Removed by Filter: 119477
175. 0.043 0.118 ↑ 1.0 117 3 / 3

Hash (cost=1.77..1.77 rows=117 width=40) (actual time=0.118..0.118 rows=117 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
176. 0.075 0.075 ↑ 1.0 117 3 / 3

Seq Scan on persons prs1_1 (cost=0.00..1.77 rows=117 width=40) (actual time=0.028..0.075 rows=117 loops=3)

177.          

CTE loan_apps

178. 17.142 40.004 ↓ 1.1 11,588 1

Sort (cost=1,176.47..1,202.21 rows=10,296 width=220) (actual time=32.845..40.004 rows=11,588 loops=1)

  • Sort Key: la_3.id
  • Sort Method: quicksort Memory: 3463kB
179. 7.862 22.862 ↓ 1.1 11,588 1

Hash Join (cost=0.95..490.25 rows=10,296 width=220) (actual time=0.123..22.862 rows=11,588 loops=1)

  • Hash Cond: (la_3.loan_status_id = ls_1.id)
180. 14.958 14.958 ↓ 1.0 20,605 1

Seq Scan on loan_applications la_3 (cost=0.00..309.12 rows=20,592 width=220) (actual time=0.036..14.958 rows=20,605 loops=1)

181. 0.017 0.042 ↓ 1.5 34 1

Hash (cost=0.66..0.66 rows=23 width=8) (actual time=0.042..0.042 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
182. 0.025 0.025 ↓ 1.5 34 1

Seq Scan on loan_status ls_1 (cost=0.00..0.66 rows=23 width=8) (actual time=0.017..0.025 rows=34 loops=1)

  • Filter: is_active
  • Rows Removed by Filter: 19
183. 35.582 3,028.962 ↑ 3,952,786.1 11,574 1

Sort (cost=33,213,126,973.82..33,327,500,840.76 rows=45,749,546,778 width=1,599) (actual time=3,026.771..3,028.962 rows=11,574 loops=1)

  • Sort Key: la.id, (CASE WHEN (la.loan_type_id = ANY ('{4,5,6}'::bigint[])) THEN 'Refi'::text ELSE 'Purchase'::text END), lt.home_price, lt.amount, la.loan_status_last_updated, cs.loan_fico, i.investor_loan_id, lt.interest_rate, w.advance_amount, w.participation_amount, (((b.last_name || ', '::text) || b.first_name)), l.name, addr.state_code, addr.county, (((((((((COALESCE(addr.street_address, ''::text) || ', '::text) || COALESCE(addr.unit, ''::text)) || ', '::text) || COALESCE(addr.city, ''::text)) || ', '::text) || COALESCE(addr.state_code, ''::text)) || ' '::text) || COALESCE(addr.zip_code, ''::text))), (CASE WHEN (lad.application_received_local_date IS NULL) THEN NULL::text WHEN ((ca.created_instant)::date < ('now'::cstring)::date) THEN 'Met'::text WHEN ((ex_addr.id IS NULL) AND (lad.application_received_local_date IS NOT NULL)) THEN (((ca.created_instant)::date + '30 days'::interval))::text ELSE NULL::text END), wi.escrow_file_id, (CASE WHEN (pri.project_type = 2) THEN 'Condo'::text WHEN (pri.num_units > 1) THEN 'Multi-Fam'::text WHEN (pri.num_units = 1) THEN 'SFR'::text ELSE 'Other'::text END), (CASE lt.product_type_id WHEN 1 THEN '30 Yr Fixed'::text WHEN 2 THEN '15 Yr Fixed'::text WHEN 3 THEN '5/1 ARM'::text WHEN 4 THEN '7/1 ARM'::text WHEN 5 THEN '10/1 ARM'::text WHEN 6 THEN '20 Yr Fixed'::text WHEN 7 THEN '25 Yr Fixed'::text WHEN 8 THEN '10 Yr Fixed'::text WHEN 9 THEN '3/1 ARM'::text ELSE NULL::text END), (CASE lt.occupancy_type_id WHEN 1 THEN 'primary'::text WHEN 2 THEN 'secondary'::text WHEN 3 THEN 'investment'::text ELSE NULL::text END), (((ltv.value_on_creation)::text || '%'::text)), imd.display_name, mi.mi_company, wm.display_name, i.commitment_number, la.mers_min, w.release_number, t.mortgage_adviser, t.processor, t.underwriter, t.closer, t.quality_reviewer, t.secondary, (CASE WHEN (ex_addr.id IS NULL) THEN lad.application_received_local_date ELSE NULL::date END), lad.closing_local_date, w.funding_local_date, (CASE WHEN (lad.rate_lock_cancelled_local_date IS NULL) THEN lad.rate_lock_local_date ELSE NULL::date END), lad.closing_disclosure_issued_local_date, lad.closing_disclosure_received_local_date, lad.cd_ordered_date, lad.loan_estimate_issued_local_date, lad.le_received_local_date, lad.appraisal_contingency_local_date, lad.financing_contingency_local_date, ip.received_date, lad.rate_lock_expiration_local_date, (COALESCE(ms_app1.field_value, faa.ordered_local_date)), faa.delivered_local_date, laa.delivered_local_date, ms_pr_ti.field_value, ms_icr.field_value, ms_pre.field_value, ms_cd.field_value, faa.sent_to_underwriter_local_date, laa.sent_to_underwriter_local_date, faa.reviewed_date_local_date, laa.reviewed_date_local_date, ms_pc_reg.field_value, ms_pc_tr.field_value, ms_pc_sp.field_value, ms_pc_co.field_value, ms_pc_coi.field_value, ms_pc_s.field_value, ms_pc_sc.field_value, ms_pc_stm.field_value, ms_pc_rmr.field_value, ms_pc_tpr.field_value, ((ctc_docs.created_instant)::date), ((uw_pre.created_instant)::date), ((uw_pred.created_instant)::date), ((uw_f.created_instant)::date), ((dis.created_instant)::date), w.funds_ordered_local_date, lad.pa_conditions_requested_date, ((min_qr.created_instant)::date), ((min_qr2.created_instant)::date), ((uw_f_min.created_instant)::date), ((ctc_docs_h.created_instant)::date), ((ctc_docs_f.created_instant)::date), ((cl.created_instant)::date), i.ship_date, i.purchase_date, i.commitment_expiration_date, i.commitment_date, i.first_payment_due, i.service_release_date, ((ca.created_instant)::date), ((reg.created_instant)::date), ((last_pro.last_updated_date)::date), (CASE WHEN (l.is_1003_submitted AND (NOT l.is_shipped)) THEN true ELSE false END), lt.eclosing, l.is_active, (COALESCE(tf.is_title_forward, la.is_title_forward)), (CASE WHEN (la.loan_status_id = 36) THEN true ELSE false END), (CASE WHEN ((ex_addr.id IS NULL) AND (lad.application_received_local_date IS NOT NULL)) THEN true ELSE false END), faa.appraisal_waiver, laa.appraisal_waiver, qbi.id, qbi.""Borrower_Name"", qbi.""QA1_Status"", qbi.""QA1_Started_Date"", qbi.""QA1_Reviewer"", qbi.""QA1_Schedule"", qbi.""QA1_Reason"", qbi.""QA2_Status"", qbi.""QA2_Started_Date"", qbi.""QA2_Reviewer"", qbi.""QA2_Schedule"", qbi.""QA2_Reason"", qbi.""QC_Status"", qbi.""QC_Started_Date"", qbi.""QC_Reviewer"", qbi.""RQC_Status"", qbi.""RQC_Started_Date"", qbi.""RQC_Reviewer"", qbi.""REOS"", qcd.loan_application_id, qcd.last_response_date, qcd.highest_qc_severity, qcd.minor_total, qcd.moderate_total, qcd.major_total, qcd.severity, qcd.reason, qcd.category, qcd.subcategory, qcd.aor, qcd.responsible_party, qcd.responsible_party_comments, qcd.initial_reviewer_comments, qcd.reporting_results, qcd.qc_severity_total, qcd.low_total, qcd.medium_total, qcd.high_total, qcd.rqc_severity_total, qcd.highest_rqc_severity, ff.loan_application_id, ff.form_free, ((date_part('epoch'::text, (now() - pg_last_xact_replay_timestamp())))::integer)
  • Sort Method: quicksort Memory: 3482kB
184. 124.184 2,993.380 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=31,639.43..12,415,188,366.22 rows=45,749,546,778 width=1,599) (actual time=2,298.646..2,993.380 rows=11,574 loops=1)

  • Merge Cond: (la.id = ctc_docs_f.loan_application_id)
185. 11.112 2,866.081 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=31,429.09..5,795,228,737.10 rows=45,749,546,778 width=2,001) (actual time=2,296.134..2,866.081 rows=11,574 loops=1)

  • Merge Cond: (la.id = ctc_docs_h.loan_application_id)
186. 11.360 2,851.866 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=31,218.75..5,523,018,723.43 rows=45,749,546,778 width=1,993) (actual time=2,293.773..2,851.866 rows=11,574 loops=1)

  • Merge Cond: (la.id = uw_f_min.loan_application_id)
187. 10.922 2,837.020 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=31,008.40..5,250,808,709.76 rows=45,749,546,778 width=1,985) (actual time=2,291.167..2,837.020 rows=11,574 loops=1)

  • Merge Cond: (la.id = min_qr2.loan_application_id)
188. 11.322 2,823.388 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=30,798.06..4,978,598,696.09 rows=45,749,546,778 width=1,977) (actual time=2,289.015..2,823.388 rows=11,574 loops=1)

  • Merge Cond: (la.id = min_qr.loan_application_id)
189. 12.057 2,744.044 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=30,587.72..4,706,388,682.42 rows=45,749,546,778 width=1,969) (actual time=2,221.637..2,744.044 rows=11,574 loops=1)

  • Merge Cond: (la.id = reg.loan_application_id)
190. 11.729 2,729.056 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=30,310.13..4,382,710,361.38 rows=45,749,546,778 width=1,961) (actual time=2,219.000..2,729.056 rows=11,574 loops=1)

  • Merge Cond: (la.id = cl.loan_application_id)
191. 11.501 2,713.102 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=30,032.54..4,059,032,040.34 rows=45,749,546,778 width=1,953) (actual time=2,215.591..2,713.102 rows=11,574 loops=1)

  • Merge Cond: (la.id = ctc_docs.loan_application_id)
192. 11.716 2,697.724 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=29,754.95..3,735,353,719.30 rows=45,749,546,778 width=1,945) (actual time=2,212.351..2,697.724 rows=11,574 loops=1)

  • Merge Cond: (la.id = dis.loan_application_id)
193. 12.766 2,682.478 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=29,477.36..3,411,675,398.26 rows=45,749,546,778 width=1,937) (actual time=2,209.325..2,682.478 rows=11,574 loops=1)

  • Merge Cond: (la.id = uw_f.loan_application_id)
194. 11.721 2,665.526 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=29,199.77..3,087,997,077.22 rows=45,749,546,778 width=1,929) (actual time=2,205.904..2,665.526 rows=11,574 loops=1)

  • Merge Cond: (la.id = ca.loan_application_id)
195. 10.089 2,649.013 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=28,922.18..2,764,318,756.18 rows=45,749,546,778 width=1,921) (actual time=2,202.163..2,649.013 rows=11,574 loops=1)

  • Merge Cond: (la.id = uw_pred.loan_application_id)
196. 10.519 2,635.727 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=28,644.58..2,440,640,435.13 rows=45,749,546,778 width=1,913) (actual time=2,199.337..2,635.727 rows=11,574 loops=1)

  • Merge Cond: (la.id = uw_pre.loan_application_id)
197. 10.154 2,548.942 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=28,366.99..2,116,962,114.09 rows=45,749,546,778 width=1,905) (actual time=2,123.505..2,548.942 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_tpr.loan_application_id)
198. 9.676 2,527.166 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=27,146.88..1,999,155,811.02 rows=45,749,546,778 width=1,901) (actual time=2,111.938..2,527.166 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_rmr.loan_application_id)
199. 10.865 2,505.983 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=25,926.77..1,881,349,507.95 rows=45,749,546,778 width=1,897) (actual time=2,100.485..2,505.983 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_stm.loan_application_id)
200. 10.477 2,481.319 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=24,706.66..1,763,543,204.88 rows=45,749,546,778 width=1,893) (actual time=2,087.738..2,481.319 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_sc.loan_application_id)
201. 10.907 2,458.489 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=23,486.55..1,645,736,901.81 rows=45,749,546,778 width=1,889) (actual time=2,075.698..2,458.489 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_s.loan_application_id)
202. 10.676 2,435.250 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=22,266.44..1,527,930,598.74 rows=45,749,546,778 width=1,885) (actual time=2,063.840..2,435.250 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_coi.loan_application_id)
203. 11.221 2,410.768 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=21,046.33..1,410,124,295.67 rows=45,749,546,778 width=1,881) (actual time=2,051.127..2,410.768 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_co.loan_application_id)
204. 10.716 2,385.837 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=19,826.22..1,292,317,992.60 rows=45,749,546,778 width=1,877) (actual time=2,038.520..2,385.837 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_sp.loan_application_id)
205. 10.070 2,361.011 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=18,606.11..1,174,511,689.53 rows=45,749,546,778 width=1,873) (actual time=2,025.642..2,361.011 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_tr.loan_application_id)
206. 11.557 2,337.578 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=17,386.00..1,056,705,386.46 rows=45,749,546,778 width=1,869) (actual time=2,013.216..2,337.578 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pc_reg.loan_application_id)
207. 10.725 2,312.198 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=16,165.89..938,899,083.39 rows=45,749,546,778 width=1,865) (actual time=2,000.615..2,312.198 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_cd.loan_application_id)
208. 10.529 2,288.494 ↑ 3,952,786.1 11,574 1

Merge Left Join (cost=14,945.78..821,092,780.32 rows=45,749,546,778 width=1,861) (actual time=1,988.840..2,288.494 rows=11,574 loops=1)

  • Merge Cond: (la.id = qbi.id)
209. 10.584 2,120.021 ↑ 233,547.2 11,574 1

Merge Left Join (cost=14,679.64..128,091,624.65 rows=2,703,075,142 width=1,637) (actual time=1,832.247..2,120.021 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pre.loan_application_id)
210. 10.285 2,096.308 ↑ 233,547.2 11,574 1

Merge Left Join (cost=13,459.53..121,129,986.04 rows=2,703,075,142 width=1,633) (actual time=1,820.343..2,096.308 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_icr.loan_application_id)
211. 10.975 2,072.262 ↑ 233,547.2 11,574 1

Merge Left Join (cost=12,239.42..114,168,347.43 rows=2,703,075,142 width=1,629) (actual time=1,807.837..2,072.262 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_pr_ti.loan_application_id)
212. 9.507 2,045.478 ↑ 233,547.2 11,574 1

Merge Left Join (cost=11,019.31..107,206,708.82 rows=2,703,075,142 width=1,625) (actual time=1,793.677..2,045.478 rows=11,574 loops=1)

  • Merge Cond: (la.id = ms_app1.loan_application_id)
213. 9.714 1,923.214 ↑ 233,547.2 11,574 1

Merge Left Join (cost=9,799.20..100,245,070.21 rows=2,703,075,142 width=1,621) (actual time=1,681.225..1,923.214 rows=11,574 loops=1)

  • Merge Cond: (la.id = last_pro.loan_application_id)
214. 8.339 1,860.403 ↑ 233,547.2 11,574 1

Merge Left Join (cost=9,798.27..89,027,307.44 rows=2,703,075,142 width=1,613) (actual time=1,629.543..1,860.403 rows=11,574 loops=1)

  • Merge Cond: (la.id = ff.loan_application_id)
215. 12.556 1,851.891 ↑ 233,547.2 11,574 1

Merge Left Join (cost=9,786.62..41,723,480.81 rows=2,703,075,142 width=1,573) (actual time=1,629.373..1,851.891 rows=11,574 loops=1)

  • Merge Cond: (la.id = cs.loan_application_id)
216. 9.341 1,780.644 ↑ 4,215.7 11,574 1

Merge Left Join (cost=8,820.69..1,054,407.88 rows=48,791,970 width=1,569) (actual time=1,574.442..1,780.644 rows=11,574 loops=1)

  • Merge Cond: (la.id = qcd.loan_application_id)
217. 9.059 1,588.581 ↑ 545.0 11,574 1

Merge Left Join (cost=8,707.79..306,645.57 rows=6,307,947 width=1,193) (actual time=1,393.478..1,588.581 rows=11,574 loops=1)

  • Merge Cond: (la.id = laa.loan_application_id)
218. 8.736 1,576.460 ↑ 545.0 11,574 1

Merge Left Join (cost=8,644.55..284,189.11 rows=6,307,947 width=1,180) (actual time=1,391.429..1,576.460 rows=11,574 loops=1)

  • Merge Cond: (la.id = faa.loan_application_id)
219. 11.049 1,550.290 ↑ 545.0 11,574 1

Merge Left Join (cost=8,581.31..261,732.66 rows=6,307,947 width=1,163) (actual time=1,375.020..1,550.290 rows=11,574 loops=1)

  • Merge Cond: (la.id = mi.loan_application_id)
220. 10.318 1,492.173 ↑ 545.0 11,574 1

Merge Left Join (cost=8,578.62..219,939.83 rows=6,307,947 width=1,131) (actual time=1,331.506..1,492.173 rows=11,574 loops=1)

  • Merge Cond: (la.id = i.loan_application_id)
221. 16.544 1,473.236 ↑ 545.0 11,574 1

Merge Left Join (cost=8,283.20..109,255.34 rows=6,307,947 width=1,056) (actual time=1,324.743..1,473.236 rows=11,574 loops=1)

  • Merge Cond: (la.id = t.loan_id)
222. 11.568 1,230.230 ↑ 5.3 11,574 1

Merge Left Join (cost=6,395.96..12,595.73 rows=61,266 width=864) (actual time=1,105.853..1,230.230 rows=11,574 loops=1)

  • Merge Cond: (la.id = ltv.loan_application_id)
223. 8.651 558.914 ↑ 5.3 11,574 1

Merge Left Join (cost=6,387.49..12,424.90 rows=61,266 width=348) (actual time=450.325..558.914 rows=11,574 loops=1)

  • Merge Cond: (la.id = wi.loan_application_id)
224. 5.552 536.031 ↑ 5.3 11,574 1

Merge Left Join (cost=6,387.21..11,296.29 rows=61,266 width=337) (actual time=450.253..536.031 rows=11,574 loops=1)

  • Merge Cond: (la.id = ex_addr.id)
225. 14.305 512.279 ↑ 5.3 11,574 1

Nested Loop Left Join (cost=6,387.18..11,138.50 rows=61,266 width=329) (actual time=432.052..512.279 rows=11,574 loops=1)

  • Join Filter: (wm.id = w.warehouse_metadata_id)
  • Rows Removed by Join Filter: 34466
226. 14.979 486.400 ↑ 5.3 11,574 1

Merge Left Join (cost=6,387.18..8,381.29 rows=61,266 width=305) (actual time=432.010..486.400 rows=11,574 loops=1)

  • Merge Cond: (la.id = pri.loan_application_id)
227. 21.072 380.037 ↑ 5.3 11,574 1

Merge Left Join (cost=3,024.31..3,946.26 rows=61,266 width=249) (actual time=348.626..380.037 rows=11,574 loops=1)

  • Merge Cond: (la.id = tf.loan_application_id)
228. 19.980 323.826 ↓ 19.6 11,574 1

Sort (cost=1,126.60..1,128.08 rows=592 width=248) (actual time=318.968..323.826 rows=11,574 loops=1)

  • Sort Key: la.id
  • Sort Method: quicksort Memory: 2406kB
229. 7.761 303.846 ↓ 19.6 11,574 1

Nested Loop Left Join (cost=76.29..1,099.34 rows=592 width=248) (actual time=34.959..303.846 rows=11,574 loops=1)

230. 10.297 249.789 ↓ 19.6 11,574 1

Hash Left Join (cost=76.01..904.85 rows=592 width=196) (actual time=34.940..249.789 rows=11,574 loops=1)

  • Hash Cond: (la.id = ip.loan_application_id)
231. 6.225 237.589 ↓ 19.6 11,574 1

Nested Loop Left Join (cost=2.10..822.80 rows=592 width=192) (actual time=33.018..237.589 rows=11,574 loops=1)

232. 12.079 185.068 ↓ 19.6 11,574 1

Nested Loop Left Join (cost=1.81..626.41 rows=592 width=165) (actual time=32.999..185.068 rows=11,574 loops=1)

233. 15.050 138.267 ↓ 19.6 11,574 1

Nested Loop Left Join (cost=1.52..435.40 rows=592 width=113) (actual time=32.987..138.267 rows=11,574 loops=1)

234. 10.892 65.347 ↓ 19.6 11,574 1

Hash Join (cost=1.24..222.73 rows=592 width=108) (actual time=32.956..65.347 rows=11,574 loops=1)

  • Hash Cond: (la.loan_status_id = l.id)
235. 54.384 54.384 ↓ 4.5 11,574 1

CTE Scan on loan_apps la (cost=0.00..205.92 rows=2,574 width=73) (actual time=32.852..54.384 rows=11,574 loops=1)

  • Filter: ((NOT is_removed) AND (NOT is_test))
  • Rows Removed by Filter: 14
236. 0.028 0.071 ↓ 1.2 53 1

Hash (cost=0.66..0.66 rows=46 width=43) (actual time=0.070..0.071 rows=53 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
237. 0.043 0.043 ↓ 1.2 53 1

Seq Scan on loan_status l (cost=0.00..0.66 rows=46 width=43) (actual time=0.028..0.043 rows=53 loops=1)

238. 57.870 57.870 ↑ 1.0 1 11,574

Index Scan using borrowers_pkey on borrowers b (cost=0.29..0.35 rows=1 width=21) (actual time=0.005..0.005 rows=1 loops=11,574)

  • Index Cond: (la.primary_borrower_id = id)
  • Filter: (NOT is_removed)
239. 34.722 34.722 ↓ 0.0 0 11,574

Index Scan using loan_application_dates_unique_per_loan on loan_application_dates lad (cost=0.29..0.31 rows=1 width=60) (actual time=0.003..0.003 rows=0 loops=11,574)

  • Index Cond: (la.id = loan_application_id)
240. 46.296 46.296 ↑ 1.0 1 11,574

Index Scan using loan_terms_unique_per_loan on loan_terms lt (cost=0.29..0.32 rows=1 width=35) (actual time=0.003..0.004 rows=1 loops=11,574)

  • Index Cond: (la.id = loan_application_id)
241. 0.882 1.903 ↓ 1.0 2,902 1

Hash (cost=37.85..37.85 rows=2,885 width=12) (actual time=1.903..1.903 rows=2,902 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 169kB
242. 1.021 1.021 ↓ 1.0 2,902 1

Seq Scan on intent_to_proceed ip (cost=0.00..37.85 rows=2,885 width=12) (actual time=0.013..1.021 rows=2,902 loops=1)

243. 46.296 46.296 ↑ 1.0 1 11,574

Index Scan using warehouses_loan_application_idx on warehouses w (cost=0.29..0.32 rows=1 width=60) (actual time=0.003..0.004 rows=1 loops=11,574)

  • Index Cond: (loan_application_id = la.id)
244. 10.466 35.139 ↑ 1.0 20,594 1

Sort (cost=1,897.72..1,949.46 rows=20,698 width=9) (actual time=29.635..35.139 rows=20,594 loops=1)

  • Sort Key: tf.loan_application_id
  • Sort Method: quicksort Memory: 1734kB
245. 24.673 24.673 ↑ 1.0 20,595 1

CTE Scan on tf_flag tf (cost=0.00..413.96 rows=20,698 width=9) (actual time=0.022..24.673 rows=20,595 loops=1)

246. 20.533 91.384 ↑ 1.0 18,094 1

Sort (cost=3,362.87..3,408.18 rows=18,124 width=64) (actual time=83.367..91.384 rows=18,094 loops=1)

  • Sort Key: pri.loan_application_id
  • Sort Method: quicksort Memory: 2537kB
247. 38.696 70.851 ↑ 1.0 18,095 1

Hash Right Join (cost=544.19..2,080.99 rows=18,124 width=64) (actual time=15.191..70.851 rows=18,095 loops=1)

  • Hash Cond: ((addr.loan_application_id = pri.loan_application_id) AND (addr.address_id = pri.address_id))
  • Join Filter: (NOT pri.is_removed)
248. 17.025 17.025 ↓ 1.0 77,924 1

Seq Scan on addresses addr (cost=0.00..966.54 rows=76,034 width=66) (actual time=0.015..17.025 rows=77,924 loops=1)

249. 6.450 15.130 ↑ 1.0 18,095 1

Hash (cost=272.33..272.33 rows=18,124 width=23) (actual time=15.130..15.130 rows=18,095 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1206kB
250. 8.680 8.680 ↑ 1.0 18,095 1

Seq Scan on property_information pri (cost=0.00..272.33 rows=18,124 width=23) (actual time=0.020..8.680 rows=18,095 loops=1)

  • Filter: (NOT is_removed)
  • Rows Removed by Filter: 9
251. 11.556 11.574 ↑ 1.0 3 11,574

Materialize (cost=0.00..0.24 rows=3 width=40) (actual time=0.000..0.001 rows=3 loops=11,574)

252. 0.018 0.018 ↑ 1.0 3 1

Seq Scan on warehouse_metadata wm (cost=0.00..0.23 rows=3 width=40) (actual time=0.018..0.018 rows=3 loops=1)

253. 0.008 18.200 ↓ 11.0 11 1

Materialize (cost=0.03..0.04 rows=1 width=8) (actual time=18.193..18.200 rows=11 loops=1)

254. 0.027 18.192 ↓ 11.0 11 1

Sort (cost=0.03..0.04 rows=1 width=8) (actual time=18.189..18.192 rows=11 loops=1)

  • Sort Key: ex_addr.id
  • Sort Method: quicksort Memory: 25kB
255. 18.165 18.165 ↓ 11.0 11 1

CTE Scan on excl_addr ex_addr (cost=0.00..0.02 rows=1 width=8) (actual time=1.955..18.165 rows=11 loops=1)

256. 1.439 14.232 ↓ 1.1 3,056 1

Materialize (cost=0.28..69.01 rows=2,786 width=19) (actual time=0.051..14.232 rows=3,056 loops=1)

257. 12.793 12.793 ↓ 1.1 3,056 1

Index Scan using wire_information_loan_application_idx on wire_information wi (cost=0.28..62.04 rows=2,786 width=19) (actual time=0.023..12.793 rows=3,056 loops=1)

  • Filter: (NOT is_removed)
  • Rows Removed by Filter: 157
258. 8.652 659.748 ↓ 6,657.5 13,315 1

Sort (cost=8.47..8.47 rows=2 width=524) (actual time=655.520..659.748 rows=13,315 loops=1)

  • Sort Key: ltv.loan_application_id
  • Sort Method: quicksort Memory: 1009kB
259. 651.096 651.096 ↓ 6,658.0 13,316 1

CTE Scan on ltv_dti ltv (cost=0.00..8.46 rows=2 width=524) (actual time=546.579..651.096 rows=13,316 loops=1)

  • Filter: (tolerance_property_id = 4)
260. 19.479 226.462 ↓ 1.0 20,604 1

Sort (cost=1,887.24..1,938.72 rows=20,592 width=200) (actual time=218.868..226.462 rows=20,604 loops=1)

  • Sort Key: t.loan_id
  • Sort Method: quicksort Memory: 2287kB
261. 206.983 206.983 ↓ 1.0 20,605 1

CTE Scan on team t (cost=0.00..411.84 rows=20,592 width=200) (actual time=1.856..206.983 rows=20,605 loops=1)

262. 4.054 8.619 ↓ 1.0 3,455 1

Sort (cost=295.42..303.96 rows=3,416 width=83) (actual time=6.752..8.619 rows=3,455 loops=1)

  • Sort Key: i.loan_application_id
  • Sort Method: quicksort Memory: 543kB
263. 1.608 4.565 ↓ 1.0 3,455 1

Hash Left Join (cost=0.38..94.93 rows=3,416 width=83) (actual time=0.061..4.565 rows=3,455 loops=1)

  • Hash Cond: (i.investor_metadata_id = imd.id)
264. 2.939 2.939 ↓ 1.0 3,455 1

Seq Scan on investors i (cost=0.00..58.96 rows=3,416 width=59) (actual time=0.031..2.939 rows=3,455 loops=1)

265. 0.007 0.018 ↓ 1.4 11 1

Hash (cost=0.28..0.28 rows=8 width=40) (actual time=0.017..0.018 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
266. 0.011 0.011 ↓ 1.4 11 1

Seq Scan on investor_metadata imd (cost=0.00..0.28 rows=8 width=40) (actual time=0.008..0.011 rows=11 loops=1)

267. 7.533 47.068 ↓ 181.7 9,992 1

Sort (cost=2.69..2.83 rows=55 width=40) (actual time=43.499..47.068 rows=9,992 loops=1)

  • Sort Key: mi.loan_application_id
  • Sort Method: quicksort Memory: 920kB
268. 39.535 39.535 ↓ 181.7 9,992 1

CTE Scan on mi (cost=0.00..1.10 rows=55 width=40) (actual time=10.638..39.535 rows=9,992 loops=1)

269. 2.197 17.434 ↓ 198.9 2,785 1

Sort (cost=63.24..63.28 rows=14 width=25) (actual time=16.402..17.434 rows=2,785 loops=1)

  • Sort Key: faa.loan_application_id
  • Sort Method: quicksort Memory: 298kB
270. 15.237 15.237 ↓ 198.9 2,785 1

CTE Scan on all_appraisals faa (cost=0.00..62.98 rows=14 width=25) (actual time=8.739..15.237 rows=2,785 loops=1)

  • Filter: (asc_app_rn = 1)
  • Rows Removed by Filter: 17
271. 2.014 3.062 ↓ 198.9 2,785 1

Sort (cost=63.24..63.28 rows=14 width=21) (actual time=2.043..3.062 rows=2,785 loops=1)

  • Sort Key: laa.loan_application_id
  • Sort Method: quicksort Memory: 288kB
272. 1.048 1.048 ↓ 198.9 2,785 1

CTE Scan on all_appraisals laa (cost=0.00..62.98 rows=14 width=21) (actual time=0.005..1.048 rows=2,785 loops=1)

  • Filter: (desc_app_rn = 1)
  • Rows Removed by Filter: 17
273. 5.331 182.722 ↑ 1.0 1,519 1

Sort (cost=112.89..116.76 rows=1,547 width=376) (actual time=180.956..182.722 rows=1,519 loops=1)

  • Sort Key: qcd.loan_application_id
  • Sort Method: quicksort Memory: 4326kB
274. 177.391 177.391 ↑ 1.0 1,519 1

CTE Scan on qc_details qcd (cost=0.00..30.94 rows=1,547 width=376) (actual time=170.530..177.391 rows=1,519 loops=1)

275. 7.980 58.691 ↓ 1.0 11,093 1

Sort (cost=965.94..993.64 rows=11,080 width=12) (actual time=54.917..58.691 rows=11,093 loops=1)

  • Sort Key: cs.loan_application_id
  • Sort Method: quicksort Memory: 905kB
276. 50.711 50.711 ↓ 1.0 11,094 1

CTE Scan on fico_scores cs (cost=0.00..221.60 rows=11,080 width=12) (actual time=0.058..50.711 rows=11,094 loops=1)

277. 0.032 0.173 ↑ 11.8 17 1

Sort (cost=11.64..12.14 rows=200 width=40) (actual time=0.165..0.173 rows=17 loops=1)

  • Sort Key: ff.loan_application_id
  • Sort Method: quicksort Memory: 25kB
278. 0.141 0.141 ↑ 11.8 17 1

CTE Scan on form_free ff (cost=0.00..4.00 rows=200 width=40) (actual time=0.028..0.141 rows=17 loops=1)

279. 2.681 53.097 ↓ 177.0 3,893 1

Sort (cost=0.93..0.99 rows=22 width=16) (actual time=51.675..53.097 rows=3,893 loops=1)

  • Sort Key: last_pro.loan_application_id
  • Sort Method: quicksort Memory: 279kB
280. 50.416 50.416 ↓ 177.0 3,893 1

CTE Scan on last_pro (cost=0.00..0.44 rows=22 width=16) (actual time=37.618..50.416 rows=3,893 loops=1)

281. 0.126 112.757 ↓ 474.0 474 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=112.444..112.757 rows=474 loops=1)

282. 0.403 112.631 ↓ 474.0 474 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=112.441..112.631 rows=474 loops=1)

  • Sort Key: ms_app1.loan_application_id
  • Sort Method: quicksort Memory: 47kB
283. 112.228 112.228 ↓ 474.0 474 1

CTE Scan on misc_section ms_app1 (cost=0.00..1,220.10 rows=1 width=12) (actual time=70.169..112.228 rows=474 loops=1)

  • Filter: ((section_name = 'ProcessingServicesOrderedDatesSection'::text) AND (field_name = 'serviceAppraisal1Ordered'::text))
  • Rows Removed by Filter: 48379
284. 0.647 15.809 ↓ 2,424.0 2,424 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=14.154..15.809 rows=2,424 loops=1)

285. 1.625 15.162 ↓ 2,424.0 2,424 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=14.146..15.162 rows=2,424 loops=1)

  • Sort Key: ms_pr_ti.loan_application_id
  • Sort Method: quicksort Memory: 210kB
286. 13.537 13.537 ↓ 2,424.0 2,424 1

CTE Scan on misc_section ms_pr_ti (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.033..13.537 rows=2,424 loops=1)

  • Filter: ((section_name = 'ProcessingServicesOrderedDatesSection'::text) AND (field_name = 'serviceTitleDocumentsRequested'::text))
  • Rows Removed by Filter: 46429
287. 0.542 13.761 ↓ 2,015.0 2,015 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.500..13.761 rows=2,015 loops=1)

288. 1.245 13.219 ↓ 2,015.0 2,015 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.496..13.219 rows=2,015 loops=1)

  • Sort Key: ms_icr.loan_application_id
  • Sort Method: quicksort Memory: 143kB
289. 11.974 11.974 ↓ 2,015.0 2,015 1

CTE Scan on misc_section ms_icr (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.029..11.974 rows=2,015 loops=1)

  • Filter: ((section_name = 'ClosingMiscFactsDatesSection'::text) AND (field_name = 'closingInitialCloserReview'::text))
  • Rows Removed by Filter: 46838
290. 0.486 13.129 ↓ 2,019.0 2,019 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.899..13.129 rows=2,019 loops=1)

291. 1.248 12.643 ↓ 2,019.0 2,019 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.893..12.643 rows=2,019 loops=1)

  • Sort Key: ms_pre.loan_application_id
  • Sort Method: quicksort Memory: 143kB
292. 11.395 11.395 ↓ 2,019.0 2,019 1

CTE Scan on misc_section ms_pre (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.024..11.395 rows=2,019 loops=1)

  • Filter: ((section_name = 'ClosingMiscFactsDatesSection'::text) AND (field_name = 'closingPrelimCDSent'::text))
  • Rows Removed by Filter: 46834
293. 3.571 157.944 ↑ 1.4 2,376 1

Sort (cost=266.14..274.61 rows=3,385 width=224) (actual time=156.582..157.944 rows=2,376 loops=1)

  • Sort Key: qbi.id
  • Sort Method: quicksort Memory: 456kB
294. 154.373 154.373 ↑ 1.4 2,376 1

CTE Scan on quality_bypass_info qbi (cost=0.00..67.70 rows=3,385 width=224) (actual time=146.831..154.373 rows=2,376 loops=1)

295. 0.496 12.979 ↓ 1,975.0 1,975 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.768..12.979 rows=1,975 loops=1)

296. 1.391 12.483 ↓ 1,975.0 1,975 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.762..12.483 rows=1,975 loops=1)

  • Sort Key: ms_cd.loan_application_id
  • Sort Method: quicksort Memory: 141kB
297. 11.092 11.092 ↓ 1,975.0 1,975 1

CTE Scan on misc_section ms_cd (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.029..11.092 rows=1,975 loops=1)

  • Filter: ((section_name = 'ClosingMiscFactsDatesSection'::text) AND (field_name = 'closingCDBalanced'::text))
  • Rows Removed by Filter: 46878
298. 0.519 13.823 ↓ 1,992.0 1,992 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.594..13.823 rows=1,992 loops=1)

299. 1.486 13.304 ↓ 1,992.0 1,992 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.584..13.304 rows=1,992 loops=1)

  • Sort Key: ms_pc_reg.loan_application_id
  • Sort Method: quicksort Memory: 142kB
300. 11.818 11.818 ↓ 1,992.0 1,992 1

CTE Scan on misc_section ms_pc_reg (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.022..11.818 rows=1,992 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingRegisteredMERS'::text))
  • Rows Removed by Filter: 46861
301. 0.389 13.363 ↓ 1,534.0 1,534 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.420..13.363 rows=1,534 loops=1)

302. 1.104 12.974 ↓ 1,534.0 1,534 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.414..12.974 rows=1,534 loops=1)

  • Sort Key: ms_pc_tr.loan_application_id
  • Sort Method: quicksort Memory: 120kB
303. 11.870 11.870 ↓ 1,534.0 1,534 1

CTE Scan on misc_section ms_pc_tr (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.052..11.870 rows=1,534 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingTransferredMERS'::text))
  • Rows Removed by Filter: 47319
304. 0.472 14.110 ↓ 2,005.0 2,005 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.869..14.110 rows=2,005 loops=1)

305. 1.515 13.638 ↓ 2,005.0 2,005 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.865..13.638 rows=2,005 loops=1)

  • Sort Key: ms_pc_sp.loan_application_id
  • Sort Method: quicksort Memory: 142kB
306. 12.123 12.123 ↓ 2,005.0 2,005 1

CTE Scan on misc_section ms_pc_sp (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.022..12.123 rows=2,005 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingSettlementPackageReceived'::text))
  • Rows Removed by Filter: 46848
307. 0.433 13.710 ↓ 1,947.0 1,947 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.600..13.710 rows=1,947 loops=1)

308. 1.318 13.277 ↓ 1,947.0 1,947 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.595..13.277 rows=1,947 loops=1)

  • Sort Key: ms_pc_co.loan_application_id
  • Sort Method: quicksort Memory: 140kB
309. 11.959 11.959 ↓ 1,947.0 1,947 1

CTE Scan on misc_section ms_pc_co (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.024..11.959 rows=1,947 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingCollateralToWarehouse'::text))
  • Rows Removed by Filter: 46906
310. 0.424 13.806 ↓ 1,822.0 1,822 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.702..13.806 rows=1,822 loops=1)

311. 1.386 13.382 ↓ 1,822.0 1,822 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.698..13.382 rows=1,822 loops=1)

  • Sort Key: ms_pc_coi.loan_application_id
  • Sort Method: quicksort Memory: 134kB
312. 11.996 11.996 ↓ 1,822.0 1,822 1

CTE Scan on misc_section ms_pc_coi (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.017..11.996 rows=1,822 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingCollateralToInvestor'::text))
  • Rows Removed by Filter: 47031
313. 0.180 12.332 ↓ 722.0 722 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.851..12.332 rows=722 loops=1)

314. 0.644 12.152 ↓ 722.0 722 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.847..12.152 rows=722 loops=1)

  • Sort Key: ms_pc_s.loan_application_id
  • Sort Method: quicksort Memory: 58kB
315. 11.508 11.508 ↓ 722.0 722 1

CTE Scan on misc_section ms_pc_s (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.038..11.508 rows=722 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingSuspenseDate'::text))
  • Rows Removed by Filter: 48131
316. 0.133 12.353 ↓ 574.0 574 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.032..12.353 rows=574 loops=1)

317. 0.440 12.220 ↓ 574.0 574 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.022..12.220 rows=574 loops=1)

  • Sort Key: ms_pc_sc.loan_application_id
  • Sort Method: quicksort Memory: 51kB
318. 11.780 11.780 ↓ 574.0 574 1

CTE Scan on misc_section ms_pc_sc (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.040..11.780 rows=574 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingSuspenseClearedDate'::text))
  • Rows Removed by Filter: 48279
319. 0.439 13.799 ↓ 1,842.0 1,842 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.740..13.799 rows=1,842 loops=1)

320. 1.305 13.360 ↓ 1,842.0 1,842 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=12.712..13.360 rows=1,842 loops=1)

  • Sort Key: ms_pc_stm.loan_application_id
  • Sort Method: quicksort Memory: 135kB
321. 12.055 12.055 ↓ 1,842.0 1,842 1

CTE Scan on misc_section ms_pc_stm (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.040..12.055 rows=1,842 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingNoticeServicingTransferMailed'::text))
  • Rows Removed by Filter: 47011
322. 0.030 11.507 ↓ 91.0 91 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.447..11.507 rows=91 loops=1)

323. 0.125 11.477 ↓ 91.0 91 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.441..11.477 rows=91 loops=1)

  • Sort Key: ms_pc_rmr.loan_application_id
  • Sort Method: quicksort Memory: 29kB
324. 11.352 11.352 ↓ 91.0 91 1

CTE Scan on misc_section ms_pc_rmr (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.065..11.352 rows=91 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingRecordedMortgageReceived'::text))
  • Rows Removed by Filter: 48762
325. 0.031 11.622 ↓ 89.0 89 1

Materialize (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.560..11.622 rows=89 loops=1)

326. 0.137 11.591 ↓ 89.0 89 1

Sort (cost=1,220.11..1,220.12 rows=1 width=12) (actual time=11.542..11.591 rows=89 loops=1)

  • Sort Key: ms_pc_tpr.loan_application_id
  • Sort Method: quicksort Memory: 29kB
327. 11.454 11.454 ↓ 89.0 89 1

CTE Scan on misc_section ms_pc_tpr (cost=0.00..1,220.10 rows=1 width=12) (actual time=0.064..11.454 rows=89 loops=1)

  • Filter: ((section_name = 'FundingPostClosingDatesSection'::text) AND (field_name = 'fundingPostClosingFinalTitlePolicyReceived'::text))
  • Rows Removed by Filter: 48764
328. 0.821 76.266 ↓ 20.9 1,273 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=75.814..76.266 rows=1,273 loops=1)

  • Sort Key: uw_pre.loan_application_id
  • Sort Method: quicksort Memory: 108kB
329. 75.445 75.445 ↓ 20.9 1,273 1

CTE Scan on max_transition_events uw_pre (cost=0.00..275.78 rows=61 width=16) (actual time=66.415..75.445 rows=1,273 loops=1)

  • Filter: (to_status = 3)
  • Rows Removed by Filter: 12463
330. 0.694 3.197 ↓ 17.5 1,069 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=2.820..3.197 rows=1,069 loops=1)

  • Sort Key: uw_pred.loan_application_id
  • Sort Method: quicksort Memory: 99kB
331. 2.503 2.503 ↓ 17.5 1,069 1

CTE Scan on max_transition_events uw_pred (cost=0.00..275.78 rows=61 width=16) (actual time=0.006..2.503 rows=1,069 loops=1)

  • Filter: (to_status = 4)
  • Rows Removed by Filter: 12667
332. 1.936 4.792 ↓ 47.9 2,923 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=3.735..4.792 rows=2,923 loops=1)

  • Sort Key: ca.loan_application_id
  • Sort Method: quicksort Memory: 234kB
333. 2.856 2.856 ↓ 47.9 2,923 1

CTE Scan on max_transition_events ca (cost=0.00..275.78 rows=61 width=16) (actual time=0.005..2.856 rows=2,923 loops=1)

  • Filter: (to_status = 7)
  • Rows Removed by Filter: 10813
334. 1.461 4.186 ↓ 36.8 2,246 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=3.414..4.186 rows=2,246 loops=1)

  • Sort Key: uw_f.loan_application_id
  • Sort Method: quicksort Memory: 202kB
335. 2.725 2.725 ↓ 36.8 2,246 1

CTE Scan on max_transition_events uw_f (cost=0.00..275.78 rows=61 width=16) (actual time=0.006..2.725 rows=2,246 loops=1)

  • Filter: (to_status = 8)
  • Rows Removed by Filter: 11490
336. 0.950 3.530 ↓ 24.3 1,482 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=3.021..3.530 rows=1,482 loops=1)

  • Sort Key: dis.loan_application_id
  • Sort Method: quicksort Memory: 118kB
337. 2.580 2.580 ↓ 24.3 1,482 1

CTE Scan on max_transition_events dis (cost=0.00..275.78 rows=61 width=16) (actual time=0.005..2.580 rows=1,482 loops=1)

  • Filter: (to_status = 39)
  • Rows Removed by Filter: 12254
338. 1.231 3.877 ↓ 30.6 1,867 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=3.234..3.877 rows=1,867 loops=1)

  • Sort Key: ctc_docs.loan_application_id
  • Sort Method: quicksort Memory: 136kB
339. 2.646 2.646 ↓ 30.6 1,867 1

CTE Scan on max_transition_events ctc_docs (cost=0.00..275.78 rows=61 width=16) (actual time=0.108..2.646 rows=1,867 loops=1)

  • Filter: (to_status = 50)
  • Rows Removed by Filter: 11869
340. 1.526 4.225 ↓ 36.0 2,198 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=3.404..4.225 rows=2,198 loops=1)

  • Sort Key: cl.loan_application_id
  • Sort Method: quicksort Memory: 200kB
341. 2.699 2.699 ↓ 36.0 2,198 1

CTE Scan on max_transition_events cl (cost=0.00..275.78 rows=61 width=16) (actual time=0.007..2.699 rows=2,198 loops=1)

  • Filter: (to_status = 10)
  • Rows Removed by Filter: 11538
342. 0.493 2.931 ↓ 11.1 678 1

Sort (cost=277.59..277.74 rows=61 width=16) (actual time=2.633..2.931 rows=678 loops=1)

  • Sort Key: reg.loan_application_id
  • Sort Method: quicksort Memory: 56kB
343. 2.438 2.438 ↓ 11.1 678 1

CTE Scan on max_transition_events reg (cost=0.00..275.78 rows=61 width=16) (actual time=0.101..2.438 rows=678 loops=1)

  • Filter: (to_status = 43)
  • Rows Removed by Filter: 13058
344. 1.122 68.022 ↓ 30.7 1,412 1

Sort (cost=210.34..210.46 rows=46 width=16) (actual time=67.369..68.022 rows=1,412 loops=1)

  • Sort Key: min_qr.loan_application_id
  • Sort Method: quicksort Memory: 115kB
345. 66.900 66.900 ↓ 30.7 1,412 1

CTE Scan on min_transition_events min_qr (cost=0.00..209.07 rows=46 width=16) (actual time=46.171..66.900 rows=1,412 loops=1)

  • Filter: (to_status = 32)
  • Rows Removed by Filter: 7482
346. 0.939 2.710 ↓ 32.4 1,490 1

Sort (cost=210.34..210.46 rows=46 width=16) (actual time=2.147..2.710 rows=1,490 loops=1)

  • Sort Key: min_qr2.loan_application_id
  • Sort Method: quicksort Memory: 118kB
347. 1.771 1.771 ↓ 32.4 1,490 1

CTE Scan on min_transition_events min_qr2 (cost=0.00..209.07 rows=46 width=16) (actual time=0.008..1.771 rows=1,490 loops=1)

  • Filter: (to_status = 35)
  • Rows Removed by Filter: 7404
348. 1.517 3.486 ↓ 48.8 2,246 1

Sort (cost=210.34..210.46 rows=46 width=16) (actual time=2.600..3.486 rows=2,246 loops=1)

  • Sort Key: uw_f_min.loan_application_id
  • Sort Method: quicksort Memory: 202kB
349. 1.969 1.969 ↓ 48.8 2,246 1

CTE Scan on min_transition_events uw_f_min (cost=0.00..209.07 rows=46 width=16) (actual time=0.004..1.969 rows=2,246 loops=1)

  • Filter: (to_status = 8)
  • Rows Removed by Filter: 6648
350. 1.319 3.103 ↓ 40.8 1,879 1

Sort (cost=210.34..210.46 rows=46 width=16) (actual time=2.355..3.103 rows=1,879 loops=1)

  • Sort Key: ctc_docs_h.loan_application_id
  • Sort Method: quicksort Memory: 137kB
351. 1.784 1.784 ↓ 40.8 1,879 1

CTE Scan on min_transition_events ctc_docs_h (cost=0.00..209.07 rows=46 width=16) (actual time=0.042..1.784 rows=1,879 loops=1)

  • Filter: (to_status = 49)
  • Rows Removed by Filter: 7015
352. 1.274 3.115 ↓ 40.6 1,867 1

Sort (cost=210.34..210.46 rows=46 width=16) (actual time=2.426..3.115 rows=1,867 loops=1)

  • Sort Key: ctc_docs_f.loan_application_id
  • Sort Method: quicksort Memory: 136kB
353. 1.841 1.841 ↓ 40.6 1,867 1

CTE Scan on min_transition_events ctc_docs_f (cost=0.00..209.07 rows=46 width=16) (actual time=0.042..1.841 rows=1,867 loops=1)

  • Filter: (to_status = 50)
  • Rows Removed by Filter: 7027
Planning time : 229.796 ms
Execution time : 3,080.021 ms