explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QSyrB

Settings
# exclusive inclusive rows x rows loops node
1. 0.100 15,875.970 ↑ 1.0 10 1

Limit (cost=314,736.46..315,511.85 rows=10 width=9,421) (actual time=10,361.118..15,875.97 rows=10 loops=1)

  • Buffers: shared hit=2651832, temp read=41785 written=25161
2.          

CTE loanpartbalance

3. 113.560 485.555 ↑ 1.0 99,343 1

Hash Join (cost=16,320.53..29,004.17 rows=99,382 width=63) (actual time=182.739..485.555 rows=99,343 loops=1)

  • Buffers: shared hit=20902
4. 49.425 216.273 ↑ 1.0 99,343 1

Hash Join (cost=11,971.38..16,692.03 rows=99,382 width=56) (actual time=125.811..216.273 rows=99,343 loops=1)

  • Buffers: shared hit=16740
5. 83.969 93.414 ↑ 1.0 99,350 1

Aggregate (cost=4,204.28..6,564.6 rows=99,382 width=40) (actual time=52.22..93.414 rows=99,350 loops=1)

  • Buffers: shared hit=5778
6. 9.445 9.445 ↑ 1.0 99,350 1

Seq Scan on productcopy pc_3 (cost=0..3,955.82 rows=99,382 width=8) (actual time=0.102..9.445 rows=99,350 loops=1)

  • Buffers: shared hit=5778
7. 19.878 73.434 ↓ 1.0 99,343 1

Hash (cost=6,555.38..6,555.38 rows=96,938 width=28) (actual time=73.434..73.434 rows=99,343 loops=1)

  • Buffers: shared hit=10962
8. 53.556 53.556 ↓ 1.0 99,343 1

Seq Scan on credit c_1_1 (cost=0..6,555.38 rows=96,938 width=28) (actual time=0.115..53.556 rows=99,343 loops=1)

  • Buffers: shared hit=10962
9. 27.500 56.379 ↓ 1.0 99,344 1

Hash (cost=3,107.4..3,107.4 rows=99,340 width=35) (actual time=56.379..56.379 rows=99,344 loops=1)

  • Buffers: shared hit=4162
10. 28.879 28.879 ↓ 1.0 99,344 1

Seq Scan on creditbalances cb (cost=0..3,107.4 rows=99,340 width=35) (actual time=0.099..28.879 rows=99,344 loops=1)

  • Buffers: shared hit=4162
11.          

SubPlan (forHash Join)

12. 0.000 99.343 ↑ 1.0 1 99,343

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

13. 99.343 99.343 ↑ 1.0 4 99,343

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

14.          

CTE dossierbalance

15. 233.147 245.458 ↓ 461.9 92,382 1

Aggregate (cost=3,229.91..3,233.91 rows=200 width=132) (actual time=128.255..245.458 rows=92,382 loops=1)

16. 12.311 12.311 ↑ 1.0 99,343 1

CTE Scan on loanpartbalance lpb_1 (cost=0..1,987.64 rows=99,382 width=90) (actual time=0.002..12.311 rows=99,343 loops=1)

17.          

CTE lastactualmarketvalue

18. 0.094 1.562 ↓ 213.3 640 1

Subquery Scan on lastactualmarketvalueprep (cost=66.93..116.45 rows=3 width=26) (actual time=0.37..1.562 rows=640 loops=1)

  • Filter: (lastactualmarketvalueprep.rn = 1)
  • Buffers: shared hit=19
19. 0.440 1.468 ↓ 1.0 640 1

WindowAgg (cost=66.93..108.46 rows=639 width=46) (actual time=0.369..1.468 rows=640 loops=1)

  • Buffers: shared hit=19
20. 0.160 0.388 ↓ 1.0 640 1

Sort (cost=66.93..68.52 rows=639 width=30) (actual time=0.353..0.388 rows=640 loops=1)

  • Sort Key: rev.realestatefk, rev.valuedeterminationdate DESC, rev.created DESC, rev.modified DESC
  • Sort Method: quicksort Memory: 75kB
  • Buffers: shared hit=19
21. 0.228 0.228 ↓ 1.0 640 1

Seq Scan on realestatevalue rev (cost=0..37.15 rows=639 width=30) (actual time=0.01..0.228 rows=640 loops=1)

  • Filter: (rev.realestatevaluetypecd = 1)
  • Buffers: shared hit=19
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.310 ↓ 85.0 85 1

Subquery Scan on lastaftertransformationmarketvalueprep (cost=39.87..46.46 rows=1 width=26) (actual time=0.151..0.31 rows=85 loops=1)

  • Filter: (lastaftertransformationmarketvalueprep.rn = 1)
  • Buffers: shared hit=19
27. 0.065 0.297 ↑ 1.0 85 1

WindowAgg (cost=39.87..45.4 rows=85 width=46) (actual time=0.15..0.297 rows=85 loops=1)

  • Buffers: shared hit=19
28. 0.023 0.147 ↑ 1.0 85 1

Sort (cost=39.87..40.09 rows=85 width=30) (actual time=0.142..0.147 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
  • Buffers: shared hit=19
29. 0.124 0.124 ↑ 1.0 85 1

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

  • Filter: (rev_1.realestatevaluetypecd = 2)
  • Buffers: shared hit=19
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 applicationdate

34. 123.998 417.116 ↓ 1.3 99,343 1

WindowAgg (cost=22,346.63..28,972.61 rows=73,622 width=28) (actual time=188.029..417.116 rows=99,343 loops=1)

  • Buffers: shared hit=13920
35. 35.504 193.775 ↓ 1.3 99,343 1

Sort (cost=22,346.63..22,530.68 rows=73,622 width=44) (actual time=187.994..193.775 rows=99,343 loops=1)

  • Sort Key: ffv.creditfk, ffv.pkey DESC
  • Sort Method: quicksort Memory: 10834kB
  • Buffers: shared hit=13920
36. 107.197 158.271 ↓ 1.3 99,343 1

Hash Join (cost=3.24..16,395.08 rows=73,622 width=44) (actual time=0.14..158.271 rows=99,343 loops=1)

  • Buffers: shared hit=13920
37. 51.048 51.048 ↑ 1.0 735,813 1

Seq Scan on freefieldvalue ffv (cost=0..14,368.25 rows=736,225 width=32) (actual time=0.1..51.048 rows=735,813 loops=1)

  • Buffers: shared hit=13918
38. 0.009 0.026 ↑ 1.0 9 1

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

  • Buffers: shared hit=2
39. 0.017 0.017 ↑ 1.0 9 1

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

  • Filter: (ffc.freefieldcd = 2)
  • Buffers: shared hit=2
40.          

SubPlan (forWindowAgg)

41. 0.000 99.343 ↑ 1.0 1 99,343

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

42. 99.343 99.343 ↑ 1.0 4 99,343

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

43.          

CTE proposaldate

44. 118.506 418.209 ↓ 1.3 92,503 1

WindowAgg (cost=22,346.63..28,972.61 rows=73,622 width=28) (actual time=201.56..418.209 rows=92,503 loops=1)

  • Buffers: shared hit=13920
45. 34.075 207.200 ↓ 1.3 92,503 1

Sort (cost=22,346.63..22,530.68 rows=73,622 width=44) (actual time=201.521..207.2 rows=92,503 loops=1)

  • Sort Key: ffv_1.creditfk, ffv_1.pkey DESC
  • Sort Method: quicksort Memory: 10299kB
  • Buffers: shared hit=13920
46. 117.607 173.125 ↓ 1.3 92,503 1

Hash Join (cost=3.24..16,395.08 rows=73,622 width=44) (actual time=0.152..173.125 rows=92,503 loops=1)

  • Buffers: shared hit=13920
47. 55.494 55.494 ↑ 1.0 735,813 1

Seq Scan on freefieldvalue ffv_1 (cost=0..14,368.25 rows=736,225 width=32) (actual time=0.115..55.494 rows=735,813 loops=1)

  • Buffers: shared hit=13918
48. 0.004 0.024 ↑ 1.0 9 1

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

  • Buffers: shared hit=2
49. 0.020 0.020 ↑ 1.0 9 1

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

  • Filter: (ffc_1.freefieldcd = 1003)
  • Buffers: shared hit=2
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 reassessmentdate

54. 23.459 194.913 ↑ 3.7 19,834 1

WindowAgg (cost=22,346.63..28,972.61 rows=73,622 width=28) (actual time=150.479..194.913 rows=19,834 loops=1)

  • Buffers: shared hit=13920
55. 7.534 151.620 ↑ 3.7 19,834 1

Sort (cost=22,346.63..22,530.68 rows=73,622 width=44) (actual time=150.445..151.62 rows=19,834 loops=1)

  • Sort Key: ffv_2.creditfk, ffv_2.pkey DESC
  • Sort Method: quicksort Memory: 2318kB
  • Buffers: shared hit=13920
56. 93.302 144.086 ↑ 3.7 19,834 1

Hash Join (cost=3.24..16,395.08 rows=73,622 width=44) (actual time=0.18..144.086 rows=19,834 loops=1)

  • Buffers: shared hit=13920
57. 50.762 50.762 ↑ 1.0 735,813 1

Seq Scan on freefieldvalue ffv_2 (cost=0..14,368.25 rows=736,225 width=32) (actual time=0.117..50.762 rows=735,813 loops=1)

  • Buffers: shared hit=13918
58. 0.006 0.022 ↑ 1.0 9 1

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

  • Buffers: shared hit=2
59. 0.016 0.016 ↑ 1.0 9 1

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

  • Filter: (ffc_2.freefieldcd = 3)
  • Buffers: shared hit=2
60.          

SubPlan (forWindowAgg)

61. 0.000 19.834 ↑ 1.0 1 19,834

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

62. 19.834 19.834 ↑ 1.0 4 19,834

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

63.          

CTE isreassessmentsent

64. 43.142 412.920 ↓ 1.2 89,806 1

WindowAgg (cost=22,346.63..28,972.61 rows=73,622 width=25) (actual time=183.928..412.92 rows=89,806 loops=1)

  • Buffers: shared hit=13920
65. 36.367 190.166 ↓ 1.2 89,806 1

Sort (cost=22,346.63..22,530.68 rows=73,622 width=41) (actual time=183.898..190.166 rows=89,806 loops=1)

  • Sort Key: ffv_3.creditfk, ffv_3.pkey DESC
  • Sort Method: quicksort Memory: 10089kB
  • Buffers: shared hit=13920
66. 102.543 153.799 ↓ 1.2 89,806 1

Hash Join (cost=3.24..16,395.08 rows=73,622 width=41) (actual time=0.156..153.799 rows=89,806 loops=1)

  • Buffers: shared hit=13920
67. 51.234 51.234 ↑ 1.0 735,813 1

Seq Scan on freefieldvalue ffv_3 (cost=0..14,368.25 rows=736,225 width=29) (actual time=0.116..51.234 rows=735,813 loops=1)

  • Buffers: shared hit=13918
68. 0.005 0.022 ↑ 1.0 9 1

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

  • Buffers: shared hit=2
69. 0.017 0.017 ↑ 1.0 9 1

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

  • Filter: (ffc_3.freefieldcd = 4)
  • Buffers: shared hit=2
70.          

SubPlan (forWindowAgg)

71. 89.806 179.612 ↑ 1.0 1 89,806

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

72. 89.806 89.806 ↑ 1.0 4 89,806

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

73.          

CTE allowedlocationsmodifiedprep

74. 0.000 0.000 ↓ 0.0 0 0

Foreign Scan (cost=100..240.27 rows=1,861 width=12) (never executed)

75.          

SubPlan (forForeign Scan)

76. 0.000 0.000 ↓ 0.0 0 0

Aggregate (cost=0.03..0.04 rows=1 width=8) (never executed)

77. 0.000 0.000 ↓ 0.0 0 0

Values Scan (cost=0..0.03 rows=2 width=8) (never executed)

78.          

CTE thirdpartywarrantycustom

79. 19.434 47.617 ↓ 1.0 31,446 1

WindowAgg (cost=3,248.45..3,877.35 rows=31,445 width=84) (actual time=24.629..47.617 rows=31,446 loops=1)

  • Buffers: shared hit=719
80. 16.763 28.183 ↓ 1.0 31,446 1

Sort (cost=3,248.45..3,327.07 rows=31,445 width=76) (actual time=24.616..28.183 rows=31,446 loops=1)

  • Sort Key: tpw.assetfk, tpw.rank
  • Sort Method: quicksort Memory: 4792kB
  • Buffers: shared hit=719
81. 9.132 11.420 ↓ 1.0 31,446 1

Hash Join (cost=1.56..899.43 rows=31,445 width=76) (actual time=0.137..11.42 rows=31,446 loops=1)

  • Buffers: shared hit=719
82. 2.276 2.276 ↓ 1.0 31,446 1

Seq Scan on thirdpartywarranty tpw (cost=0..776.45 rows=31,445 width=58) (actual time=0.115..2.276 rows=31,446 loops=1)

  • Buffers: shared hit=718
83. 0.005 0.012 ↑ 1.0 9 1

Hash (cost=1.45..1.45 rows=9 width=22) (actual time=0.012..0.012 rows=9 loops=1)

  • Buffers: shared hit=1
84. 0.007 0.007 ↑ 1.0 9 1

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

  • Filter: (pwt.languageid = 4)
  • Buffers: shared hit=1
85. 0.186 15,875.870 ↑ 71.3 10 1

Nested Loop (cost=162,327.41..217,612.92 rows=713 width=9,421) (actual time=10,361.117..15,875.87 rows=10 loops=1)

  • Buffers: shared hit=2651832, temp read=41785 written=25161
86. 0.123 13,192.854 ↑ 71.3 10 1

Nested Loop (cost=160,792.52..214,998.49 rows=713 width=9,417) (actual time=9,546.548..13,192.854 rows=10 loops=1)

  • Buffers: shared hit=2643683, temp read=41785 written=25161
87. 0.590 13,192.321 ↑ 71.3 10 1

Nested Loop (cost=160,792.52..214,982.44 rows=713 width=9,379) (actual time=9,546.197..13,192.321 rows=10 loops=1)

  • Buffers: shared hit=2643664, temp read=41785 written=25161
88. 23.433 13,189.421 ↑ 71.3 10 1

Nested Loop (cost=160,792.52..214,934.28 rows=713 width=9,341) (actual time=9,544.379..13,189.421 rows=10 loops=1)

  • Buffers: shared hit=2643645, temp read=41785 written=25161
89. 39.151 13,045.938 ↑ 71.3 10 1

Nested Loop (cost=160,792.52..211,709.66 rows=713 width=8,799) (actual time=9,494.68..13,045.938 rows=10 loops=1)

  • Buffers: shared hit=2642926, temp read=41785 written=25161
90. 34.626 11,079.517 ↑ 71.3 10 1

Nested Loop (cost=105,596.21..154,749.98 rows=713 width=8,062) (actual time=8,504.604..11,079.517 rows=10 loops=1)

  • Buffers: shared hit=2497512, temp read=40582 written=23960
91. 28.924 10,687.231 ↑ 71.3 10 1

Nested Loop (cost=86,822.65..133,316.82 rows=713 width=6,924) (actual time=8,334.384..10,687.231 rows=10 loops=1)

  • Buffers: shared hit=2483277, temp read=40582 written=23960
92. 82.004 10,282.817 ↑ 71.3 10 1

Nested Loop (cost=66,025.44..109,965.82 rows=713 width=5,628) (actual time=8,072.159..10,282.817 rows=10 loops=1)

  • Buffers: shared hit=2469044, temp read=40582 written=23960
93. 0.063 2,710.573 ↑ 71.3 10 1

Nested Loop (cost=35,658.99..79,554.93 rows=713 width=4,220) (actual time=2,709.174..2,710.573 rows=10 loops=1)

  • Buffers: shared hit=93632, temp written=1368
94. 0.071 2,710.450 ↑ 71.3 10 1

Nested Loop (cost=35,658.71..79,219.76 rows=713 width=4,201) (actual time=2,709.157..2,710.45 rows=10 loops=1)

  • Buffers: shared hit=93602, temp written=1368
95. 0.064 2,710.329 ↑ 71.3 10 1

Nested Loop (cost=35,658.44..79,012.77 rows=713 width=3,869) (actual time=2,709.142..2,710.329 rows=10 loops=1)

  • Buffers: shared hit=93572, temp written=1368
96. 0.044 2,710.205 ↑ 71.3 10 1

Nested Loop (cost=35,658.3..78,897.27 rows=713 width=3,839) (actual time=2,709.112..2,710.205 rows=10 loops=1)

  • Buffers: shared hit=93552, temp written=1368
97. 0.578 2,710.141 ↑ 71.3 10 1

Hash Join (cost=35,658.3..78,878.35 rows=713 width=3,812) (actual time=2,709.088..2,710.141 rows=10 loops=1)

  • Buffers: shared hit=93551, temp written=1368
98. 0.070 2,582.737 ↑ 71.3 10 1

Nested Loop (cost=26,857.6..61,211.5 rows=713 width=3,772) (actual time=2,581.74..2,582.737 rows=10 loops=1)

  • Buffers: shared hit=87773, temp written=1368
99. 0.036 2,582.607 ↑ 71.3 10 1

Nested Loop (cost=26,857.31..60,895.26 rows=713 width=3,420) (actual time=2,581.725..2,582.607 rows=10 loops=1)

  • Buffers: shared hit=87743, temp written=1368
100. 0.035 2,582.561 ↑ 71.3 10 1

Nested Loop (cost=26,857.31..60,827.06 rows=713 width=3,390) (actual time=2,581.717..2,582.561 rows=10 loops=1)

  • Buffers: shared hit=87742, temp written=1368
101. 0.074 2,582.506 ↑ 71.3 10 1

Nested Loop (cost=26,857.31..60,789.48 rows=713 width=3,373) (actual time=2,581.703..2,582.506 rows=10 loops=1)

  • Buffers: shared hit=87741, temp written=1368
102. 0.172 2,582.332 ↑ 71.3 10 1

Hash Join (cost=26,857.17..60,674.18 rows=713 width=3,350) (actual time=2,581.677..2,582.332 rows=10 loops=1)

  • Buffers: shared hit=87721, temp written=1368
103. 0.093 2,513.297 ↑ 4,969.1 20 1

Hash Join (cost=20,517.02..50,600.08 rows=99,382 width=2,562) (actual time=2,512.799..2,513.297 rows=20 loops=1)

  • Buffers: shared hit=79378
104. 0.600 2,213.840 ↑ 4,969.1 20 1

Hash Join (cost=20,510.52..47,858.42 rows=99,382 width=2,430) (actual time=2,213.395..2,213.84 rows=20 loops=1)

  • Buffers: shared hit=79378
105. 0.062 2,187.889 ↑ 4,969.1 20 1

Merge Join (cost=16,925.82..44,012.84 rows=99,382 width=2,336) (actual time=2,187.502..2,187.889 rows=20 loops=1)

  • Buffers: shared hit=76593
106. 0.053 1,626.581 ↑ 4,846.9 20 1

Merge Join (cost=6,689.13..32,043.07 rows=96,938 width=2,234) (actual time=1,626.262..1,626.581 rows=20 loops=1)

  • Buffers: shared hit=55691
107. 0.037 1,152.551 ↑ 4,846.9 20 1

Merge Join (cost=5,016.95..30,123.03 rows=96,938 width=2,213) (actual time=1,152.286..1,152.551 rows=20 loops=1)

  • Buffers: shared hit=41771
108. 0.052 946.573 ↑ 4,846.9 20 1

Merge Join (cost=3,344.77..28,202.98 rows=96,938 width=2,189) (actual time=946.34..946.573 rows=20 loops=1)

  • Buffers: shared hit=27851
109. 0.098 475.115 ↑ 4,846.9 20 1

Merge Join (cost=1,672.6..26,282.94 rows=96,938 width=2,165) (actual time=474.938..475.115 rows=20 loops=1)

  • Buffers: shared hit=13931
110. 0.094 0.094 ↑ 4,846.9 20 1

Index Scan using pk__credit__5e190d187b016d94 on credit c (cost=0.42..24,362.9 rows=96,938 width=2,141) (actual time=0.014..0.094 rows=20 loops=1)

  • Buffers: shared hit=11
111. 20.723 474.923 ↑ 18.4 20 1

Sort (cost=1,672.18..1,673.1 rows=368 width=24) (actual time=474.916..474.923 rows=20 loops=1)

  • Sort Key: appdate.loanpartentityid
  • Sort Method: quicksort Memory: 10834kB
  • Buffers: shared hit=13920
112. 454.200 454.200 ↓ 270.0 99,343 1

CTE Scan on applicationdate appdate (cost=0..1,656.49 rows=368 width=24) (actual time=188.033..454.2 rows=99,343 loops=1)

  • Filter: (appdate.rn = 1)
  • Buffers: shared hit=13920
113. 18.194 471.406 ↑ 18.4 20 1

Sort (cost=1,672.18..1,673.1 rows=368 width=24) (actual time=471.397..471.406 rows=20 loops=1)

  • Sort Key: propdate.loanpartentityid
  • Sort Method: quicksort Memory: 10299kB
  • Buffers: shared hit=13920
114. 453.212 453.212 ↓ 251.4 92,503 1

CTE Scan on proposaldate propdate (cost=0..1,656.49 rows=368 width=24) (actual time=201.563..453.212 rows=92,503 loops=1)

  • Filter: (propdate.rn = 1)
  • Buffers: shared hit=13920
115. 3.658 205.941 ↑ 368.0 1 1

Sort (cost=1,672.18..1,673.1 rows=368 width=24) (actual time=205.941..205.941 rows=1 loops=1)

  • Sort Key: reassdate.loanpartentityid
  • Sort Method: quicksort Memory: 2318kB
  • Buffers: shared hit=13920
116. 202.283 202.283 ↓ 53.9 19,834 1

CTE Scan on reassessmentdate reassdate (cost=0..1,656.49 rows=368 width=24) (actual time=150.484..202.283 rows=19,834 loops=1)

  • Filter: (reassdate.rn = 1)
  • Buffers: shared hit=13920
117. 22.323 473.977 ↑ 18.4 20 1

Sort (cost=1,672.18..1,673.1 rows=368 width=21) (actual time=473.969..473.977 rows=20 loops=1)

  • Sort Key: isreasssent.loanpartentityid
  • Sort Method: quicksort Memory: 10089kB
  • Buffers: shared hit=13920
118. 451.654 451.654 ↓ 244.0 89,806 1

CTE Scan on isreassessmentsent isreasssent (cost=0..1,656.49 rows=368 width=21) (actual time=183.931..451.654 rows=89,806 loops=1)

  • Filter: (isreasssent.rn = 1)
  • Buffers: shared hit=13920
119. 34.485 561.246 ↑ 4,969.1 20 1

Sort (cost=10,236.69..10,485.15 rows=99,382 width=102) (actual time=561.232..561.246 rows=20 loops=1)

  • Sort Key: lpb.loanpartentityid
  • Sort Method: quicksort Memory: 10834kB
  • Buffers: shared hit=20902
120. 526.761 526.761 ↑ 1.0 99,343 1

CTE Scan on loanpartbalance lpb (cost=0..1,987.64 rows=99,382 width=102) (actual time=182.742..526.761 rows=99,343 loops=1)

  • Buffers: shared hit=20902
121. 17.104 25.351 ↓ 1.0 92,432 1

Hash (cost=2,429.31..2,429.31 rows=92,431 width=94) (actual time=25.351..25.351 rows=92,432 loops=1)

  • Buffers: shared hit=2785
122. 8.247 8.247 ↓ 1.0 92,432 1

Seq Scan on creditdossier cd (cost=0..2,429.31 rows=92,431 width=94) (actual time=0.091..8.247 rows=92,432 loops=1)

  • Buffers: shared hit=2785
123. 16.115 299.364 ↓ 461.9 92,382 1

Hash (cost=4..4 rows=200 width=132) (actual time=299.364..299.364 rows=92,382 loops=1)

124. 283.249 283.249 ↓ 461.9 92,382 1

CTE Scan on dossierbalance db (cost=0..4 rows=200 width=132) (actual time=128.258..283.249 rows=92,382 loops=1)

125. 39.970 68.863 ↓ 142.9 99,343 1

Hash (cost=6,331.46..6,331.46 rows=695 width=788) (actual time=68.863..68.863 rows=99,343 loops=1)

  • Buffers: shared hit=8343, temp written=1368
126. 28.893 28.893 ↓ 142.9 99,343 1

Seq Scan on amortizationversion av (cost=0..6,331.46 rows=695 width=788) (actual time=0.115..28.893 rows=99,343 loops=1)

  • Filter: ((av.isactive)::integer = 1)
  • Buffers: shared hit=8343
127. 0.100 0.100 ↑ 1.0 1 10

Index Scan using pk_par_creditstatuscaption on par_creditstatuscaption pcs (cost=0.14..0.16 rows=1 width=23) (actual time=0.01..0.01 rows=1 loops=10)

  • Index Cond: ((pcs.codeid = c.creditstatuscd) AND (pcs.languageid = 4))
  • Buffers: shared hit=20
128. 0.011 0.020 ↑ 4.0 1 10

Materialize (cost=0..1.22 rows=4 width=17) (actual time=0.002..0.002 rows=1 loops=10)

  • Buffers: shared hit=1
129. 0.009 0.009 ↑ 4.0 1 1

Seq Scan on par_periodicitycaption pp (cost=0..1.2 rows=4 width=17) (actual time=0.009..0.009 rows=1 loops=1)

  • Filter: (pp.languageid = 4)
  • Buffers: shared hit=1
130. 0.007 0.010 ↑ 7.0 1 10

Materialize (cost=0..1.39 rows=7 width=30) (actual time=0.001..0.001 rows=1 loops=10)

  • Buffers: shared hit=1
131. 0.003 0.003 ↑ 7.0 1 1

Seq Scan on par_amortizationshedulecaption pasc (cost=0..1.35 rows=7 width=30) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: (pasc.languageid = 4)
  • Buffers: shared hit=1
132. 0.060 0.060 ↑ 1.0 1 10

Index Scan using pk__productc__5e190d18ff92f2a5 on productcopy pc (cost=0.29..0.44 rows=1 width=352) (actual time=0.006..0.006 rows=1 loops=10)

  • Index Cond: (pc.pkey = c.productcopyfk)
  • Buffers: shared hit=30
133. 22.212 126.826 ↑ 1.0 99,350 1

Hash (cost=7,558.42..7,558.42 rows=99,382 width=40) (actual time=126.826..126.826 rows=99,350 loops=1)

  • Buffers: shared hit=5778
134. 92.225 104.614 ↑ 1.0 99,350 1

Aggregate (cost=4,204.28..6,564.6 rows=99,382 width=40) (actual time=68.808..104.614 rows=99,350 loops=1)

  • Buffers: shared hit=5778
135. 12.389 12.389 ↑ 1.0 99,350 1

Seq Scan on productcopy pc_1 (cost=0..3,955.82 rows=99,382 width=8) (actual time=0.106..12.389 rows=99,350 loops=1)

  • Buffers: shared hit=5778
136. 0.006 0.020 ↑ 2.0 1 10

Materialize (cost=0..1.11 rows=2 width=27) (actual time=0.002..0.002 rows=1 loops=10)

  • Buffers: shared hit=1
137. 0.014 0.014 ↑ 1.0 2 1

Seq Scan on par_productfamilycaption ppf (cost=0..1.1 rows=2 width=27) (actual time=0.013..0.014 rows=2 loops=1)

  • Filter: (ppf.languageid = 4)
  • Buffers: shared hit=1
138. 0.060 0.060 ↑ 1.0 1 10

Index Scan using pk_par_productnamecaption on par_productnamecaption ppnc (cost=0.14..0.16 rows=1 width=30) (actual time=0.006..0.006 rows=1 loops=10)

  • Index Cond: ((ppnc.codeid = pc.productnamecd) AND (ppnc.languageid = 4))
  • Buffers: shared hit=20
139. 0.050 0.050 ↑ 1.0 1 10

Index Scan using pk__creditpr__5e190d1836620d44 on creditprovider credprov (cost=0.27..0.29 rows=1 width=332) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (credprov.pkey = pc.economicalownerfk)
  • Buffers: shared hit=30
140. 0.060 0.060 ↑ 1.0 1 10

Index Scan using pk_par_creditprovidernamecaption on par_creditprovidernamecaption pcpn (cost=0.28..0.47 rows=1 width=19) (actual time=0.006..0.006 rows=1 loops=10)

  • Index Cond: ((pcpn.codeid = credprov.namecd) AND (pcpn.languageid = 4))
  • Buffers: shared hit=30
141. 275.457 7,490.240 ↓ 20,786.5 83,146 10

Materialize (cost=30,366.45..30,368.12 rows=4 width=1,408) (actual time=536.304..749.024 rows=83,146 loops=10)

  • Buffers: shared hit=2375412, temp read=40582 written=22592
142. 7,030.017 7,214.783 ↓ 23,095.8 92,383 1

CTE Scan on grouped grouped (cost=30,366.45..30,368.06 rows=4 width=1,408) (actual time=5,362.971..7,214.783 rows=92,383 loops=1)

  • Buffers: shared hit=2375412, temp read=14349 written=19314
143.          

CTE contractors

144. 303.310 3,272.761 ↓ 199.9 156,937 1

WindowAgg (cost=22,651.58..22,781.1 rows=785 width=738) (actual time=2,619.046..3,272.761 rows=156,937 loops=1)

  • Buffers: shared hit=2368205, temp read=7160 written=7159
145. 282.027 2,655.577 ↓ 199.9 156,937 1

Sort (cost=22,651.58..22,653.54 rows=785 width=248) (actual time=2,619.018..2,655.577 rows=156,937 loops=1)

  • Sort Key: cd_1.pkey, r.roletypecd, r.pkey
  • Sort Method: external merge Disk: 28256kB
  • Buffers: shared hit=2368205, temp read=7160 written=7159
146. 107.656 2,373.550 ↓ 199.9 156,937 1

Nested Loop (cost=9,676.21..22,613.83 rows=785 width=248) (actual time=560.556..2,373.55 rows=156,937 loops=1)

  • Buffers: shared hit=2368205, temp read=3628 written=3626
147. 123.844 1,952.020 ↓ 199.9 156,937 1

Nested Loop (cost=9,675.92..22,313.47 rows=785 width=232) (actual time=560.544..1,952.02 rows=156,937 loops=1)

  • Buffers: shared hit=1896972, temp read=3628 written=3626
148. 54.375 1,357.365 ↓ 199.9 156,937 1

Hash Join (cost=9,675.5..17,040 rows=785 width=212) (actual time=560.53..1,357.365 rows=156,937 loops=1)

  • Buffers: shared hit=1269071, temp read=3628 written=3626
149. 58.745 1,302.983 ↓ 199.9 156,937 1

Hash Join (cost=9,674.38..17,033.07 rows=785 width=202) (actual time=560.507..1,302.983 rows=156,937 loops=1)

  • Buffers: shared hit=1269070, temp read=3628 written=3626
150. 70.326 1,244.229 ↓ 199.9 156,937 1

Nested Loop (cost=9,673.19..17,026.68 rows=785 width=198) (actual time=560.475..1,244.229 rows=156,937 loops=1)

  • Buffers: shared hit=1269069, temp read=3628 written=3626
151. 281.335 860.029 ↓ 199.9 156,937 1

Hash Join (cost=9,672.77..16,626.92 rows=785 width=198) (actual time=560.46..860.029 rows=156,937 loops=1)

  • Buffers: shared hit=640879, temp read=3628 written=3626
152. 19.874 19.874 ↑ 1.0 170,427 1

Seq Scan on partydetail pd_1 (cost=0..6,305.58 rows=170,858 width=91) (actual time=0.102..19.874 rows=170,427 loops=1)

  • Buffers: shared hit=8949
153. 92.684 558.820 ↓ 199.9 156,937 1

Hash (cost=9,662.96..9,662.96 rows=785 width=181) (actual time=558.82..558.82 rows=156,937 loops=1)

  • Buffers: shared hit=631930, temp written=1449
154. 110.249 466.136 ↓ 199.9 156,937 1

Nested Loop (cost=0.42..9,662.96 rows=785 width=181) (actual time=0.132..466.136 rows=156,937 loops=1)

  • Buffers: shared hit=631930
155. 42.013 42.013 ↓ 199.9 156,937 1

Seq Scan on role r (cost=0..4,711.52 rows=785 width=32) (actual time=0.117..42.013 rows=156,937 loops=1)

  • Filter: ((r.roletypecd = ANY ('{1,2}'::integer[])) AND ((r.activerole)::integer = 1))
  • Buffers: shared hit=3756
156. 313.874 313.874 ↑ 1.0 1 156,937

Index Scan using pk__party__5e190d180bba75a2 on party p_1 (cost=0.42..6.31 rows=1 width=157) (actual time=0.002..0.002 rows=1 loops=156,937)

  • Index Cond: (p_1.pkey = r.partyfk)
  • Buffers: shared hit=628174
157. 313.874 313.874 ↑ 1.0 1 156,937

Index Scan using pk_partydetailregion on partydetailregion pdr (cost=0.42..0.51 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=156,937)

  • Index Cond: (pd_1.partydetailregionfk = pdr.pkey)
  • Buffers: shared hit=628190
158. 0.004 0.009 ↑ 1.0 3 1

Hash (cost=1.15..1.15 rows=3 width=12) (actual time=0.009..0.009 rows=3 loops=1)

  • Buffers: shared hit=1
159. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on par_gendercaption par_gendercaption (cost=0..1.15 rows=3 width=12) (actual time=0.004..0.005 rows=3 loops=1)

  • Filter: (par_gendercaption.languageid = 4)
  • Buffers: shared hit=1
160. 0.003 0.007 ↑ 1.0 2 1

Hash (cost=1.1..1.1 rows=2 width=14) (actual time=0.006..0.007 rows=2 loops=1)

  • Buffers: shared hit=1
161. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on par_partytypecaption ppt (cost=0..1.1 rows=2 width=14) (actual time=0.004..0.004 rows=2 loops=1)

  • Filter: (ppt.languageid = 4)
  • Buffers: shared hit=1
162. 470.811 470.811 ↑ 1.0 1 156,937

Index Scan using pk__credit__5e190d187b016d94 on credit c_3 (cost=0.42..6.72 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=156,937)

  • Index Cond: (c_3.pkey = r.creditfk)
  • Buffers: shared hit=627901
163. 313.874 313.874 ↑ 1.0 1 156,937

Index Scan using pk_creditdossier on creditdossier cd_1 (cost=0.29..0.38 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=156,937)

  • Index Cond: (cd_1.pkey = c_3.creditdossierfk)
  • Buffers: shared hit=471233
164.          

SubPlan (forWindowAgg)

165. 156.937 313.874 ↑ 1.0 1 156,937

Aggregate (cost=0.12..0.13 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=156,937)

166. 156.937 156.937 ↑ 1.0 8 156,937

Values Scan (cost=0..0.1 rows=8 width=8) (actual time=0..0.001 rows=8 loops=156,937)

167.          

CTE grouped

168. 606.651 6,014.942 ↓ 23,095.8 92,383 1

Aggregate (cost=7,584.36..7,585.35 rows=4 width=1,140) (actual time=5,362.927..6,014.942 rows=92,383 loops=1)

  • Buffers: shared hit=2375412, temp read=14349 written=16960
169. 238.523 5,408.291 ↓ 37,204.2 148,817 1

Sort (cost=7,584.36..7,584.37 rows=4 width=4,040) (actual time=5,362.897..5,408.291 rows=148,817 loops=1)

  • Sort Key: con.dossierentityid
  • Sort Method: external merge Disk: 24848kB
  • Buffers: shared hit=2375412, temp read=14349 written=16960
170. 173.309 5,169.768 ↓ 37,204.2 148,817 1

Hash Join (cost=7,254.42..7,584.32 rows=4 width=4,040) (actual time=3,799.476..5,169.768 rows=148,817 loops=1)

  • Buffers: shared hit=2375412, temp read=11243 written=13853
171. 34.429 1,451.160 ↓ 31,958.2 159,791 1

Subquery Scan on conadd (cost=7,236.7..7,566.58 rows=5 width=84) (actual time=248.388..1,451.16 rows=159,791 loops=1)

  • Filter: (conadd.rn = 1)
  • Buffers: shared hit=7207, temp read=1918 written=1919
172. 1,129.501 1,416.731 ↓ 185.9 188,728 1

WindowAgg (cost=7,236.7..7,553.89 rows=1,015 width=96) (actual time=248.387..1,416.731 rows=188,728 loops=1)

  • Buffers: shared hit=7207, temp read=1918 written=1919
173. 223.419 287.230 ↓ 185.9 188,728 1

Sort (cost=7,236.7..7,239.24 rows=1,015 width=62) (actual time=248.324..287.23 rows=188,728 loops=1)

  • Sort Key: address.partydetailfk, address.addresstypecd, address.pkey
  • Sort Method: external merge Disk: 15344kB
  • Buffers: shared hit=7207, temp read=1918 written=1919
174. 63.811 63.811 ↓ 185.9 188,728 1

Seq Scan on address address (cost=0..7,186.02 rows=1,015 width=62) (actual time=0.12..63.811 rows=188,728 loops=1)

  • Filter: ((address.addresstypecd = ANY ('{1,11}'::integer[])) AND ((address.isactive)::integer = 1))
  • Buffers: shared hit=7207
175. 85.962 3,545.299 ↓ 37,082.0 148,328 1

Hash (cost=17.66..17.66 rows=4 width=3,964) (actual time=3,545.299..3,545.299 rows=148,328 loops=1)

  • Buffers: shared hit=2368205, temp read=7160 written=10974
176. 3,459.337 3,459.337 ↓ 37,082.0 148,328 1

CTE Scan on contractors con (cost=0..17.66 rows=4 width=3,964) (actual time=2,619.051..3,459.337 rows=148,328 loops=1)

  • Filter: (con.rn = 1)
  • Buffers: shared hit=2368205, temp read=7160 written=9771
177.          

SubPlan (forCTE Scan)

178. 92.383 184.766 ↑ 1.0 1 92,383

Aggregate (cost=0.05..0.06 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=92,383)

179. 92.383 92.383 ↑ 1.0 3 92,383

Values Scan (cost=0..0.04 rows=3 width=8) (actual time=0..0.001 rows=3 loops=92,383)

180. 33.670 375.490 ↓ 180.7 29,997 10

Materialize (cost=20,797.22..21,576.05 rows=166 width=1,296) (actual time=26.222..37.549 rows=29,997 loops=10)

  • Buffers: shared hit=14233
181. 27.339 341.820 ↓ 180.7 29,997 1

Hash Join (cost=20,797.22..21,573.56 rows=166 width=1,296) (actual time=262.21..341.82 rows=29,997 loops=1)

  • Buffers: shared hit=14233
182.          

CTE guaranteesprep

183. 38.670 232.895 ↑ 1.1 30,000 1

WindowAgg (cost=14,218.59..18,544.73 rows=33,278 width=123) (actual time=130.34..232.895 rows=30,000 loops=1)

  • Buffers: shared hit=14233
184. 22.156 134.225 ↑ 1.1 30,000 1

Sort (cost=14,218.59..14,301.78 rows=33,278 width=143) (actual time=130.3..134.225 rows=30,000 loops=1)

  • Sort Key: c_4.pkey, (CASE WHEN (gt.codeid = 3) THEN 0 ELSE gt.codeid END), coll.pkey
  • Sort Method: quicksort Memory: 8619kB
  • Buffers: shared hit=14233
185. 7.367 112.069 ↑ 1.1 30,000 1

Hash Join (cost=4,145.52..11,719.03 rows=33,278 width=143) (actual time=54.104..112.069 rows=30,000 loops=1)

  • Buffers: shared hit=14233
186. 38.860 104.691 ↑ 1.1 30,000 1

Hash Join (cost=4,144.15..11,517 rows=33,278 width=122) (actual time=54.078..104.691 rows=30,000 loops=1)

  • Buffers: shared hit=14232
187. 11.942 11.942 ↓ 1.0 99,343 1

Seq Scan on credit c_4 (cost=0..6,555.38 rows=96,938 width=24) (actual time=0.117..11.942 rows=99,343 loops=1)

  • Buffers: shared hit=10962
188. 8.897 53.889 ↑ 1.1 30,000 1

Hash (cost=3,728.17..3,728.17 rows=33,278 width=102) (actual time=53.889..53.889 rows=30,000 loops=1)

  • Buffers: shared hit=3270
189. 19.316 44.992 ↑ 1.1 30,000 1

Hash Join (cost=2,294.11..3,728.17 rows=33,278 width=102) (actual time=20.929..44.992 rows=30,000 loops=1)

  • Buffers: shared hit=3270
190. 4.897 4.897 ↓ 1.0 68,205 1

Seq Scan on collateral2credit c2c (cost=0..1,255.02 rows=68,202 width=24) (actual time=0.108..4.897 rows=68,205 loops=1)

  • Buffers: shared hit=1085
191. 7.379 20.779 ↑ 1.0 29,601 1

Hash (cost=1,922.54..1,922.54 rows=29,726 width=82) (actual time=20.779..20.779 rows=29,601 loops=1)

  • Buffers: shared hit=2185
192. 13.400 13.400 ↑ 1.0 29,601 1

Seq Scan on collateral coll (cost=0..1,922.54 rows=29,726 width=82) (actual time=0.11..13.4 rows=29,601 loops=1)

  • Filter: ((coll.classname)::text = 'Guarantee'::text)
  • Buffers: shared hit=2185
193. 0.003 0.011 ↑ 1.0 6 1

Hash (cost=1.3..1.3 rows=6 width=21) (actual time=0.011..0.011 rows=6 loops=1)

  • Buffers: shared hit=1
194. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on par_guaranteetypecaption gt (cost=0..1.3 rows=6 width=21) (actual time=0.005..0.008 rows=6 loops=1)

  • Filter: (gt.languageid = 4)
  • Buffers: shared hit=1
195.          

SubPlan (forWindowAgg)

196. 30.000 60.000 ↑ 1.0 1 30,000

Aggregate (cost=0.09..0.1 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=30,000)

197. 30.000 30.000 ↑ 1.0 6 30,000

Values Scan (cost=0..0.08 rows=6 width=8) (actual time=0..0.001 rows=6 loops=30,000)

198. 6.612 280.196 ↓ 180.7 29,997 1

Hash Join (cost=1,501.66..2,261.06 rows=166 width=1,554) (actual time=257.896..280.196 rows=29,997 loops=1)

  • Buffers: shared hit=14233
199. 6.086 268.130 ↓ 180.7 29,997 1

Hash Join (cost=750.83..1,504.91 rows=166 width=1,040) (actual time=252.423..268.13 rows=29,997 loops=1)

  • Buffers: shared hit=14233
200. 139.980 139.980 ↓ 180.7 29,997 1

CTE Scan on guaranteesprep rn1 (cost=0..748.75 rows=166 width=526) (actual time=130.344..139.98 rows=29,997 loops=1)

  • Filter: (rn1.rn = 1)
  • Buffers: shared hit=14233
201. 0.011 122.064 ↑ 55.3 3 1

Hash (cost=748.75..748.75 rows=166 width=518) (actual time=122.064..122.064 rows=3 loops=1)

202. 122.053 122.053 ↑ 55.3 3 1

CTE Scan on guaranteesprep rn2 (cost=0..748.75 rows=166 width=518) (actual time=57.996..122.053 rows=3 loops=1)

  • Filter: (rn2.rn = 2)
203. 0.000 5.454 ↓ 0.0 0 1

Hash (cost=748.75..748.75 rows=166 width=518) (actual time=5.454..5.454 rows=0 loops=1)

204. 5.454 5.454 ↓ 0.0 0 1

CTE Scan on guaranteesprep rn3 (cost=0..748.75 rows=166 width=518) (actual time=5.454..5.454 rows=0 loops=1)

  • Filter: (rn3.rn = 3)
205. 0.001 4.288 ↓ 0.0 0 1

Hash (cost=748.75..748.75 rows=166 width=518) (actual time=4.288..4.288 rows=0 loops=1)

206. 4.287 4.287 ↓ 0.0 0 1

CTE Scan on guaranteesprep rn4 (cost=0..748.75 rows=166 width=518) (actual time=4.287..4.287 rows=0 loops=1)

  • Filter: (rn4.rn = 4)
207.          

SubPlan (forHash Join)

208. 0.000 29.997 ↑ 1.0 1 29,997

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

209. 29.997 29.997 ↑ 1.0 4 29,997

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

210. 35.813 357.660 ↓ 179.0 31,324 10

Materialize (cost=18,773.55..19,561.97 rows=175 width=1,138) (actual time=17.022..35.766 rows=31,324 loops=10)

  • Buffers: shared hit=14235
211. 321.847 321.847 ↓ 179.0 31,324 1

CTE Scan on firstwarrantyprep firstwarrantyprep (cost=18,773.55..19,559.34 rows=175 width=1,138) (actual time=170.213..321.847 rows=31,324 loops=1)

  • Filter: (firstwarrantyprep."RN" = 1)
  • Buffers: shared hit=14235
212.          

CTE firstwarrantyprep

213. 37.284 289.057 ↓ 1.1 38,205 1

WindowAgg (cost=14,582.67..18,773.55 rows=34,924 width=226) (actual time=170.209..289.057 rows=38,205 loops=1)

  • Buffers: shared hit=14235
214. 29.416 175.363 ↓ 1.1 38,205 1

Sort (cost=14,582.67..14,669.98 rows=34,924 width=219) (actual time=170.18..175.363 rows=38,205 loops=1)

  • Sort Key: c_5.creditdossierfk, coll_1.pkey
  • Sort Method: quicksort Memory: 11685kB
  • Buffers: shared hit=14235
215. 7.806 145.947 ↓ 1.1 38,205 1

Hash Join (cost=4,187.11..11,947.32 rows=34,924 width=219) (actual time=59.558..145.947 rows=38,205 loops=1)

  • Buffers: shared hit=14235
216. 9.925 138.133 ↓ 1.1 38,205 1

Hash Join (cost=4,185.86..11,854.4 rows=34,924 width=202) (actual time=59.541..138.133 rows=38,205 loops=1)

  • Buffers: shared hit=14234
217. 9.860 128.200 ↓ 1.1 38,205 1

Hash Join (cost=4,184.67..11,687.76 rows=34,924 width=177) (actual time=59.525..128.2 rows=38,205 loops=1)

  • Buffers: shared hit=14233
218. 45.981 118.326 ↓ 1.1 38,205 1

Hash Join (cost=4,183.11..11,572.42 rows=34,924 width=159) (actual time=59.489..118.326 rows=38,205 loops=1)

  • Buffers: shared hit=14232
219. 13.247 13.247 ↓ 1.0 99,343 1

Seq Scan on credit c_5 (cost=0..6,555.38 rows=96,938 width=24) (actual time=0.12..13.247 rows=99,343 loops=1)

  • Buffers: shared hit=10962
220. 12.098 59.098 ↓ 1.1 38,205 1

Hash (cost=3,746.56..3,746.56 rows=34,924 width=139) (actual time=59.098..59.098 rows=38,205 loops=1)

  • Buffers: shared hit=3270
221. 20.412 47.000 ↓ 1.1 38,205 1

Hash Join (cost=2,312.5..3,746.56 rows=34,924 width=139) (actual time=21.749..47 rows=38,205 loops=1)

  • Buffers: shared hit=3270
222. 5.088 5.088 ↓ 1.0 68,205 1

Seq Scan on collateral2credit c2c_1 (cost=0..1,255.02 rows=68,202 width=24) (actual time=0.109..5.088 rows=68,205 loops=1)

  • Buffers: shared hit=1085
223. 8.079 21.500 ↓ 1.0 31,324 1

Hash (cost=1,922.54..1,922.54 rows=31,197 width=119) (actual time=21.5..21.5 rows=31,324 loops=1)

  • Buffers: shared hit=2185
224. 13.421 13.421 ↓ 1.0 31,324 1

Seq Scan on collateral coll_1 (cost=0..1,922.54 rows=31,197 width=119) (actual time=0.11..13.421 rows=31,324 loops=1)

  • Filter: ((coll_1.classname)::text = 'Warranty'::text)
  • Buffers: shared hit=2185
225. 0.005 0.014 ↑ 1.0 9 1

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

  • Buffers: shared hit=1
226. 0.009 0.009 ↑ 1.0 9 1

Seq Scan on par_warrantytypecaption wt (cost=0..1.45 rows=9 width=22) (actual time=0.005..0.009 rows=9 loops=1)

  • Filter: (wt.languageid = 4)
  • Buffers: shared hit=1
227. 0.004 0.008 ↑ 1.0 3 1

Hash (cost=1.15..1.15 rows=3 width=29) (actual time=0.008..0.008 rows=3 loops=1)

  • Buffers: shared hit=1
228. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on par_warrantyinscriptiontypecaption wit (cost=0..1.15 rows=3 width=29) (actual time=0.003..0.004 rows=3 loops=1)

  • Filter: (wit.languageid = 4)
  • Buffers: shared hit=1
229. 0.004 0.008 ↑ 1.0 4 1

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

  • Buffers: shared hit=1
230. 0.004 0.004 ↑ 1.0 4 1

Seq Scan on par_warrantysubtypecaption wst (cost=0..1.2 rows=4 width=21) (actual time=0.003..0.004 rows=4 loops=1)

  • Filter: (wst.languageid = 4)
  • Buffers: shared hit=1
231.          

SubPlan (forWindowAgg)

232. 38.205 76.410 ↑ 1.0 1 38,205

Aggregate (cost=0.09..0.1 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=38,205)

233. 38.205 38.205 ↑ 1.0 6 38,205

Values Scan (cost=0..0.08 rows=6 width=8) (actual time=0..0.001 rows=6 loops=38,205)

234. 48.987 1,927.270 ↓ 424.5 38,205 10

Materialize (cost=55,196.32..55,997.36 rows=90 width=737) (actual time=99.007..192.727 rows=38,205 loops=10)

  • Buffers: shared hit=145414, temp read=1203 written=1201
235. 85.125 1,878.283 ↓ 424.5 38,205 1

Nested Loop (cost=55,196.32..55,996.01 rows=90 width=737) (actual time=990.063..1,878.283 rows=38,205 loops=1)

  • Buffers: shared hit=145414, temp read=1203 written=1201
236.          

CTE distinctrealestates

237. 313.966 878.417 ↓ 2.1 38,392 1

Hash Join (cost=14,418.36..31,076.7 rows=18,036 width=409) (actual time=394.645..878.417 rows=38,392 loops=1)

  • Buffers: shared hit=23363, temp read=1203 written=1201
238. 16.561 16.561 ↓ 1.0 99,343 1

Seq Scan on credit c_6 (cost=0..6,555.38 rows=96,938 width=20) (actual time=0.097..16.561 rows=99,343 loops=1)

  • Buffers: shared hit=10962
239. 15.155 394.322 ↓ 2.1 38,392 1

Hash (cost=14,192.91..14,192.91 rows=18,036 width=462) (actual time=394.322..394.322 rows=38,392 loops=1)

  • Buffers: shared hit=12401, temp read=1203 written=1201
240. 27.147 379.167 ↓ 2.1 38,392 1

Hash Join (cost=12,501.77..14,192.91 rows=18,036 width=462) (actual time=347.221..379.167 rows=38,392 loops=1)

  • Buffers: shared hit=12401, temp read=1203 written=1201
241. 4.936 4.936 ↓ 1.0 68,205 1

Seq Scan on collateral2credit c2c_2 (cost=0..1,255.02 rows=68,202 width=24) (actual time=0.097..4.936 rows=68,205 loops=1)

  • Buffers: shared hit=1085
242. 21.072 347.084 ↓ 2.0 31,463 1

Hash (cost=12,300.38..12,300.38 rows=16,111 width=450) (actual time=347.084..347.084 rows=31,463 loops=1)

  • Buffers: shared hit=11316, temp read=1203 written=1201
243. 49.895 326.012 ↓ 2.0 31,463 1

Hash Join (cost=11,183.42..12,300.38 rows=16,111 width=450) (actual time=215.832..326.012 rows=31,463 loops=1)

  • Buffers: shared hit=11316, temp read=1203 written=1201
244. 23.544 111.905 ↓ 2.0 31,463 1

Hash Join (cost=4,493.68..5,568.35 rows=16,111 width=125) (actual time=51.603..111.905 rows=31,463 loops=1)

  • Buffers: shared hit=4109
245. 23.673 73.699 ↓ 2.0 31,463 1

Hash Join (cost=3,237.11..4,269.47 rows=16,111 width=64) (actual time=36.8..73.699 rows=31,463 loops=1)

  • Buffers: shared hit=3383
246. 13.401 13.401 ↓ 1.0 31,463 1

Seq Scan on warranty2assetstatushistory w2ash (cost=0..753.28 rows=31,462 width=20) (actual time=0.099..13.401 rows=31,463 loops=1)

  • Filter: (w2ash.warranty2assetstatuscd = 1)
  • Buffers: shared hit=616
247. 7.667 36.625 ↓ 2.0 31,463 1

Hash (cost=3,035.72..3,035.72 rows=16,111 width=52) (actual time=36.625..36.625 rows=31,463 loops=1)

  • Buffers: shared hit=2767
248. 10.521 28.958 ↓ 2.0 31,463 1

Hash Join (cost=2,312.5..3,035.72 rows=16,111 width=52) (actual time=16.473..28.958 rows=31,463 loops=1)

  • Buffers: shared hit=2767
249. 2.199 2.199 ↓ 1.0 31,463 1

Seq Scan on warranty2asset w2a (cost=0..640.62 rows=31,462 width=32) (actual time=0.098..2.199 rows=31,463 loops=1)

  • Buffers: shared hit=582
250. 5.497 16.238 ↓ 1.0 31,324 1

Hash (cost=1,922.54..1,922.54 rows=31,197 width=20) (actual time=16.238..16.238 rows=31,324 loops=1)

  • Buffers: shared hit=2185
251. 10.741 10.741 ↓ 1.0 31,324 1

Seq Scan on collateral col (cost=0..1,922.54 rows=31,197 width=20) (actual time=0.103..10.741 rows=31,324 loops=1)

  • Filter: ((col.classname)::text = 'Warranty'::text)
  • Buffers: shared hit=2185
252. 6.655 14.662 ↓ 1.0 31,464 1

Hash (cost=863.29..863.29 rows=31,463 width=65) (actual time=14.662..14.662 rows=31,464 loops=1)

  • Buffers: shared hit=726
253. 8.007 8.007 ↓ 1.0 31,464 1

Seq Scan on asset a (cost=0..863.29 rows=31,463 width=65) (actual time=0.098..8.007 rows=31,464 loops=1)

  • Filter: ((a.classname)::text = 'RealEstate'::text)
  • Buffers: shared hit=726
254. 90.326 164.212 ↓ 186.0 189,378 1

Hash (cost=6,677.01..6,677.01 rows=1,018 width=333) (actual time=164.212..164.212 rows=189,378 loops=1)

  • Buffers: shared hit=7207, temp written=1034
255. 73.886 73.886 ↓ 186.0 189,378 1

Seq Scan on address ad (cost=0..6,677.01 rows=1,018 width=333) (actual time=0.093..73.886 rows=189,378 loops=1)

  • Filter: ((ad.isactive)::integer = 1)
  • Buffers: shared hit=7207
256.          

SubPlan (forHash Join)

257. 38.392 153.568 ↑ 1.0 1 38,392

Aggregate (cost=0.21..0.22 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=38,392)

258. 115.176 115.176 ↑ 1.0 14 38,392

Values Scan (cost=0..0.18 rows=14 width=8) (actual time=0..0.003 rows=14 loops=38,392)

259.          

CTE realestateaddressesfields

260. 590.600 1,626.918 ↓ 2.1 38,392 1

WindowAgg (cost=15,281.56..24,119.2 rows=18,036 width=542) (actual time=990.033..1,626.918 rows=38,392 loops=1)

  • Buffers: shared hit=24096, temp read=1203 written=1201
261. 35.482 997.926 ↓ 2.1 38,392 1

Sort (cost=15,281.56..15,326.65 rows=18,036 width=1,566) (actual time=989.972..997.926 rows=38,392 loops=1)

  • Sort Key: dre.loanpartentityid, dre.isactive, dre."Rank", a_1.pkey
  • Sort Method: quicksort Memory: 11070kB
  • Buffers: shared hit=24096, temp read=1203 written=1201
262. 13.749 962.444 ↓ 2.1 38,392 1

Hash Join (cost=1,279.33..1,735.55 rows=18,036 width=1,566) (actual time=407.637..962.444 rows=38,392 loops=1)

  • Buffers: shared hit=24096, temp read=1203 written=1201
263. 27.133 948.553 ↓ 2.1 38,392 1

Hash Join (cost=1,256.58..1,664.65 rows=18,036 width=1,559) (actual time=407.487..948.553 rows=38,392 loops=1)

  • Buffers: shared hit=24089, temp read=1203 written=1201
264. 908.603 908.603 ↓ 2.1 38,392 1

CTE Scan on distinctrealestates dre (cost=0..360.72 rows=18,036 width=1,543) (actual time=394.648..908.603 rows=38,392 loops=1)

  • Buffers: shared hit=23363, temp read=1203 written=1201
265. 5.623 12.817 ↓ 1.0 31,464 1

Hash (cost=863.29..863.29 rows=31,463 width=20) (actual time=12.817..12.817 rows=31,464 loops=1)

  • Buffers: shared hit=726
266. 7.194 7.194 ↓ 1.0 31,464 1

Seq Scan on asset a_1 (cost=0..863.29 rows=31,463 width=20) (actual time=0.109..7.194 rows=31,464 loops=1)

  • Filter: ((a_1.classname)::text = 'RealEstate'::text)
  • Buffers: shared hit=726
267. 0.046 0.142 ↑ 1.0 252 1

Hash (cost=19.6..19.6 rows=252 width=15) (actual time=0.142..0.142 rows=252 loops=1)

  • Buffers: shared hit=7
268. 0.096 0.096 ↑ 1.0 252 1

Seq Scan on par_countrycaption country (cost=0..19.6 rows=252 width=15) (actual time=0.004..0.096 rows=252 loops=1)

  • Filter: (country.languageid = 4)
  • Buffers: shared hit=7
269.          

SubPlan (forWindowAgg)

270. 0.000 38.392 ↑ 1.0 1 38,392

Aggregate (cost=0.05..0.06 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=38,392)

271. 38.392 38.392 ↑ 1.0 3 38,392

Values Scan (cost=0..0.04 rows=3 width=8) (actual time=0..0.001 rows=3 loops=38,392)

272. 1,678.543 1,678.543 ↓ 424.5 38,205 1

CTE Scan on realestateaddressesfields reaf1 (cost=0..405.81 rows=90 width=737) (actual time=990.037..1,678.543 rows=38,205 loops=1)

  • Filter: (reaf1.rn = 1)
  • Buffers: shared hit=24096, temp read=1203 written=1201
273. 76.410 76.410 ↑ 1.0 1 38,205

Index Only Scan using pk__credit__5e190d187b016d94 on credit c_1 (cost=0.42..4.35 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=38,205)

  • Index Cond: (c_1.pkey = reaf1.loanpartentityid)
  • Buffers: shared hit=121318
274.          

SubPlan (forNested Loop)

275. 38.205 38.205 ↑ 1.0 1 38,205

Aggregate (cost=0.01..0.02 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=38,205)

276. 0.000 0.000 ↑ 1.0 1 38,205

Result (cost=0..0.01 rows=1 width=0) (actual time=0..0 rows=1 loops=38,205)

277. 120.050 120.050 ↓ 198.6 31,183 10

CTE Scan on thirdpartywarrantycustom thirdpartywarr (cost=0..707.51 rows=157 width=542) (actual time=2.465..12.005 rows=31,183 loops=10)

  • Filter: (thirdpartywarr.rn = 1)
  • Buffers: shared hit=719
278. 2.310 2.310 ↓ 213.3 640 10

CTE Scan on lastactualmarketvalue actualmarketvalue (cost=0..0.06 rows=3 width=38) (actual time=0.038..0.231 rows=640 loops=10)

  • Buffers: shared hit=19
279. 0.410 0.410 ↓ 85.0 85 10

CTE Scan on lastaftertransformationmarketvalue aftertransformmarketvalue (cost=0..0.02 rows=1 width=38) (actual time=0.016..0.041 rows=85 loops=10)

  • Buffers: shared hit=19
280. 0.184 2,682.830 ↑ 1.0 100 10

Materialize (cost=1,534.89..1,545.18 rows=100 width=4) (actual time=10.773..268.283 rows=100 loops=10)

  • Buffers: shared hit=8149
281. 0.064 2,682.646 ↑ 1.0 100 1

Limit (cost=1,534.89..1,543.68 rows=100 width=4) (actual time=107.72..2,682.646 rows=100 loops=1)

  • Buffers: shared hit=8149
282. 0.061 2,682.582 ↑ 79,218,046,970,726.9 100 1

Subquery Scan on RunningAccountAndLoansBaseView (cost=1,534.89..696,335,408,670,880 rows=7,921,804,697,072,691 width=4) (actual time=107.719..2,682.582 rows=100 loops=1)

  • Buffers: shared hit=8149
283. 0.257 2,682.521 ↑ 79,218,046,970,726.9 100 1

Hash Join (cost=1,534.89..617,117,361,700,154 rows=7,921,804,697,072,691 width=1,060) (actual time=107.718..2,682.521 rows=100 loops=1)

  • Buffers: shared hit=8149
284. 7.771 2,680.766 ↑ 5,416,618,596,289.0 100 1

Nested Loop (cost=1,300.58..338,838,581,315,571 rows=541,661,859,628,902 width=12) (actual time=106.18..2,680.766 rows=100 loops=1)

  • Buffers: shared hit=8149
285. 3.537 2,652.495 ↑ 423,173,327,835.1 100 1

Nested Loop (cost=1,200.58..233,468,422,684,371 rows=42,317,332,783,508 width=12) (actual time=90.036..2,652.495 rows=100 loops=1)

  • Buffers: shared hit=8149
286. 18.363 2,645.358 ↑ 28,934,928,399.0 100 1

Nested Loop (cost=1,100.58..106,516,424,333,641 rows=2,893,492,839,898 width=16) (actual time=89.02..2,645.358 rows=100 loops=1)

  • Buffers: shared hit=8149
287. 61.050 2,616.395 ↑ 28,934,928,399.0 100 1

Nested Loop (cost=1,100.58..19,841,846,314,409.6 rows=2,893,492,839,898 width=48) (actual time=88.362..2,616.395 rows=100 loops=1)

  • Buffers: shared hit=8087
288. 0.486 2,466.645 ↑ 4,521,082,562.3 100 1

Nested Loop (cost=1,000.58..19,367,132,645,111.8 rows=452,108,256,234 width=12) (actual time=57.627..2,466.645 rows=100 loops=1)

  • Buffers: shared hit=8087
289. 61.479 2,466.059 ↑ 4,068,974,306.1 100 1

Nested Loop (cost=1,000.58..19,255,235,851,692.6 rows=406,897,430,611 width=44) (actual time=57.614..2,466.059 rows=100 loops=1)

  • Buffers: shared hit=8086
290. 0.161 2,352.180 ↑ 4,068,974,306.1 100 1

Nested Loop (cost=900.58..1,402,611,083,429.91 rows=406,897,430,611 width=44) (actual time=52.799..2,352.18 rows=100 loops=1)

  • Buffers: shared hit=8086
291. 25.237 2,351.719 ↑ 4,068,974,306.1 100 1

Nested Loop (cost=800.58..1,311,059,161,395.54 rows=406,897,430,611 width=48) (actual time=52.531..2,351.719 rows=100 loops=1)

  • Buffers: shared hit=8086
292. 0.334 2,302.282 ↑ 278,220,463.3 100 1

Nested Loop (cost=700.58..90,366,878,461.72 rows=27,822,046,330 width=52) (actual time=45.971..2,302.282 rows=100 loops=1)

  • Buffers: shared hit=8086
293. 0.245 2,301.448 ↑ 19,023,622.1 100 1

Nested Loop (cost=600.58..6,900,736,117.41 rows=1,902,362,214 width=56) (actual time=45.715..2,301.448 rows=100 loops=1)

  • Buffers: shared hit=8086
294. 48.724 2,300.803 ↑ 19,023,622.1 100 1

Nested Loop (cost=500.57..6,472,704,472.36 rows=1,902,362,214 width=60) (actual time=45.43..2,300.803 rows=100 loops=1)

  • Buffers: shared hit=8086
295. 3.482 2,211.679 ↑ 1,486,220.5 100 1

Nested Loop (cost=400.57..765,617,635.96 rows=148,622,048 width=60) (actual time=42.932..2,211.679 rows=100 loops=1)

  • Buffers: shared hit=8086
296. 9.546 2,204.997 ↑ 232,222.0 100 1

Nested Loop (cost=300.57..319,751,340.36 rows=23,222,195 width=28) (actual time=42.118..2,204.997 rows=100 loops=1)

  • Buffers: shared hit=8086
297. 48.465 2,185.451 ↑ 18,142.3 100 1

Nested Loop (cost=200.57..250,084,561.56 rows=1,814,234 width=28) (actual time=39.616..2,185.451 rows=100 loops=1)

  • Buffers: shared hit=8086
298. 50.214 2,082.286 ↑ 1,417.4 100 1

Nested Loop (cost=100.58..244,641,667.56 rows=141,737 width=24) (actual time=29.15..2,082.286 rows=100 loops=1)

  • Buffers: shared hit=8086
299. 0.302 1,986.672 ↑ 1,417.4 100 1

Nested Loop (cost=0.57..239,804,708.5 rows=141,737 width=16) (actual time=16.174..1,986.672 rows=100 loops=1)

  • Buffers: shared hit=8086
300. 1,268.180 1,985.570 ↑ 1,417.4 100 1

Nested Loop (cost=0.29..239,761,754.28 rows=141,737 width=12) (actual time=16.161..1,985.57 rows=100 loops=1)

  • Buffers: shared hit=7782
301. 0.152 2.110 ↑ 1,211.7 80 1

Nested Loop (cost=0.29..135,441.86 rows=96,938 width=17) (actual time=0.145..2.11 rows=80 loops=1)

  • Buffers: shared hit=503
302. 0.345 1.878 ↑ 1,211.7 80 1

Nested Loop (cost=0.29..94,628.57 rows=96,938 width=21) (actual time=0.134..1.878 rows=80 loops=1)

  • Buffers: shared hit=502
303. 0.448 1.373 ↑ 1,211.7 80 1

Nested Loop (cost=0.29..49,550.01 rows=96,938 width=21) (actual time=0.127..1.373 rows=80 loops=1)

  • Buffers: shared hit=500
304. 0.205 0.205 ↑ 1,211.7 80 1

Seq Scan on credit c_2 (cost=0..6,555.38 rows=96,938 width=21) (actual time=0.109..0.205 rows=80 loops=1)

  • Buffers: shared hit=260
305. 0.720 0.720 ↑ 1.0 1 80

Index Scan using pk__productc__5e190d18ff92f2a5 on productcopy pc_2 (cost=0.29..0.44 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=80)

  • Index Cond: (pc_2.pkey = c_2.productcopyfk)
  • Buffers: shared hit=240
306. 0.148 0.160 ↑ 1.0 31 80

Materialize (cost=0..2.46 rows=31 width=8) (actual time=0..0.002 rows=31 loops=80)

  • Buffers: shared hit=2
307. 0.012 0.012 ↑ 1.0 31 1

Seq Scan on product p (cost=0..2.31 rows=31 width=8) (actual time=0.003..0.012 rows=31 loops=1)

  • Buffers: shared hit=2
308. 0.060 0.080 ↑ 4.8 6 80

Materialize (cost=0..2.6 rows=29 width=4) (actual time=0..0.001 rows=6 loops=80)

  • Buffers: shared hit=1
309. 0.020 0.020 ↑ 1.1 26 1

Seq Scan on par_productnamecaption pname (cost=0..2.45 rows=29 width=4) (actual time=0.004..0.02 rows=26 loops=1)

  • Filter: (pname.languageid = 4)
  • Buffers: shared hit=1
310. 683.323 715.280 ↑ 1.0 164,738 80

Materialize (cost=0..6,166.9 rows=164,793 width=13) (actual time=0.002..8.941 rows=164,738 loops=80)

  • Buffers: shared hit=7279
311. 31.957 31.957 ↓ 1.0 164,797 1

Seq Scan on creditinstance ci (cost=0..5,342.93 rows=164,793 width=13) (actual time=0.111..31.957 rows=164,797 loops=1)

  • Buffers: shared hit=7279
312. 0.800 0.800 ↑ 1.0 1 100

Index Scan using cpdistribution_pkey on cpdistribution cpdis (cost=0.28..0.3 rows=1 width=12) (actual time=0.008..0.008 rows=1 loops=100)

  • Index Cond: (cpdis.pkey = ci.cpdistributionfk)
  • Buffers: shared hit=304
313. 32.584 45.400 ↓ 2.8 6,477 100

Materialize (cost=100..189.62 rows=2,275 width=12) (actual time=0.006..0.454 rows=6,477 loops=100)

314. 12.816 12.816 ↓ 2.9 6,528 1

Foreign Scan (cost=100..178.25 rows=2,275 width=12) (actual time=0.602..12.816 rows=6,528 loops=1)

315. 32.180 54.700 ↓ 2.5 6,317 100

Materialize (cost=100..199.6 rows=2,560 width=8) (actual time=0.006..0.547 rows=6,317 loops=100)

316. 22.520 22.520 ↓ 2.5 6,351 1

Foreign Scan (cost=100..186.8 rows=2,560 width=8) (actual time=0.574..22.52 rows=6,351 loops=1)

317. 6.103 10.000 ↑ 2.2 1,149 100

Materialize (cost=100..199.6 rows=2,560 width=8) (actual time=0.021..0.1 rows=1,149 loops=100)

318. 3.897 3.897 ↑ 2.2 1,155 1

Foreign Scan (cost=100..186.8 rows=2,560 width=8) (actual time=2.104..3.897 rows=1,155 loops=1)

319. 2.142 3.200 ↑ 2.9 443 100

Materialize (cost=100..154.8 rows=1,280 width=40) (actual time=0.004..0.032 rows=443 loops=100)

320. 1.058 1.058 ↑ 2.9 443 1

Foreign Scan (cost=100..148.4 rows=1,280 width=40) (actual time=0.359..1.058 rows=443 loops=1)

321. 30.092 40.400 ↓ 2.5 6,314 100

Materialize (cost=100..199.6 rows=2,560 width=8) (actual time=0.003..0.404 rows=6,314 loops=100)

322. 10.308 10.308 ↓ 2.5 6,348 1

Foreign Scan (cost=100..186.8 rows=2,560 width=8) (actual time=0.3..10.308 rows=6,348 loops=1)

323. 0.119 0.400 ↑ 1.0 15 100

Materialize (cost=100..146.94 rows=15 width=4) (actual time=0.003..0.004 rows=15 loops=100)

324. 0.281 0.281 ↑ 1.0 15 1

Foreign Scan (cost=100..146.86 rows=15 width=4) (actual time=0.279..0.281 rows=15 loops=1)

325. 0.251 0.500 ↑ 81.2 36 100

Materialize (cost=100..212.38 rows=2,925 width=4) (actual time=0.003..0.005 rows=36 loops=100)

326. 0.249 0.249 ↑ 81.2 36 1

Foreign Scan (cost=100..197.75 rows=2,925 width=4) (actual time=0.245..0.249 rows=36 loops=1)

327. 17.377 24.200 ↓ 1.1 3,243 100

Materialize (cost=100..212.38 rows=2,925 width=4) (actual time=0.004..0.242 rows=3,243 loops=100)

328. 6.823 6.823 ↓ 1.1 3,243 1

Foreign Scan (cost=100..197.75 rows=2,925 width=4) (actual time=0.365..6.823 rows=3,243 loops=1)

329. 0.034 0.300 ↑ 3.0 5 100

Materialize (cost=100..146.94 rows=15 width=4) (actual time=0.003..0.003 rows=5 loops=100)

330. 0.266 0.266 ↑ 3.0 5 1

Foreign Scan (cost=100..146.86 rows=15 width=4) (actual time=0.264..0.266 rows=5 loops=1)

331. 40.652 52.400 ↓ 2.7 7,982 100

Materialize (cost=100..212.38 rows=2,925 width=4) (actual time=0.003..0.524 rows=7,982 loops=100)

332. 11.748 11.748 ↓ 2.7 8,012 1

Foreign Scan (cost=100..197.75 rows=2,925 width=4) (actual time=0.3..11.748 rows=8,012 loops=1)

333. 0.090 0.100 ↑ 1.0 10 100

Materialize (cost=0..1.15 rows=10 width=12) (actual time=0..0.001 rows=10 loops=100)

  • Buffers: shared hit=1
334. 0.010 0.010 ↑ 1.0 10 1

Seq Scan on owner2participantmapping o2p (cost=0..1.1 rows=10 width=12) (actual time=0.007..0.01 rows=10 loops=1)

  • Buffers: shared hit=1
335. 42.242 88.700 ↓ 114.0 7,980 100

Materialize (cost=100..252.32 rows=70 width=40) (actual time=0.055..0.887 rows=7,980 loops=100)

336. 46.458 46.458 ↓ 114.5 8,012 1

Foreign Scan (cost=100..251.97 rows=70 width=40) (actual time=5.471..46.458 rows=8,012 loops=1)

337. 9.897 10.600 ↑ 1.0 1,963 100

Materialize (cost=0..91.95 rows=1,997 width=5) (actual time=0..0.106 rows=1,963 loops=100)

  • Buffers: shared hit=62
338. 0.703 0.703 ↑ 1.0 1,965 1

Seq Scan on runningaccount ra (cost=0..81.97 rows=1,997 width=5) (actual time=0.012..0.703 rows=1,965 loops=1)

  • Buffers: shared hit=62
339. 2.349 3.600 ↑ 6.6 443 100

Materialize (cost=100..212.38 rows=2,925 width=4) (actual time=0.005..0.036 rows=443 loops=100)

340. 1.251 1.251 ↑ 6.6 443 1

Foreign Scan (cost=100..197.75 rows=2,925 width=4) (actual time=0.455..1.251 rows=443 loops=1)

341. 4.761 20.500 ↓ 6.0 993 100

Materialize (cost=100..265.37 rows=166 width=8) (actual time=0.019..0.205 rows=993 loops=100)

342. 15.739 15.739 ↓ 6.0 993 1

Foreign Scan (cost=100..264.54 rows=166 width=8) (actual time=1.888..15.739 rows=993 loops=1)

343. 0.139 1.498 ↑ 6.6 443 1

Hash (cost=197.75..197.75 rows=2,925 width=4) (actual time=1.498..1.498 rows=443 loops=1)

344. 1.359 1.359 ↑ 6.6 443 1

Foreign Scan (cost=100..197.75 rows=2,925 width=4) (actual time=0.468..1.359 rows=443 loops=1)