explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X1EI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Subquery Scan on results (cost=339,308.05..339,312.23 rows=335 width=560) (actual rows= loops=)

2.          

CTE arhiv_tmp

3. 0.000 0.000 ↓ 0.0

Unique (cost=103,124.46..103,361.63 rows=4,375 width=36) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=103,124.46..103,183.75 rows=23,717 width=36) (actual rows= loops=)

  • Sort Key: arh.pr_id, arh."DateValue
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=98,478.78..100,749.99 rows=23,717 width=36) (actual rows= loops=)

  • Hash Cond: (arh.pr_id = p.prp_id)
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=98,292.07..100,202.14 rows=43,749 width=36) (actual rows= loops=)

  • Merge Cond: (arh.pr_id = arangcontract3.prp_id)
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=98,133.10..99,442.94 rows=43,749 width=32) (actual rows= loops=)

  • Merge Cond: (arh.pr_id = aranguser3.prp_id)
8. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=97,974.14..98,683.74 rows=43,749 width=28) (actual rows= loops=)

  • Merge Cond: (arh.pr_id = arangmetrol3.prp_id)
9. 0.000 0.000 ↓ 0.0

Sort (cost=97,815.18..97,924.55 rows=43,749 width=24) (actual rows= loops=)

  • Sort Key: arh.pr_id
10. 0.000 0.000 ↓ 0.0

Seq Scan on "Arhiv_cnt" arh (cost=0.00..93,543.29 rows=43,749 width=24) (actual rows= loops=)

  • Filter: (("DateValue" >= '2019-06-24 00:00:00'::timestamp without time zone) AND ("DateValue" <= '2019-07-01 00:00:00'::timestamp without time zone) AND (typ_arh = 2))
11. 0.000 0.000 ↓ 0.0

Sort (cost=158.96..164.31 rows=2,140 width=8) (actual rows= loops=)

  • Sort Key: arangmetrol3.prp_id
12. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.05..40.58 rows=2,140 width=8) (actual rows= loops=)

  • Hash Cond: (arangmetrol3.range_id = arang033.range_id)
13. 0.000 0.000 ↓ 0.0

Seq Scan on "RangesToParam" arangmetrol3 (cost=0.00..31.40 rows=2,140 width=8) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

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

15. 0.000 0.000 ↓ 0.0

Seq Scan on "AnalyticRanges" arang033 (cost=0.00..1.04 rows=1 width=4) (actual rows= loops=)

  • Filter: (range_typ = 2)
16. 0.000 0.000 ↓ 0.0

Sort (cost=158.96..164.31 rows=2,140 width=8) (actual rows= loops=)

  • Sort Key: aranguser3.prp_id
17. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.05..40.58 rows=2,140 width=8) (actual rows= loops=)

  • Hash Cond: (aranguser3.range_id = arang023.range_id)
18. 0.000 0.000 ↓ 0.0

Seq Scan on "RangesToParam" aranguser3 (cost=0.00..31.40 rows=2,140 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

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

20. 0.000 0.000 ↓ 0.0

Seq Scan on "AnalyticRanges" arang023 (cost=0.00..1.04 rows=1 width=4) (actual rows= loops=)

  • Filter: (range_typ = 1)
21. 0.000 0.000 ↓ 0.0

Sort (cost=158.96..164.31 rows=2,140 width=8) (actual rows= loops=)

  • Sort Key: arangcontract3.prp_id
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.05..40.58 rows=2,140 width=8) (actual rows= loops=)

  • Hash Cond: (arangcontract3.range_id = arang013.range_id)
23. 0.000 0.000 ↓ 0.0

Seq Scan on "RangesToParam" arangcontract3 (cost=0.00..31.40 rows=2,140 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

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

25. 0.000 0.000 ↓ 0.0

Seq Scan on "AnalyticRanges" arang013 (cost=0.00..1.04 rows=1 width=4) (actual rows= loops=)

  • Filter: (range_typ = 0)
26. 0.000 0.000 ↓ 0.0

Hash (cost=167.32..167.32 rows=1,551 width=4) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

HashAggregate (cost=151.81..167.32 rows=1,551 width=4) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=12.69..147.94 rows=1,551 width=4) (actual rows= loops=)

  • Hash Cond: (p.plc_id = "Places_cnt".plc_id)
29. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=0.33..114.15 rows=1,588 width=8) (actual rows= loops=)

  • Hash Cond: (p."ParamRes_id" = "*VALUES*".column1)
30. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" p (cost=0.00..83.65 rows=4,765 width=12) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=0.16..0.16 rows=13 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.00..0.16 rows=13 width=4) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=8.18..8.18 rows=335 width=4) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on "Places_cnt" (cost=0.00..8.18 rows=335 width=4) (actual rows= loops=)

  • Filter: ((place_id = 338) OR (plc_id = 338))
35. 0.000 0.000 ↓ 0.0

Sort (cost=235,946.41..235,947.25 rows=335 width=414) (actual rows= loops=)

  • Sort Key: (max(((pt."Name" || ' '::text) || p."Name")))
36. 0.000 0.000 ↓ 0.0

HashAggregate (cost=235,929.01..235,932.36 rows=335 width=414) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=104,088.15..173,116.51 rows=335,000 width=414) (actual rows= loops=)

  • Hash Cond: (prp24.prp_id = a24.pr_id)
38. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=103,989.44..171,327.33 rows=335,000 width=394) (actual rows= loops=)

  • Hash Cond: (prp21.prp_id = pr21.prp_id)
39. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=103,730.46..164,787.81 rows=335,000 width=391) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp24.plc_id)
40. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=103,634.84..163,781.86 rows=335,000 width=387) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp22.plc_id)
41. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=103,440.63..162,677.33 rows=335,000 width=379) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp23.plc_id)
42. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=103,246.42..161,572.79 rows=335,000 width=355) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp21.plc_id)
43. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=103,150.80..160,566.84 rows=335,000 width=351) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp18.plc_id)
44. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=102,945.98..156,072.57 rows=335,000 width=343) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp19.plc_id)
45. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=102,741.16..151,578.31 rows=335,000 width=319) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp20.plc_id)
46. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=102,536.34..147,084.04 rows=335,000 width=299) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp15.plc_id)
47. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=102,326.27..141,142.55 rows=335,000 width=275) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp16.plc_id)
48. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=102,116.25..135,215.68 rows=335,000 width=251) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp17.plc_id)
49. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=101,868.95..130,678.93 rows=335,000 width=244) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp12.plc_id)
50. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=101,674.74..129,574.39 rows=335,000 width=220) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp14.plc_id)
51. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=101,464.67..123,632.91 rows=335,000 width=212) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp13.plc_id)
52. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=101,208.16..117,644.99 rows=335,000 width=205) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp10.plc_id)
53. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=101,013.95..116,540.45 rows=335,000 width=197) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp11.plc_id)
54. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=100,819.74..115,435.91 rows=335,000 width=173) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp9.plc_id)
55. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=100,681.23..114,387.08 rows=335,000 width=166) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp6.plc_id)
56. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=100,476.41..109,892.81 rows=335,000 width=158) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp7.plc_id)
57. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=100,271.59..105,398.54 rows=335,000 width=134) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp8.plc_id)
58. 0.000 0.000 ↓ 0.0

Sort (cost=100,066.77..100,904.27 rows=335,000 width=110) (actual rows= loops=)

  • Sort Key: p.plc_id
59. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,130.82..30,390.16 rows=335,000 width=110) (actual rows= loops=)

  • Hash Cond: (pr5.dev_id = d5.dev_id)
60. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1,076.50..25,310.83 rows=335,000 width=107) (actual rows= loops=)

  • Hash Cond: (prp2.prp_id = a2.pr_id)
61. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=977.79..23,521.65 rows=335,000 width=103) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp5.plc_id)
62. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=776.04..19,030.45 rows=335,000 width=99) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp3.plc_id)
63. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=565.97..13,088.96 rows=335,000 width=75) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp4.plc_id)
64. 0.000 0.000 ↓ 0.0

Nested Loop (cost=355.95..7,162.09 rows=335,000 width=51) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=355.70..461.84 rows=335 width=51) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=355.70..362.31 rows=335 width=48) (actual rows= loops=)

  • Merge Cond: (p.plc_id = prp2.plc_id)
67. 0.000 0.000 ↓ 0.0

Sort (cost=246.03..246.87 rows=335 width=44) (actual rows= loops=)

  • Sort Key: p.plc_id
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=127.99..231.99 rows=335 width=44) (actual rows= loops=)

  • Hash Cond: (p.typ_id = pt.typ_id)
69. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=126.54..225.93 rows=335 width=16) (actual rows= loops=)

  • Hash Cond: (prp1.plc_id = p.plc_id)
70. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=99.76..194.63 rows=336 width=8) (actual rows= loops=)

  • Hash Cond: (pr1.prp_id = prp1.prp_id)
71. 0.000 0.000 ↓ 0.0

Seq Scan on "PointRead" pr1 (cost=0.00..73.64 rows=4,764 width=8) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=336 width=8) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp1 (cost=0.00..95.56 rows=336 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 2)
74. 0.000 0.000 ↓ 0.0

Hash (cost=22.59..22.59 rows=335 width=12) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=11.50..22.59 rows=335 width=12) (actual rows= loops=)

  • Hash Cond: (pchild.place_id = p.plc_id)
76. 0.000 0.000 ↓ 0.0

Seq Scan on "Places_cnt" pchild (cost=0.00..6.45 rows=345 width=4) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=7.31..7.31 rows=335 width=12) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on "Places_cnt" p (cost=0.00..7.31 rows=335 width=12) (actual rows= loops=)

  • Filter: (place_id = 338)
79. 0.000 0.000 ↓ 0.0

Hash (cost=1.20..1.20 rows=20 width=36) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on "PlaceTyp_cnt" pt (cost=0.00..1.20 rows=20 width=36) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Sort (cost=109.66..110.50 rows=336 width=8) (actual rows= loops=)

  • Sort Key: prp2.plc_id
82. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp2 (cost=0.00..95.56 rows=336 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 2)
83. 0.000 0.000 ↓ 0.0

Index Scan using "Device_cnt_pkey" on "Device_cnt" d1 (cost=0.00..0.28 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (pr1.dev_id = dev_id)
84. 0.000 0.000 ↓ 0.0

Function Scan on "GetDateRange" dts (cost=0.25..10.25 rows=1,000 width=0) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Sort (cost=210.02..210.86 rows=335 width=28) (actual rows= loops=)

  • Sort Key: prp4.plc_id
86. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.97 rows=335 width=28) (actual rows= loops=)

  • Hash Cond: (prp4.prp_id = a4.pr_id)
87. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp4 (cost=0.00..95.56 rows=335 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 995)
88. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a4 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
90. 0.000 0.000 ↓ 0.0

Sort (cost=210.07..210.91 rows=336 width=28) (actual rows= loops=)

  • Sort Key: prp3.plc_id
91. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.98 rows=336 width=28) (actual rows= loops=)

  • Hash Cond: (prp3.prp_id = a3.pr_id)
92. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp3 (cost=0.00..95.56 rows=336 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 2)
93. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a3 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
95. 0.000 0.000 ↓ 0.0

Sort (cost=201.75..202.34 rows=237 width=8) (actual rows= loops=)

  • Sort Key: prp5.plc_id
96. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=98.53..192.40 rows=237 width=8) (actual rows= loops=)

  • Hash Cond: (pr5.prp_id = prp5.prp_id)
97. 0.000 0.000 ↓ 0.0

Seq Scan on "PointRead" pr5 (cost=0.00..73.64 rows=4,764 width=8) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=237 width=8) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp5 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 44)
100. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=12) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a2 (cost=0.00..98.44 rows=22 width=12) (actual rows= loops=)

  • Filter: (typ_arh = 2)
102. 0.000 0.000 ↓ 0.0

Hash (cost=30.81..30.81 rows=1,881 width=11) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Seq Scan on "Device_cnt" d5 (cost=0.00..30.81 rows=1,881 width=11) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Sort (cost=204.82..205.41 rows=237 width=28) (actual rows= loops=)

  • Sort Key: prp8.plc_id
105. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.47 rows=237 width=28) (actual rows= loops=)

  • Hash Cond: (prp8.prp_id = a8.pr_id)
106. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp8 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 999)
107. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a8 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
109. 0.000 0.000 ↓ 0.0

Sort (cost=204.82..205.41 rows=237 width=28) (actual rows= loops=)

  • Sort Key: prp7.plc_id
110. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.47 rows=237 width=28) (actual rows= loops=)

  • Hash Cond: (prp7.prp_id = a7.pr_id)
111. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp7 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 44)
112. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a7 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
114. 0.000 0.000 ↓ 0.0

Sort (cost=204.82..205.41 rows=237 width=12) (actual rows= loops=)

  • Sort Key: prp6.plc_id
115. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.47 rows=237 width=12) (actual rows= loops=)

  • Hash Cond: (prp6.prp_id = a6.pr_id)
116. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp6 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 44)
117. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=12) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a6 (cost=0.00..98.44 rows=22 width=12) (actual rows= loops=)

  • Filter: (typ_arh = 2)
119. 0.000 0.000 ↓ 0.0

Sort (cost=138.51..138.52 rows=5 width=11) (actual rows= loops=)

  • Sort Key: prp9.plc_id
120. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..138.45 rows=5 width=11) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..136.97 rows=5 width=8) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp9 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 377)
123. 0.000 0.000 ↓ 0.0

Index Scan using "PointIndex" on "PointRead" pr9 (cost=0.00..8.27 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (prp9.prp_id = prp_id)
124. 0.000 0.000 ↓ 0.0

Index Scan using "Device_cnt_pkey" on "Device_cnt" d9 (cost=0.00..0.28 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (pr9.dev_id = dev_id)
125. 0.000 0.000 ↓ 0.0

Sort (cost=194.21..194.23 rows=5 width=28) (actual rows= loops=)

  • Sort Key: prp11.plc_id
126. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=95.63..194.16 rows=5 width=28) (actual rows= loops=)

  • Hash Cond: (a11.pr_id = prp11.prp_id)
127. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a11 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
128. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=5 width=8) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp11 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 377)
130. 0.000 0.000 ↓ 0.0

Sort (cost=194.21..194.23 rows=5 width=12) (actual rows= loops=)

  • Sort Key: prp10.plc_id
131. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=95.63..194.16 rows=5 width=12) (actual rows= loops=)

  • Hash Cond: (a10.pr_id = prp10.prp_id)
132. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a10 (cost=0.00..98.44 rows=22 width=12) (actual rows= loops=)

  • Filter: (typ_arh = 2)
133. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=5 width=8) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp10 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 377)
135. 0.000 0.000 ↓ 0.0

Sort (cost=256.50..257.34 rows=336 width=11) (actual rows= loops=)

  • Sort Key: prp13.plc_id
136. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=198.83..242.40 rows=336 width=11) (actual rows= loops=)

  • Hash Cond: (d13.dev_id = pr13.dev_id)
137. 0.000 0.000 ↓ 0.0

Seq Scan on "Device_cnt" d13 (cost=0.00..30.81 rows=1,881 width=11) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Hash (cost=194.63..194.63 rows=336 width=8) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=99.76..194.63 rows=336 width=8) (actual rows= loops=)

  • Hash Cond: (pr13.prp_id = prp13.prp_id)
140. 0.000 0.000 ↓ 0.0

Seq Scan on "PointRead" pr13 (cost=0.00..73.64 rows=4,764 width=8) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=336 width=8) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp13 (cost=0.00..95.56 rows=336 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 1)
143. 0.000 0.000 ↓ 0.0

Sort (cost=210.07..210.91 rows=336 width=12) (actual rows= loops=)

  • Sort Key: prp14.plc_id
144. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.98 rows=336 width=12) (actual rows= loops=)

  • Hash Cond: (prp14.prp_id = a14.pr_id)
145. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp14 (cost=0.00..95.56 rows=336 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 1)
146. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=12) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a14 (cost=0.00..98.44 rows=22 width=12) (actual rows= loops=)

  • Filter: (typ_arh = 2)
148. 0.000 0.000 ↓ 0.0

Sort (cost=194.21..194.23 rows=5 width=28) (actual rows= loops=)

  • Sort Key: prp12.plc_id
149. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=95.63..194.16 rows=5 width=28) (actual rows= loops=)

  • Hash Cond: (a12.pr_id = prp12.prp_id)
150. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a12 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
151. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=5 width=8) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp12 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 1003)
153. 0.000 0.000 ↓ 0.0

Sort (cost=247.30..247.89 rows=237 width=11) (actual rows= loops=)

  • Sort Key: prp17.plc_id
154. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=195.36..237.95 rows=237 width=11) (actual rows= loops=)

  • Hash Cond: (d17.dev_id = pr17.dev_id)
155. 0.000 0.000 ↓ 0.0

Seq Scan on "Device_cnt" d17 (cost=0.00..30.81 rows=1,881 width=11) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Hash (cost=192.40..192.40 rows=237 width=8) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=98.53..192.40 rows=237 width=8) (actual rows= loops=)

  • Hash Cond: (pr17.prp_id = prp17.prp_id)
158. 0.000 0.000 ↓ 0.0

Seq Scan on "PointRead" pr17 (cost=0.00..73.64 rows=4,764 width=8) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=237 width=8) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp17 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 308)
161. 0.000 0.000 ↓ 0.0

Sort (cost=210.02..210.86 rows=335 width=28) (actual rows= loops=)

  • Sort Key: prp16.plc_id
162. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.97 rows=335 width=28) (actual rows= loops=)

  • Hash Cond: (prp16.prp_id = a16.pr_id)
163. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp16 (cost=0.00..95.56 rows=335 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 955)
164. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a16 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
166. 0.000 0.000 ↓ 0.0

Sort (cost=210.07..210.91 rows=336 width=28) (actual rows= loops=)

  • Sort Key: prp15.plc_id
167. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.98 rows=336 width=28) (actual rows= loops=)

  • Hash Cond: (prp15.prp_id = a15.pr_id)
168. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp15 (cost=0.00..95.56 rows=336 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 1)
169. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a15 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
171. 0.000 0.000 ↓ 0.0

Sort (cost=204.82..205.41 rows=237 width=24) (actual rows= loops=)

  • Sort Key: prp20.plc_id
172. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.47 rows=237 width=24) (actual rows= loops=)

  • Hash Cond: (prp20.prp_id = a20.pr_id)
173. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp20 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 959)
174. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=20) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a20 (cost=0.00..98.44 rows=22 width=20) (actual rows= loops=)

  • Filter: (typ_arh = 2)
176. 0.000 0.000 ↓ 0.0

Sort (cost=204.82..205.41 rows=237 width=28) (actual rows= loops=)

  • Sort Key: prp19.plc_id
177. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.47 rows=237 width=28) (actual rows= loops=)

  • Hash Cond: (prp19.prp_id = a19.pr_id)
178. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp19 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 308)
179. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a19 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
181. 0.000 0.000 ↓ 0.0

Sort (cost=204.82..205.41 rows=237 width=12) (actual rows= loops=)

  • Sort Key: prp18.plc_id
182. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=98.71..195.47 rows=237 width=12) (actual rows= loops=)

  • Hash Cond: (prp18.prp_id = a18.pr_id)
183. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp18 (cost=0.00..95.56 rows=237 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 308)
184. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=12) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a18 (cost=0.00..98.44 rows=22 width=12) (actual rows= loops=)

  • Filter: (typ_arh = 2)
186. 0.000 0.000 ↓ 0.0

Sort (cost=95.62..95.63 rows=5 width=8) (actual rows= loops=)

  • Sort Key: prp21.plc_id
187. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp21 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 310)
188. 0.000 0.000 ↓ 0.0

Sort (cost=194.21..194.23 rows=5 width=28) (actual rows= loops=)

  • Sort Key: prp23.plc_id
189. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=95.63..194.16 rows=5 width=28) (actual rows= loops=)

  • Hash Cond: (a23.pr_id = prp23.prp_id)
190. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a23 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)
191. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=5 width=8) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp23 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 310)
193. 0.000 0.000 ↓ 0.0

Sort (cost=194.21..194.23 rows=5 width=12) (actual rows= loops=)

  • Sort Key: prp22.plc_id
194. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=95.63..194.16 rows=5 width=12) (actual rows= loops=)

  • Hash Cond: (a22.pr_id = prp22.prp_id)
195. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a22 (cost=0.00..98.44 rows=22 width=12) (actual rows= loops=)

  • Filter: (typ_arh = 2)
196. 0.000 0.000 ↓ 0.0

Hash (cost=95.56..95.56 rows=5 width=8) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp22 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 310)
198. 0.000 0.000 ↓ 0.0

Sort (cost=95.62..95.63 rows=5 width=8) (actual rows= loops=)

  • Sort Key: prp24.plc_id
199. 0.000 0.000 ↓ 0.0

Seq Scan on "ParamResPlc_cnt" prp24 (cost=0.00..95.56 rows=5 width=8) (actual rows= loops=)

  • Filter: ("ParamRes_id" = 963)
200. 0.000 0.000 ↓ 0.0

Hash (cost=199.42..199.42 rows=4,764 width=11) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=54.32..199.42 rows=4,764 width=11) (actual rows= loops=)

  • Hash Cond: (pr21.dev_id = d21.dev_id)
202. 0.000 0.000 ↓ 0.0

Seq Scan on "PointRead" pr21 (cost=0.00..73.64 rows=4,764 width=8) (actual rows= loops=)

203. 0.000 0.000 ↓ 0.0

Hash (cost=30.81..30.81 rows=1,881 width=11) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Seq Scan on "Device_cnt" d21 (cost=0.00..30.81 rows=1,881 width=11) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Hash (cost=98.44..98.44 rows=22 width=24) (actual rows= loops=)

206. 0.000 0.000 ↓ 0.0

CTE Scan on arhiv_tmp a24 (cost=0.00..98.44 rows=22 width=24) (actual rows= loops=)

  • Filter: (typ_arh = 2)