explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ijz5

Settings
# exclusive inclusive rows x rows loops node
1. 0.198 9,052.705 ↓ 50.0 100 1

Limit (cost=246,526.75..248,219.21 rows=2 width=3,279) (actual time=8,181.152..9,052.705 rows=100 loops=1)

2.          

CTE _cte_loanpartbalance

3. 69.021 499.382 ↑ 1.0 99,346 1

Hash Join (cost=4,843.04..33,864.29 rows=99,358 width=63) (actual time=44.838..499.382 rows=99,346 loops=1)

4. 98.420 187.086 ↑ 1.0 99,346 1

Merge Join (cost=0.58..17,236.41 rows=99,358 width=56) (actual time=0.053..187.086 rows=99,346 loops=1)

5. 44.207 65.419 ↓ 1.0 99,353 1

Group (cost=0.29..7,165.98 rows=99,350 width=40) (actual time=0.03..65.419 rows=99,353 loops=1)

6. 21.212 21.212 ↓ 1.0 99,353 1

Index Scan using productcopy_pkey on productcopy pc_2 (cost=0.29..5,551.54 rows=99,350 width=8) (actual time=0.023..21.212 rows=99,353 loops=1)

7. 23.247 23.247 ↑ 1.0 99,346 1

Index Scan using ix_credit_productcopyfk on credit c_1 (cost=0.29..7,586.66 rows=99,358 width=28) (actual time=0.017..23.247 rows=99,346 loops=1)

8. 21.991 44.583 ↑ 1.0 99,347 1

Hash (cost=2,822.98..2,822.98 rows=99,398 width=35) (actual time=44.583..44.583 rows=99,347 loops=1)

9. 22.592 22.592 ↑ 1.0 99,347 1

Seq Scan on creditbalances cb (cost=0..2,822.98 rows=99,398 width=35) (actual time=0.132..22.592 rows=99,347 loops=1)

10.          

SubPlan (forHash Join)

11. 99.346 198.692 ↑ 1.0 1 99,346

Aggregate (cost=0.06..0.07 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=99,346)

12. 99.346 99.346 ↑ 1.0 4 99,346

Values Scan (cost=0..0.05 rows=4 width=8) (actual time=0..0.001 rows=4 loops=99,346)

13.          

CTE _cte_dossierbalance

14. 122.728 196.555 ↓ 1.0 92,384 1

Aggregate (cost=12,138.76..15,391.17 rows=88,111 width=132) (actual time=60.637..196.555 rows=92,384 loops=1)

15. 59.242 73.827 ↑ 1.0 99,346 1

Sort (cost=12,138.76..12,387.13 rows=99,346 width=24) (actual time=60.617..73.827 rows=99,346 loops=1)

  • Sort Key: lpb_1.dossierentityid
  • Sort Method: external merge Disk: 3520kB
16. 14.585 14.585 ↑ 1.0 99,346 1

Seq Scan on cte_loanpartbalance lpb_1 (cost=0..1,852.46 rows=99,346 width=24) (actual time=0.09..14.585 rows=99,346 loops=1)

17.          

CTE _cte_lastactualmarketvalue

18. 0.085 1.437 ↓ 213.3 640 1

Subquery Scan on lastactualmarketvalueprep (cost=67.02..116.62 rows=3 width=26) (actual time=0.34..1.437 rows=640 loops=1)

  • Filter: (lastactualmarketvalueprep.rn = 1)
19. 0.356 1.352 ↑ 1.0 640 1

WindowAgg (cost=67.02..108.62 rows=640 width=46) (actual time=0.339..1.352 rows=640 loops=1)

20. 0.130 0.356 ↑ 1.0 640 1

Sort (cost=67.02..68.62 rows=640 width=30) (actual time=0.324..0.356 rows=640 loops=1)

  • Sort Key: rev.realestatefk, rev.valuedeterminationdate DESC, rev.created DESC, rev.modified DESC
  • Sort Method: quicksort Memory: 75kB
21. 0.226 0.226 ↑ 1.0 640 1

Seq Scan on realestatevalue rev (cost=0..37.19 rows=640 width=30) (actual time=0.014..0.226 rows=640 loops=1)

  • Filter: (realestatevaluetypecd = 1)
22.          

SubPlan (forWindowAgg)

23. 0.640 0.640 ↑ 1.0 1 640

Aggregate (cost=0.03..0.04 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=640)

24. 0.000 0.000 ↑ 1.0 2 640

Values Scan (cost=0..0.03 rows=2 width=8) (actual time=0..0 rows=2 loops=640)

25.          

CTE lastaftertransformationmarketvalue

26. 0.013 0.326 ↓ 85.0 85 1

Subquery Scan on lastaftertransformationmarketvalueprep (cost=39.91..46.5 rows=1 width=26) (actual time=0.167..0.326 rows=85 loops=1)

  • Filter: (lastaftertransformationmarketvalueprep.rn = 1)
27. 0.065 0.313 ↑ 1.0 85 1

WindowAgg (cost=39.91..45.44 rows=85 width=46) (actual time=0.166..0.313 rows=85 loops=1)

28. 0.029 0.163 ↑ 1.0 85 1

Sort (cost=39.91..40.12 rows=85 width=30) (actual time=0.158..0.163 rows=85 loops=1)

  • Sort Key: rev_1.realestatefk, rev_1.valuedeterminationdate DESC, rev_1.created DESC, rev_1.modified DESC
  • Sort Method: quicksort Memory: 31kB
29. 0.134 0.134 ↑ 1.0 85 1

Seq Scan on realestatevalue rev_1 (cost=0..37.19 rows=85 width=30) (actual time=0.004..0.134 rows=85 loops=1)

  • Filter: (realestatevaluetypecd = 2)
30.          

SubPlan (forWindowAgg)

31. 0.085 0.085 ↑ 1.0 1 85

Aggregate (cost=0.03..0.04 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=85)

32. 0.000 0.000 ↑ 1.0 2 85

Values Scan (cost=0..0.03 rows=2 width=8) (actual time=0..0 rows=2 loops=85)

33.          

CTE _cte_applicationdate

34. 130.765 445.408 ↓ 1.4 99,346 1

WindowAgg (cost=24,599.27..31,221.56 rows=73,581 width=28) (actual time=204.583..445.408 rows=99,346 loops=1)

35. 66.454 215.297 ↓ 1.4 99,346 1

Sort (cost=24,599.27..24,783.22 rows=73,581 width=44) (actual time=204.555..215.297 rows=99,346 loops=1)

  • Sort Key: ffv.creditfk, ffv.pkey DESC
  • Sort Method: external sort Disk: 3696kB
36. 92.131 148.843 ↓ 1.4 99,346 1

Hash Join (cost=3.24..16,386.83 rows=73,581 width=44) (actual time=0.128..148.843 rows=99,346 loops=1)

37. 56.692 56.692 ↓ 1.0 735,823 1

Seq Scan on freefieldvalue ffv (cost=0..14,361.13 rows=735,813 width=32) (actual time=0.101..56.692 rows=735,823 loops=1)

38. 0.006 0.020 ↑ 1.0 9 1

Hash (cost=3.12..3.12 rows=9 width=20) (actual time=0.02..0.02 rows=9 loops=1)

39. 0.014 0.014 ↑ 1.0 9 1

Seq Scan on freefieldconfig ffc (cost=0..3.12 rows=9 width=20) (actual time=0.005..0.014 rows=9 loops=1)

  • Filter: (freefieldcd = 2)
40.          

SubPlan (forWindowAgg)

41. 0.000 99.346 ↑ 1.0 1 99,346

Aggregate (cost=0.06..0.07 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=99,346)

42. 99.346 99.346 ↑ 1.0 4 99,346

Values Scan (cost=0..0.05 rows=4 width=8) (actual time=0..0.001 rows=4 loops=99,346)

43.          

CTE _cte_proposaldate

44. 102.169 400.147 ↓ 1.3 92,503 1

WindowAgg (cost=24,599.27..31,221.56 rows=73,581 width=28) (actual time=196.351..400.147 rows=92,503 loops=1)

45. 57.862 205.475 ↓ 1.3 92,503 1

Sort (cost=24,599.27..24,783.22 rows=73,581 width=44) (actual time=196.331..205.475 rows=92,503 loops=1)

  • Sort Key: ffv_1.creditfk, ffv_1.pkey DESC
  • Sort Method: external sort Disk: 3440kB
46. 90.618 147.613 ↓ 1.3 92,503 1

Hash Join (cost=3.24..16,386.83 rows=73,581 width=44) (actual time=0.161..147.613 rows=92,503 loops=1)

47. 56.974 56.974 ↓ 1.0 735,823 1

Seq Scan on freefieldvalue ffv_1 (cost=0..14,361.13 rows=735,813 width=32) (actual time=0.127..56.974 rows=735,823 loops=1)

48. 0.005 0.021 ↑ 1.0 9 1

Hash (cost=3.12..3.12 rows=9 width=20) (actual time=0.021..0.021 rows=9 loops=1)

49. 0.016 0.016 ↑ 1.0 9 1

Seq Scan on freefieldconfig ffc_1 (cost=0..3.12 rows=9 width=20) (actual time=0.006..0.016 rows=9 loops=1)

  • Filter: (freefieldcd = 1003)
50.          

SubPlan (forWindowAgg)

51. 0.000 92.503 ↑ 1.0 1 92,503

Aggregate (cost=0.06..0.07 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=92,503)

52. 92.503 92.503 ↑ 1.0 4 92,503

Values Scan (cost=0..0.05 rows=4 width=8) (actual time=0..0.001 rows=4 loops=92,503)

53.          

CTE _cte_reassessmentdate

54. 19.915 180.972 ↑ 3.7 19,836 1

WindowAgg (cost=24,599.27..31,221.56 rows=73,581 width=28) (actual time=140.165..180.972 rows=19,836 loops=1)

55. 6.781 141.221 ↑ 3.7 19,836 1

Sort (cost=24,599.27..24,783.22 rows=73,581 width=44) (actual time=140.133..141.221 rows=19,836 loops=1)

  • Sort Key: ffv_2.creditfk, ffv_2.pkey DESC
  • Sort Method: quicksort Memory: 2318kB
56. 77.636 134.440 ↑ 3.7 19,836 1

Hash Join (cost=3.24..16,386.83 rows=73,581 width=44) (actual time=0.178..134.44 rows=19,836 loops=1)

57. 56.784 56.784 ↓ 1.0 735,823 1

Seq Scan on freefieldvalue ffv_2 (cost=0..14,361.13 rows=735,813 width=32) (actual time=0.123..56.784 rows=735,823 loops=1)

58. 0.005 0.020 ↑ 1.0 9 1

Hash (cost=3.12..3.12 rows=9 width=20) (actual time=0.02..0.02 rows=9 loops=1)

59. 0.015 0.015 ↑ 1.0 9 1

Seq Scan on freefieldconfig ffc_2 (cost=0..3.12 rows=9 width=20) (actual time=0.005..0.015 rows=9 loops=1)

  • Filter: (freefieldcd = 3)
60.          

SubPlan (forWindowAgg)

61. 0.000 19.836 ↑ 1.0 1 19,836

Aggregate (cost=0.06..0.07 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=19,836)

62. 19.836 19.836 ↑ 1.0 4 19,836

Values Scan (cost=0..0.05 rows=4 width=8) (actual time=0..0.001 rows=4 loops=19,836)

63.          

CTE _cte_isreassessmentsent

64. 101.808 417.674 ↓ 1.2 89,808 1

WindowAgg (cost=24,599.27..31,221.56 rows=73,581 width=25) (actual time=216.098..417.674 rows=89,808 loops=1)

65. 71.547 226.058 ↓ 1.2 89,808 1

Sort (cost=24,599.27..24,783.22 rows=73,581 width=41) (actual time=216.069..226.058 rows=89,808 loops=1)

  • Sort Key: ffv_3.creditfk, ffv_3.pkey DESC
  • Sort Method: external merge Disk: 3104kB
66. 94.748 154.511 ↓ 1.2 89,808 1

Hash Join (cost=3.24..16,386.83 rows=73,581 width=41) (actual time=0.152..154.511 rows=89,808 loops=1)

67. 59.744 59.744 ↓ 1.0 735,823 1

Seq Scan on freefieldvalue ffv_3 (cost=0..14,361.13 rows=735,813 width=29) (actual time=0.121..59.744 rows=735,823 loops=1)

68. 0.004 0.019 ↑ 1.0 9 1

Hash (cost=3.12..3.12 rows=9 width=20) (actual time=0.019..0.019 rows=9 loops=1)

69. 0.015 0.015 ↑ 1.0 9 1

Seq Scan on freefieldconfig ffc_3 (cost=0..3.12 rows=9 width=20) (actual time=0.005..0.015 rows=9 loops=1)

  • Filter: (freefieldcd = 4)
70.          

SubPlan (forWindowAgg)

71. 0.000 89.808 ↑ 1.0 1 89,808

Aggregate (cost=0.06..0.07 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=89,808)

72. 89.808 89.808 ↑ 1.0 4 89,808

Values Scan (cost=0..0.05 rows=4 width=8) (actual time=0..0.001 rows=4 loops=89,808)

73.          

CTE _cte_allowedlocationsmodifiedprep

74. 2.694 4.000 ↑ 1.4 1,306 1

Foreign Scan (cost=100..240.27 rows=1,861 width=12) (actual time=2.511..4 rows=1,306 loops=1)

75.          

SubPlan (forForeign Scan)

76. 1.306 1.306 ↑ 1.0 1 1,306

Aggregate (cost=0.03..0.04 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,306)

77. 0.000 0.000 ↑ 1.0 2 1,306

Values Scan (cost=0..0.03 rows=2 width=8) (actual time=0..0 rows=2 loops=1,306)

78.          

CTE allowedlocationsmodified

79. 0.573 4.898 ↓ 5.2 1,033 1

Aggregate (cost=46.53..48.53 rows=200 width=12) (actual time=4.767..4.898 rows=1,033 loops=1)

80. 4.325 4.325 ↑ 1.4 1,306 1

CTE Scan on _cte_allowedlocationsmodifiedprep _cte_allowedlocationsmodifiedprep (cost=0..37.22 rows=1,861 width=12) (actual time=2.512..4.325 rows=1,306 loops=1)

81.          

CTE _cte_thirdpartywarrantycustom

82. 17.444 57.475 ↓ 1.0 31,447 1

WindowAgg (cost=7,303.8..7,932.72 rows=31,446 width=284) (actual time=36.614..57.475 rows=31,447 loops=1)

83. 28.915 40.031 ↓ 1.0 31,447 1

Sort (cost=7,303.8..7,382.42 rows=31,446 width=276) (actual time=36.607..40.031 rows=31,447 loops=1)

  • Sort Key: tpw.assetfk, tpw.rank
  • Sort Method: external merge Disk: 2408kB
84. 8.208 11.116 ↓ 1.0 31,447 1

Hash Join (cost=1.46..870.19 rows=31,446 width=276) (actual time=0.139..11.116 rows=31,447 loops=1)

85. 2.893 2.893 ↓ 1.0 31,447 1

Seq Scan on thirdpartywarranty tpw (cost=0..776.46 rows=31,446 width=58) (actual time=0.114..2.893 rows=31,447 loops=1)

86. 0.005 0.015 ↓ 9.0 9 1

Hash (cost=1.45..1.45 rows=1 width=222) (actual time=0.014..0.015 rows=9 loops=1)

87. 0.010 0.010 ↓ 9.0 9 1

Seq Scan on par_warrantytypecaption pwt (cost=0..1.45 rows=1 width=222) (actual time=0.007..0.01 rows=9 loops=1)

  • Filter: (languageid = 4)
88. 1.625 9,052.507 ↓ 50.0 100 1

Nested Loop (cost=64,000.42..65,692.87 rows=2 width=3,279) (actual time=8,181.151..9,052.507 rows=100 loops=1)

89. 0.287 9,049.882 ↓ 50.0 100 1

Nested Loop (cost=64,000.42..65,690.49 rows=2 width=3,190) (actual time=8,181.079..9,049.882 rows=100 loops=1)

90. 0.214 9,049.195 ↓ 50.0 100 1

Nested Loop (cost=64,000.12..65,689.66 rows=2 width=3,170) (actual time=8,181.061..9,049.195 rows=100 loops=1)

91. 7.095 9,048.081 ↓ 50.0 100 1

Nested Loop (cost=63,999.83..65,688.76 rows=2 width=3,136) (actual time=8,181.035..9,048.081 rows=100 loops=1)

92. 0.777 9,027.386 ↓ 50.0 100 1

Nested Loop (cost=63,999.83..65,677.76 rows=2 width=3,132) (actual time=8,175.854..9,027.386 rows=100 loops=1)

93. 4.771 9,025.509 ↓ 50.0 100 1

Nested Loop (cost=63,999.83..65,677.71 rows=2 width=3,110) (actual time=8,175.494..9,025.509 rows=100 loops=1)

94. 182.976 9,014.038 ↓ 50.0 100 1

Nested Loop (cost=63,999.83..65,677.54 rows=2 width=3,084) (actual time=8,173.822..9,014.038 rows=100 loops=1)

95. 0.217 8,132.262 ↓ 50.0 100 1

Nested Loop (cost=63,999.83..64,964.51 rows=2 width=2,784) (actual time=8,128.803..8,132.262 rows=100 loops=1)

96. 0.219 8,131.365 ↓ 34.0 68 1

Nested Loop (cost=63,999.13..64,962.79 rows=2 width=1,997) (actual time=8,128.775..8,131.365 rows=68 loops=1)

97. 0.160 8,130.806 ↓ 34.0 68 1

Nested Loop (cost=63,998.84..64,961.81 rows=2 width=1,625) (actual time=8,128.763..8,130.806 rows=68 loops=1)

98. 0.191 8,130.374 ↓ 34.0 68 1

Nested Loop (cost=63,998.57..64,961.23 rows=2 width=1,613) (actual time=8,128.753..8,130.374 rows=68 loops=1)

99. 0.960 8,129.843 ↓ 34.0 68 1

Hash Join (cost=63,998.42..64,960.91 rows=2 width=1,591) (actual time=8,128.743..8,129.843 rows=68 loops=1)

100. 0.365 0.365 ↑ 36.9 812 1

Seq Scan on mv_first4guaranteesperloanpart f4g (cost=0..849.98 rows=29,998 width=49) (actual time=0.112..0.365 rows=812 loops=1)

101. 154.143 8,128.518 ↓ 49,673.0 99,346 1

Hash (cost=63,998.4..63,998.4 rows=2 width=1,546) (actual time=8,128.518..8,128.518 rows=99,346 loops=1)

102. 94.928 7,974.375 ↓ 49,673.0 99,346 1

Nested Loop (cost=56,954.73..63,998.4 rows=2 width=1,546) (actual time=7,056.861..7,974.375 rows=99,346 loops=1)

103. 84.115 7,780.101 ↓ 49,673.0 99,346 1

Nested Loop (cost=56,954.44..63,997.7 rows=2 width=1,139) (actual time=7,056.848..7,780.101 rows=99,346 loops=1)

104. 64.419 7,596.640 ↓ 49,673.0 99,346 1

Nested Loop (cost=56,954.16..63,997 rows=2 width=1,112) (actual time=7,056.838..7,596.64 rows=99,346 loops=1)

105. 63.646 7,532.221 ↓ 49,673.0 99,346 1

Nested Loop (cost=56,954.16..63,995.87 rows=2 width=898) (actual time=7,056.817..7,532.221 rows=99,346 loops=1)

106. 151.724 7,369.229 ↓ 49,673.0 99,346 1

Merge Join (cost=56,954.01..63,995.54 rows=2 width=883) (actual time=7,056.791..7,369.229 rows=99,346 loops=1)

107. 48.533 79.388 ↓ 1.0 99,353 1

Group (cost=0.29..5,799.92 rows=99,350 width=40) (actual time=0.013..79.388 rows=99,353 loops=1)

108. 30.855 30.855 ↓ 1.0 99,353 1

Index Scan using productcopy_pkey on productcopy pc_1 (cost=0.29..5,551.54 rows=99,350 width=8) (actual time=0.012..30.855 rows=99,353 loops=1)

109. 332.572 7,138.117 ↓ 49,673.0 99,346 1

Sort (cost=56,953.72..56,953.73 rows=2 width=887) (actual time=7,056.77..7,138.117 rows=99,346 loops=1)

  • Sort Key: pc.pkey
  • Sort Method: external sort Disk: 33560kB
110. 63.224 6,805.545 ↓ 49,673.0 99,346 1

Nested Loop (cost=38,040.29..56,953.71 rows=2 width=887) (actual time=2,551.149..6,805.545 rows=99,346 loops=1)

111. 52.088 6,543.629 ↓ 49,673.0 99,346 1

Nested Loop (cost=38,039.99..56,952.83 rows=2 width=859) (actual time=2,551.131..6,543.629 rows=99,346 loops=1)

112. 0.021 0.021 ↓ 4.0 4 1

Seq Scan on par_periodicitycaption pp (cost=0..1.2 rows=1 width=222) (actual time=0.006..0.021 rows=4 loops=1)

  • Filter: (languageid = 4)
113. 643.232 6,491.520 ↓ 4,139.4 99,346 4

Hash Join (cost=38,039.99..56,951.33 rows=24 width=641) (actual time=1,054.309..1,622.88 rows=99,346 loops=4)

114. 564.864 5,296.724 ↑ 1.0 99,346 4

Hash Join (cost=32,083.96..50,622.47 rows=99,358 width=393) (actual time=916.404..1,324.181 rows=99,346 loops=4)

115. 492.356 3,999.864 ↑ 1.0 99,346 4

Hash Join (cost=18,567.32..27,064.65 rows=99,358 width=242) (actual time=733.17..999.966 rows=99,346 loops=4)

116. 620.556 620.556 ↑ 1.0 99,346 4

CTE Scan on _cte_loanpartbalance lpb (cost=0..1,987.16 rows=99,358 width=98) (actual time=11.219..155.139 rows=99,346 loops=4)

117. 226.116 2,886.952 ↑ 1.0 99,346 4

Hash (cost=15,287.35..15,287.35 rows=99,358 width=144) (actual time=721.738..721.738 rows=99,346 loops=4)

118. 155.676 2,660.836 ↑ 1.0 99,346 4

Merge Join (cost=6,685.32..15,287.35 rows=99,358 width=144) (actual time=431.605..665.209 rows=99,346 loops=4)

119. 93.656 1,961.880 ↑ 1.0 99,346 4

Merge Join (cost=5,014.06..13,362.18 rows=99,358 width=135) (actual time=305.676..490.47 rows=99,346 loops=4)

120. 135.340 1,672.600 ↑ 1.0 99,346 4

Merge Join (cost=3,342.8..11,437 rows=99,358 width=123) (actual time=257.976..418.15 rows=99,346 loops=4)

121. 327.588 1,012.524 ↑ 1.0 99,346 4

Merge Join (cost=1,671.55..9,511.83 rows=99,358 width=111) (actual time=136.494..253.131 rows=99,346 loops=4)

122. 96.348 96.348 ↑ 1.0 99,346 4

Index Scan using credit_pkey on credit c (cost=0.29..7,586.66 rows=99,358 width=99) (actual time=0.018..24.087 rows=99,346 loops=4)

123. 98.171 588.588 ↓ 270.0 99,346 4

Sort (cost=1,671.26..1,672.18 rows=368 width=16) (actual time=136.469..147.147 rows=99,346 loops=4)

  • Sort Key: appdate.loanpartentityid
  • Sort Method: external sort Disk: 2920kB
124. 490.417 490.417 ↓ 270.0 99,346 1

CTE Scan on _cte_applicationdate appdate (cost=0..1,655.57 rows=368 width=16) (actual time=204.587..490.417 rows=99,346 loops=1)

  • Filter: (rn = 1)
125. 85.760 524.736 ↓ 251.4 92,503 4

Sort (cost=1,671.26..1,672.18 rows=368 width=16) (actual time=121.479..131.184 rows=92,503 loops=4)

  • Sort Key: propdate.loanpartentityid
  • Sort Method: external sort Disk: 2720kB
126. 438.976 438.976 ↓ 251.4 92,503 1

CTE Scan on _cte_proposaldate propdate (cost=0..1,655.57 rows=368 width=16) (actual time=196.354..438.976 rows=92,503 loops=1)

  • Filter: (rn = 1)
127. 7.454 195.624 ↓ 53.9 19,836 4

Sort (cost=1,671.26..1,672.18 rows=368 width=16) (actual time=47.697..48.906 rows=19,836 loops=4)

  • Sort Key: reassdate.loanpartentityid
  • Sort Method: quicksort Memory: 1698kB
128. 188.170 188.170 ↓ 53.9 19,836 1

CTE Scan on _cte_reassessmentdate reassdate (cost=0..1,655.57 rows=368 width=16) (actual time=140.169..188.17 rows=19,836 loops=1)

  • Filter: (rn = 1)
129. 86.464 543.280 ↓ 244.0 89,808 4

Sort (cost=1,671.26..1,672.18 rows=368 width=13) (actual time=125.926..135.82 rows=89,808 loops=4)

  • Sort Key: isreasssent.loanpartentityid
  • Sort Method: external sort Disk: 2640kB
130. 456.816 456.816 ↓ 244.0 89,808 1

CTE Scan on _cte_isreassessmentsent isreasssent (cost=0..1,655.57 rows=368 width=13) (actual time=216.102..456.816 rows=89,808 loops=1)

  • Filter: (rn = 1)
131. 100.396 731.996 ↓ 1.0 92,434 4

Hash (cost=10,284.24..10,284.24 rows=92,432 width=155) (actual time=182.999..182.999 rows=92,434 loops=4)

132. 185.252 631.600 ↓ 1.0 92,434 4

Hash Join (cost=4,216.72..10,284.24 rows=92,432 width=155) (actual time=54.323..157.9 rows=92,434 loops=4)

133. 290.852 290.852 ↓ 1.0 92,384 4

CTE Scan on _cte_dossierbalance db (cost=0..1,762.22 rows=88,111 width=132) (actual time=15.17..72.713 rows=92,384 loops=4)

134. 72.136 155.496 ↓ 1.0 92,434 4

Hash (cost=2,429.32..2,429.32 rows=92,432 width=27) (actual time=38.874..38.874 rows=92,434 loops=4)

135. 83.360 83.360 ↓ 1.0 92,434 4

Seq Scan on creditdossier cd (cost=0..2,429.32 rows=92,432 width=27) (actual time=0.117..20.84 rows=92,434 loops=4)

136. 207.144 551.564 ↓ 4,139.4 99,346 4

Hash (cost=5,955.73..5,955.73 rows=24 width=256) (actual time=137.891..137.891 rows=99,346 loops=4)

137. 96.568 344.420 ↓ 4,139.4 99,346 4

Gather (cost=1,001.36..5,955.73 rows=24 width=256) (actual time=0.719..86.105 rows=99,346 loops=4)

138. 147.016 247.852 ↓ 3,311.5 33,115 12

Hash Join (cost=1.36..4,953.33 rows=10 width=256) (actual time=0.935..61.963 rows=33,115 loops=12)

139. 100.740 100.740 ↓ 115.8 33,115 12

Seq Scan on amortizationversion av (cost=0..4,951.11 rows=286 width=42) (actual time=0.816..25.185 rows=33,115 loops=12)

  • Filter: ((isactive)::integer = 1)
140. 0.024 0.096 ↓ 7.0 7 9

Hash (cost=1.35..1.35 rows=1 width=222) (actual time=0.024..0.024 rows=7 loops=9)

141. 0.072 0.072 ↓ 7.0 7 9

Seq Scan on par_amortizationshedulecaption pasc (cost=0..1.35 rows=1 width=222) (actual time=0.014..0.018 rows=7 loops=9)

  • Filter: (languageid = 4)
142. 198.692 198.692 ↑ 1.0 1 99,346

Index Scan using productcopy_pkey on productcopy pc (cost=0.29..0.44 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=99,346)

  • Index Cond: (pkey = c.productcopyfk)
143. 99.346 99.346 ↑ 1.0 1 99,346

Index Scan using par_creditstatuscaption_pkey on par_creditstatuscaption pcs (cost=0.14..0.16 rows=1 width=19) (actual time=0.001..0.001 rows=1 loops=99,346)

  • Index Cond: ((codeid = c.creditstatuscd) AND (languageid = 4))
144. 0.000 0.000 ↑ 1.0 1 99,346

Materialize (cost=0..1.1 rows=1 width=222) (actual time=0..0 rows=1 loops=99,346)

145. 0.008 0.008 ↓ 2.0 2 1

Seq Scan on par_productfamilycaption ppf (cost=0..1.1 rows=1 width=222) (actual time=0.007..0.008 rows=2 loops=1)

  • Filter: (languageid = 4)
146. 99.346 99.346 ↓ 0.0 0 99,346

Index Scan using _ix_mv_firstwarranty_dossierentityid on mv_firstwarranty fw (cost=0.29..0.34 rows=1 width=31) (actual time=0.001..0.001 rows=0 loops=99,346)

  • Index Cond: ("DossierEntityId" = cd.pkey)
147. 99.346 99.346 ↓ 0.0 0 99,346

Index Scan using _ix_mv_first3realestatesperloanpart_loanpartentityid on mv_first3realestatesperloanpart f3re (cost=0.29..0.34 rows=1 width=411) (actual time=0.001..0.001 rows=0 loops=99,346)

  • Index Cond: ("LoanPartEntityId" = c.pkey)
148. 0.340 0.340 ↑ 1.0 1 68

Index Scan using par_productnamecaption_pkey on par_productnamecaption ppnc (cost=0.14..0.16 rows=1 width=26) (actual time=0.005..0.005 rows=1 loops=68)

  • Index Cond: ((codeid = pc.productnamecd) AND (languageid = 4))
149. 0.272 0.272 ↑ 1.0 1 68

Index Scan using creditprovider_pkey on creditprovider credprov (cost=0.27..0.29 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=68)

  • Index Cond: (pkey = pc.economicalownerfk)
150. 0.340 0.340 ↑ 1.0 1 68

Index Scan using ix_report_mv_contractors_dossierentityid on mv_contractors cont (cost=0.29..0.48 rows=1 width=376) (actual time=0.004..0.005 rows=1 loops=68)

  • Index Cond: ("DossierEntityId" = cd.pkey)
151. 0.204 0.680 ↑ 1.0 1 68

Nested Loop (cost=0.7..0.85 rows=1 width=791) (actual time=0.008..0.01 rows=1 loops=68)

152. 0.476 0.476 ↑ 1.0 1 68

Index Scan using _ix_mv_runningaccountandloansbaseview_loanpartentityid on mv_runningaccountandloansbaseview raalbase (cost=0.42..0.54 rows=1 width=775) (actual time=0.005..0.007 rows=1 loops=68)

  • Index Cond: ("LoanPartEntityId" = c.pkey)
153. 0.000 0.000 ↓ 0.0 0 100

Index Scan using _ix_cte_allowedlocationsstringset_subframeworkagreemententityid on cte_allowedlocationsstringset allowedlocations (cost=0.28..0.3 rows=1 width=20) (actual time=0..0 rows=0 loops=100)

  • Index Cond: (subframeworkagreemententityid = raalbase."SubframeworkAgreementEntityId")
154. 698.800 698.800 ↓ 197.6 31,030 100

CTE Scan on _cte_thirdpartywarrantycustom thirdpartywarr (cost=0..707.53 rows=157 width=304) (actual time=0.369..6.988 rows=31,030 loops=100)

  • Filter: (rn = 1)
155. 6.700 6.700 ↓ 213.3 640 100

CTE Scan on _cte_lastactualmarketvalue actualmarketvalue (cost=0..0.06 rows=3 width=30) (actual time=0.004..0.067 rows=640 loops=100)

156. 1.100 1.100 ↓ 85.0 85 100

CTE Scan on lastaftertransformationmarketvalue aftertransformmarketvalue (cost=0..0.02 rows=1 width=30) (actual time=0.002..0.011 rows=85 loops=100)

157. 13.600 13.600 ↓ 5.2 1,033 100

CTE Scan on allowedlocationsmodified allowedlocationsmodified (cost=0..4 rows=200 width=12) (actual time=0.048..0.136 rows=1,033 loops=100)

158. 0.900 0.900 ↑ 1.0 1 100

Index Scan using _ix_directdebit_creditfk on directdebit dide (cost=0.29..0.44 rows=1 width=38) (actual time=0.009..0.009 rows=1 loops=100)

  • Index Cond: (creditfk = c.pkey)
  • Filter: ((startdate < CURRENT_TIMESTAMP) AND (COALESCE((enddate)::timestamp with time zone, CURRENT_TIMESTAMP) >= CURRENT_TIMESTAMP) AND (COALESCE((suspendperiodenddate)::timestamp with time zone, (CURRENT_TIMESTAMP + '1 day'::interval)) > CURRENT_TIMESTAMP) AND (COALESCE((suspendperiodstartdate)::timestamp with time zone, (CURRENT_TIMESTAMP - '1 day'::interval)) < CURRENT_TIMESTAMP))
159. 0.400 0.400 ↑ 1.0 1 100

Index Scan using _ix_constructiondepot_creditfk on constructiondepot con (cost=0.29..0.4 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (creditfk = c.pkey)
160. 0.000 0.000 ↓ 2.0 2 100

Materialize (cost=0..1.2 rows=1 width=222) (actual time=0..0 rows=2 loops=100)

161. 0.009 0.009 ↓ 2.0 2 1

Seq Scan on par_constructiondepottypecaption pcdt (cost=0..1.2 rows=1 width=222) (actual time=0.008..0.009 rows=2 loops=1)

  • Filter: (languageid = 4)
162.          

SubPlan (forNested Loop)

163. 0.400 1.000 ↑ 1.0 1 100

Aggregate (cost=0.42..0.43 rows=1 width=8) (actual time=0.01..0.01 rows=1 loops=100)

164. 0.600 0.600 ↑ 1.0 28 100

Values Scan (cost=0..0.35 rows=28 width=8) (actual time=0.001..0.006 rows=28 loops=100)