explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4GM

Settings
# exclusive inclusive rows x rows loops node
1. 152,445.099 152,445.099 ↑ 55,191,159,900,590.2 3,201 1

CTE Scan on bb_data (cost=145,101,923,269,994,624.00..148,635,261,326,830,400.00 rows=176,666,902,841,789,376 width=5,003) (actual time=152,219.851..152,445.099 rows=3,201 loops=1)

2.          

CTE constant

3. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)

4.          

CTE loan

5. 3.879 132.955 ↓ 7.1 3,201 1

HashAggregate (cost=70,035.29..70,039.79 rows=450 width=78) (actual time=131.730..132.955 rows=3,201 loops=1)

  • Group Key: lo.id, lo.asset_id, lo.external_id, lo.origination_date, lo.loan_type, lo.term_in_months, lo.stated_interest_rate, lo.monthly_payment, lo.charge_off_date, lo.charge_off_principal, lo.charge_off_origination_fee, lo.lending_license_state
6.          

Initplan (for HashAggregate)

7. 0.004 0.004 ↑ 1.0 1 1

CTE Scan on constant (cost=0.00..0.02 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=1)

8. 3.448 129.072 ↓ 7.1 3,201 1

Nested Loop (cost=1,613.68..70,021.77 rows=450 width=78) (actual time=116.211..129.072 rows=3,201 loops=1)

9. 1.330 119.222 ↓ 2.3 3,201 1

Nested Loop (cost=1,613.26..66,235.46 rows=1,372 width=4) (actual time=116.175..119.222 rows=3,201 loops=1)

10. 0.002 0.003 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=1)

  • Group Key: constant_1.owner_entity_id
11. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_1 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=1)

12. 98.725 117.889 ↓ 2.3 3,201 1

Bitmap Heap Scan on asset_ownership_transfer aot (cost=1,613.23..66,221.71 rows=1,372 width=8) (actual time=116.168..117.889 rows=3,201 loops=1)

  • Recheck Cond: (to_entity_id = constant_1.owner_entity_id)
  • Filter: (((ownership_end_date IS NULL) OR (to_entity_id <> 504)) AND (ownership_start_date >= '2020-01-01'::date))
  • Rows Removed by Filter: 198638
  • Heap Blocks: exact=27584
13. 19.164 19.164 ↓ 3.1 249,894 1

Bitmap Index Scan on nc_asset_asset_ownership_transfer_to_entity_id (cost=0.00..1,612.89 rows=79,528 width=0) (actual time=19.164..19.164 rows=249,894 loops=1)

  • Index Cond: (to_entity_id = constant_1.owner_entity_id)
14. 6.402 6.402 ↑ 1.0 1 3,201

Index Scan using unc_asset_loan_asset_id on loan lo (cost=0.42..2.75 rows=1 width=78) (actual time=0.002..0.002 rows=1 loops=3,201)

  • Index Cond: (asset_id = aot.asset_id)
  • Filter: ((origination_date <= $1) AND (originator_id = 1003))
15.          

CTE aot

16. 10.159 38.897 ↑ 335.4 3,201 1

Nested Loop (cost=10.60..18,441,216.72 rows=1,073,622 width=28) (actual time=2.097..38.897 rows=3,201 loops=1)

17. 2.357 3.130 ↓ 16.0 3,201 1

HashAggregate (cost=10.12..12.12 rows=200 width=4) (actual time=2.053..3.130 rows=3,201 loops=1)

  • Group Key: loan.asset_id
18. 0.773 0.773 ↓ 7.1 3,201 1

CTE Scan on loan (cost=0.00..9.00 rows=450 width=4) (actual time=0.000..0.773 rows=3,201 loops=1)

19. 12.803 12.804 ↑ 7.0 1 3,201

Index Scan using nc_asset_asset_ownership_transfer_asset_id on asset_ownership_transfer aot_1 (cost=0.47..8.66 rows=7 width=28) (actual time=0.003..0.004 rows=1 loops=3,201)

  • Index Cond: (asset_id = loan.asset_id)
  • Filter: ((hashed SubPlan 6) OR (hashed SubPlan 7))
  • Rows Removed by Filter: 2
20.          

SubPlan (for Index Scan)

21. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_2 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

22. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_3 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

23.          

SubPlan (for Nested Loop)

24. 6.402 6.402 ↑ 1.0 1 3,201

Index Scan using loan_balance_snapshot_pkey on loan_balance_snapshot lbs (cost=0.57..8.59 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=3,201)

  • Index Cond: (id = aot_1.loan_balance_snapshot_id)
25. 6.402 6.402 ↑ 1.0 1 3,201

Index Scan using loan_balance_snapshot_pkey on loan_balance_snapshot lbs_1 (cost=0.57..8.59 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=3,201)

  • Index Cond: (id = aot_1.loan_balance_snapshot_id)
26.          

CTE loan_data_start

27. 3.430 392.017 ↑ 3,545.8 76 1

Nested Loop (cost=11.14..924,658.14 rows=269,484 width=92) (actual time=11.655..392.017 rows=76 loops=1)

28. 3.197 17.271 ↑ 84.2 3,201 1

Nested Loop (cost=10.55..1,646.62 rows=269,484 width=16) (actual time=2.760..17.271 rows=3,201 loops=1)

29. 3.360 4.471 ↓ 16.0 3,201 1

HashAggregate (cost=10.12..12.12 rows=200 width=4) (actual time=2.737..4.471 rows=3,201 loops=1)

  • Group Key: loan_1.asset_loan_id
30. 1.111 1.111 ↓ 7.1 3,201 1

CTE Scan on loan loan_1 (cost=0.00..9.00 rows=450 width=4) (actual time=0.001..1.111 rows=3,201 loops=1)

31. 9.603 9.603 ↑ 1.0 1 3,201

Index Scan using fki_loan_asset_registration_2_asset_loan on loan_asset_registration l (cost=0.42..8.16 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=3,201)

  • Index Cond: (asset_loan_id = loan_1.asset_loan_id)
32. 0.000 371.316 ↓ 0.0 0 3,201

Limit (cost=0.59..3.41 rows=1 width=61) (actual time=0.116..0.116 rows=0 loops=3,201)

33.          

Initplan (for Limit)

34. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

35. 371.316 371.316 ↓ 0.0 0 3,201

Index Scan using unc_lendify_loan_summary_loan_id_as_of_date_desc on loan_summary ls (cost=0.57..431.28 rows=153 width=61) (actual time=0.116..0.116 rows=0 loops=3,201)

  • Index Cond: ((loan_id = l.lendify_loan_id) AND (as_of_date < $11))
36.          

CTE loan_data_end

37. 3.467 10,114.564 ↑ 84.2 3,201 1

Nested Loop (cost=11.14..924,658.14 rows=269,484 width=143) (actual time=11.544..10,114.564 rows=3,201 loops=1)

38. 4.410 175.193 ↑ 84.2 3,201 1

Nested Loop (cost=10.55..1,646.62 rows=269,484 width=16) (actual time=2.177..175.193 rows=3,201 loops=1)

39. 3.513 4.331 ↓ 16.0 3,201 1

HashAggregate (cost=10.12..12.12 rows=200 width=4) (actual time=2.155..4.331 rows=3,201 loops=1)

  • Group Key: loan_2.asset_loan_id
40. 0.818 0.818 ↓ 7.1 3,201 1

CTE Scan on loan loan_2 (cost=0.00..9.00 rows=450 width=4) (actual time=0.002..0.818 rows=3,201 loops=1)

41. 166.452 166.452 ↑ 1.0 1 3,201

Index Scan using fki_loan_asset_registration_2_asset_loan on loan_asset_registration l_1 (cost=0.42..8.16 rows=1 width=16) (actual time=0.051..0.052 rows=1 loops=3,201)

  • Index Cond: (asset_loan_id = loan_2.asset_loan_id)
42. 3.199 9,935.904 ↑ 1.0 1 3,201

Limit (cost=0.59..3.41 rows=1 width=108) (actual time=3.103..3.104 rows=1 loops=3,201)

43.          

Initplan (for Limit)

44. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

45. 9,932.703 9,932.703 ↑ 153.0 1 3,201

Index Scan using unc_lendify_loan_summary_loan_id_as_of_date_desc on loan_summary ls_1 (cost=0.57..431.28 rows=153 width=108) (actual time=3.103..3.103 rows=1 loops=3,201)

  • Index Cond: ((loan_id = l_1.lendify_loan_id) AND (as_of_date <= $15))
46.          

CTE spv_cashflow

47. 0.913 181.014 ↑ 3,957.1 41 1

Hash Semi Join (cost=10.59..24,997.84 rows=162,240 width=233) (actual time=2.509..181.014 rows=41 loops=1)

  • Hash Cond: (cf.recipient_entity_id = constant_6.spv_entity_id)
48. 3.956 180.095 ↑ 1,543.8 3,573 1

Nested Loop (cost=10.56..8,712.93 rows=5,516,175 width=233) (actual time=2.099..180.095 rows=3,573 loops=1)

49. 2.496 3.285 ↓ 16.0 3,201 1

HashAggregate (cost=10.12..12.12 rows=200 width=4) (actual time=2.075..3.285 rows=3,201 loops=1)

  • Group Key: loan_3.asset_loan_id
50. 0.789 0.789 ↓ 7.1 3,201 1

CTE Scan on loan loan_3 (cost=0.00..9.00 rows=450 width=4) (actual time=0.001..0.789 rows=3,201 loops=1)

51. 172.854 172.854 ↑ 36.0 1 3,201

Index Scan using nc_asset_loan_cashflow_loan_id on loan_cashflow cf (cost=0.43..43.14 rows=36 width=233) (actual time=0.008..0.054 rows=1 loops=3,201)

  • Index Cond: (loan_id = loan_3.asset_loan_id)
52. 0.005 0.006 ↑ 1.0 1 1

Hash (cost=0.02..0.02 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
53. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_6 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

54.          

CTE pmts

55. 0.224 20,825.198 ↑ 4.9 41 1

HashAggregate (cost=465,106.43..465,115.43 rows=200 width=144) (actual time=20,825.140..20,825.198 rows=41 loops=1)

  • Group Key: cf_1.loan_id
56.          

Initplan (for HashAggregate)

57. 0.004 0.004 ↑ 1.0 1 1

CTE Scan on constant constant_7 (cost=0.00..0.02 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=1)

58. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_8 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

59. 0.077 20,824.969 ↑ 19.8 41 1

Nested Loop (cost=29,486.73..465,090.17 rows=811 width=144) (actual time=20,442.062..20,824.969 rows=41 loops=1)

60. 2,225.795 20,483.854 ↑ 3,957.1 41 1

Merge Join (cost=29,486.30..365,338.57 rows=162,240 width=152) (actual time=20,426.400..20,483.854 rows=41 loops=1)

  • Merge Cond: (ler.asset_loan_cashflow_id = cf_1.id)
61. 18,257.954 18,257.954 ↑ 1.0 7,966,193 1

Index Scan using fki_loan_event_registration_2_asset_loan_cashflow on loan_event_registration ler (cost=0.43..313,097.64 rows=7,966,347 width=16) (actual time=0.012..18,257.954 rows=7,966,193 loops=1)

62. 0.029 0.105 ↑ 3,957.1 41 1

Materialize (cost=29,485.86..30,297.06 rows=162,240 width=148) (actual time=0.049..0.105 rows=41 loops=1)

63. 0.044 0.076 ↑ 3,957.1 41 1

Sort (cost=29,485.86..29,891.46 rows=162,240 width=148) (actual time=0.048..0.076 rows=41 loops=1)

  • Sort Key: cf_1.id
  • Sort Method: quicksort Memory: 28kB
64. 0.032 0.032 ↑ 3,957.1 41 1

CTE Scan on spv_cashflow cf_1 (cost=0.00..3,244.80 rows=162,240 width=148) (actual time=0.003..0.032 rows=41 loops=1)

65. 341.038 341.038 ↑ 1.0 1 41

Index Scan using loan_event_pkey on loan_event le (cost=0.43..0.60 rows=1 width=8) (actual time=8.317..8.318 rows=1 loops=41)

  • Index Cond: (id = ler.lendify_loan_event_id)
  • Filter: (((posting_date)::date >= $21) AND ((posting_date)::date <= $22))
66.          

CTE whcf

67. 0.203 106,590.359 ↑ 5,188.5 2 1

GroupAggregate (cost=759,966.35..764,636.00 rows=10,377 width=158) (actual time=106,590.336..106,590.359 rows=2 loops=1)

  • Group Key: cf_2.loan_id, cf_2.recipient_entity_id
68.          

Initplan (for GroupAggregate)

69. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_9 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

70. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_10 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

71. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_11 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

72. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_12 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

73. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_13 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

74. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_14 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

75. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_15 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

76. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_16 (cost=0.00..0.02 rows=1 width=4) (never executed)

77. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_17 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

78. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_18 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

79. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_19 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

80. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_20 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

81. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_21 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

82. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_22 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

83. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_23 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

84. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_24 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

85. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_25 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

86. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_26 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

87. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_27 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

88. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_28 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

89. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_29 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=1)

90. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_30 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

91. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_31 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

92. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_32 (cost=0.00..0.02 rows=1 width=4) (never executed)

93. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_33 (cost=0.00..0.02 rows=1 width=4) (never executed)

94. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_34 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

95. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_35 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

96. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_36 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

97. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_37 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

98. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_38 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

99. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_39 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

100. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_40 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

101. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_41 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

102. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_42 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

103. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_43 (cost=0.00..0.02 rows=1 width=4) (never executed)

104. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_44 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

105. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_45 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

106. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_46 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

107. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_47 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=1)

108. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_48 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

109. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_49 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

110. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_50 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

111. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_51 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

112. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_52 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

113. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_53 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

114. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_54 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

115. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_55 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

116. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_56 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

117. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_57 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

118. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_58 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

119. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_59 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

120. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_60 (cost=0.00..0.02 rows=1 width=4) (never executed)

121. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_61 (cost=0.00..0.02 rows=1 width=4) (never executed)

122. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_62 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

123. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_63 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

124. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_64 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

125. 0.008 106,590.109 ↑ 5,188.5 2 1

Sort (cost=759,965.23..759,991.18 rows=10,377 width=158) (actual time=106,590.109..106,590.109 rows=2 loops=1)

  • Sort Key: cf_2.loan_id, cf_2.recipient_entity_id
  • Sort Method: quicksort Memory: 25kB
126. 443.374 106,590.101 ↑ 5,188.5 2 1

Merge Join (cost=754,967.00..759,273.03 rows=10,377 width=158) (actual time=106,589.834..106,590.101 rows=2 loops=1)

  • Merge Cond: (lcri.loan_cashflow_id = cf_2.id)
127. 2,845.993 105,965.549 ↓ 3.0 1,803,039 1

Sort (cost=724,924.63..726,417.37 rows=597,093 width=13) (actual time=104,935.932..105,965.549 rows=1,803,039 loops=1)

  • Sort Key: lcri.loan_cashflow_id
  • Sort Method: external merge Disk: 45800kB
128. 1,006.009 103,119.556 ↓ 3.0 1,803,039 1

Hash Join (cost=3,555.19..657,434.74 rows=597,093 width=13) (actual time=96.509..103,119.556 rows=1,803,039 loops=1)

  • Hash Cond: (lcri.loan_cashflow_report_id = lcr.id)
129. 102,053.023 102,053.023 ↓ 1.0 1,818,102 1

Seq Scan on loan_cashflow_report_item lcri (cost=0.00..641,165.85 rows=1,798,071 width=13) (actual time=35.934..102,053.023 rows=1,818,102 loops=1)

  • Filter: (type = 'WAREHOUSE_DISBURSEMENT'::text)
  • Rows Removed by Filter: 19727845
130. 23.266 60.524 ↓ 3.0 69,929 1

Hash (cost=3,265.14..3,265.14 rows=23,204 width=8) (actual time=60.524..60.524 rows=69,929 loops=1)

  • Buckets: 131072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 3756kB
131. 37.258 37.258 ↓ 3.0 69,929 1

Seq Scan on loan_cashflow_report lcr (cost=0.00..3,265.14 rows=23,204 width=8) (actual time=0.014..37.258 rows=69,929 loops=1)

  • Filter: ((status = ANY ('{TRANSFER_CONFIRMED_PENDING_COMPLETION,COMPLETE}'::text[])) AND (cash_transfer_date <= $80))
  • Rows Removed by Filter: 360
132. 0.012 181.178 ↑ 10,816.0 15 1

Materialize (cost=30,042.36..30,853.56 rows=162,240 width=153) (actual time=181.165..181.178 rows=15 loops=1)

133. 0.052 181.166 ↑ 10,816.0 15 1

Sort (cost=30,042.36..30,447.96 rows=162,240 width=153) (actual time=181.161..181.166 rows=15 loops=1)

  • Sort Key: cf_2.id
  • Sort Method: quicksort Memory: 28kB
134. 181.114 181.114 ↑ 3,957.1 41 1

CTE Scan on spv_cashflow cf_2 (cost=0.00..3,244.80 rows=162,240 width=153) (actual time=2.515..181.114 rows=41 loops=1)

135.          

CTE whcf_adj

136. 0.001 0.024 ↓ 0.0 0 1

HashAggregate (cost=5,460.96..5,465.91 rows=55 width=153) (actual time=0.024..0.024 rows=0 loops=1)

  • Group Key: cf_3.loan_id, cf_3.recipient_entity_id
137.          

Initplan (for HashAggregate)

138. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_65 (cost=0.00..0.02 rows=1 width=4) (never executed)

139. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_66 (cost=0.00..0.02 rows=1 width=4) (never executed)

140. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_67 (cost=0.00..0.02 rows=1 width=4) (never executed)

141. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_68 (cost=0.00..0.02 rows=1 width=4) (never executed)

142. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_69 (cost=0.00..0.02 rows=1 width=4) (never executed)

143. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_70 (cost=0.00..0.02 rows=1 width=4) (never executed)

144. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_71 (cost=0.00..0.02 rows=1 width=4) (never executed)

145. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_72 (cost=0.00..0.02 rows=1 width=4) (never executed)

146. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_73 (cost=0.00..0.02 rows=1 width=4) (never executed)

147. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_74 (cost=0.00..0.02 rows=1 width=4) (never executed)

148. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_75 (cost=0.00..0.02 rows=1 width=4) (never executed)

149. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_76 (cost=0.00..0.02 rows=1 width=4) (never executed)

150. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_77 (cost=0.00..0.02 rows=1 width=4) (never executed)

151. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_78 (cost=0.00..0.02 rows=1 width=4) (never executed)

152. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_79 (cost=0.00..0.02 rows=1 width=4) (never executed)

153. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_80 (cost=0.00..0.02 rows=1 width=4) (never executed)

154. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_81 (cost=0.00..0.02 rows=1 width=4) (never executed)

155. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_82 (cost=0.00..0.02 rows=1 width=4) (never executed)

156. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_83 (cost=0.00..0.02 rows=1 width=4) (never executed)

157. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_84 (cost=0.00..0.02 rows=1 width=4) (never executed)

158. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_85 (cost=0.00..0.02 rows=1 width=4) (never executed)

159. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_86 (cost=0.00..0.02 rows=1 width=4) (never executed)

160. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_87 (cost=0.00..0.02 rows=1 width=4) (never executed)

161. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_88 (cost=0.00..0.02 rows=1 width=4) (never executed)

162. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_89 (cost=0.00..0.02 rows=1 width=4) (never executed)

163. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_90 (cost=0.00..0.02 rows=1 width=4) (never executed)

164. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_91 (cost=0.00..0.02 rows=1 width=4) (never executed)

165. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_92 (cost=0.00..0.02 rows=1 width=4) (never executed)

166. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_93 (cost=0.00..0.02 rows=1 width=4) (never executed)

167. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_94 (cost=0.00..0.02 rows=1 width=4) (never executed)

168. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_95 (cost=0.00..0.02 rows=1 width=4) (never executed)

169. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_96 (cost=0.00..0.02 rows=1 width=4) (never executed)

170. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_97 (cost=0.00..0.02 rows=1 width=4) (never executed)

171. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_98 (cost=0.00..0.02 rows=1 width=4) (never executed)

172. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_99 (cost=0.00..0.02 rows=1 width=4) (never executed)

173. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_100 (cost=0.00..0.02 rows=1 width=4) (never executed)

174. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_101 (cost=0.00..0.02 rows=1 width=4) (never executed)

175. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_102 (cost=0.00..0.02 rows=1 width=4) (never executed)

176. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_103 (cost=0.00..0.02 rows=1 width=4) (never executed)

177. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_104 (cost=0.00..0.02 rows=1 width=4) (never executed)

178. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_105 (cost=0.00..0.02 rows=1 width=4) (never executed)

179. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_106 (cost=0.00..0.02 rows=1 width=4) (never executed)

180. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_107 (cost=0.00..0.02 rows=1 width=4) (never executed)

181. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_108 (cost=0.00..0.02 rows=1 width=4) (never executed)

182. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_109 (cost=0.00..0.02 rows=1 width=4) (never executed)

183. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_110 (cost=0.00..0.02 rows=1 width=4) (never executed)

184. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_111 (cost=0.00..0.02 rows=1 width=4) (never executed)

185. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_112 (cost=0.00..0.02 rows=1 width=4) (never executed)

186. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_113 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

187. 0.000 0.021 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.44..5,376.96 rows=270 width=153) (actual time=0.021..0.021 rows=0 loops=1)

188. 0.021 0.021 ↓ 0.0 0 1

CTE Scan on spv_cashflow cf_3 (cost=0.00..4,056.00 rows=541 width=157) (actual time=0.021..0.021 rows=0 loops=1)

  • Filter: ((cashflow_date <= $130) AND ((cashflow_type)::text = ANY ('{CREDIT,CREDIT_REVERSAL}'::text[])))
  • Rows Removed by Filter: 41
189. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fki_loan_cashflow_report_item_2_loan_cashflow_id on loan_cashflow_report_item lcri_1 (cost=0.44..5.14 rows=2 width=4) (never executed)

  • Index Cond: (loan_cashflow_id = cf_3.id)
  • Heap Fetches: 0
190.          

CTE bb_data

191. 89.529 152,424.082 ↑ 55,191,159,900,590.2 3,201 1

Merge Right Join (cost=284,365,559.57..145,101,923,248,373,824.00 rows=176,666,902,841,789,376 width=3,572) (actual time=152,219.836..152,424.082 rows=3,201 loops=1)

  • Merge Cond: (ln_1.asset_loan_id = ln.asset_loan_id)
  • Filter: ((hashed SubPlan 213) OR (COALESCE(aot_2.ownership_end_date, '1900-01-01'::date) >= (date_trunc('month'::text, ($223)::timestamp with time zone))::date) OR ((((COALESCE(whcf.prin_received_cumulative, 0.00)) + COALESCE((COALESCE(whcf_adj.prin_received_cumulative, 0.00)), 0.00)) + COALESCE(round(aot_sale.principal_balance, 2), 0.00)) <> round(aot_2.principal_balance, 2)) OR ((((COALESCE(whcf.orig_fee_received_cumulative, 0.00)) + COALESCE((COALESCE(whcf_adj.orig_fee_received_cumulative, 0.00)), 0.00)) + COALESCE(round(aot_sale.origination_fee_balance, 2), 0.00)) <> round(aot_2.origination_fee_balance, 2)) OR (COALESCE((GREATEST(whcf.max_cash_transfer_date, whcf_adj.max_adj_transfer_date)), '1900-01-01'::date) >= $224))
192.          

Initplan (for Merge Right Join)

193. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_114 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

194. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_115 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

195. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_116 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

196. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_117 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

197. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_118 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

198. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_119 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

199. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_121 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

200. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_122 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

201. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_123 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

202. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_124 (cost=0.00..0.02 rows=1 width=4) (never executed)

203. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_125 (cost=0.00..0.02 rows=1 width=4) (never executed)

204. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_126 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

205. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_127 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

206. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_128 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

207. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_129 (cost=0.00..0.02 rows=1 width=4) (never executed)

208. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_130 (cost=0.00..0.02 rows=1 width=4) (never executed)

209. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_131 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

210. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_132 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

211. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_133 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

212. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_134 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

213. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_135 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

214. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_137 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

215. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_138 (cost=0.00..0.02 rows=1 width=4) (never executed)

216. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_139 (cost=0.00..0.02 rows=1 width=4) (never executed)

217. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_140 (cost=0.00..0.02 rows=1 width=4) (never executed)

218. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_141 (cost=0.00..0.02 rows=1 width=4) (never executed)

219. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_142 (cost=0.00..0.02 rows=1 width=4) (never executed)

220. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_144 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

221. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_145 (cost=0.00..0.02 rows=1 width=4) (never executed)

222. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_146 (cost=0.00..0.02 rows=1 width=4) (never executed)

223. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_147 (cost=0.00..0.02 rows=1 width=4) (never executed)

224. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_148 (cost=0.00..0.02 rows=1 width=4) (never executed)

225. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_149 (cost=0.00..0.02 rows=1 width=4) (never executed)

226. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_151 (cost=0.00..0.02 rows=1 width=4) (never executed)

227. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_152 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

228. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_153 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

229. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_154 (cost=0.00..0.02 rows=1 width=4) (never executed)

230. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_155 (cost=0.00..0.02 rows=1 width=4) (never executed)

231. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_156 (cost=0.00..0.02 rows=1 width=4) (never executed)

232. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_157 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

233. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_158 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

234. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_159 (cost=0.00..0.02 rows=1 width=4) (never executed)

235. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_160 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

236. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_161 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

237. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_162 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

238. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_163 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

239. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_164 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

240. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_166 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

241. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_167 (cost=0.00..0.02 rows=1 width=4) (never executed)

242. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_168 (cost=0.00..0.02 rows=1 width=4) (never executed)

243. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_169 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

244. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_171 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

245. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_172 (cost=0.00..0.02 rows=1 width=4) (never executed)

246. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_173 (cost=0.00..0.02 rows=1 width=4) (never executed)

247. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_174 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

248. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_176 (cost=0.00..0.02 rows=1 width=4) (never executed)

249. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_177 (cost=0.00..0.02 rows=1 width=4) (never executed)

250. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_178 (cost=0.00..0.02 rows=1 width=4) (never executed)

251. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_179 (cost=0.00..0.02 rows=1 width=4) (never executed)

252. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_180 (cost=0.00..0.02 rows=1 width=4) (never executed)

253. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_181 (cost=0.00..0.02 rows=1 width=4) (never executed)

254. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_183 (cost=0.00..0.02 rows=1 width=4) (never executed)

255. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_184 (cost=0.00..0.02 rows=1 width=4) (never executed)

256. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_185 (cost=0.00..0.02 rows=1 width=4) (never executed)

257. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_186 (cost=0.00..0.02 rows=1 width=4) (never executed)

258. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_187 (cost=0.00..0.02 rows=1 width=4) (never executed)

259. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_188 (cost=0.00..0.02 rows=1 width=4) (never executed)

260. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_189 (cost=0.00..0.02 rows=1 width=4) (never executed)

261. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_190 (cost=0.00..0.02 rows=1 width=4) (never executed)

262. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_191 (cost=0.00..0.02 rows=1 width=4) (never executed)

263. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_192 (cost=0.00..0.02 rows=1 width=4) (never executed)

264. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_193 (cost=0.00..0.02 rows=1 width=4) (never executed)

265. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_194 (cost=0.00..0.02 rows=1 width=4) (never executed)

266. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_195 (cost=0.00..0.02 rows=1 width=4) (never executed)

267. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_196 (cost=0.00..0.02 rows=1 width=4) (never executed)

268. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_197 (cost=0.00..0.02 rows=1 width=4) (never executed)

269. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_198 (cost=0.00..0.02 rows=1 width=4) (never executed)

270. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_199 (cost=0.00..0.02 rows=1 width=4) (never executed)

271. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_200 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1)

272. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_201 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

273. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_202 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

274. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_204 (cost=0.00..0.02 rows=1 width=4) (never executed)

275. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_205 (cost=0.00..0.02 rows=1 width=4) (never executed)

276. 13.314 106,802.934 ↑ 25.3 3,201 1

Merge Left Join (cost=66,747.91..68,156.78 rows=81,044 width=2,356) (actual time=106,782.440..106,802.934 rows=3,201 loops=1)

  • Merge Cond: ((ln_1.asset_loan_id = whcf_adj.loan_id) AND (aot_3.to_entity_id = whcf_adj.recipient_entity_id))
277. 6.086 106,789.586 ↑ 25.3 3,201 1

Merge Left Join (cost=66,745.22..67,746.93 rows=81,044 width=1,388) (actual time=106,782.361..106,789.586 rows=3,201 loops=1)

  • Merge Cond: ((ln_1.asset_loan_id = whcf.loan_id) AND (aot_3.to_entity_id = whcf.recipient_entity_id))
278. 2.274 193.119 ↑ 25.3 3,201 1

Sort (cost=60,560.48..60,763.09 rows=81,044 width=100) (actual time=191.972..193.119 rows=3,201 loops=1)

  • Sort Key: ln_1.asset_loan_id, aot_3.to_entity_id
  • Sort Method: quicksort Memory: 347kB
279. 2.786 190.845 ↑ 25.3 3,201 1

Merge Join (cost=49,424.64..49,518.29 rows=81,044 width=100) (actual time=186.553..190.845 rows=3,201 loops=1)

  • Merge Cond: ((constant_208.spv_entity_id = aot_3.to_entity_id) AND (ln_1.asset_id = aot_3.asset_id))
280. 1.798 184.273 ↑ 1.9 3,201 1

Sort (cost=24,935.59..24,950.69 rows=6,039 width=60) (actual time=183.550..184.273 rows=3,201 loops=1)

  • Sort Key: constant_208.spv_entity_id, ln_1.asset_id
  • Sort Method: quicksort Memory: 247kB
281. 1.767 182.475 ↑ 1.9 3,201 1

Merge Left Join (cost=24,463.50..24,556.34 rows=6,039 width=60) (actual time=179.725..182.475 rows=3,201 loops=1)

  • Merge Cond: (ln_1.asset_id = aot_sale.asset_id)
282. 2.389 139.885 ↓ 7.1 3,201 1

Sort (cost=33.36..34.49 rows=450 width=16) (actual time=138.897..139.885 rows=3,201 loops=1)

  • Sort Key: ln_1.asset_id
  • Sort Method: quicksort Memory: 247kB
283. 1.665 137.496 ↓ 7.1 3,201 1

Nested Loop (cost=0.02..13.53 rows=450 width=16) (actual time=131.742..137.496 rows=3,201 loops=1)

284. 0.005 0.009 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Group Key: constant_208.spv_entity_id
285. 0.004 0.004 ↑ 1.0 1 1

CTE Scan on constant constant_208 (cost=0.00..0.02 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=1)

286. 135.822 135.822 ↓ 7.1 3,201 1

CTE Scan on loan ln_1 (cost=0.00..9.00 rows=450 width=12) (actual time=131.733..135.822 rows=3,201 loops=1)

287. 0.008 40.823 ↓ 0.0 0 1

Sort (cost=24,430.14..24,436.85 rows=2,684 width=48) (actual time=40.823..40.823 rows=0 loops=1)

  • Sort Key: aot_sale.asset_id
  • Sort Method: quicksort Memory: 25kB
288. 0.002 40.815 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.00..24,277.28 rows=2,684 width=48) (actual time=40.815..40.815 rows=0 loops=1)

  • Join Filter: (aot_sale.from_entity_id = constant_207.spv_entity_id)
289. 40.813 40.813 ↓ 0.0 0 1

CTE Scan on aot aot_sale (cost=0.00..24,156.49 rows=5,368 width=52) (actual time=40.813..40.813 rows=0 loops=1)

  • Filter: (to_entity_id = 130)
  • Rows Removed by Filter: 3201
290. 0.000 0.000 ↓ 0.0 0

CTE Scan on constant constant_207 (cost=0.00..0.02 rows=1 width=4) (never executed)

291. 2.658 3.786 ↑ 1.7 3,201 1

Sort (cost=24,489.05..24,502.47 rows=5,368 width=52) (actual time=2.998..3.786 rows=3,201 loops=1)

  • Sort Key: aot_3.to_entity_id, aot_3.asset_id
  • Sort Method: quicksort Memory: 347kB
292. 1.128 1.128 ↑ 1.7 3,201 1

CTE Scan on aot aot_3 (cost=0.00..24,156.49 rows=5,368 width=52) (actual time=0.006..1.128 rows=3,201 loops=1)

  • Filter: (from_entity_id = 130)
293. 0.004 106,590.381 ↑ 5,188.5 2 1

Materialize (cost=6,184.74..6,236.63 rows=10,377 width=1,168) (actual time=106,590.378..106,590.381 rows=2 loops=1)

294. 0.010 106,590.377 ↑ 5,188.5 2 1

Sort (cost=6,184.74..6,210.69 rows=10,377 width=1,168) (actual time=106,590.376..106,590.377 rows=2 loops=1)

  • Sort Key: whcf.loan_id, whcf.recipient_entity_id
  • Sort Method: quicksort Memory: 25kB
295. 106,590.367 106,590.367 ↑ 5,188.5 2 1

CTE Scan on whcf (cost=0.00..207.54 rows=10,377 width=1,168) (actual time=106,590.342..106,590.367 rows=2 loops=1)

296. 0.009 0.034 ↓ 0.0 0 1

Sort (cost=2.69..2.83 rows=55 width=1,036) (actual time=0.034..0.034 rows=0 loops=1)

  • Sort Key: whcf_adj.loan_id, whcf_adj.recipient_entity_id
  • Sort Method: quicksort Memory: 25kB
297. 0.025 0.025 ↓ 0.0 0 1

CTE Scan on whcf_adj (cost=0.00..1.10 rows=55 width=1,036) (actual time=0.025..0.025 rows=0 loops=1)

298. 4.882 45,531.571 ↑ 136,201,240,116.1 3,201 1

Materialize (cost=284,298,809.80..15,265,258,057,310.03 rows=435,980,169,611,657 width=1,220) (actual time=45,437.125..45,531.571 rows=3,201 loops=1)

299. 2.455 45,526.689 ↑ 136,201,240,116.1 3,201 1

Merge Left Join (cost=284,298,809.80..14,175,307,633,280.89 rows=435,980,169,611,657 width=1,220) (actual time=45,437.120..45,526.689 rows=3,201 loops=1)

  • Merge Cond: (ln.asset_loan_id = pmts.loan_id)
300. 4.692 24,698.944 ↑ 136,201,240,116.1 3,201 1

Merge Left Join (cost=284,298,798.16..6,545,654,665,065.25 rows=435,980,169,611,657 width=996) (actual time=24,611.847..24,698.944 rows=3,201 loops=1)

  • Merge Cond: (ln.asset_loan_id = ln_end.asset_loan_id)
301. 2.458 24,687.463 ↑ 101,082,988.3 3,201 1

Merge Left Join (cost=284,238,703.73..5,143,143,508.26 rows=323,566,645,598 width=764) (actual time=24,608.024..24,687.463 rows=3,201 loops=1)

  • Merge Cond: (ln.asset_loan_id = ln_start.asset_loan_id)
302. 168.486 24,292.630 ↑ 75,019.7 3,201 1

Merge Left Join (cost=284,186,897.31..288,990,999.35 rows=240,137,927 width=608) (actual time=24,215.713..24,292.630 rows=3,201 loops=1)

  • Merge Cond: (ln.asset_loan_id = lsr.loan_id)
303. 4.334 22,846.739 ↑ 75,019.7 3,201 1

Sort (cost=284,104,766.39..284,705,111.21 rows=240,137,927 width=576) (actual time=22,845.230..22,846.739 rows=3,201 loops=1)

  • Sort Key: ln.asset_loan_id
  • Sort Method: quicksort Memory: 1145kB
304. 4.337 22,842.405 ↑ 75,019.7 3,201 1

Merge Right Join (cost=839,595.20..4,443,229.80 rows=240,137,927 width=576) (actual time=22,834.058..22,842.405 rows=3,201 loops=1)

  • Merge Cond: (aot_2.asset_id = ln.asset_id)
305. 2.539 5.433 ↑ 55.9 3,201 1

Sort (cost=49,929.95..50,377.30 rows=178,937 width=56) (actual time=4.359..5.433 rows=3,201 loops=1)

  • Sort Key: aot_2.asset_id
  • Sort Method: quicksort Memory: 347kB
306. 1.729 2.894 ↑ 55.9 3,201 1

Hash Join (cost=0.04..28,200.51 rows=178,937 width=56) (actual time=0.024..2.894 rows=3,201 loops=1)

  • Hash Cond: (aot_2.to_entity_id = constant_206.spv_entity_id)
307. 1.157 1.157 ↑ 111.8 3,201 1

CTE Scan on aot aot_2 (cost=0.00..26,840.55 rows=357,874 width=60) (actual time=0.006..1.157 rows=3,201 loops=1)

  • Filter: (ownership_start_date <= ($221 + 1))
308. 0.001 0.008 ↑ 1.0 1 1

Hash (cost=0.03..0.03 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
309. 0.006 0.007 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=1)

  • Group Key: constant_206.spv_entity_id
310. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_206 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

311. 1.592 22,832.635 ↑ 83.9 3,201 1

Materialize (cost=789,665.25..791,007.27 rows=268,405 width=528) (actual time=22,829.694..22,832.635 rows=3,201 loops=1)

312. 4.629 22,831.043 ↑ 83.9 3,201 1

Sort (cost=789,665.25..790,336.26 rows=268,405 width=528) (actual time=22,829.691..22,831.043 rows=3,201 loops=1)

  • Sort Key: ln.asset_id
  • Sort Method: quicksort Memory: 986kB
313. 158.631 22,826.414 ↑ 83.9 3,201 1

Hash Left Join (cost=158,899.84..638,861.10 rows=268,405 width=528) (actual time=18,975.869..22,826.414 rows=3,201 loops=1)

  • Hash Cond: (nt.loan_id = borrower.loan_id)
314. 118.358 22,031.404 ↑ 83.9 3,201 1

Hash Left Join (cost=126,214.50..563,133.19 rows=268,405 width=474) (actual time=18,274.114..22,031.404 rows=3,201 loops=1)

  • Hash Cond: (nt.loan_id = lp.loan_id)
315. 2.186 10,229.707 ↑ 83.9 3,201 1

Hash Left Join (cost=48,830.30..446,923.42 rows=268,405 width=470) (actual time=6,578.731..10,229.707 rows=3,201 loops=1)

  • Hash Cond: (aot_curr_owner.to_entity_id = le_1.id)
316. 12.798 10,227.407 ↑ 83.9 3,201 1

Hash Left Join (cost=48,823.58..443,695.85 rows=268,405 width=441) (actual time=6,578.602..10,227.407 rows=3,201 loops=1)

  • Hash Cond: (ln.asset_id = aot_curr_owner.asset_id)
317. 2.230 10,205.386 ↓ 7.1 3,201 1

Nested Loop Left Join (cost=3,804.57..388,646.59 rows=450 width=433) (actual time=6,443.017..10,205.386 rows=3,201 loops=1)

318. 2.148 10,049.508 ↓ 7.1 3,201 1

Hash Left Join (cost=3,804.14..384,945.84 rows=450 width=432) (actual time=6,431.655..10,049.508 rows=3,201 loops=1)

  • Hash Cond: (nt.tenant_id = lt.id)
319. 197.741 10,047.201 ↓ 7.1 3,201 1

Hash Right Join (cost=3,794.35..384,929.86 rows=450 width=435) (actual time=6,431.483..10,047.201 rows=3,201 loops=1)

  • Hash Cond: (de.loan_number = nt.loan_number)
320. 403.389 3,617.730 ↓ 12.8 538,838 1

Hash Join (cost=84.10..381,061.54 rows=42,059 width=51) (actual time=1.414..3,617.730 rows=538,838 loops=1)

  • Hash Cond: ((de.tenant_id = loc.tenant_id) AND (de.location_id = loc.location_id))
321. 3,212.995 3,212.995 ↑ 1.0 538,987 1

Seq Scan on loan_event de (cost=0.00..376,393.08 rows=555,170 width=23) (actual time=0.052..3,212.995 rows=538,987 loops=1)

  • Filter: (transaction_type = 'DISBURSEMENT'::text)
  • Rows Removed by Filter: 8984889
322. 0.662 1.346 ↓ 1.0 1,765 1

Hash (cost=57.64..57.64 rows=1,764 width=40) (actual time=1.346..1.346 rows=1,765 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 144kB
323. 0.684 0.684 ↓ 1.0 1,765 1

Seq Scan on location loc (cost=0.00..57.64 rows=1,764 width=40) (actual time=0.005..0.684 rows=1,765 loops=1)

324. 3.323 6,231.730 ↓ 7.1 3,201 1

Hash (cost=3,704.63..3,704.63 rows=450 width=414) (actual time=6,231.730..6,231.730 rows=3,201 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 561kB
325. 4.056 6,228.407 ↓ 7.1 3,201 1

Nested Loop (cost=0.42..3,704.63 rows=450 width=414) (actual time=7.685..6,228.407 rows=3,201 loops=1)

326. 1.607 1.607 ↓ 7.1 3,201 1

CTE Scan on loan ln (cost=0.00..9.00 rows=450 width=362) (actual time=0.002..1.607 rows=3,201 loops=1)

327. 6,222.744 6,222.744 ↑ 1.0 1 3,201

Index Scan using unc_lendify_loan_product_loan_number on loan_product nt (cost=0.42..8.20 rows=1 width=52) (actual time=1.938..1.944 rows=1 loops=3,201)

  • Index Cond: (loan_number = (ln.external_id)::text)
328. 0.063 0.159 ↓ 1.1 230 1

Hash (cost=7.13..7.13 rows=213 width=5) (actual time=0.159..0.159 rows=230 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
329. 0.096 0.096 ↓ 1.1 230 1

Seq Scan on tenant lt (cost=0.00..7.13 rows=213 width=5) (actual time=0.006..0.096 rows=230 loops=1)

330. 153.648 153.648 ↑ 1.0 1 3,201

Index Scan using loan_pkey on loan loan_4 (cost=0.42..8.21 rows=1 width=5) (actual time=0.044..0.048 rows=1 loops=3,201)

  • Index Cond: (ln.asset_loan_id = id)
  • Filter: (originator_id = 1003)
331. 6.568 9.223 ↑ 37.3 3,201 1

Hash (cost=42,944.88..42,944.88 rows=119,291 width=12) (actual time=9.223..9.223 rows=3,201 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 1089kB
332. 2.655 2.655 ↑ 37.3 3,201 1

CTE Scan on aot aot_curr_owner (cost=0.00..42,944.88 rows=119,291 width=12) (actual time=0.026..2.655 rows=3,201 loops=1)

  • Filter: ((($219 + 1) >= ownership_start_date) AND (($220 + 1) <= COALESCE((ownership_end_date - 1), (timezone('PST8PDT'::text, now()))::date)))
333. 0.053 0.114 ↑ 1.1 155 1

Hash (cost=4.65..4.65 rows=165 width=33) (actual time=0.114..0.114 rows=155 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
334. 0.061 0.061 ↑ 1.1 155 1

Seq Scan on legal_entity le_1 (cost=0.00..4.65 rows=165 width=33) (actual time=0.005..0.061 rows=155 loops=1)

335. 293.422 11,683.339 ↓ 1.0 538,987 1

Hash (cost=68,020.30..68,020.30 rows=538,632 width=12) (actual time=11,683.339..11,683.339 rows=538,987 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2473kB
336. 565.875 11,389.917 ↓ 1.0 538,987 1

Hash Right Join (cost=53,662.22..68,020.30 rows=538,632 width=12) (actual time=868.014..11,389.917 rows=538,987 loops=1)

  • Hash Cond: (loan_data_end.loan_id = lp.loan_id)
337. 10,120.662 10,120.662 ↑ 84.2 3,201 1

CTE Scan on loan_data_end (cost=0.00..5,389.68 rows=269,484 width=16) (actual time=11.549..10,120.662 rows=3,201 loops=1)

338. 273.533 703.380 ↓ 1.0 538,987 1

Hash (cost=44,298.32..44,298.32 rows=538,632 width=16) (actual time=703.380..703.380 rows=538,987 loops=1)

  • Buckets: 131072 Batches: 16 Memory Usage: 2605kB
339. 429.847 429.847 ↓ 1.0 538,987 1

Seq Scan on loan_product lp (cost=0.00..44,298.32 rows=538,632 width=16) (actual time=0.005..429.847 rows=538,987 loops=1)

340. 364.674 636.379 ↑ 1.0 538,987 1

Hash (cost=19,616.15..19,616.15 rows=539,615 width=70) (actual time=636.379..636.379 rows=538,987 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 3434kB
341. 271.705 271.705 ↑ 1.0 538,987 1

Seq Scan on borrower_application borrower (cost=0.00..19,616.15 rows=539,615 width=70) (actual time=0.005..271.705 rows=538,987 loops=1)

342. 244.827 1,277.405 ↓ 1.0 546,681 1

Materialize (cost=82,130.92..84,817.90 rows=537,397 width=36) (actual time=785.753..1,277.405 rows=546,681 loops=1)

343. 771.901 1,032.578 ↓ 1.0 546,681 1

Sort (cost=82,130.92..83,474.41 rows=537,397 width=36) (actual time=785.751..1,032.578 rows=546,681 loops=1)

  • Sort Key: lsr.loan_id
  • Sort Method: external merge Disk: 26648kB
344. 260.677 260.677 ↓ 1.0 547,763 1

Seq Scan on loan_securitization_review lsr (cost=0.00..16,285.97 rows=537,397 width=36) (actual time=0.008..260.677 rows=547,763 loops=1)

345. 0.039 392.375 ↑ 3,545.8 76 1

Materialize (cost=51,806.42..53,153.84 rows=269,484 width=164) (actual time=392.303..392.375 rows=76 loops=1)

346. 0.149 392.336 ↑ 3,545.8 76 1

Sort (cost=51,806.42..52,480.13 rows=269,484 width=164) (actual time=392.298..392.336 rows=76 loops=1)

  • Sort Key: ln_start.asset_loan_id
  • Sort Method: quicksort Memory: 35kB
347. 392.187 392.187 ↑ 3,545.8 76 1

CTE Scan on loan_data_start ln_start (cost=0.00..5,389.68 rows=269,484 width=164) (actual time=11.660..392.187 rows=76 loops=1)

348. 1.542 6.789 ↑ 84.2 3,201 1

Materialize (cost=60,094.42..61,441.84 rows=269,484 width=240) (actual time=3.818..6.789 rows=3,201 loops=1)

349. 3.618 5.247 ↑ 84.2 3,201 1

Sort (cost=60,094.42..60,768.13 rows=269,484 width=240) (actual time=3.813..5.247 rows=3,201 loops=1)

  • Sort Key: ln_end.asset_loan_id
  • Sort Method: quicksort Memory: 547kB
350. 1.629 1.629 ↑ 84.2 3,201 1

CTE Scan on loan_data_end ln_end (cost=0.00..5,389.68 rows=269,484 width=240) (actual time=0.003..1.629 rows=3,201 loops=1)

351. 0.046 20,825.290 ↑ 4.9 41 1

Sort (cost=11.64..12.14 rows=200 width=228) (actual time=20,825.269..20,825.290 rows=41 loops=1)

  • Sort Key: pmts.loan_id
  • Sort Method: quicksort Memory: 28kB
352. 20,825.244 20,825.244 ↑ 4.9 41 1

CTE Scan on pmts (cost=0.00..4.00 rows=200 width=228) (actual time=20,825.144..20,825.244 rows=41 loops=1)

353.          

SubPlan (for Merge Right Join)

354. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_120 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

355. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_136 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

356. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_143 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

357. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_150 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

358. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on constant constant_165 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

359. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_170 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

360. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_175 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

361. 0.000 0.000 ↑ 1.0 1 1

CTE Scan on constant constant_182 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

362. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on constant constant_203 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)

Planning time : 11.623 ms
Execution time : 152,457.720 ms