explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EDVI

Settings
# exclusive inclusive rows x rows loops node
1. 53,625.494 55,034.637 ↓ 3.8 217,749 1

Sort (cost=395,310.82..395,454.72 rows=57,560 width=7,716) (actual time=51,750.239..55,034.637 rows=217,749 loops=1)

  • Sort Key: r.id, a0.applicant_id, a0.file_id, a1.applicant_id, a1.file_id, a2.applicant_id, a2.file_id, a3.applicant_id, a3.file_id, a4.applicant_id, a4.file_id, d0.delegat_id, d0.file_id, d1.delegat_id, d1.file_id, n.id, n0.change_id, n0.file_id, n1.change_id, n1.file_id, c1.connection_area_id, c1.file_id, c2.connection_area_id, c2.file_id, c3.connection_area_id, c3.file_id, c4.id, c5.connection_object_id, c5.file_id, c6.connection_object_id, c6.file_id, c7.connection_object_id, c7.file_id, c8.connection_object_id, c8.file_id, c9.id, c10.id, c11.id, h.id, c12.connection_params_id, c12.file_id, p.id, c13.file_id, c13.connection_params_id, c14.file_id, c14.connection_params_id, c15.file_id, c15.connection_params_id
  • Sort Method: external merge Disk: 178,416kB
  • Buffers: shared hit=208, temp read=45,983 written=45,983
2. 474.559 1,409.143 ↓ 3.8 217,749 1

Hash Join (cost=630.83..9,868.9 rows=57,560 width=7,716) (actual time=42.717..1,409.143 rows=217,749 loops=1)

  • Buffers: shared hit=205
3. 273.232 901.376 ↓ 3.9 213,664 1

Hash Join (cost=360.2..8,608.95 rows=55,162 width=6,784) (actual time=9.485..901.376 rows=213,664 loops=1)

  • Buffers: shared hit=146
4. 275.464 628.010 ↓ 3.9 213,639 1

Hash Join (cost=355.05..8,053.99 rows=55,162 width=6,744) (actual time=9.339..628.01 rows=213,639 loops=1)

  • Buffers: shared hit=144
5. 248.519 352.521 ↓ 3.9 213,631 1

Hash Join (cost=353.72..7,838.59 rows=55,162 width=6,712) (actual time=9.304..352.521 rows=213,631 loops=1)

  • Buffers: shared hit=143
6. 31.207 103.967 ↑ 2.2 25,021 1

Hash Join (cost=351.93..7,613.16 rows=55,162 width=6,680) (actual time=9.256..103.967 rows=25,021 loops=1)

  • Buffers: shared hit=142
7. 7.753 72.309 ↑ 11.4 4,848 1

Hash Join (cost=335.89..6,375.16 rows=55,162 width=6,648) (actual time=8.789..72.309 rows=4,848 loops=1)

  • Buffers: shared hit=138
8. 8.339 64.501 ↑ 11.4 4,848 1

Hash Join (cost=333.43..6,134.66 rows=55,162 width=6,616) (actual time=8.723..64.501 rows=4,848 loops=1)

  • Buffers: shared hit=137
9. 7.128 56.055 ↑ 11.7 4,711 1

Hash Join (cost=328.77..5,177.03 rows=55,162 width=6,565) (actual time=8.608..56.055 rows=4,711 loops=1)

  • Buffers: shared hit=135
10. 3.562 48.899 ↑ 31.6 1,746 1

Hash Join (cost=327.1..4,954.1 rows=55,162 width=6,533) (actual time=8.567..48.899 rows=1,746 loops=1)

  • Buffers: shared hit=134
11. 2.744 44.785 ↑ 37.0 1,489 1

Hash Join (cost=305.46..4,047.48 rows=55,162 width=6,501) (actual time=8.005..44.785 rows=1,489 loops=1)

  • Buffers: shared hit=128
12. 1.896 41.825 ↑ 43.2 1,277 1

Hash Join (cost=298.26..3,239.95 rows=55,162 width=6,469) (actual time=7.769..41.825 rows=1,277 loops=1)

  • Buffers: shared hit=126
13. 1.667 39.553 ↑ 45.0 1,225 1

Hash Join (cost=290.43..2,701.82 rows=55,162 width=6,183) (actual time=7.378..39.553 rows=1,225 loops=1)

  • Buffers: shared hit=122
14. 1.642 37.883 ↑ 6.6 1,225 1

Hash Join (cost=249.82..710.28 rows=8,112 width=6,151) (actual time=7.362..37.883 rows=1,225 loops=1)

  • Buffers: shared hit=122
15. 1.784 36.238 ↓ 1.0 1,225 1

Hash Join (cost=209.22..382.77 rows=1,193 width=6,119) (actual time=7.343..36.238 rows=1,225 loops=1)

  • Buffers: shared hit=122
16. 1.696 34.350 ↓ 1.0 1,225 1

Hash Join (cost=205.62..373.48 rows=1,193 width=6,087) (actual time=7.227..34.35 rows=1,225 loops=1)

  • Buffers: shared hit=121
17. 1.645 32.626 ↓ 1.0 1,201 1

Hash Join (cost=204.21..367.41 rows=1,193 width=6,055) (actual time=7.187..32.626 rows=1,201 loops=1)

  • Buffers: shared hit=120
18. 5.100 30.936 ↓ 1.0 1,197 1

Hash Join (cost=202.6..361.05 rows=1,193 width=6,023) (actual time=7.125..30.936 rows=1,197 loops=1)

  • Buffers: shared hit=119
19. 1.848 24.846 ↑ 1.0 1,157 1

Hash Join (cost=171.63..307.56 rows=1,193 width=5,991) (actual time=6.106..24.846 rows=1,157 loops=1)

  • Buffers: shared hit=111
20. 2.307 22.481 ↑ 1.0 1,153 1

Hash Join (cost=159.72..281.1 rows=1,193 width=5,959) (actual time=5.575..22.481 rows=1,153 loops=1)

  • Buffers: shared hit=108
21. 2.009 18.678 ↑ 1.0 1,153 1

Hash Join (cost=115.84..220.82 rows=1,193 width=5,467) (actual time=4.064..18.678 rows=1,153 loops=1)

  • Buffers: shared hit=90
22. 4.468 15.475 ↑ 1.0 1,153 1

Hash Join (cost=76.97..165.97 rows=1,193 width=5,242) (actual time=2.853..15.475 rows=1,153 loops=1)

  • Buffers: shared hit=77
23. 2.684 10.967 ↑ 1.0 1,153 1

Hash Join (cost=75.56..159.91 rows=1,193 width=1,078) (actual time=2.801..10.967 rows=1,153 loops=1)

  • Buffers: shared hit=76
24. 1.383 6.200 ↓ 1.0 1,153 1

Hash Join (cost=20.72..89.26 rows=1,150 width=642) (actual time=0.691..6.2 rows=1,153 loops=1)

  • Buffers: shared hit=48
25. 1.122 4.300 ↓ 1.0 1,153 1

Hash Join (cost=4.38..64.46 rows=1,150 width=541) (actual time=0.163..4.3 rows=1,153 loops=1)

  • Buffers: shared hit=41
26. 2.024 3.120 ↓ 1.0 1,153 1

Hash Join (cost=2.21..57.57 rows=1,150 width=521) (actual time=0.093..3.12 rows=1,153 loops=1)

  • Buffers: shared hit=40
27. 1.033 1.033 ↓ 1.0 1,153 1

Seq Scan on applicant a (cost=0..50.5 rows=1,150 width=501) (actual time=0.009..1.033 rows=1,153 loops=1)

  • Buffers: shared hit=39
28. 0.028 0.063 ↑ 1.0 54 1

Hash (cost=1.54..1.54 rows=54 width=20) (actual time=0.063..0.063 rows=54 loops=1)

  • Buffers: shared hit=1
29. 0.035 0.035 ↑ 1.0 54 1

Seq Scan on gas_network_applicant_extension g (cost=0..1.54 rows=54 width=20) (actual time=0.014..0.035 rows=54 loops=1)

  • Buffers: shared hit=1
30. 0.032 0.058 ↓ 1.0 53 1

Hash (cost=1.52..1.52 rows=52 width=20) (actual time=0.058..0.058 rows=53 loops=1)

  • Buffers: shared hit=1
31. 0.026 0.026 ↓ 1.0 53 1

Seq Scan on electric_network_applicant_extension e (cost=0..1.52 rows=52 width=20) (actual time=0.007..0.026 rows=53 loops=1)

  • Buffers: shared hit=1
32. 0.270 0.517 ↓ 1.0 418 1

Hash (cost=11.15..11.15 rows=415 width=101) (actual time=0.517..0.517 rows=418 loops=1)

  • Buffers: shared hit=7
33. 0.247 0.247 ↓ 1.0 418 1

Seq Scan on bank_info b (cost=0..11.15 rows=415 width=101) (actual time=0.008..0.247 rows=418 loops=1)

  • Buffers: shared hit=7
34. 1.016 2.083 ↑ 1.0 1,153 1

Hash (cost=39.93..39.93 rows=1,193 width=436) (actual time=2.083..2.083 rows=1,153 loops=1)

  • Buffers: shared hit=28
35. 1.067 1.067 ↑ 1.0 1,153 1

Seq Scan on request r (cost=0..39.93 rows=1,193 width=436) (actual time=0.016..1.067 rows=1,153 loops=1)

  • Buffers: shared hit=28
36. 0.019 0.040 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=4,164) (actual time=0.04..0.04 rows=18 loops=1)

  • Buffers: shared hit=1
37. 0.021 0.021 ↑ 1.0 18 1

Seq Scan on delegat d (cost=0..1.18 rows=18 width=4,164) (actual time=0.008..0.021 rows=18 loops=1)

  • Buffers: shared hit=1
38. 0.632 1.194 ↓ 1.0 1,153 1

Hash (cost=24.5..24.5 rows=1,150 width=225) (actual time=1.194..1.194 rows=1,153 loops=1)

  • Buffers: shared hit=13
39. 0.562 0.562 ↓ 1.0 1,153 1

Seq Scan on connection_area c (cost=0..24.5 rows=1,150 width=225) (actual time=0.022..0.562 rows=1,153 loops=1)

  • Buffers: shared hit=13
40. 0.781 1.496 ↓ 1.0 1,153 1

Hash (cost=29.5..29.5 rows=1,150 width=492) (actual time=1.496..1.496 rows=1,153 loops=1)

  • Buffers: shared hit=18
41. 0.715 0.715 ↓ 1.0 1,153 1

Seq Scan on connection_object c0 (cost=0..29.5 rows=1,150 width=492) (actual time=0.008..0.715 rows=1,153 loops=1)

  • Buffers: shared hit=18
42. 0.242 0.517 ↑ 1.0 396 1

Hash (cost=6.96..6.96 rows=396 width=32) (actual time=0.517..0.517 rows=396 loops=1)

  • Buffers: shared hit=3
43. 0.275 0.275 ↑ 1.0 396 1

Seq Scan on applicant_founding_document a0 (cost=0..6.96 rows=396 width=32) (actual time=0.008..0.275 rows=396 loops=1)

  • Buffers: shared hit=3
44. 0.505 0.990 ↓ 1.0 1,024 1

Hash (cost=18.21..18.21 rows=1,021 width=32) (actual time=0.99..0.99 rows=1,024 loops=1)

  • Buffers: shared hit=8
45. 0.485 0.485 ↓ 1.0 1,024 1

Seq Scan on applicant_registration_documents a1 (cost=0..18.21 rows=1,021 width=32) (actual time=0.01..0.485 rows=1,024 loops=1)

  • Buffers: shared hit=8
46. 0.029 0.045 ↑ 1.0 27 1

Hash (cost=1.27..1.27 rows=27 width=32) (actual time=0.045..0.045 rows=27 loops=1)

  • Buffers: shared hit=1
47. 0.016 0.016 ↑ 1.0 27 1

Seq Scan on applicant_power_of_attorney_documents a2 (cost=0..1.27 rows=27 width=32) (actual time=0.009..0.016 rows=27 loops=1)

  • Buffers: shared hit=1
48. 0.017 0.028 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=32) (actual time=0.028..0.028 rows=18 loops=1)

  • Buffers: shared hit=1
49. 0.011 0.011 ↑ 1.0 18 1

Seq Scan on applicant_sign_user_power_of_attorney_document a3 (cost=0..1.18 rows=18 width=32) (actual time=0.005..0.011 rows=18 loops=1)

  • Buffers: shared hit=1
50. 0.057 0.104 ↑ 1.0 116 1

Hash (cost=2.16..2.16 rows=116 width=32) (actual time=0.104..0.104 rows=116 loops=1)

  • Buffers: shared hit=1
51. 0.047 0.047 ↑ 1.0 116 1

Seq Scan on applicant_user_identity_documents a4 (cost=0..2.16 rows=116 width=32) (actual time=0.007..0.047 rows=116 loops=1)

  • Buffers: shared hit=1
52. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=23.6..23.6 rows=1,360 width=32) (actual time=0.003..0.003 rows=0 loops=1)

53. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on delegat_power_of_attorney_documents d0 (cost=0..23.6 rows=1,360 width=32) (actual time=0.002..0.002 rows=0 loops=1)

54. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=23.6..23.6 rows=1,360 width=32) (actual time=0.003..0.003 rows=0 loops=1)

55. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on delegat_user_identity_documents d1 (cost=0..23.6 rows=1,360 width=32) (actual time=0.002..0.002 rows=0 loops=1)

56. 0.087 0.376 ↓ 1.1 111 1

Hash (cost=6.55..6.55 rows=103 width=286) (actual time=0.376..0.376 rows=111 loops=1)

  • Buffers: shared hit=4
57. 0.093 0.289 ↓ 1.1 111 1

Hash Join (cost=2.52..6.55 rows=103 width=286) (actual time=0.073..0.289 rows=111 loops=1)

  • Buffers: shared hit=4
58. 0.105 0.172 ↑ 1.0 103 1

Hash Join (cost=1.09..4.55 rows=103 width=254) (actual time=0.04..0.172 rows=103 loops=1)

  • Buffers: shared hit=3
59. 0.047 0.047 ↑ 1.0 103 1

Seq Scan on networking_organization_change n (cost=0..3.03 rows=103 width=222) (actual time=0.007..0.047 rows=103 loops=1)

  • Buffers: shared hit=2
60. 0.006 0.020 ↑ 1.0 4 1

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

  • Buffers: shared hit=1
61. 0.014 0.014 ↑ 1.0 4 1

Seq Scan on networking_organization_change_comment_attachment n0 (cost=0..1.04 rows=4 width=32) (actual time=0.012..0.014 rows=4 loops=1)

  • Buffers: shared hit=1
62. 0.012 0.024 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=32) (actual time=0.024..0.024 rows=19 loops=1)

  • Buffers: shared hit=1
63. 0.012 0.012 ↑ 1.0 19 1

Seq Scan on networking_organization_change_reason_attachment n1 (cost=0..1.19 rows=19 width=32) (actual time=0.004..0.012 rows=19 loops=1)

  • Buffers: shared hit=1
64. 0.113 0.216 ↑ 1.0 231 1

Hash (cost=4.31..4.31 rows=231 width=32) (actual time=0.216..0.216 rows=231 loops=1)

  • Buffers: shared hit=2
65. 0.103 0.103 ↑ 1.0 231 1

Seq Scan on connection_area_legal_document c1 (cost=0..4.31 rows=231 width=32) (actual time=0.007..0.103 rows=231 loops=1)

  • Buffers: shared hit=2
66. 0.299 0.552 ↓ 1.0 698 1

Hash (cost=12.95..12.95 rows=695 width=32) (actual time=0.552..0.552 rows=698 loops=1)

  • Buffers: shared hit=6
67. 0.253 0.253 ↓ 1.0 698 1

Seq Scan on connection_area_topographic_map c2 (cost=0..12.95 rows=695 width=32) (actual time=0.007..0.253 rows=698 loops=1)

  • Buffers: shared hit=6
68. 0.016 0.028 ↑ 1.0 30 1

Hash (cost=1.3..1.3 rows=30 width=32) (actual time=0.028..0.028 rows=30 loops=1)

  • Buffers: shared hit=1
69. 0.012 0.012 ↑ 1.0 30 1

Seq Scan on connection_area_additional_file c3 (cost=0..1.3 rows=30 width=32) (actual time=0.004..0.012 rows=30 loops=1)

  • Buffers: shared hit=1
70. 0.055 0.107 ↑ 1.0 118 1

Hash (cost=3.18..3.18 rows=118 width=51) (actual time=0.107..0.107 rows=118 loops=1)

  • Buffers: shared hit=2
71. 0.052 0.052 ↑ 1.0 118 1

Seq Scan on cadastral_number c4 (cost=0..3.18 rows=118 width=51) (actual time=0.008..0.052 rows=118 loops=1)

  • Buffers: shared hit=2
72. 0.032 0.055 ↑ 1.0 65 1

Hash (cost=1.65..1.65 rows=65 width=32) (actual time=0.055..0.055 rows=65 loops=1)

  • Buffers: shared hit=1
73. 0.023 0.023 ↑ 1.0 65 1

Seq Scan on connection_object_situational_plan c5 (cost=0..1.65 rows=65 width=32) (actual time=0.006..0.023 rows=65 loops=1)

  • Buffers: shared hit=1
74. 0.239 0.451 ↑ 1.0 535 1

Hash (cost=9.35..9.35 rows=535 width=32) (actual time=0.451..0.451 rows=535 loops=1)

  • Buffers: shared hit=4
75. 0.212 0.212 ↑ 1.0 535 1

Seq Scan on connection_object_legal_document c6 (cost=0..9.35 rows=535 width=32) (actual time=0.006..0.212 rows=535 loops=1)

  • Buffers: shared hit=4
76. 0.020 0.035 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=32) (actual time=0.035..0.035 rows=35 loops=1)

  • Buffers: shared hit=1
77. 0.015 0.015 ↑ 1.0 35 1

Seq Scan on connection_object_additional_file c7 (cost=0..1.35 rows=35 width=32) (actual time=0.004..0.015 rows=35 loops=1)

  • Buffers: shared hit=1
78. 0.013 0.025 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=32) (actual time=0.025..0.025 rows=15 loops=1)

  • Buffers: shared hit=1
79. 0.012 0.012 ↑ 1.0 15 1

Seq Scan on connection_object_previous_connection_confirming_document_file c8 (cost=0..1.15 rows=15 width=32) (actual time=0.006..0.012 rows=15 loops=1)

  • Buffers: shared hit=1
80. 0.073 0.134 ↑ 1.0 140 1

Hash (cost=3.4..3.4 rows=140 width=40) (actual time=0.134..0.134 rows=140 loops=1)

  • Buffers: shared hit=2
81. 0.061 0.061 ↑ 1.0 140 1

Seq Scan on connection_point_capacity c9 (cost=0..3.4 rows=140 width=40) (actual time=0.01..0.061 rows=140 loops=1)

  • Buffers: shared hit=2
82. 2.311 33.208 ↓ 1.5 1,832 1

Hash (cost=255.63..255.63 rows=1,200 width=932) (actual time=33.208..33.208 rows=1,832 loops=1)

  • Buffers: shared hit=59
83. 1.842 30.897 ↓ 1.5 1,832 1

Hash Join (cost=242.22..255.63 rows=1,200 width=932) (actual time=24.99..30.897 rows=1,832 loops=1)

  • Buffers: shared hit=59
84. 1.850 29.030 ↓ 1.5 1,832 1

Hash Join (cost=240.88..249.64 rows=1,200 width=900) (actual time=24.954..29.03 rows=1,832 loops=1)

  • Buffers: shared hit=58
85. 2.235 27.148 ↓ 1.5 1,829 1

Hash Join (cost=239.43..243.49 rows=1,200 width=868) (actual time=24.893..27.148 rows=1,829 loops=1)

  • Buffers: shared hit=57
86. 0.057 0.057 ↑ 1.0 129 1

Seq Scan on connection_params_electricity_devices_position_plan_file c14 (cost=0..2.29 rows=129 width=32) (actual time=0.015..0.057 rows=129 loops=1)

  • Buffers: shared hit=1
87. 4.445 24.856 ↓ 1.5 1,805 1

Hash (cost=224.43..224.43 rows=1,200 width=836) (actual time=24.856..24.856 rows=1,805 loops=1)

  • Buffers: shared hit=56
88. 3.567 20.411 ↓ 1.5 1,805 1

Hash Join (cost=127.8..224.43 rows=1,200 width=836) (actual time=3.882..20.411 rows=1,805 loops=1)

  • Buffers: shared hit=56
89. 1.453 16.288 ↓ 1.2 1,485 1

Hash Join (cost=111..195.33 rows=1,200 width=752) (actual time=3.307..16.288 rows=1,485 loops=1)

  • Buffers: shared hit=50
90. 1.624 14.820 ↓ 1.2 1,485 1

Hash Join (cost=109.77..189.5 rows=1,200 width=720) (actual time=3.275..14.82 rows=1,485 loops=1)

  • Buffers: shared hit=49
91. 1.148 12.903 ↓ 1.0 1,205 1

Hash Join (cost=98.21..162.58 rows=1,200 width=652) (actual time=2.973..12.903 rows=1,205 loops=1)

  • Buffers: shared hit=45
92. 1.329 11.732 ↓ 1.0 1,203 1

Hash Join (cost=97.01..156.79 rows=1,200 width=556) (actual time=2.94..11.732 rows=1,203 loops=1)

  • Buffers: shared hit=44
93. 1.834 9.280 ↓ 1.0 1,203 1

Hash Join (cost=57.81..108.33 rows=1,200 width=516) (actual time=1.802..9.28 rows=1,203 loops=1)

  • Buffers: shared hit=34
94. 5.029 6.240 ↓ 1.0 1,203 1

Hash Join (cost=18.6..59.86 rows=1,200 width=476) (actual time=0.579..6.24 rows=1,203 loops=1)

  • Buffers: shared hit=24
95. 0.655 0.655 ↓ 1.0 1,203 1

Seq Scan on connection_params c10 (cost=0..32 rows=1,200 width=448) (actual time=0.009..0.655 rows=1,203 loops=1)

  • Buffers: shared hit=20
96. 0.285 0.556 ↓ 1.0 652 1

Hash (cost=10.49..10.49 rows=649 width=28) (actual time=0.556..0.556 rows=652 loops=1)

  • Buffers: shared hit=4
97. 0.271 0.271 ↓ 1.0 652 1

Seq Scan on firefighting_costs f (cost=0..10.49 rows=649 width=28) (actual time=0.009..0.271 rows=652 loops=1)

  • Buffers: shared hit=4
98. 0.609 1.206 ↓ 1.0 1,304 1

Hash (cost=22.98..22.98 rows=1,298 width=40) (actual time=1.206..1.206 rows=1,304 loops=1)

  • Buffers: shared hit=10
99. 0.597 0.597 ↓ 1.0 1,304 1

Seq Scan on water_capacity w (cost=0..22.98 rows=1,298 width=40) (actual time=0.013..0.597 rows=1,304 loops=1)

  • Buffers: shared hit=10
100. 0.589 1.123 ↓ 1.0 1,304 1

Hash (cost=22.98..22.98 rows=1,298 width=40) (actual time=1.123..1.123 rows=1,304 loops=1)

  • Buffers: shared hit=10
101. 0.534 0.534 ↓ 1.0 1,304 1

Seq Scan on water_capacity w0 (cost=0..22.98 rows=1,298 width=40) (actual time=0.007..0.534 rows=1,304 loops=1)

  • Buffers: shared hit=10
102. 0.008 0.023 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=96) (actual time=0.023..0.023 rows=9 loops=1)

  • Buffers: shared hit=1
103. 0.015 0.015 ↑ 1.0 9 1

Seq Scan on consumption_balance c11 (cost=0..1.09 rows=9 width=96) (actual time=0.009..0.015 rows=9 loops=1)

  • Buffers: shared hit=1
104. 0.155 0.293 ↑ 1.0 336 1

Hash (cost=7.36..7.36 rows=336 width=68) (actual time=0.293..0.293 rows=336 loops=1)

  • Buffers: shared hit=4
105. 0.138 0.138 ↑ 1.0 336 1

Seq Scan on heat_carrier_consumption h (cost=0..7.36 rows=336 width=68) (actual time=0.007..0.138 rows=336 loops=1)

  • Buffers: shared hit=4
106. 0.007 0.015 ↑ 1.0 10 1

Hash (cost=1.1..1.1 rows=10 width=32) (actual time=0.015..0.015 rows=10 loops=1)

  • Buffers: shared hit=1
107. 0.008 0.008 ↑ 1.0 10 1

Seq Scan on connection_params_consumption_calculation_file c12 (cost=0..1.1 rows=10 width=32) (actual time=0.004..0.008 rows=10 loops=1)

  • Buffers: shared hit=1
108. 0.295 0.556 ↑ 1.0 480 1

Hash (cost=10.8..10.8 rows=480 width=84) (actual time=0.556..0.556 rows=480 loops=1)

  • Buffers: shared hit=6
109. 0.261 0.261 ↑ 1.0 480 1

Seq Scan on power_distribution p (cost=0..10.8 rows=480 width=84) (actual time=0.007..0.261 rows=480 loops=1)

  • Buffers: shared hit=6
110. 0.016 0.032 ↑ 1.0 20 1

Hash (cost=1.2..1.2 rows=20 width=32) (actual time=0.032..0.032 rows=20 loops=1)

  • Buffers: shared hit=1
111. 0.016 0.016 ↑ 1.0 20 1

Seq Scan on connection_params_energy_device_name_file c13 (cost=0..1.2 rows=20 width=32) (actual time=0.006..0.016 rows=20 loops=1)

  • Buffers: shared hit=1
112. 0.015 0.025 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=32) (actual time=0.025..0.025 rows=15 loops=1)

  • Buffers: shared hit=1
113. 0.010 0.010 ↑ 1.0 15 1

Seq Scan on connection_params_electricity_supply_contract_file c15 (cost=0..1.15 rows=15 width=32) (actual time=0.005..0.01 rows=15 loops=1)

  • Buffers: shared hit=1
Planning time : 39.558 ms
Execution time : 55,197.134 ms