explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QKqD

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,228.346 ↑ 1.0 1 1

Result (cost=20,000,634,289.61..20,000,634,289.62 rows=1 width=192) (actual time=2,228.345..2,228.346 rows=1 loops=1)

2.          

CTE selected_file

3. 0.017 458.313 ↓ 70.0 70 1

Unique (cost=38,015.78..38,015.79 rows=1 width=16) (actual time=458.293..458.313 rows=70 loops=1)

4. 0.000 458.296 ↓ 70.0 70 1

Sort (cost=38,015.78..38,015.79 rows=1 width=16) (actual time=458.292..458.296 rows=70 loops=1)

  • Sort Key: f.id
  • Sort Method: quicksort Memory: 28kB
5. 17.379 458.414 ↓ 70.0 70 1

Gather (cost=30,528.56..38,015.77 rows=1 width=16) (actual time=456.013..458.414 rows=70 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 13.448 441.035 ↓ 23.0 23 3

Hash Join (cost=29,528.56..37,015.67 rows=1 width=16) (actual time=440.641..441.035 rows=23 loops=3)

  • Hash Cond: (a."DECLARATION" = d.id)
7. 58.092 426.880 ↑ 1.3 169,536 3

Hash Join (cost=29,526.10..36,456.87 rows=211,942 width=32) (actual time=354.515..426.880 rows=169,536 loops=3)

  • Hash Cond: (a."FILE" = f.id)
8. 18.542 18.542 ↑ 1.3 169,536 3

Parallel Seq Scan on association a (cost=0.00..6,374.42 rows=211,942 width=32) (actual time=0.016..18.542 rows=169,536 loops=3)

9. 121.204 350.246 ↑ 1.0 452,173 3

Hash (cost=23,785.49..23,785.49 rows=459,249 width=16) (actual time=350.246..350.246 rows=452,173 loops=3)

  • Buckets: 524288 Batches: 1 Memory Usage: 25292kB
10. 229.042 229.042 ↑ 1.0 452,173 3

Seq Scan on file f (cost=0.00..23,785.49 rows=459,249 width=16) (actual time=0.044..229.042 rows=452,173 loops=3)

  • Filter: (NOT "toBeDeleted")
11. 0.019 0.707 ↓ 35.0 35 3

Hash (cost=2.44..2.44 rows=1 width=16) (actual time=0.707..0.707 rows=35 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.688 0.688 ↓ 35.0 35 3

Index Scan using "declaration_ORGANIZATION_date_idx" on declaration d (cost=0.42..2.44 rows=1 width=16) (actual time=0.149..0.688 rows=35 loops=3)

  • Index Cond: (("ORGANIZATION" = '9faf476a-cef8-46a7-9afe-bffae9337e46'::uuid) AND (date = '2018-10-01'::date))
  • Filter: ("NEXT_SERIAL" IS NULL)
  • Rows Removed by Filter: 300
13.          

CTE selected_declaration

14. 0.010 517.163 ↓ 35.0 35 1

Unique (cost=7,933.38..7,933.39 rows=1 width=20) (actual time=517.151..517.163 rows=35 loops=1)

15. 0.058 517.153 ↓ 70.0 70 1

Sort (cost=7,933.38..7,933.38 rows=1 width=20) (actual time=517.150..517.153 rows=70 loops=1)

  • Sort Key: d_1.id
  • Sort Method: quicksort Memory: 30kB
16. 0.000 517.095 ↓ 70.0 70 1

Hash Join (cost=1,002.49..7,933.37 rows=1 width=20) (actual time=516.624..517.095 rows=70 loops=1)

  • Hash Cond: (a_1."FILE" = f_1.id)
17. 9.184 58.750 ↓ 70.0 70 1

Gather (cost=1,002.46..7,933.32 rows=1 width=36) (actual time=58.246..58.750 rows=70 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
18. 21.580 49.566 ↓ 23.0 23 3

Hash Join (cost=2.46..6,933.22 rows=1 width=36) (actual time=49.280..49.566 rows=23 loops=3)

  • Hash Cond: (a_1."DECLARATION" = d_1.id)
19. 27.389 27.389 ↑ 1.3 169,536 3

Parallel Seq Scan on association a_1 (cost=0.00..6,374.42 rows=211,942 width=32) (actual time=0.025..27.389 rows=169,536 loops=3)

20. 0.019 0.597 ↓ 35.0 35 3

Hash (cost=2.44..2.44 rows=1 width=20) (actual time=0.597..0.597 rows=35 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
21. 0.578 0.578 ↓ 35.0 35 3

Index Scan using "declaration_ORGANIZATION_date_idx" on declaration d_1 (cost=0.42..2.44 rows=1 width=20) (actual time=0.126..0.578 rows=35 loops=3)

  • Index Cond: (("ORGANIZATION" = '9faf476a-cef8-46a7-9afe-bffae9337e46'::uuid) AND (date = '2018-10-01'::date))
  • Filter: ("NEXT_SERIAL" IS NULL)
  • Rows Removed by Filter: 300
22. 0.026 458.356 ↓ 70.0 70 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=458.356..458.356 rows=70 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
23. 458.330 458.330 ↓ 70.0 70 1

CTE Scan on selected_file f_1 (cost=0.00..0.02 rows=1 width=16) (actual time=458.295..458.330 rows=70 loops=1)

24.          

CTE the_dates

25. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1)

26.          

CTE error_values

27. 0.160 303.970 ↓ 12.3 296 1

GroupAggregate (cost=178,409.15..178,410.41 rows=24 width=112) (actual time=303.811..303.970 rows=296 loops=1)

  • Group Key: e."rowId
28. 0.167 303.810 ↓ 14.3 343 1

Sort (cost=178,409.15..178,409.21 rows=24 width=114) (actual time=303.797..303.810 rows=343 loops=1)

  • Sort Key: e."rowId
  • Sort Method: quicksort Memory: 42kB
29. 1.275 303.643 ↓ 14.3 343 1

Hash Join (cost=0.45..178,408.60 rows=24 width=114) (actual time=10.909..303.643 rows=343 loops=1)

  • Hash Cond: (e."FILE" = f_2.id)
30. 302.349 302.349 ↓ 1.2 7,219 1

Index Scan using "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_row_idx" on "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" e (cost=0.42..178,385.72 rows=6,028 width=130) (actual time=0.246..302.349 rows=7,219 loops=1)

  • Filter: (subgroup = 'S21.G00.30'::text)
  • Rows Removed by Filter: 215846
31. 0.011 0.019 ↓ 70.0 70 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.019..0.019 rows=70 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
32. 0.008 0.008 ↓ 70.0 70 1

CTE Scan on selected_file f_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.008 rows=70 loops=1)

33.          

CTE selection8_165

34. 0.001 0.023 ↑ 1.0 1 1

Result (cost=1.58..1.59 rows=1 width=1) (actual time=0.023..0.023 rows=1 loops=1)

35.          

Initplan (forResult)

36. 0.022 0.022 ↓ 0.0 0 1

Index Only Scan using "filter_selection_ORGANIZATION_USER_FILTER_black_value0_valu_idx" on filter_selection (cost=0.55..1.58 rows=1 width=0) (actual time=0.021..0.022 rows=0 loops=1)

  • Index Cond: (("ORGANIZATION" = '9faf476a-cef8-46a7-9afe-bffae9337e46'::uuid) AND ("USER" = 'a85caaed-3b0c-4c88-a1cf-387c60e4d0fb'::uuid) AND ("FILTER" = 'e2682d2b-34d3-4e82-96fb-99c79c7c1f5f'::uuid) AND (black = true) AND (value0 = '#NULL#'::text) AND (value1 = '#NULL#'::text) AND (value2 = '#NULL#'::text))
  • Filter: black
  • Heap Fetches: 0
37.          

CTE f11_165

38. 0.006 0.696 ↓ 17.0 34 1

Unique (cost=10,000,000,131.05..10,000,000,131.06 rows=2 width=16) (actual time=0.689..0.696 rows=34 loops=1)

39. 0.025 0.690 ↓ 17.0 34 1

Sort (cost=10,000,000,131.05..10,000,000,131.06 rows=2 width=16) (actual time=0.688..0.690 rows=34 loops=1)

  • Sort Key: "S21.G00.11".id
  • Sort Method: quicksort Memory: 26kB
40. 0.004 0.665 ↓ 17.0 34 1

Nested Loop (cost=10,000,000,066.53..10,000,000,131.04 rows=2 width=16) (actual time=0.594..0.665 rows=34 loops=1)

41. 0.096 0.627 ↓ 17.0 34 1

Hash Right Join (cost=66.53..130.99 rows=2 width=16) (actual time=0.568..0.627 rows=34 loops=1)

  • Hash Cond: ("S21.G00.06".id = "S21.G00.11"."S21.G00.06")
  • Filter: (NOT (hashed SubPlan 7))
  • Rows Removed by Filter: 1
42. 0.246 0.246 ↑ 2.3 335 1

Seq Scan on "S21.G00.06_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.06" (cost=0.00..61.56 rows=756 width=48) (actual time=0.013..0.246 rows=335 loops=1)

43. 0.012 0.250 ↓ 8.8 35 1

Hash (cost=64.90..64.90 rows=4 width=96) (actual time=0.250..0.250 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
44. 0.090 0.238 ↓ 8.8 35 1

Hash Join (cost=0.03..64.90 rows=4 width=96) (actual time=0.199..0.238 rows=35 loops=1)

  • Hash Cond: ("S21.G00.11"."DECLARATION" = d_2.id)
45. 0.134 0.134 ↑ 2.1 335 1

Seq Scan on "S21.G00.11_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.11" (cost=0.00..62.15 rows=715 width=112) (actual time=0.012..0.134 rows=335 loops=1)

46. 0.009 0.014 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.014..0.014 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
47. 0.005 0.005 ↓ 35.0 35 1

CTE Scan on selected_declaration d_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.005 rows=35 loops=1)

48.          

SubPlan (forHash Right Join)

49. 0.035 0.035 ↓ 2.0 2 1

Index Only Scan using "filter_selection_ORGANIZATION_USER_FILTER_black_value0_valu_idx" on filter_selection filter_selection_1 (cost=0.55..1.57 rows=1 width=24) (actual time=0.033..0.035 rows=2 loops=1)

  • Index Cond: (("ORGANIZATION" = '9faf476a-cef8-46a7-9afe-bffae9337e46'::uuid) AND ("USER" = 'a85caaed-3b0c-4c88-a1cf-387c60e4d0fb'::uuid) AND ("FILTER" = 'e2682d2b-34d3-4e82-96fb-99c79c7c1f5f'::uuid) AND (black = true))
  • Filter: black
  • Heap Fetches: 0
50. 0.034 0.034 ↑ 1.0 1 34

CTE Scan on selection8_165 se8_165 (cost=0.00..0.02 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=34)

51.          

CTE selected_data

52. 0.236 827.475 ↓ 1,144.0 1,144 1

Hash Left Join (cost=10,000,000,000.88..10,000,001,652.52 rows=1 width=184) (actual time=822.590..827.475 rows=1,144 loops=1)

  • Hash Cond: ("S21.G00.30".id = "values".id)
53. 0.096 523.147 ↓ 1,144.0 1,144 1

Nested Loop (cost=10,000,000,000.10..10,000,001,651.73 rows=1 width=88) (actual time=518.483..523.147 rows=1,144 loops=1)

54. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on the_dates (cost=0.00..0.02 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

55. 0.271 523.048 ↓ 1,144.0 1,144 1

Hash Join (cost=0.10..1,651.70 rows=1 width=80) (actual time=518.477..523.048 rows=1,144 loops=1)

  • Hash Cond: ("S21.G00.30"."DECLARATION" = d_3.id)
56. 1.633 5.585 ↓ 8.5 1,144 1

Hash Join (cost=0.07..1,651.16 rows=134 width=96) (actual time=1.261..5.585 rows=1,144 loops=1)

  • Hash Cond: ("S21.G00.30"."S21.G00.11" = f11_165.id)
57. 3.241 3.241 ↑ 1.2 16,731 1

Seq Scan on "S21.G00.30_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.30" (cost=0.00..1,572.91 rows=20,491 width=96) (actual time=0.011..3.241 rows=16,731 loops=1)

58. 0.007 0.711 ↓ 17.0 34 1

Hash (cost=0.04..0.04 rows=2 width=16) (actual time=0.711..0.711 rows=34 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
59. 0.704 0.704 ↓ 17.0 34 1

CTE Scan on f11_165 (cost=0.00..0.04 rows=2 width=16) (actual time=0.692..0.704 rows=34 loops=1)

60. 0.018 517.192 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=517.192..517.192 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
61. 517.174 517.174 ↓ 35.0 35 1

CTE Scan on selected_declaration d_3 (cost=0.00..0.02 rows=1 width=16) (actual time=517.154..517.174 rows=35 loops=1)

62. 0.046 304.092 ↓ 12.3 296 1

Hash (cost=0.48..0.48 rows=24 width=112) (actual time=304.092..304.092 rows=296 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
63. 304.046 304.046 ↓ 12.3 296 1

CTE Scan on error_values "values" (cost=0.00..0.48 rows=24 width=112) (actual time=303.814..304.046 rows=296 loops=1)

64.          

CTE error_codes_for_filtering

65. 5.061 292.161 ↓ 37.3 33,667 1

Hash Join (cost=104.12..204,290.30 rows=902 width=37) (actual time=0.823..292.161 rows=33,667 loops=1)

  • Hash Cond: (e_1."CONTROL" = c.id)
66. 23.772 286.338 ↓ 37.3 33,667 1

Hash Join (cost=0.03..204,183.85 rows=902 width=43) (actual time=0.039..286.338 rows=33,667 loops=1)

  • Hash Cond: (e_1."FILE" = f_3.id)
67. 262.547 262.547 ↑ 1.0 223,065 1

Seq Scan on "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" e_1 (cost=0.00..203,332.40 rows=224,640 width=59) (actual time=0.008..262.547 rows=223,065 loops=1)

68. 0.010 0.019 ↓ 70.0 70 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.019..0.019 rows=70 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
69. 0.009 0.009 ↓ 70.0 70 1

CTE Scan on selected_file f_3 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.009 rows=70 loops=1)

70. 0.395 0.762 ↑ 1.0 2,817 1

Hash (cost=67.37..67.37 rows=2,937 width=26) (actual time=0.762..0.762 rows=2,817 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 193kB
71. 0.367 0.367 ↑ 1.0 2,817 1

Seq Scan on control c (cost=0.00..67.37 rows=2,937 width=26) (actual time=0.007..0.367 rows=2,817 loops=1)

72.          

CTE selected_data_by_code

73. 0.501 1,401.535 ↓ 312.3 10,929 1

Append (cost=32.86..203,853.31 rows=35 width=48) (actual time=319.709..1,401.535 rows=10,929 loops=1)

74. 0.001 301.894 ↓ 0.0 0 1

Unique (cost=32.86..32.87 rows=1 width=48) (actual time=301.894..301.894 rows=0 loops=1)

75. 0.021 301.893 ↓ 0.0 0 1

Sort (cost=32.86..32.87 rows=1 width=48) (actual time=301.893..301.893 rows=0 loops=1)

  • Sort Key: "S21.G00.3A"."S21.G00.30", e_2.code
  • Sort Method: quicksort Memory: 25kB
76. 0.000 301.872 ↓ 0.0 0 1

Hash Join (cost=12.53..32.85 rows=1 width=48) (actual time=301.872..301.872 rows=0 loops=1)

  • Hash Cond: (e_2.id = "S21.G00.3A".id)
77. 301.872 301.872 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_2 (cost=0.00..20.29 rows=5 width=48) (actual time=301.872..301.872 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.3A'::text)
  • Rows Removed by Filter: 33667
78. 0.000 0.000 ↓ 0.0 0

Hash (cost=12.52..12.52 rows=1 width=32) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..12.52 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.3A"."DECLARATION" = d_4.id)
80. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.3A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.3A" (cost=0.00..11.80 rows=180 width=48) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

82. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_4 (cost=0.00..0.02 rows=1 width=16) (never executed)

83. 0.001 2.461 ↓ 0.0 0 1

Unique (cost=33.55..33.56 rows=1 width=48) (actual time=2.461..2.461 rows=0 loops=1)

84. 0.015 2.460 ↓ 0.0 0 1

Sort (cost=33.55..33.56 rows=1 width=48) (actual time=2.460..2.460 rows=0 loops=1)

  • Sort Key: "S21.G00.5B"."S21.G00.30", e_3.code
  • Sort Method: quicksort Memory: 25kB
85. 0.001 2.445 ↓ 0.0 0 1

Hash Join (cost=13.22..33.54 rows=1 width=48) (actual time=2.445..2.445 rows=0 loops=1)

  • Hash Cond: (e_3.id = "S21.G00.5B".id)
86. 2.444 2.444 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_3 (cost=0.00..20.29 rows=5 width=48) (actual time=2.444..2.444 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.5B'::text)
  • Rows Removed by Filter: 33667
87. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.21..13.21 rows=1 width=32) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..13.21 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.5B"."DECLARATION" = d_5.id)
89. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.5B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5B" (cost=0.00..12.30 rows=230 width=48) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

91. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_5 (cost=0.00..0.02 rows=1 width=16) (never executed)

92. 0.000 3.267 ↓ 0.0 0 1

Unique (cost=205.22..205.23 rows=1 width=48) (actual time=3.267..3.267 rows=0 loops=1)

93. 0.004 3.267 ↓ 0.0 0 1

Sort (cost=205.22..205.22 rows=1 width=48) (actual time=3.267..3.267 rows=0 loops=1)

  • Sort Key: "S21.G00.62"."S21.G00.30", e_4.code
  • Sort Method: quicksort Memory: 25kB
94. 0.005 3.263 ↓ 0.0 0 1

Hash Join (cost=20.39..205.21 rows=1 width=48) (actual time=3.263..3.263 rows=0 loops=1)

  • Hash Cond: ("S21.G00.62".id = e_4.id)
95. 0.361 0.875 ↑ 13.0 1 1

Hash Join (cost=0.03..184.79 rows=13 width=32) (actual time=0.875..0.875 rows=1 loops=1)

  • Hash Cond: ("S21.G00.62"."DECLARATION" = d_6.id)
96. 0.502 0.502 ↓ 1.1 2,970 1

Seq Scan on "S21.G00.62_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.62" (cost=0.00..174.64 rows=2,664 width=48) (actual time=0.009..0.502 rows=2,970 loops=1)

97. 0.006 0.012 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.012..0.012 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
98. 0.006 0.006 ↓ 35.0 35 1

CTE Scan on selected_declaration d_6 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.006 rows=35 loops=1)

99. 0.000 2.383 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.383..2.383 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
100. 2.383 2.383 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_4 (cost=0.00..20.29 rows=5 width=48) (actual time=2.383..2.383 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.62'::text)
  • Rows Removed by Filter: 33667
101. 0.002 2.388 ↓ 0.0 0 1

Unique (cost=34.54..34.55 rows=1 width=48) (actual time=2.388..2.388 rows=0 loops=1)

102. 0.003 2.386 ↓ 0.0 0 1

Sort (cost=34.54..34.54 rows=1 width=48) (actual time=2.386..2.386 rows=0 loops=1)

  • Sort Key: "S21.G00.66"."S21.G00.30", e_5.code
  • Sort Method: quicksort Memory: 25kB
103. 0.000 2.383 ↓ 0.0 0 1

Hash Join (cost=14.20..34.53 rows=1 width=48) (actual time=2.383..2.383 rows=0 loops=1)

  • Hash Cond: (e_5.id = "S21.G00.66".id)
104. 2.383 2.383 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_5 (cost=0.00..20.29 rows=5 width=48) (actual time=2.383..2.383 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.66'::text)
  • Rows Removed by Filter: 33667
105. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.18..14.18 rows=2 width=32) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..14.18 rows=2 width=32) (never executed)

  • Hash Cond: ("S21.G00.66"."DECLARATION" = d_7.id)
107. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.66_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.66" (cost=0.00..13.00 rows=300 width=48) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

109. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_7 (cost=0.00..0.02 rows=1 width=16) (never executed)

110. 0.001 2.388 ↓ 0.0 0 1

Unique (cost=34.38..34.39 rows=1 width=48) (actual time=2.387..2.388 rows=0 loops=1)

111. 0.003 2.387 ↓ 0.0 0 1

Sort (cost=34.38..34.38 rows=1 width=48) (actual time=2.387..2.387 rows=0 loops=1)

  • Sort Key: "S21.G00.5D"."S21.G00.30", e_6.code
  • Sort Method: quicksort Memory: 25kB
112. 0.001 2.384 ↓ 0.0 0 1

Hash Join (cost=14.04..34.37 rows=1 width=48) (actual time=2.384..2.384 rows=0 loops=1)

  • Hash Cond: (e_6.id = "S21.G00.5D".id)
113. 2.383 2.383 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_6 (cost=0.00..20.29 rows=5 width=48) (actual time=2.383..2.383 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.5D'::text)
  • Rows Removed by Filter: 33667
114. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.03..14.03 rows=1 width=32) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..14.03 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.5D"."DECLARATION" = d_8.id)
116. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.5D_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5D" (cost=0.00..12.90 rows=290 width=48) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

118. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_8 (cost=0.00..0.02 rows=1 width=16) (never executed)

119. 0.027 7.342 ↓ 174.0 174 1

Unique (cost=775.12..775.13 rows=1 width=48) (actual time=7.309..7.342 rows=174 loops=1)

120. 0.073 7.315 ↓ 174.0 174 1

Sort (cost=775.12..775.13 rows=1 width=48) (actual time=7.308..7.315 rows=174 loops=1)

  • Sort Key: "S21.G00.53"."S21.G00.30", e_7.code
  • Sort Method: quicksort Memory: 38kB
121. 0.135 7.242 ↓ 174.0 174 1

Hash Join (cost=20.39..775.11 rows=1 width=48) (actual time=6.161..7.242 rows=174 loops=1)

  • Hash Cond: ("S21.G00.53".id = e_7.id)
122. 2.129 4.553 ↓ 26.2 1,259 1

Hash Join (cost=0.03..754.57 rows=48 width=32) (actual time=3.599..4.553 rows=1,259 loops=1)

  • Hash Cond: ("S21.G00.53"."DECLARATION" = d_9.id)
123. 2.415 2.415 ↑ 1.0 14,622 1

Seq Scan on "S21.G00.53_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.53" (cost=0.00..699.22 rows=14,622 width=48) (actual time=0.016..2.415 rows=14,622 loops=1)

124. 0.004 0.009 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.009..0.009 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
125. 0.005 0.005 ↓ 35.0 35 1

CTE Scan on selected_declaration d_9 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.005 rows=35 loops=1)

126. 0.030 2.554 ↓ 34.8 174 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.554..2.554 rows=174 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
127. 2.524 2.524 ↓ 34.8 174 1

CTE Scan on error_codes_for_filtering e_7 (cost=0.00..20.29 rows=5 width=48) (actual time=0.003..2.524 rows=174 loops=1)

  • Filter: (subgroup = 'S21.G00.53'::text)
  • Rows Removed by Filter: 33493
128. 0.117 38.049 ↓ 753.0 753 1

Unique (cost=5,608.53..5,608.54 rows=1 width=48) (actual time=37.901..38.049 rows=753 loops=1)

129. 0.262 37.932 ↓ 753.0 753 1

Sort (cost=5,608.53..5,608.53 rows=1 width=48) (actual time=37.900..37.932 rows=753 loops=1)

  • Sort Key: "S21.G00.81"."S21.G00.30", e_8.code
  • Sort Method: quicksort Memory: 83kB
130. 0.701 37.670 ↓ 753.0 753 1

Hash Join (cost=20.39..5,608.52 rows=1 width=48) (actual time=5.096..37.670 rows=753 loops=1)

  • Hash Cond: ("S21.G00.81".id = e_8.id)
131. 15.730 34.525 ↓ 19.8 7,040 1

Hash Join (cost=0.03..5,586.82 rows=355 width=32) (actual time=2.641..34.525 rows=7,040 loops=1)

  • Hash Cond: ("S21.G00.81"."DECLARATION" = d_10.id)
132. 18.785 18.785 ↑ 1.0 108,308 1

Seq Scan on "S21.G00.81_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.81" (cost=0.00..5,177.08 rows=108,308 width=48) (actual time=0.009..18.785 rows=108,308 loops=1)

133. 0.006 0.010 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.010..0.010 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
134. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_10 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

135. 0.104 2.444 ↓ 150.6 753 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.444..2.444 rows=753 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
136. 2.340 2.340 ↓ 150.6 753 1

CTE Scan on error_codes_for_filtering e_8 (cost=0.00..20.29 rows=5 width=48) (actual time=0.002..2.340 rows=753 loops=1)

  • Filter: (subgroup = 'S21.G00.81'::text)
  • Rows Removed by Filter: 32914
137. 0.000 2.379 ↓ 0.0 0 1

Unique (cost=2,151.74..2,151.75 rows=1 width=48) (actual time=2.379..2.379 rows=0 loops=1)

138. 0.010 2.379 ↓ 0.0 0 1

Sort (cost=2,151.74..2,151.74 rows=1 width=48) (actual time=2.379..2.379 rows=0 loops=1)

  • Sort Key: "S21.G00.70"."S21.G00.30", e_9.code
  • Sort Method: quicksort Memory: 25kB
139. 0.010 2.369 ↓ 0.0 0 1

Hash Join (cost=20.39..2,151.73 rows=1 width=48) (actual time=2.369..2.369 rows=0 loops=1)

  • Hash Cond: ("S21.G00.70".id = e_9.id)
140. 0.027 0.096 ↑ 121.0 1 1

Hash Join (cost=0.03..2,130.91 rows=121 width=32) (actual time=0.096..0.096 rows=1 loops=1)

  • Hash Cond: ("S21.G00.70"."DECLARATION" = d_11.id)
141. 0.042 0.042 ↑ 348.3 106 1

Seq Scan on "S21.G00.70_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.70" (cost=0.00..1,991.21 rows=36,921 width=48) (actual time=0.013..0.042 rows=106 loops=1)

142. 0.008 0.027 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.027..0.027 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
143. 0.019 0.019 ↓ 35.0 35 1

CTE Scan on selected_declaration d_11 (cost=0.00..0.02 rows=1 width=16) (actual time=0.004..0.019 rows=35 loops=1)

144. 0.001 2.263 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.263..2.263 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
145. 2.262 2.262 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_9 (cost=0.00..20.29 rows=5 width=48) (actual time=2.262..2.262 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.70'::text)
  • Rows Removed by Filter: 33667
146. 0.001 2.286 ↓ 0.0 0 1

Unique (cost=34.81..34.82 rows=1 width=48) (actual time=2.285..2.286 rows=0 loops=1)

147. 0.009 2.285 ↓ 0.0 0 1

Sort (cost=34.81..34.82 rows=1 width=48) (actual time=2.285..2.285 rows=0 loops=1)

  • Sort Key: "S21.G00.6A"."S21.G00.30", e_10.code
  • Sort Method: quicksort Memory: 25kB
148. 0.000 2.276 ↓ 0.0 0 1

Hash Join (cost=14.48..34.80 rows=1 width=48) (actual time=2.276..2.276 rows=0 loops=1)

  • Hash Cond: (e_10.id = "S21.G00.6A".id)
149. 2.276 2.276 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_10 (cost=0.00..20.29 rows=5 width=48) (actual time=2.275..2.276 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.6A'::text)
  • Rows Removed by Filter: 33667
150. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.45..14.45 rows=2 width=32) (never executed)

151. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..14.45 rows=2 width=32) (never executed)

  • Hash Cond: ("S21.G00.6A"."DECLARATION" = d_12.id)
152. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.6A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.6A" (cost=0.00..13.20 rows=320 width=48) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

154. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_12 (cost=0.00..0.02 rows=1 width=16) (never executed)

155. 0.000 2.618 ↓ 0.0 0 1

Unique (cost=87.04..87.05 rows=1 width=48) (actual time=2.618..2.618 rows=0 loops=1)

156. 0.007 2.618 ↓ 0.0 0 1

Sort (cost=87.04..87.04 rows=1 width=48) (actual time=2.618..2.618 rows=0 loops=1)

  • Sort Key: "S21.G00.41"."S21.G00.30", e_11.code
  • Sort Method: quicksort Memory: 25kB
157. 0.012 2.611 ↓ 0.0 0 1

Hash Join (cost=20.39..87.03 rows=1 width=48) (actual time=2.611..2.611 rows=0 loops=1)

  • Hash Cond: ("S21.G00.41".id = e_11.id)
158. 0.128 0.345 ↑ 2.0 1 1

Hash Join (cost=0.03..66.65 rows=2 width=32) (actual time=0.345..0.345 rows=1 loops=1)

  • Hash Cond: ("S21.G00.41"."DECLARATION" = d_13.id)
159. 0.206 0.206 ↓ 1.9 916 1

Seq Scan on "S21.G00.41_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.41" (cost=0.00..64.80 rows=480 width=48) (actual time=0.015..0.206 rows=916 loops=1)

160. 0.007 0.011 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.011..0.011 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
161. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_13 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

162. 0.000 2.254 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.254..2.254 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
163. 2.254 2.254 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_11 (cost=0.00..20.29 rows=5 width=48) (actual time=2.254..2.254 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.41'::text)
  • Rows Removed by Filter: 33667
164. 0.129 23.859 ↓ 942.0 942 1

Unique (cost=3,763.22..3,763.23 rows=1 width=48) (actual time=23.694..23.859 rows=942 loops=1)

165. 0.341 23.730 ↓ 942.0 942 1

Sort (cost=3,763.22..3,763.23 rows=1 width=48) (actual time=23.693..23.730 rows=942 loops=1)

  • Sort Key: "S21.G00.51"."S21.G00.30", e_12.code
  • Sort Method: quicksort Memory: 98kB
166. 0.577 23.389 ↓ 942.0 942 1

Hash Join (cost=20.39..3,763.21 rows=1 width=48) (actual time=2.581..23.389 rows=942 loops=1)

  • Hash Cond: ("S21.G00.51".id = e_12.id)
167. 9.135 20.365 ↓ 23.5 5,284 1

Hash Join (cost=0.03..3,742.00 rows=225 width=32) (actual time=0.120..20.365 rows=5,284 loops=1)

  • Hash Cond: ("S21.G00.51"."DECLARATION" = d_14.id)
168. 11.219 11.219 ↓ 1.1 72,182 1

Seq Scan on "S21.G00.51_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.51" (cost=0.00..3,483.16 rows=68,416 width=48) (actual time=0.005..11.219 rows=72,182 loops=1)

169. 0.007 0.011 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.011..0.011 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
170. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_14 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.004 rows=35 loops=1)

171. 0.133 2.447 ↓ 188.4 942 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.447..2.447 rows=942 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 59kB
172. 2.314 2.314 ↓ 188.4 942 1

CTE Scan on error_codes_for_filtering e_12 (cost=0.00..20.29 rows=5 width=48) (actual time=0.003..2.314 rows=942 loops=1)

  • Filter: (subgroup = 'S21.G00.51'::text)
  • Rows Removed by Filter: 32725
173. 0.002 2.493 ↓ 7.0 7 1

Unique (cost=44.93..44.94 rows=1 width=48) (actual time=2.491..2.493 rows=7 loops=1)

174. 0.015 2.491 ↓ 9.0 9 1

Sort (cost=44.93..44.94 rows=1 width=48) (actual time=2.491..2.491 rows=9 loops=1)

  • Sort Key: "S21.G00.65"."S21.G00.30", e_13.code
  • Sort Method: quicksort Memory: 25kB
175. 0.011 2.476 ↓ 9.0 9 1

Hash Join (cost=20.39..44.92 rows=1 width=48) (actual time=2.454..2.476 rows=9 loops=1)

  • Hash Cond: ("S21.G00.65".id = e_13.id)
176. 0.059 0.137 ↓ 3.0 9 1

Hash Join (cost=0.03..24.54 rows=3 width=32) (actual time=0.117..0.137 rows=9 loops=1)

  • Hash Cond: ("S21.G00.65"."DECLARATION" = d_15.id)
177. 0.067 0.067 ↑ 1.6 332 1

Seq Scan on "S21.G00.65_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.65" (cost=0.00..22.44 rows=544 width=48) (actual time=0.009..0.067 rows=332 loops=1)

178. 0.007 0.011 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.011..0.011 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
179. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_15 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

180. 0.005 2.328 ↓ 1.8 9 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.328..2.328 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
181. 2.323 2.323 ↓ 1.8 9 1

CTE Scan on error_codes_for_filtering e_13 (cost=0.00..20.29 rows=5 width=48) (actual time=0.026..2.323 rows=9 loops=1)

  • Filter: (subgroup = 'S21.G00.65'::text)
  • Rows Removed by Filter: 33658
182. 0.001 2.347 ↓ 0.0 0 1

Hash Join (cost=0.03..20.36 rows=1 width=48) (actual time=2.347..2.347 rows=0 loops=1)

  • Hash Cond: (e_14.id = sd."S20.G00.05")
183. 2.346 2.346 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_14 (cost=0.00..20.29 rows=5 width=48) (actual time=2.346..2.346 rows=0 loops=1)

  • Filter: (subgroup = 'S20.G00.05'::text)
  • Rows Removed by Filter: 33667
184. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=32) (never executed)

185. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_data sd (cost=0.00..0.02 rows=1 width=32) (never executed)

186. 0.000 2.315 ↓ 0.0 0 1

Unique (cost=33.96..33.97 rows=1 width=48) (actual time=2.315..2.315 rows=0 loops=1)

187. 0.009 2.315 ↓ 0.0 0 1

Sort (cost=33.96..33.97 rows=1 width=48) (actual time=2.315..2.315 rows=0 loops=1)

  • Sort Key: "S21.G00.7A"."S21.G00.30", e_15.code
  • Sort Method: quicksort Memory: 25kB
188. 0.000 2.306 ↓ 0.0 0 1

Hash Join (cost=13.63..33.95 rows=1 width=48) (actual time=2.306..2.306 rows=0 loops=1)

  • Hash Cond: (e_15.id = "S21.G00.7A".id)
189. 2.306 2.306 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_15 (cost=0.00..20.29 rows=5 width=48) (actual time=2.306..2.306 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.7A'::text)
  • Rows Removed by Filter: 33667
190. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.62..13.62 rows=1 width=32) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..13.62 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.7A"."DECLARATION" = d_16.id)
192. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.7A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.7A" (cost=0.00..12.60 rows=260 width=48) (never executed)

193. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

194. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_16 (cost=0.00..0.02 rows=1 width=16) (never executed)

195. 0.001 2.341 ↓ 0.0 0 1

Unique (cost=34.54..34.55 rows=1 width=48) (actual time=2.341..2.341 rows=0 loops=1)

196. 0.007 2.340 ↓ 0.0 0 1

Sort (cost=34.54..34.54 rows=1 width=48) (actual time=2.340..2.340 rows=0 loops=1)

  • Sort Key: "S21.G00.7B"."S21.G00.30", e_16.code
  • Sort Method: quicksort Memory: 25kB
197. 0.000 2.333 ↓ 0.0 0 1

Hash Join (cost=14.20..34.53 rows=1 width=48) (actual time=2.333..2.333 rows=0 loops=1)

  • Hash Cond: (e_16.id = "S21.G00.7B".id)
198. 2.333 2.333 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_16 (cost=0.00..20.29 rows=5 width=48) (actual time=2.333..2.333 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.7B'::text)
  • Rows Removed by Filter: 33667
199. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.18..14.18 rows=2 width=32) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..14.18 rows=2 width=32) (never executed)

  • Hash Cond: ("S21.G00.7B"."DECLARATION" = d_17.id)
201. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.7B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.7B" (cost=0.00..13.00 rows=300 width=48) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

203. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_17 (cost=0.00..0.02 rows=1 width=16) (never executed)

204. 0.000 2.303 ↓ 0.0 0 1

Unique (cost=32.86..32.87 rows=1 width=48) (actual time=2.303..2.303 rows=0 loops=1)

205. 0.008 2.303 ↓ 0.0 0 1

Sort (cost=32.86..32.87 rows=1 width=48) (actual time=2.303..2.303 rows=0 loops=1)

  • Sort Key: "S21.G00.56"."S21.G00.30", e_17.code
  • Sort Method: quicksort Memory: 25kB
206. 0.002 2.295 ↓ 0.0 0 1

Hash Join (cost=12.53..32.85 rows=1 width=48) (actual time=2.295..2.295 rows=0 loops=1)

  • Hash Cond: (e_17.id = "S21.G00.56".id)
207. 2.293 2.293 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_17 (cost=0.00..20.29 rows=5 width=48) (actual time=2.293..2.293 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.56'::text)
  • Rows Removed by Filter: 33667
208. 0.000 0.000 ↓ 0.0 0

Hash (cost=12.52..12.52 rows=1 width=32) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..12.52 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.56"."DECLARATION" = d_18.id)
210. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.56_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.56" (cost=0.00..11.80 rows=180 width=48) (never executed)

211. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

212. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_18 (cost=0.00..0.02 rows=1 width=16) (never executed)

213. 0.067 7.446 ↓ 496.0 496 1

Unique (cost=876.62..876.63 rows=1 width=48) (actual time=7.361..7.446 rows=496 loops=1)

214. 0.170 7.379 ↓ 496.0 496 1

Sort (cost=876.62..876.62 rows=1 width=48) (actual time=7.361..7.379 rows=496 loops=1)

  • Sort Key: "S21.G00.50"."S21.G00.30", e_18.code
  • Sort Method: quicksort Memory: 63kB
215. 0.159 7.209 ↓ 496.0 496 1

Hash Join (cost=20.39..876.61 rows=1 width=48) (actual time=6.141..7.209 rows=496 loops=1)

  • Hash Cond: ("S21.G00.50".id = e_18.id)
216. 1.978 4.609 ↓ 20.2 1,150 1

Hash Join (cost=0.03..856.02 rows=57 width=32) (actual time=3.684..4.609 rows=1,150 loops=1)

  • Hash Cond: ("S21.G00.50"."DECLARATION" = d_19.id)
217. 2.621 2.621 ↑ 1.0 16,736 1

Seq Scan on "S21.G00.50_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.50" (cost=0.00..790.67 rows=17,267 width=48) (actual time=0.011..2.621 rows=16,736 loops=1)

218. 0.006 0.010 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.010..0.010 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
219. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_19 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.004 rows=35 loops=1)

220. 0.068 2.441 ↓ 99.2 496 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.441..2.441 rows=496 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
221. 2.373 2.373 ↓ 99.2 496 1

CTE Scan on error_codes_for_filtering e_18 (cost=0.00..20.29 rows=5 width=48) (actual time=0.001..2.373 rows=496 loops=1)

  • Filter: (subgroup = 'S21.G00.50'::text)
  • Rows Removed by Filter: 33171
222. 0.000 2.292 ↓ 0.0 0 1

Hash Join (cost=0.03..20.36 rows=1 width=48) (actual time=2.292..2.292 rows=0 loops=1)

  • Hash Cond: (e_19.id = sd_1."S10.G00.00")
223. 2.292 2.292 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_19 (cost=0.00..20.29 rows=5 width=48) (actual time=2.292..2.292 rows=0 loops=1)

  • Filter: (subgroup = 'S10.G00.00'::text)
  • Rows Removed by Filter: 33667
224. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=32) (never executed)

225. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_data sd_1 (cost=0.00..0.02 rows=1 width=32) (never executed)

226. 0.249 8.117 ↓ 2,514.0 2,514 1

Hash Join (cost=0.03..20.36 rows=1 width=48) (actual time=5.556..8.117 rows=2,514 loops=1)

  • Hash Cond: (e_20.id = sd_2."S21.G00.11")
227. 2.326 2.326 ↓ 6.4 32 1

CTE Scan on error_codes_for_filtering e_20 (cost=0.00..20.29 rows=5 width=48) (actual time=0.002..2.326 rows=32 loops=1)

  • Filter: (subgroup = 'S21.G00.11'::text)
  • Rows Removed by Filter: 33635
228. 0.182 5.542 ↓ 1,144.0 1,144 1

Hash (cost=0.02..0.02 rows=1 width=32) (actual time=5.542..5.542 rows=1,144 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 88kB
229. 5.360 5.360 ↓ 1,144.0 1,144 1

CTE Scan on selected_data sd_2 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..5.360 rows=1,144 loops=1)

230. 0.339 42.716 ↓ 2,554.0 2,554 1

Unique (cost=6,781.51..6,781.52 rows=1 width=48) (actual time=42.272..42.716 rows=2,554 loops=1)

231. 1.106 42.377 ↓ 2,554.0 2,554 1

Sort (cost=6,781.51..6,781.52 rows=1 width=48) (actual time=42.270..42.377 rows=2,554 loops=1)

  • Sort Key: "S21.G00.78"."S21.G00.30", e_21.code
  • Sort Method: quicksort Memory: 296kB
232. 1.111 41.271 ↓ 2,554.0 2,554 1

Hash Join (cost=20.39..6,781.50 rows=1 width=48) (actual time=15.878..41.271 rows=2,554 loops=1)

  • Hash Cond: ("S21.G00.78".id = e_21.id)
233. 16.108 37.313 ↓ 20.2 8,713 1

Hash Join (cost=0.03..6,759.52 rows=431 width=32) (actual time=13.018..37.313 rows=8,713 loops=1)

  • Hash Cond: ("S21.G00.78"."DECLARATION" = d_20.id)
234. 21.195 21.195 ↑ 1.0 131,431 1

Seq Scan on "S21.G00.78_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.78" (cost=0.00..6,262.31 rows=131,431 width=48) (actual time=0.015..21.195 rows=131,431 loops=1)

235. 0.006 0.010 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.010..0.010 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
236. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_20 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

237. 0.373 2.847 ↓ 510.8 2,554 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.847..2.847 rows=2,554 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 170kB
238. 2.474 2.474 ↓ 510.8 2,554 1

CTE Scan on error_codes_for_filtering e_21 (cost=0.00..20.29 rows=5 width=48) (actual time=0.002..2.474 rows=2,554 loops=1)

  • Filter: (subgroup = 'S21.G00.78'::text)
  • Rows Removed by Filter: 31113
239. 2.420 891.306 ↓ 3,020.0 3,020 1

Unique (cost=174,062.31..174,062.32 rows=1 width=48) (actual time=887.706..891.306 rows=3,020 loops=1)

240. 12.188 888.886 ↓ 28,197.0 28,197 1

Sort (cost=174,062.31..174,062.32 rows=1 width=48) (actual time=887.705..888.886 rows=28,197 loops=1)

  • Sort Key: "S21.G00.3B"."S21.G00.30", e_22.code
  • Sort Method: quicksort Memory: 2971kB
241. 44.229 876.698 ↓ 28,197.0 28,197 1

Hash Join (cost=20.39..174,062.30 rows=1 width=48) (actual time=600.903..876.698 rows=28,197 loops=1)

  • Hash Cond: ("S21.G00.3B".id = e_22.id)
242. 377.854 824.243 ↓ 33.5 364,320 1

Hash Join (cost=0.03..174,001.11 rows=10,887 width=32) (actual time=592.644..824.243 rows=364,320 loops=1)

  • Hash Cond: ("S21.G00.3B"."DECLARATION" = d_21.id)
243. 446.378 446.378 ↓ 1.0 2,645,610 1

Seq Scan on "S21.G00.3B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.3B" (cost=0.00..164,012.06 rows=2,634,706 width=48) (actual time=0.011..446.378 rows=2,645,610 loops=1)

244. 0.007 0.011 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.011..0.011 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
245. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_21 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

246. 3.963 8.226 ↓ 5,639.4 28,197 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=8.226..8.226 rows=28,197 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1771kB
247. 4.263 4.263 ↓ 5,639.4 28,197 1

CTE Scan on error_codes_for_filtering e_22 (cost=0.00..20.29 rows=5 width=48) (actual time=0.005..4.263 rows=28,197 loops=1)

  • Filter: (subgroup = 'S21.G00.3B'::text)
  • Rows Removed by Filter: 5470
248. 0.000 3.738 ↓ 0.0 0 1

Unique (cost=4,265.25..4,265.26 rows=1 width=48) (actual time=3.738..3.738 rows=0 loops=1)

249. 0.012 3.738 ↓ 0.0 0 1

Sort (cost=4,265.25..4,265.26 rows=1 width=48) (actual time=3.738..3.738 rows=0 loops=1)

  • Sort Key: "S21.G00.79"."S21.G00.30", e_23.code
  • Sort Method: quicksort Memory: 25kB
250. 0.003 3.726 ↓ 0.0 0 1

Hash Join (cost=20.39..4,265.24 rows=1 width=48) (actual time=3.726..3.726 rows=0 loops=1)

  • Hash Cond: ("S21.G00.79".id = e_23.id)
251. 0.686 1.448 ↑ 286.0 1 1

Hash Join (cost=0.03..4,243.80 rows=286 width=32) (actual time=1.448..1.448 rows=1 loops=1)

  • Hash Cond: ("S21.G00.79"."DECLARATION" = d_22.id)
252. 0.751 0.751 ↑ 13.9 6,222 1

Seq Scan on "S21.G00.79_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.79" (cost=0.00..3,915.57 rows=86,757 width=48) (actual time=0.009..0.751 rows=6,222 loops=1)

253. 0.005 0.011 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.011..0.011 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
254. 0.006 0.006 ↓ 35.0 35 1

CTE Scan on selected_declaration d_22 (cost=0.00..0.02 rows=1 width=16) (actual time=0.002..0.006 rows=35 loops=1)

255. 0.001 2.275 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.275..2.275 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
256. 2.274 2.274 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_23 (cost=0.00..20.29 rows=5 width=48) (actual time=2.274..2.274 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.79'::text)
  • Rows Removed by Filter: 33667
257. 0.000 2.248 ↓ 0.0 0 1

Hash Join (cost=0.03..20.36 rows=1 width=48) (actual time=2.248..2.248 rows=0 loops=1)

  • Hash Cond: (e_24.id = sd_3."S21.G00.06")
258. 2.248 2.248 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_24 (cost=0.00..20.29 rows=5 width=48) (actual time=2.248..2.248 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.06'::text)
  • Rows Removed by Filter: 33667
259. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=32) (never executed)

260. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_data sd_3 (cost=0.00..0.02 rows=1 width=32) (never executed)

261. 0.076 2.640 ↓ 338.0 338 1

Hash Join (cost=0.03..20.36 rows=1 width=48) (actual time=0.258..2.640 rows=338 loops=1)

  • Hash Cond: (e_25.id = sd_4.id)
262. 2.313 2.313 ↓ 68.6 343 1

CTE Scan on error_codes_for_filtering e_25 (cost=0.00..20.29 rows=5 width=48) (actual time=0.002..2.313 rows=343 loops=1)

  • Filter: (subgroup = 'S21.G00.30'::text)
  • Rows Removed by Filter: 33324
263. 0.121 0.251 ↓ 1,144.0 1,144 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.251..0.251 rows=1,144 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 70kB
264. 0.130 0.130 ↓ 1,144.0 1,144 1

CTE Scan on selected_data sd_4 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.130 rows=1,144 loops=1)

265. 0.000 2.230 ↓ 0.0 0 1

Unique (cost=33.83..33.84 rows=1 width=48) (actual time=2.230..2.230 rows=0 loops=1)

266. 0.004 2.230 ↓ 0.0 0 1

Sort (cost=33.83..33.83 rows=1 width=48) (actual time=2.230..2.230 rows=0 loops=1)

  • Sort Key: "S21.G00.31"."S21.G00.30", e_26.code
  • Sort Method: quicksort Memory: 25kB
267. 0.000 2.226 ↓ 0.0 0 1

Hash Join (cost=13.49..33.82 rows=1 width=48) (actual time=2.226..2.226 rows=0 loops=1)

  • Hash Cond: (e_26.id = "S21.G00.31".id)
268. 2.226 2.226 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_26 (cost=0.00..20.29 rows=5 width=48) (actual time=2.226..2.226 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.31'::text)
  • Rows Removed by Filter: 33667
269. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.48..13.48 rows=1 width=32) (never executed)

270. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..13.48 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.31"."DECLARATION" = d_23.id)
271. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.31_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.31" (cost=0.00..12.50 rows=250 width=48) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

273. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_23 (cost=0.00..0.02 rows=1 width=16) (never executed)

274. 0.002 4.058 ↓ 4.0 4 1

Unique (cost=495.07..495.08 rows=1 width=48) (actual time=4.057..4.058 rows=4 loops=1)

275. 0.006 4.056 ↓ 4.0 4 1

Sort (cost=495.07..495.07 rows=1 width=48) (actual time=4.056..4.056 rows=4 loops=1)

  • Sort Key: "S21.G00.52"."S21.G00.30", e_27.code
  • Sort Method: quicksort Memory: 25kB
276. 0.035 4.050 ↓ 4.0 4 1

Hash Join (cost=20.39..495.06 rows=1 width=48) (actual time=3.691..4.050 rows=4 loops=1)

  • Hash Cond: ("S21.G00.52".id = e_27.id)
277. 0.680 1.770 ↓ 9.8 420 1

Hash Join (cost=0.03..474.53 rows=43 width=32) (actual time=1.401..1.770 rows=420 loops=1)

  • Hash Cond: ("S21.G00.52"."DECLARATION" = d_24.id)
278. 1.081 1.081 ↑ 1.1 4,970 1

Seq Scan on "S21.G00.52_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.52" (cost=0.00..453.05 rows=5,605 width=48) (actual time=0.005..1.081 rows=4,970 loops=1)

279. 0.004 0.009 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.009..0.009 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
280. 0.005 0.005 ↓ 35.0 35 1

CTE Scan on selected_declaration d_24 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.005 rows=35 loops=1)

281. 0.002 2.245 ↑ 1.2 4 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.245..2.245 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
282. 2.243 2.243 ↑ 1.2 4 1

CTE Scan on error_codes_for_filtering e_27 (cost=0.00..20.29 rows=5 width=48) (actual time=0.006..2.243 rows=4 loops=1)

  • Filter: (subgroup = 'S21.G00.52'::text)
  • Rows Removed by Filter: 33663
283. 0.000 2.341 ↓ 0.0 0 1

Unique (cost=33.96..33.97 rows=1 width=48) (actual time=2.341..2.341 rows=0 loops=1)

284. 0.015 2.341 ↓ 0.0 0 1

Sort (cost=33.96..33.97 rows=1 width=48) (actual time=2.341..2.341 rows=0 loops=1)

  • Sort Key: "S21.G00.5A"."S21.G00.30", e_28.code
  • Sort Method: quicksort Memory: 25kB
285. 0.001 2.326 ↓ 0.0 0 1

Hash Join (cost=13.63..33.95 rows=1 width=48) (actual time=2.326..2.326 rows=0 loops=1)

  • Hash Cond: (e_28.id = "S21.G00.5A".id)
286. 2.325 2.325 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_28 (cost=0.00..20.29 rows=5 width=48) (actual time=2.325..2.325 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.5A'::text)
  • Rows Removed by Filter: 33667
287. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.62..13.62 rows=1 width=32) (never executed)

288. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..13.62 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.5A"."DECLARATION" = d_25.id)
289. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.5A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5A" (cost=0.00..12.60 rows=260 width=48) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

291. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_25 (cost=0.00..0.02 rows=1 width=16) (never executed)

292. 0.000 4.365 ↓ 0.0 0 1

Unique (cost=600.42..600.43 rows=1 width=48) (actual time=4.365..4.365 rows=0 loops=1)

293. 0.003 4.365 ↓ 0.0 0 1

Sort (cost=600.42..600.42 rows=1 width=48) (actual time=4.365..4.365 rows=0 loops=1)

  • Sort Key: "S21.G00.54"."S21.G00.30", e_29.code
  • Sort Method: quicksort Memory: 25kB
294. 0.011 4.362 ↓ 0.0 0 1

Hash Join (cost=20.39..600.41 rows=1 width=48) (actual time=4.362..4.362 rows=0 loops=1)

  • Hash Cond: ("S21.G00.54".id = e_29.id)
295. 0.859 2.067 ↑ 60.0 1 1

Hash Join (cost=0.03..579.82 rows=60 width=32) (actual time=2.067..2.067 rows=1 loops=1)

  • Hash Cond: ("S21.G00.54"."DECLARATION" = d_26.id)
296. 1.197 1.197 ↑ 1.5 8,508 1

Seq Scan on "S21.G00.54_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.54" (cost=0.00..530.86 rows=12,886 width=48) (actual time=0.005..1.197 rows=8,508 loops=1)

297. 0.007 0.011 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.011..0.011 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
298. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_26 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.004 rows=35 loops=1)

299. 0.000 2.284 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.284..2.284 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
300. 2.284 2.284 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_29 (cost=0.00..20.29 rows=5 width=48) (actual time=2.284..2.284 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.54'::text)
  • Rows Removed by Filter: 33667
301. 0.018 8.987 ↓ 116.0 116 1

Unique (cost=1,615.75..1,615.76 rows=1 width=48) (actual time=8.965..8.987 rows=116 loops=1)

302. 0.046 8.969 ↓ 116.0 116 1

Sort (cost=1,615.75..1,615.75 rows=1 width=48) (actual time=8.964..8.969 rows=116 loops=1)

  • Sort Key: "S21.G00.40"."S21.G00.30", e_30.code
  • Sort Method: quicksort Memory: 34kB
303. 0.119 8.923 ↓ 116.0 116 1

Hash Join (cost=20.39..1,615.74 rows=1 width=48) (actual time=2.412..8.923 rows=116 loops=1)

  • Hash Cond: ("S21.G00.40".id = e_30.id)
304. 2.721 6.487 ↓ 18.3 1,150 1

Hash Join (cost=0.03..1,595.13 rows=63 width=32) (actual time=0.083..6.487 rows=1,150 loops=1)

  • Hash Cond: ("S21.G00.40"."DECLARATION" = d_27.id)
305. 3.752 3.752 ↑ 1.2 16,736 1

Seq Scan on "S21.G00.40_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.40" (cost=0.00..1,522.07 rows=19,307 width=48) (actual time=0.059..3.752 rows=16,736 loops=1)

306. 0.010 0.014 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.014..0.014 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
307. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_27 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

308. 0.018 2.317 ↓ 23.2 116 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.317..2.317 rows=116 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
309. 2.299 2.299 ↓ 23.2 116 1

CTE Scan on error_codes_for_filtering e_30 (cost=0.00..20.29 rows=5 width=48) (actual time=0.005..2.299 rows=116 loops=1)

  • Filter: (subgroup = 'S21.G00.40'::text)
  • Rows Removed by Filter: 33551
310. 0.002 2.495 ↓ 11.0 11 1

Unique (cost=40.59..40.60 rows=1 width=48) (actual time=2.493..2.495 rows=11 loops=1)

311. 0.014 2.493 ↓ 13.0 13 1

Sort (cost=40.59..40.60 rows=1 width=48) (actual time=2.492..2.493 rows=13 loops=1)

  • Sort Key: "S21.G00.60"."S21.G00.30", e_31.code
  • Sort Method: quicksort Memory: 26kB
312. 0.014 2.479 ↓ 13.0 13 1

Hash Join (cost=20.26..40.58 rows=1 width=48) (actual time=0.125..2.479 rows=13 loops=1)

  • Hash Cond: (e_31.id = "S21.G00.60".id)
313. 2.351 2.351 ↓ 2.6 13 1

CTE Scan on error_codes_for_filtering e_31 (cost=0.00..20.29 rows=5 width=48) (actual time=0.001..2.351 rows=13 loops=1)

  • Filter: (subgroup = 'S21.G00.60'::text)
  • Rows Removed by Filter: 33654
314. 0.008 0.114 ↓ 21.0 42 1

Hash (cost=20.23..20.23 rows=2 width=32) (actual time=0.114..0.114 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
315. 0.042 0.106 ↓ 21.0 42 1

Hash Join (cost=0.03..20.23 rows=2 width=32) (actual time=0.042..0.106 rows=42 loops=1)

  • Hash Cond: ("S21.G00.60"."DECLARATION" = d_28.id)
316. 0.055 0.055 ↑ 1.6 195 1

Seq Scan on "S21.G00.60_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.60" (cost=0.00..19.04 rows=304 width=48) (actual time=0.021..0.055 rows=195 loops=1)

317. 0.005 0.009 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.009..0.009 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
318. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_28 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.004 rows=35 loops=1)

319. 0.000 2.253 ↓ 0.0 0 1

Unique (cost=33.41..33.42 rows=1 width=48) (actual time=2.253..2.253 rows=0 loops=1)

320. 0.009 2.253 ↓ 0.0 0 1

Sort (cost=33.41..33.42 rows=1 width=48) (actual time=2.253..2.253 rows=0 loops=1)

  • Sort Key: "S21.G00.8A"."S21.G00.30", e_32.code
  • Sort Method: quicksort Memory: 25kB
321. 0.001 2.244 ↓ 0.0 0 1

Hash Join (cost=13.08..33.40 rows=1 width=48) (actual time=2.243..2.244 rows=0 loops=1)

  • Hash Cond: (e_32.id = "S21.G00.8A".id)
322. 2.243 2.243 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_32 (cost=0.00..20.29 rows=5 width=48) (actual time=2.243..2.243 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.8A'::text)
  • Rows Removed by Filter: 33667
323. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.07..13.07 rows=1 width=32) (never executed)

324. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..13.07 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.8A"."DECLARATION" = d_29.id)
325. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.8A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.8A" (cost=0.00..12.20 rows=220 width=48) (never executed)

326. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

327. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_29 (cost=0.00..0.02 rows=1 width=16) (never executed)

328. 0.000 2.491 ↓ 0.0 0 1

Unique (cost=80.96..80.97 rows=1 width=48) (actual time=2.491..2.491 rows=0 loops=1)

329. 0.007 2.491 ↓ 0.0 0 1

Sort (cost=80.96..80.97 rows=1 width=48) (actual time=2.491..2.491 rows=0 loops=1)

  • Sort Key: "S21.G00.34"."S21.G00.30", e_33.code
  • Sort Method: quicksort Memory: 25kB
330. 0.010 2.484 ↓ 0.0 0 1

Hash Join (cost=20.39..80.95 rows=1 width=48) (actual time=2.484..2.484 rows=0 loops=1)

  • Hash Cond: ("S21.G00.34".id = e_33.id)
331. 0.065 0.178 ↑ 6.0 1 1

Hash Join (cost=0.03..60.56 rows=6 width=32) (actual time=0.178..0.178 rows=1 loops=1)

  • Hash Cond: ("S21.G00.34"."DECLARATION" = d_30.id)
332. 0.104 0.104 ↑ 2.7 416 1

Seq Scan on "S21.G00.34_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.34" (cost=0.00..56.25 rows=1,125 width=48) (actual time=0.008..0.104 rows=416 loops=1)

333. 0.005 0.009 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.009..0.009 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
334. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_30 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.004 rows=35 loops=1)

335. 0.001 2.296 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.296..2.296 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
336. 2.295 2.295 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_33 (cost=0.00..20.29 rows=5 width=48) (actual time=2.295..2.295 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.34'::text)
  • Rows Removed by Filter: 33667
337. 0.001 5.978 ↓ 0.0 0 1

Unique (cost=859.82..859.83 rows=1 width=48) (actual time=5.978..5.978 rows=0 loops=1)

338. 0.008 5.977 ↓ 0.0 0 1

Sort (cost=859.82..859.83 rows=1 width=48) (actual time=5.977..5.977 rows=0 loops=1)

  • Sort Key: "S21.G00.71"."S21.G00.30", e_34.code
  • Sort Method: quicksort Memory: 25kB
339. 0.009 5.969 ↓ 0.0 0 1

Hash Join (cost=20.39..859.81 rows=1 width=48) (actual time=5.969..5.969 rows=0 loops=1)

  • Hash Cond: ("S21.G00.71".id = e_34.id)
340. 1.720 3.602 ↑ 57.0 1 1

Hash Join (cost=0.03..839.23 rows=57 width=32) (actual time=3.601..3.602 rows=1 loops=1)

  • Hash Cond: ("S21.G00.71"."DECLARATION" = d_31.id)
341. 1.873 1.873 ↑ 1.3 13,367 1

Seq Scan on "S21.G00.71_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.71" (cost=0.00..773.82 rows=17,282 width=48) (actual time=0.005..1.873 rows=13,367 loops=1)

342. 0.005 0.009 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.009..0.009 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
343. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_31 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

344. 0.000 2.358 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.358..2.358 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
345. 2.358 2.358 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_34 (cost=0.00..20.29 rows=5 width=48) (actual time=2.358..2.358 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.71'::text)
  • Rows Removed by Filter: 33667
346. 0.000 2.351 ↓ 0.0 0 1

Unique (cost=1,030.25..1,030.26 rows=1 width=48) (actual time=2.351..2.351 rows=0 loops=1)

347. 0.008 2.351 ↓ 0.0 0 1

Sort (cost=1,030.25..1,030.25 rows=1 width=48) (actual time=2.351..2.351 rows=0 loops=1)

  • Sort Key: "S21.G00.86"."S21.G00.30", e_35.code
  • Sort Method: quicksort Memory: 25kB
348. 0.010 2.343 ↓ 0.0 0 1

Hash Join (cost=20.39..1,030.24 rows=1 width=48) (actual time=2.343..2.343 rows=0 loops=1)

  • Hash Cond: ("S21.G00.86".id = e_35.id)
349. 0.036 0.082 ↑ 50.0 1 1

Hash Join (cost=0.03..1,009.68 rows=50 width=32) (actual time=0.082..0.082 rows=1 loops=1)

  • Hash Cond: ("S21.G00.86"."DECLARATION" = d_32.id)
350. 0.037 0.037 ↑ 67.0 227 1

Seq Scan on "S21.G00.86_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.86" (cost=0.00..952.11 rows=15,211 width=48) (actual time=0.008..0.037 rows=227 loops=1)

351. 0.005 0.009 ↓ 35.0 35 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.009..0.009 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
352. 0.004 0.004 ↓ 35.0 35 1

CTE Scan on selected_declaration d_32 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.004 rows=35 loops=1)

353. 0.000 2.251 ↓ 0.0 0 1

Hash (cost=20.29..20.29 rows=5 width=48) (actual time=2.251..2.251 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
354. 2.251 2.251 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_35 (cost=0.00..20.29 rows=5 width=48) (actual time=2.251..2.251 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.86'::text)
  • Rows Removed by Filter: 33667
355. 0.000 2.252 ↓ 0.0 0 1

Unique (cost=33.83..33.84 rows=1 width=48) (actual time=2.252..2.252 rows=0 loops=1)

356. 0.009 2.252 ↓ 0.0 0 1

Sort (cost=33.83..33.83 rows=1 width=48) (actual time=2.252..2.252 rows=0 loops=1)

  • Sort Key: "S21.G00.5C"."S21.G00.30", e_36.code
  • Sort Method: quicksort Memory: 25kB
357. 0.001 2.243 ↓ 0.0 0 1

Hash Join (cost=13.49..33.82 rows=1 width=48) (actual time=2.243..2.243 rows=0 loops=1)

  • Hash Cond: (e_36.id = "S21.G00.5C".id)
358. 2.242 2.242 ↓ 0.0 0 1

CTE Scan on error_codes_for_filtering e_36 (cost=0.00..20.29 rows=5 width=48) (actual time=2.242..2.242 rows=0 loops=1)

  • Filter: (subgroup = 'S21.G00.5C'::text)
  • Rows Removed by Filter: 33667
359. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.48..13.48 rows=1 width=32) (never executed)

360. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.03..13.48 rows=1 width=32) (never executed)

  • Hash Cond: ("S21.G00.5C"."DECLARATION" = d_33.id)
361. 0.000 0.000 ↓ 0.0 0

Seq Scan on "S21.G00.5C_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5C" (cost=0.00..12.50 rows=250 width=48) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.02..0.02 rows=1 width=16) (never executed)

363. 0.000 0.000 ↓ 0.0 0

CTE Scan on selected_declaration d_33 (cost=0.00..0.02 rows=1 width=16) (never executed)

364.          

Initplan (forResult)

365. 0.069 2,227.936 ↑ 1.0 1 1

Aggregate (cost=1.18..1.19 rows=1 width=32) (actual time=2,227.936..2,227.936 rows=1 loops=1)

366. 0.209 2,227.867 ↓ 1,144.0 1,144 1

Hash Semi Join (cost=1.14..1.17 rows=1 width=32) (actual time=2,227.593..2,227.867 rows=1,144 loops=1)

  • Hash Cond: (selected_data.id = selected_data_by_code.id)
367. 822.678 822.678 ↓ 1,144.0 1,144 1

CTE Scan on selected_data (cost=0.00..0.02 rows=1 width=48) (actual time=822.593..822.678 rows=1,144 loops=1)

368. 1.395 1,404.980 ↓ 312.3 10,929 1

Hash (cost=0.70..0.70 rows=35 width=16) (actual time=1,404.980..1,404.980 rows=10,929 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 641kB
369. 1,403.585 1,403.585 ↓ 312.3 10,929 1

CTE Scan on selected_data_by_code (cost=0.00..0.70 rows=35 width=16) (actual time=319.710..1,403.585 rows=10,929 loops=1)

370. 0.334 0.404 ↑ 1.0 1 1

Aggregate (cost=0.02..0.04 rows=1 width=32) (actual time=0.404..0.404 rows=1 loops=1)

371. 0.070 0.070 ↓ 1,144.0 1,144 1

CTE Scan on selected_data selected_data_1 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.070 rows=1,144 loops=1)