explain.depesz.com

PostgreSQL's explain analyze made readable

Result: puPe : pgare

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3,603.882 ↑ 1.0 1 1

Aggregate (cost=8,498.88..8,498.89 rows=1 width=8) (actual time=3,603.881..3,603.882 rows=1 loops=1)

2. 3,603.565 3,603.565 ↓ 437.0 437 1

Unique (cost=8,498.81..8,498.86 rows=1 width=738) (actual time=3,601.278..3,603.565 rows=437 loops=1)

3. 3,602.006 3,602.006 ↓ 855.0 855 1

Sort (cost=8,498.81..8,498.81 rows=1 width=738) (actual time=3,601.274..3,602.006 rows=855 loops=1)

4. 3,595.066 3,595.066 ↓ 855.0 855 1

Nested Loop (cost=8,490.64..8,498.80 rows=1 width=738) (actual time=3,585.910..3,595.066 rows=855 loops=1)

5. 3,588.771 3,588.771 ↓ 911.0 911 1

Unique (cost=8,490.36..8,490.47 rows=1 width=1,136) (actual time=3,585.859..3,588.771 rows=911 loops=1)

6. 3,586.743 3,586.743 ↓ 911.0 911 1

Sort (cost=8,490.36..8,490.36 rows=1 width=1,136) (actual time=3,585.855..3,586.743 rows=911 loops=1)

7. 3,577.746 3,577.746 ↓ 911.0 911 1

Nested Loop (cost=8,483.07..8,490.35 rows=1 width=1,136) (actual time=3,565.793..3,577.746 rows=911 loops=1)

8. 3,566.208 3,566.208 ↓ 493.0 493 1

Sort (cost=8,474.50..8,474.51 rows=1 width=928) (actual time=3,565.719..3,566.208 rows=493 loops=1)

9. 3,564.472 3,564.472 ↓ 493.0 493 1

GroupAggregate (cost=8,474.24..8,474.49 rows=1 width=928) (actual time=3,557.772..3,564.472 rows=493 loops=1)

10. 3,558.063 3,558.063 ↓ 493.0 493 1

Sort (cost=8,474.24..8,474.24 rows=1 width=1,068) (actual time=3,557.494..3,558.063 rows=493 loops=1)

11. 3,555.739 3,555.739 ↓ 493.0 493 1

Nested Loop (cost=7,865.25..8,474.23 rows=1 width=1,068) (actual time=3,175.175..3,555.739 rows=493 loops=1)

12. 3,548.870 3,548.870 ↓ 493.0 493 1

Merge Join (cost=7,864.97..8,466.30 rows=1 width=1,157) (actual time=3,175.124..3,548.870 rows=493 loops=1)

13. 3,537.877 3,537.877 ↓ 59.2 2,959 1

Nested Loop (cost=7,863.49..9,064.70 rows=50 width=1,156) (actual time=3,175.011..3,537.877 rows=2,959 loops=1)

14. 0.039 0.039 ↑ 1.6 13 1

Index Scan using azioni_id on azioni c (cost=0.14..12.45 rows=21 width=110) (actual time=0.006..0.039 rows=13 loops=1)

15. 3,529.032 3,529.032 ↓ 19.0 455 13

Materialize (cost=7,863.36..9,044.75 rows=24 width=1,050) (actual time=244.231..271.464 rows=455 loops=13)

16. 3,522.929 3,522.929 ↓ 20.5 493 1

Hash Right Join (cost=7,863.36..9,044.63 rows=24 width=1,050) (actual time=3,174.985..3,522.929 rows=493 loops=1)

17. 3,388.960 3,388.960 ↑ 2.4 7,900 1

Hash Left Join (cost=2,900.69..4,009.68 rows=19,210 width=260) (actual time=3,015.190..3,388.960 rows=7,900 loops=1)

18. 1,722.180 1,722.180 ↓ 1.2 7,900 1

Hash Left Join (cost=786.10..1,334.43 rows=6,552 width=132) (actual time=1,368.764..1,722.180 rows=7,900 loops=1)

19. 1,699.927 1,699.927 ↓ 1.2 7,900 1

Hash Join (cost=678.87..1,137.11 rows=6,552 width=74) (actual time=1,365.064..1,699.927 rows=7,900 loops=1)

20. 13.319 13.319 ↑ 1.0 13,103 1

Seq Scan on journal (cost=0.00..261.03 rows=13,103 width=25) (actual time=0.028..13.319 rows=13,103 loops=1)

21. 1,364.797 1,364.797 ↓ 7,900.0 165,900 1

Hash (cost=678.56..678.56 rows=21 width=93) (actual time=1,364.797..1,364.797 rows=165,900 loops=1)

22. 1,160.087 1,160.087 ↓ 7,900.0 165,900 1

Nested Loop (cost=622.79..678.56 rows=21 width=93) (actual time=119.020..1,160.087 rows=165,900 loops=1)

23. 128.837 128.837 ↓ 39.5 7,900 1

HashAggregate (cost=622.79..624.79 rows=200 width=32) (actual time=118.973..128.837 rows=7,900 loops=1)

24. 107.791 107.791 ↑ 1.0 7,900 1

HashAggregate (cost=326.54..524.04 rows=7,900 width=36) (actual time=93.155..107.791 rows=7,900 loops=1)

25. 12.727 12.727 ↑ 1.0 13,103 1

Seq Scan on journal x (cost=0.00..261.03 rows=13,103 width=8) (actual time=0.007..12.727 rows=13,103 loops=1)

26. 339.700 339.700 ↑ 1.0 21 7,900

Materialize (cost=0.00..1.31 rows=21 width=61) (actual time=0.001..0.043 rows=21 loops=7,900)

27. 0.058 0.058 ↑ 1.0 21 1

Seq Scan on azioni b (cost=0.00..1.21 rows=21 width=61) (actual time=0.032..0.058 rows=21 loops=1)

28. 3.684 3.684 ↑ 1.0 1,699 1

Hash (cost=85.99..85.99 rows=1,699 width=62) (actual time=3.684..3.684 rows=1,699 loops=1)

29. 1.810 1.810 ↑ 1.0 1,699 1

Seq Scan on impianti (cost=0.00..85.99 rows=1,699 width=62) (actual time=0.022..1.810 rows=1,699 loops=1)

30. 1,646.376 1,646.376 ↓ 1.2 7,599 1

Hash (cost=2,032.69..2,032.69 rows=6,552 width=132) (actual time=1,646.376..1,646.376 rows=7,599 loops=1)

31. 1,633.658 1,633.658 ↓ 1.2 7,599 1

Hash Left Join (cost=1,484.36..2,032.69 rows=6,552 width=132) (actual time=1,278.507..1,633.658 rows=7,599 loops=1)

32. 1,610.917 1,610.917 ↓ 1.2 7,599 1

Hash Join (cost=1,377.14..1,835.37 rows=6,552 width=74) (actual time=1,274.137..1,610.917 rows=7,599 loops=1)

33. 13.208 13.208 ↑ 1.0 13,103 1

Seq Scan on journal journal_1 (cost=0.00..261.03 rows=13,103 width=25) (actual time=0.020..13.208 rows=13,103 loops=1)

34. 1,273.799 1,273.799 ↓ 7,599.0 159,579 1

Hash (cost=1,376.82..1,376.82 rows=21 width=93) (actual time=1,273.799..1,273.799 rows=159,579 loops=1)

35. 681.360 681.360 ↓ 7,599.0 159,579 1

Nested Loop (cost=1,321.06..1,376.82 rows=21 width=93) (actual time=81.964..681.360 rows=159,579 loops=1)

36. 91.198 91.198 ↓ 38.0 7,599 1

HashAggregate (cost=1,321.06..1,323.06 rows=200 width=32) (actual time=81.921..91.198 rows=7,599 loops=1)

37. 73.954 73.954 ↓ 1.4 7,599 1

HashAggregate (cost=1,123.58..1,255.23 rows=5,266 width=36) (actual time=63.798..73.954 rows=7,599 loops=1)

38. 51.380 51.380 ↓ 1.1 9,962 1

Sort (cost=970.72..992.56 rows=8,735 width=93) (actual time=41.262..51.380 rows=9,962 loops=1)

39. 30.185 30.185 ↓ 1.1 9,962 1

Hash Join (cost=1.39..398.90 rows=8,735 width=93) (actual time=0.063..30.185 rows=9,962 loops=1)

40. 10.182 10.182 ↑ 1.0 13,103 1

Seq Scan on journal a (cost=0.00..261.03 rows=13,103 width=20) (actual time=0.006..10.182 rows=13,103 loops=1)

41. 0.041 0.041 ↑ 1.0 14 1

Hash (cost=1.21..1.21 rows=14 width=4) (actual time=0.041..0.041 rows=14 loops=1)

42. 0.022 0.022 ↑ 1.0 14 1

Seq Scan on azioni b_2 (cost=0.00..1.21 rows=14 width=4) (actual time=0.008..0.022 rows=14 loops=1)

43. 121.584 121.584 ↑ 1.0 21 7,599

Materialize (cost=0.00..1.31 rows=21 width=61) (actual time=0.001..0.016 rows=21 loops=7,599)

44. 0.049 0.049 ↑ 1.0 21 1

Seq Scan on azioni b_1 (cost=0.00..1.21 rows=21 width=61) (actual time=0.032..0.049 rows=21 loops=1)

45. 4.348 4.348 ↑ 1.0 1,699 1

Hash (cost=85.99..85.99 rows=1,699 width=62) (actual time=4.348..4.348 rows=1,699 loops=1)

46. 2.188 2.188 ↑ 1.0 1,699 1

Seq Scan on impianti impianti_1 (cost=0.00..85.99 rows=1,699 width=62) (actual time=0.025..2.188 rows=1,699 loops=1)

47. 124.181 124.181 ↓ 49.3 493 1

Hash (cost=4,962.54..4,962.54 rows=10 width=794) (actual time=124.181..124.181 rows=493 loops=1)

48. 123.135 123.135 ↓ 49.3 493 1

Subquery Scan on v_calendari3 (cost=4,962.34..4,962.54 rows=10 width=794) (actual time=121.414..123.135 rows=493 loops=1)

49. 122.191 122.191 ↓ 49.3 493 1

HashAggregate (cost=4,962.34..4,962.44 rows=10 width=870) (actual time=121.411..122.191 rows=493 loops=1)

50. 119.109 119.109 ↓ 49.3 493 1

Append (cost=495.67..4,961.54 rows=10 width=870) (actual time=3.156..119.109 rows=493 loops=1)

51. 38.397 38.397 ↓ 46.4 418 1

Nested Loop (cost=495.67..2,515.28 rows=9 width=403) (actual time=3.154..38.397 rows=418 loops=1)

52. 32.012 32.012 ↓ 46.4 418 1

Nested Loop (cost=495.39..2,510.31 rows=9 width=320) (actual time=3.107..32.012 rows=418 loops=1)

53. 28.358 28.358 ↓ 46.6 419 1

Nested Loop (cost=495.11..2,506.63 rows=9 width=296) (actual time=3.088..28.358 rows=419 loops=1)

54. 22.314 22.314 ↓ 46.6 419 1

Hash Left Join (cost=494.83..2,503.19 rows=9 width=231) (actual time=3.054..22.314 rows=419 loops=1)

55. 18.143 18.143 ↑ 1.3 1,320 1

Hash Join (cost=492.88..2,483.82 rows=1,712 width=255) (actual time=2.348..18.143 rows=1,320 loops=1)

56. 8.833 8.833 ↓ 1.0 4,778 1

Bitmap Heap Scan on calendari a_1 (cost=425.27..2,375.30 rows=4,755 width=68) (actual time=0.999..8.833 rows=4,778 loops=1)

57. 0.909 0.909 ↓ 1.0 4,835 1

Bitmap Index Scan on calendari_data (cost=0.00..424.08 rows=4,765 width=0) (actual time=0.909..0.909 rows=4,835 loops=1)

58. 1.298 1.298 ↑ 1.0 72 1

Hash (cost=66.72..66.72 rows=72 width=196) (actual time=1.298..1.298 rows=72 loops=1)

59. 1.206 1.206 ↑ 1.0 72 1

Hash Left Join (cost=63.98..66.72 rows=72 width=196) (actual time=0.939..1.206 rows=72 loops=1)

60. 0.937 0.937 ↑ 1.0 72 1

HashAggregate (cost=62.44..63.88 rows=72 width=212) (actual time=0.871..0.937 rows=72 loops=1)

61. 0.701 0.701 ↑ 1.0 72 1

Hash Join (cost=3.71..59.73 rows=72 width=212) (actual time=0.267..0.701 rows=72 loops=1)

62. 0.306 0.306 ↑ 1.0 72 1

Seq Scan on siglecampionati a_2 (cost=0.00..54.23 rows=72 width=133) (actual time=0.034..0.306 rows=72 loops=1)

63. 0.214 0.214 ↑ 1.0 76 1

Hash (cost=2.76..2.76 rows=76 width=29) (actual time=0.214..0.214 rows=76 loops=1)

64. 0.095 0.095 ↑ 1.0 76 1

Seq Scan on categorie b_3 (cost=0.00..2.76 rows=76 width=29) (actual time=0.014..0.095 rows=76 loops=1)

65. 0.054 0.054 ↑ 1.1 12 1

Hash (cost=1.38..1.38 rows=13 width=45) (actual time=0.054..0.054 rows=12 loops=1)

66. 0.029 0.029 ↑ 1.0 13 1

Seq Scan on soglie g (cost=0.00..1.38 rows=13 width=45) (actual time=0.016..0.029 rows=13 loops=1)

67. 0.095 0.095 ↑ 1.5 25 1

Hash (cost=1.38..1.38 rows=38 width=57) (actual time=0.095..0.095 rows=25 loops=1)

68. 0.043 0.043 ↑ 1.0 38 1

Seq Scan on soglie f (cost=0.00..1.38 rows=38 width=57) (actual time=0.010..0.043 rows=38 loops=1)

69. 4.190 4.190 ↑ 1.0 1 419

Index Scan using impianti_i0imp on impianti c_1 (cost=0.28..0.37 rows=1 width=74) (actual time=0.009..0.010 rows=1 loops=419)

70. 1.676 1.676 ↑ 1.0 1 419

Index Scan using anagrafe_scoso on anagrafe d_1 (cost=0.28..0.40 rows=1 width=28) (actual time=0.003..0.004 rows=1 loops=419)

71. 1.672 1.672 ↑ 1.0 1 418

Index Scan using anagrafe_scoso on anagrafe e (cost=0.28..0.40 rows=1 width=28) (actual time=0.003..0.004 rows=1 loops=418)

72. 79.821 79.821 ↓ 75.0 75 1

Subquery Scan on raggruppamenti (cost=2,446.08..2,446.16 rows=1 width=870) (actual time=79.302..79.821 rows=75 loops=1)

73. 79.642 79.642 ↓ 75.0 75 1

Unique (cost=2,446.08..2,446.15 rows=1 width=922) (actual time=79.297..79.642 rows=75 loops=1)

74. 79.375 79.375 ↓ 75.0 75 1

Sort (cost=2,446.08..2,446.08 rows=1 width=922) (actual time=79.294..79.375 rows=75 loops=1)

75. 79.006 79.006 ↓ 75.0 75 1

Hash Join (cost=2,440.61..2,446.07 rows=1 width=922) (actual time=77.972..79.006 rows=75 loops=1)

76. 53.644 53.644 ↓ 1.4 289 1

HashAggregate (cost=1,609.61..1,612.11 rows=200 width=36) (actual time=53.296..53.644 rows=289 loops=1)

77. 51.839 51.839 ↑ 3.8 1,100 1

HashAggregate (cost=1,506.21..1,547.57 rows=4,136 width=941) (actual time=50.348..51.839 rows=1,100 loops=1)

78. 47.134 47.134 ↑ 3.7 1,107 1

Append (cost=478.30..1,206.35 rows=4,136 width=941) (actual time=23.261..47.134 rows=1,107 loops=1)

79. 29.123 29.123 ↑ 3.8 818 1

Hash Join (cost=478.30..704.10 rows=3,070 width=468) (actual time=23.259..29.123 rows=818 loops=1)

80. 20.515 20.515 ↑ 3.7 289 1

Hash Join (cost=272.44..460.90 rows=1,066 width=279) (actual time=15.902..20.515 rows=289 loops=1)

81. 10.767 10.767 ↑ 1.0 289 1

Hash Join (cost=138.86..289.20 rows=289 width=128) (actual time=6.725..10.767 rows=289 loops=1)

82. 5.957 5.957 ↑ 1.0 289 1

Hash Join (cost=31.64..178.00 rows=289 width=58) (actual time=2.524..5.957 rows=289 loops=1)

83. 1.515 1.515 ↑ 1.0 1,732 1

Seq Scan on anagrafe f_2 (cost=0.00..128.32 rows=1,732 width=24) (actual time=0.028..1.515 rows=1,732 loops=1)

84. 2.459 2.459 ↑ 1.0 289 1

Hash (cost=28.02..28.02 rows=289 width=42) (actual time=2.459..2.459 rows=289 loops=1)

85. 2.065 2.065 ↑ 1.0 289 1

Merge Right Join (cost=17.99..28.02 rows=289 width=42) (actual time=0.787..2.065 rows=289 loops=1)

86. 0.308 0.308 ↑ 34.6 127 1

Index Scan using refertimain_idp on refertimain r (cost=0.28..273.97 rows=4,393 width=8) (actual time=0.027..0.308 rows=127 loops=1)

87. 1.030 1.030 ↑ 1.0 289 1

Sort (cost=17.70..18.43 rows=289 width=38) (actual time=0.752..1.030 rows=289 loops=1)

88. 0.348 0.348 ↑ 1.0 289 1

Seq Scan on ragg a_3 (cost=0.00..5.89 rows=289 width=38) (actual time=0.020..0.348 rows=289 loops=1)

89. 4.174 4.174 ↑ 1.0 1,699 1

Hash (cost=85.99..85.99 rows=1,699 width=74) (actual time=4.174..4.174 rows=1,699 loops=1)

90. 1.970 1.970 ↑ 1.0 1,699 1

Seq Scan on impianti d_2 (cost=0.00..85.99 rows=1,699 width=74) (actual time=0.017..1.970 rows=1,699 loops=1)

91. 9.153 9.153 ↑ 1.0 738 1

Hash (cost=124.35..124.35 rows=738 width=155) (actual time=9.153..9.153 rows=738 loops=1)

92. 7.913 7.913 ↑ 1.0 738 1

Subquery Scan on e_1 (cost=102.21..124.35 rows=738 width=155) (actual time=5.520..7.913 rows=738 loops=1)

93. 6.537 6.537 ↑ 1.0 738 1

HashAggregate (cost=102.21..116.97 rows=738 width=212) (actual time=5.516..6.537 rows=738 loops=1)

94. 3.623 3.623 ↑ 1.0 738 1

Hash Join (cost=3.71..74.54 rows=738 width=212) (actual time=0.264..3.623 rows=738 loops=1)

95. 1.004 1.004 ↑ 1.0 738 1

Seq Scan on siglecampionati a_4 (cost=0.00..52.38 rows=738 width=133) (actual time=0.022..1.004 rows=738 loops=1)

96. 0.216 0.216 ↑ 1.0 76 1

Hash (cost=2.76..2.76 rows=76 width=29) (actual time=0.216..0.216 rows=76 loops=1)

97. 0.087 0.087 ↑ 1.0 76 1

Seq Scan on categorie b_5 (cost=0.00..2.76 rows=76 width=29) (actual time=0.010..0.087 rows=76 loops=1)

98. 7.336 7.336 ↑ 1.0 1,321 1

Hash (cost=189.34..189.34 rows=1,321 width=28) (actual time=7.336..7.336 rows=1,321 loops=1)

99. 6.156 6.156 ↑ 1.0 1,321 1

Hash Join (cost=149.97..189.34 rows=1,321 width=28) (actual time=2.986..6.156 rows=1,321 loops=1)

100. 0.991 0.991 ↑ 1.0 1,321 1

Seq Scan on ragavv b_4 (cost=0.00..21.21 rows=1,321 width=8) (actual time=0.013..0.991 rows=1,321 loops=1)

101. 2.954 2.954 ↑ 1.0 1,732 1

Hash (cost=128.32..128.32 rows=1,732 width=24) (actual time=2.954..2.954 rows=1,732 loops=1)

102. 1.508 1.508 ↑ 1.0 1,732 1

Seq Scan on anagrafe c_2 (cost=0.00..128.32 rows=1,732 width=24) (actual time=0.007..1.508 rows=1,732 loops=1)

103. 16.376 16.376 ↑ 3.7 289 1

Hash Join (cost=272.44..460.90 rows=1,066 width=468) (actual time=12.258..16.376 rows=289 loops=1)

104. 8.624 8.624 ↑ 1.0 289 1

Hash Join (cost=138.86..289.20 rows=289 width=132) (actual time=5.049..8.624 rows=289 loops=1)

105. 4.894 4.894 ↑ 1.0 289 1

Hash Join (cost=31.64..178.00 rows=289 width=62) (actual time=1.831..4.894 rows=289 loops=1)

106. 1.357 1.357 ↑ 1.0 1,732 1

Seq Scan on anagrafe c_3 (cost=0.00..128.32 rows=1,732 width=24) (actual time=0.019..1.357 rows=1,732 loops=1)

107. 1.787 1.787 ↑ 1.0 289 1

Hash (cost=28.02..28.02 rows=289 width=42) (actual time=1.787..1.787 rows=289 loops=1)

108. 1.516 1.516 ↑ 1.0 289 1

Merge Right Join (cost=17.99..28.02 rows=289 width=42) (actual time=0.588..1.516 rows=289 loops=1)

109. 0.201 0.201 ↑ 34.6 127 1

Index Scan using refertimain_idp on refertimain r_1 (cost=0.28..273.97 rows=4,393 width=8) (actual time=0.017..0.201 rows=127 loops=1)

110. 0.768 0.768 ↑ 1.0 289 1

Sort (cost=17.70..18.43 rows=289 width=38) (actual time=0.563..0.768 rows=289 loops=1)

111. 0.258 0.258 ↑ 1.0 289 1

Seq Scan on ragg a_5 (cost=0.00..5.89 rows=289 width=38) (actual time=0.013..0.258 rows=289 loops=1)

112. 3.196 3.196 ↑ 1.0 1,699 1

Hash (cost=85.99..85.99 rows=1,699 width=74) (actual time=3.196..3.196 rows=1,699 loops=1)

113. 1.507 1.507 ↑ 1.0 1,699 1

Seq Scan on impianti d_3 (cost=0.00..85.99 rows=1,699 width=74) (actual time=0.011..1.507 rows=1,699 loops=1)

114. 7.185 7.185 ↑ 1.0 738 1

Hash (cost=124.35..124.35 rows=738 width=155) (actual time=7.185..7.185 rows=738 loops=1)

115. 6.333 6.333 ↑ 1.0 738 1

Subquery Scan on e_2 (cost=102.21..124.35 rows=738 width=155) (actual time=4.582..6.333 rows=738 loops=1)

116. 5.286 5.286 ↑ 1.0 738 1

HashAggregate (cost=102.21..116.97 rows=738 width=212) (actual time=4.579..5.286 rows=738 loops=1)

117. 3.079 3.079 ↑ 1.0 738 1

Hash Join (cost=3.71..74.54 rows=738 width=212) (actual time=0.319..3.079 rows=738 loops=1)

118. 0.806 0.806 ↑ 1.0 738 1

Seq Scan on siglecampionati a_6 (cost=0.00..52.38 rows=738 width=133) (actual time=0.020..0.806 rows=738 loops=1)

119. 0.238 0.238 ↑ 1.0 76 1

Hash (cost=2.76..2.76 rows=76 width=29) (actual time=0.238..0.238 rows=76 loops=1)

120. 0.102 0.102 ↑ 1.0 76 1

Seq Scan on categorie b_6 (cost=0.00..2.76 rows=76 width=29) (actual time=0.017..0.102 rows=76 loops=1)

121. 24.581 24.581 ↓ 75.0 75 1

Hash (cost=830.99..830.99 rows=1 width=889) (actual time=24.581..24.581 rows=75 loops=1)

122. 24.439 24.439 ↓ 75.0 75 1

Hash Left Join (cost=822.92..830.99 rows=1 width=889) (actual time=23.375..24.439 rows=75 loops=1)

123. 23.878 23.878 ↑ 1.5 142 1

Hash Left Join (cost=820.97..826.81 rows=217 width=913) (actual time=23.202..23.878 rows=142 loops=1)

124. 23.244 23.244 ↑ 1.5 142 1

HashAggregate (cost=819.43..821.60 rows=217 width=941) (actual time=23.052..23.244 rows=142 loops=1)

125. 22.509 22.509 ↑ 1.5 142 1

Append (cost=332.73..803.70 rows=217 width=941) (actual time=10.712..22.509 rows=142 loops=1)

126. 14.094 14.094 ↑ 1.5 106 1

Nested Loop (cost=332.73..469.78 rows=161 width=468) (actual time=10.708..14.094 rows=106 loops=1)

127. 13.208 13.208 ↑ 1.5 106 1

Hash Join (cost=332.45..360.22 rows=161 width=283) (actual time=10.678..13.208 rows=106 loops=1)

128. 1.233 1.233 ↑ 1.0 1,321 1

Seq Scan on ragavv b_7 (cost=0.00..21.21 rows=1,321 width=8) (actual time=0.034..1.233 rows=1,321 loops=1)

129. 10.546 10.546 ↑ 1.6 36 1

Hash (cost=331.75..331.75 rows=56 width=279) (actual time=10.546..10.546 rows=36 loops=1)

130. 10.435 10.435 ↑ 1.6 36 1

Hash Join (cost=186.94..331.75 rows=56 width=279) (actual time=6.613..10.435 rows=36 loops=1)

131. 8.799 8.799 ↑ 1.0 56 1

Hash Join (cost=121.45..265.48 rows=56 width=128) (actual time=5.093..8.799 rows=56 loops=1)

132. 1.721 1.721 ↑ 1.0 1,732 1

Seq Scan on anagrafe f_3 (cost=0.00..128.32 rows=1,732 width=24) (actual time=0.014..1.721 rows=1,732 loops=1)

133. 5.051 5.051 ↑ 1.0 56 1

Hash (cost=120.75..120.75 rows=56 width=112) (actual time=5.051..5.051 rows=56 loops=1)

134. 4.930 4.930 ↑ 1.0 56 1

Hash Join (cost=17.21..120.75 rows=56 width=112) (actual time=1.133..4.930 rows=56 loops=1)

135. 2.111 2.111 ↑ 1.0 1,699 1

Seq Scan on impianti d_4 (cost=0.00..85.99 rows=1,699 width=74) (actual time=0.011..2.111 rows=1,699 loops=1)

136. 1.091 1.091 ↑ 1.0 56 1

Hash (cost=16.51..16.51 rows=56 width=42) (actual time=1.091..1.091 rows=56 loops=1)

137. 1.003 1.003 ↑ 1.0 56 1

Merge Right Join (cost=9.97..16.51 rows=56 width=42) (actual time=0.368..1.003 rows=56 loops=1)

138. 0.409 0.409 ↑ 34.6 127 1

Index Scan using refertimain_idp on refertimain r_2 (cost=0.28..273.97 rows=4,393 width=8) (actual time=0.031..0.409 rows=127 loops=1)

139. 0.359 0.359 ↑ 1.0 56 1

Sort (cost=9.68..9.82 rows=56 width=38) (actual time=0.307..0.359 rows=56 loops=1)

140. 0.211 0.211 ↑ 1.0 56 1

Seq Scan on ragg a_7 (cost=0.00..8.06 rows=56 width=38) (actual time=0.037..0.211 rows=56 loops=1)

141. 1.505 1.505 ↑ 1.0 72 1

Hash (cost=64.59..64.59 rows=72 width=155) (actual time=1.505..1.505 rows=72 loops=1)

142. 1.385 1.385 ↑ 1.0 72 1

Subquery Scan on e_3 (cost=62.44..64.59 rows=72 width=155) (actual time=1.163..1.385 rows=72 loops=1)

143. 1.251 1.251 ↑ 1.0 72 1

HashAggregate (cost=62.44..63.88 rows=72 width=212) (actual time=1.161..1.251 rows=72 loops=1)

144. 0.947 0.947 ↑ 1.0 72 1

Hash Join (cost=3.71..59.73 rows=72 width=212) (actual time=0.323..0.947 rows=72 loops=1)

145. 0.400 0.400 ↑ 1.0 72 1

Seq Scan on siglecampionati a_8 (cost=0.00..54.23 rows=72 width=133) (actual time=0.036..0.400 rows=72 loops=1)

146. 0.258 0.258 ↑ 1.0 76 1

Hash (cost=2.76..2.76 rows=76 width=29) (actual time=0.258..0.258 rows=76 loops=1)

147. 0.108 0.108 ↑ 1.0 76 1

Seq Scan on categorie b_8 (cost=0.00..2.76 rows=76 width=29) (actual time=0.014..0.108 rows=76 loops=1)

148. 0.424 0.424 ↑ 1.0 1 106

Index Scan using anagrafe_scoso on anagrafe c_4 (cost=0.28..0.67 rows=1 width=24) (actual time=0.003..0.004 rows=1 loops=106)

149. 8.190 8.190 ↑ 1.6 36 1

Hash Join (cost=186.94..331.75 rows=56 width=468) (actual time=5.274..8.190 rows=36 loops=1)

150. 6.827 6.827 ↑ 1.0 56 1

Hash Join (cost=121.45..265.48 rows=56 width=132) (actual time=4.005..6.827 rows=56 loops=1)

151. 1.337 1.337 ↑ 1.0 1,732 1

Seq Scan on anagrafe c_5 (cost=0.00..128.32 rows=1,732 width=24) (actual time=0.014..1.337 rows=1,732 loops=1)

152. 3.967 3.967 ↑ 1.0 56 1

Hash (cost=120.75..120.75 rows=56 width=112) (actual time=3.967..3.967 rows=56 loops=1)

153. 3.878 3.878 ↑ 1.0 56 1

Hash Join (cost=17.21..120.75 rows=56 width=112) (actual time=0.965..3.878 rows=56 loops=1)

154. 1.561 1.561 ↑ 1.0 1,699 1

Seq Scan on impianti d_5 (cost=0.00..85.99 rows=1,699 width=74) (actual time=0.011..1.561 rows=1,699 loops=1)

155. 0.929 0.929 ↑ 1.0 56 1

Hash (cost=16.51..16.51 rows=56 width=42) (actual time=0.929..0.929 rows=56 loops=1)

156. 0.852 0.852 ↑ 1.0 56 1

Merge Right Join (cost=9.97..16.51 rows=56 width=42) (actual time=0.332..0.852 rows=56 loops=1)

157. 0.215 0.215 ↑ 34.6 127 1

Index Scan using refertimain_idp on refertimain r_3 (cost=0.28..273.97 rows=4,393 width=8) (actual time=0.024..0.215 rows=127 loops=1)

158. 0.432 0.432 ↑ 1.0 56 1

Sort (cost=9.68..9.82 rows=56 width=38) (actual time=0.292..0.432 rows=56 loops=1)

159. 0.169 0.169 ↑ 1.0 56 1

Seq Scan on ragg a_9 (cost=0.00..8.06 rows=56 width=38) (actual time=0.039..0.169 rows=56 loops=1)

160. 1.248 1.248 ↑ 1.0 72 1

Hash (cost=64.59..64.59 rows=72 width=155) (actual time=1.248..1.248 rows=72 loops=1)

161. 1.148 1.148 ↑ 1.0 72 1

Subquery Scan on e_4 (cost=62.44..64.59 rows=72 width=155) (actual time=0.960..1.148 rows=72 loops=1)

162. 1.030 1.030 ↑ 1.0 72 1

HashAggregate (cost=62.44..63.88 rows=72 width=212) (actual time=0.956..1.030 rows=72 loops=1)

163. 0.783 0.783 ↑ 1.0 72 1

Hash Join (cost=3.71..59.73 rows=72 width=212) (actual time=0.248..0.783 rows=72 loops=1)

164. 0.355 0.355 ↑ 1.0 72 1

Seq Scan on siglecampionati a_10 (cost=0.00..54.23 rows=72 width=133) (actual time=0.037..0.355 rows=72 loops=1)

165. 0.188 0.188 ↑ 1.0 76 1

Hash (cost=2.76..2.76 rows=76 width=29) (actual time=0.188..0.188 rows=76 loops=1)

166. 0.080 0.080 ↑ 1.0 76 1

Seq Scan on categorie b_9 (cost=0.00..2.76 rows=76 width=29) (actual time=0.009..0.080 rows=76 loops=1)

167. 0.114 0.114 ↑ 1.1 12 1

Hash (cost=1.38..1.38 rows=13 width=45) (actual time=0.114..0.114 rows=12 loops=1)

168. 0.054 0.054 ↑ 1.0 13 1

Seq Scan on soglie g_1 (cost=0.00..1.38 rows=13 width=45) (actual time=0.033..0.054 rows=13 loops=1)

169. 0.130 0.130 ↑ 1.5 25 1

Hash (cost=1.38..1.38 rows=38 width=57) (actual time=0.130..0.130 rows=25 loops=1)

170. 0.052 0.052 ↑ 1.0 38 1

Seq Scan on soglie f_1 (cost=0.00..1.38 rows=38 width=57) (actual time=0.012..0.052 rows=38 loops=1)

171. 3.567 3.567 ↓ 216.2 3,460 1

Sort (cost=1.48..1.52 rows=16 width=54) (actual time=0.094..3.567 rows=3,460 loops=1)

172. 0.048 0.048 ↑ 1.0 16 1

Seq Scan on stati (cost=0.00..1.16 rows=16 width=54) (actual time=0.030..0.048 rows=16 loops=1)

173. 2.958 2.958 ↑ 1.0 1 493

Index Scan using impianti_id on impianti d (cost=0.28..7.90 rows=1 width=13) (actual time=0.005..0.006 rows=1 loops=493)

174. 5.916 5.916 ↓ 2.0 2 493

Bitmap Heap Scan on anagrafe anagrafe_1 (cost=8.57..15.80 rows=1 width=8) (actual time=0.010..0.012 rows=2 loops=493)

175. 3.451 3.451 ↓ 0.0 0 493

BitmapOr (cost=8.57..8.57 rows=2 width=0) (actual time=0.007..0.007 rows=0 loops=493)

176. 0.986 0.986 ↑ 1.0 1 493

Bitmap Index Scan on anagrafe_scoso (cost=0.00..4.29 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=493)

177. 1.479 1.479 ↑ 1.0 1 493

Bitmap Index Scan on anagrafe_scoso (cost=0.00..4.29 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=493)

178. 2.733 2.733 ↑ 1.0 1 911

Index Scan using anagrafe_scoso on anagrafe (cost=0.28..8.29 rows=1 width=24) (actual time=0.002..0.003 rows=1 loops=911)