explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h31

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 9,635.563 ↑ 1.0 1 1

Result (cost=3,125.23..3,125.24 rows=1 width=192) (actual time=9,635.562..9,635.563 rows=1 loops=1)

2.          

CTE selected_file

3. 0.022 1.126 ↓ 70.0 70 1

Unique (cost=4.54..4.55 rows=1 width=16) (actual time=1.095..1.126 rows=70 loops=1)

4. 0.075 1.104 ↓ 70.0 70 1

Sort (cost=4.54..4.54 rows=1 width=16) (actual time=1.094..1.104 rows=70 loops=1)

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

Nested Loop (cost=0.42..4.53 rows=1 width=16) (actual time=0.071..1.029 rows=70 loops=1)

6. 0.040 0.567 ↓ 70.0 70 1

Nested Loop (cost=0.42..4.47 rows=1 width=16) (actual time=0.062..0.567 rows=70 loops=1)

7. 0.282 0.282 ↓ 35.0 35 1

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

  • 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
8. 0.245 0.245 ↓ 2.0 2 35

Index Scan using "association_DECLARATION_idx" on association a (cost=0.00..2.02 rows=1 width=32) (actual time=0.005..0.007 rows=2 loops=35)

  • Index Cond: ("DECLARATION" = d.id)
9. 0.420 0.420 ↑ 1.0 1 70

Index Scan using file_id_idx on file f (cost=0.00..0.06 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=70)

  • Index Cond: (id = a."FILE")
  • Filter: (NOT "toBeDeleted")
10.          

CTE selected_declaration

11. 0.017 2.174 ↓ 35.0 35 1

Unique (cost=2.86..2.87 rows=1 width=20) (actual time=2.150..2.174 rows=35 loops=1)

12. 0.079 2.157 ↓ 70.0 70 1

Sort (cost=2.86..2.87 rows=1 width=20) (actual time=2.149..2.157 rows=70 loops=1)

  • Sort Key: d_1.id
  • Sort Method: quicksort Memory: 30kB
13. 0.030 2.078 ↓ 70.0 70 1

Nested Loop (cost=0.42..2.85 rows=1 width=20) (actual time=1.133..2.078 rows=70 loops=1)

14. 0.061 1.768 ↓ 14.0 70 1

Nested Loop (cost=0.42..2.58 rows=5 width=16) (actual time=1.126..1.768 rows=70 loops=1)

15. 1.147 1.147 ↓ 70.0 70 1

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

16. 0.560 0.560 ↑ 5.0 1 70

Index Only Scan using "association_FILE_DECLARATION_fraction_scope_idx" on association a_1 (cost=0.42..2.51 rows=5 width=32) (actual time=0.008..0.008 rows=1 loops=70)

  • Index Cond: ("FILE" = f_1.id)
  • Heap Fetches: 70
17. 0.280 0.280 ↑ 1.0 1 70

Index Scan using declaration_id_idx on declaration d_1 (cost=0.00..0.05 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=70)

  • Index Cond: (id = a_1."DECLARATION")
  • Filter: (("NEXT_SERIAL" IS NULL) AND ("ORGANIZATION" = '9faf476a-cef8-46a7-9afe-bffae9337e46'::uuid) AND (date = '2018-10-01'::date))
18.          

CTE the_dates

19. 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)

20.          

CTE error_values

21. 0.264 26.602 ↓ 12.3 296 1

GroupAggregate (cost=1,056.85..1,058.11 rows=24 width=112) (actual time=26.327..26.602 rows=296 loops=1)

  • Group Key: e."rowId
22. 0.231 26.338 ↓ 14.3 343 1

Sort (cost=1,056.85..1,056.91 rows=24 width=114) (actual time=26.314..26.338 rows=343 loops=1)

  • Sort Key: e."rowId
  • Sort Method: quicksort Memory: 42kB
23. 0.052 26.107 ↓ 14.3 343 1

Nested Loop (cost=0.00..1,056.30 rows=24 width=114) (actual time=0.016..26.107 rows=343 loops=1)

24. 0.015 0.015 ↓ 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.015 rows=70 loops=1)

25. 26.040 26.040 ↑ 4.8 5 70

Index Scan using "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_FILE_idx" on "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" e (cost=0.00..1,056.04 rows=24 width=130) (actual time=0.077..0.372 rows=5 loops=70)

  • Index Cond: ("FILE" = f_2.id)
  • Filter: (subgroup = 'S21.G00.30'::text)
  • Rows Removed by Filter: 476
26.          

CTE selection8_165

27. 0.002 0.036 ↑ 1.0 1 1

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

28.          

Initplan (forResult)

29. 0.034 0.034 ↓ 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.034..0.034 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
30.          

CTE f11_165

31. 0.010 0.566 ↓ 17.0 34 1

Unique (cost=7.22..7.23 rows=2 width=16) (actual time=0.554..0.566 rows=34 loops=1)

32. 0.032 0.556 ↓ 17.0 34 1

Sort (cost=7.22..7.22 rows=2 width=16) (actual time=0.553..0.556 rows=34 loops=1)

  • Sort Key: "S21.G00.11".id
  • Sort Method: quicksort Memory: 26kB
33. 0.080 0.524 ↓ 17.0 34 1

Nested Loop Left Join (cost=1.57..7.21 rows=2 width=16) (actual time=0.097..0.524 rows=34 loops=1)

  • Filter: (NOT (hashed SubPlan 7))
  • Rows Removed by Filter: 1
34. 0.016 0.352 ↓ 8.8 35 1

Nested Loop (cost=0.00..5.16 rows=4 width=96) (actual time=0.051..0.352 rows=35 loops=1)

35. 0.007 0.091 ↓ 35.0 35 1

Nested Loop (cost=0.00..0.05 rows=1 width=16) (actual time=0.042..0.091 rows=35 loops=1)

36. 0.038 0.038 ↑ 1.0 1 1

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

37. 0.046 0.046 ↓ 35.0 35 1

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

38. 0.245 0.245 ↑ 4.0 1 35

Index Scan using "S21.G00.11_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.11_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.11" (cost=0.00..5.07 rows=4 width=112) (actual time=0.002..0.007 rows=1 loops=35)

  • Index Cond: ("DECLARATION" = d_2.id)
39. 0.070 0.070 ↑ 1.0 1 35

Index Scan using "S21.G00.06_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.06_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.06" (cost=0.00..0.10 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=35)

  • Index Cond: (id = "S21.G00.11"."S21.G00.06")
40.          

SubPlan (forNested Loop Left Join)

41. 0.022 0.022 ↓ 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.020..0.022 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
42.          

CTE selected_data

43. 0.647 77.732 ↓ 1,144.0 1,144 1

Nested Loop (cost=0.07..70.00 rows=1 width=184) (actual time=29.407..77.732 rows=1,144 loops=1)

44. 21.064 77.085 ↓ 1,144.0 1,144 1

Nested Loop Left Join (cost=0.07..69.97 rows=1 width=176) (actual time=29.403..77.085 rows=1,144 loops=1)

  • Join Filter: ("values".id = "S21.G00.30".id)
  • Rows Removed by Join Filter: 338333
45. 0.485 7.973 ↓ 1,144.0 1,144 1

Hash Join (cost=0.07..69.19 rows=1 width=80) (actual time=2.778..7.973 rows=1,144 loops=1)

  • Hash Cond: ("S21.G00.30"."S21.G00.11" = f11_165.id)
46. 0.187 6.895 ↓ 17.2 1,150 1

Nested Loop (cost=0.00..68.86 rows=67 width=80) (actual time=2.160..6.895 rows=1,150 loops=1)

47. 2.158 2.158 ↓ 35.0 35 1

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

48. 4.550 4.550 ↑ 2.0 33 35

Index Scan using "S21.G00.30_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.30_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.30" (cost=0.00..68.17 rows=67 width=96) (actual time=0.006..0.130 rows=33 loops=35)

  • Index Cond: ("DECLARATION" = d_3.id)
49. 0.017 0.593 ↓ 17.0 34 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
50. 0.576 0.576 ↓ 17.0 34 1

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

51. 48.048 48.048 ↓ 12.3 296 1,144

CTE Scan on error_values "values" (cost=0.00..0.48 rows=24 width=112) (actual time=0.023..0.042 rows=296 loops=1,144)

52. 0.000 0.000 ↑ 1.0 1 1,144

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

53.          

CTE error_codes_for_filtering

54. 5.924 60.841 ↓ 37.3 33,667 1

Nested Loop (cost=0.00..1,078.83 rows=902 width=37) (actual time=0.015..60.841 rows=33,667 loops=1)

55. 7.516 21.250 ↓ 37.3 33,667 1

Nested Loop (cost=0.00..1,062.82 rows=902 width=43) (actual time=0.005..21.250 rows=33,667 loops=1)

56. 0.014 0.014 ↓ 70.0 70 1

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

57. 13.720 13.720 ↑ 1.9 481 70

Index Scan using "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_FILE_idx" on "error_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" e_1 (cost=0.00..1,053.78 rows=902 width=59) (actual time=0.002..0.196 rows=481 loops=70)

  • Index Cond: ("FILE" = f_3.id)
58. 33.667 33.667 ↑ 1.0 1 33,667

Index Scan using control_id_idx on control c (cost=0.00..0.02 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=33,667)

  • Index Cond: (id = e_1."CONTROL")
59.          

CTE selected_data_by_code

60. 0.492 9,468.940 ↓ 208.7 7,304 1

Append (cost=22.41..900.84 rows=35 width=48) (actual time=299.592..9,468.940 rows=7,304 loops=1)

61. 0.000 0.058 ↓ 0.0 0 1

Unique (cost=22.41..22.42 rows=1 width=48) (actual time=0.058..0.058 rows=0 loops=1)

62. 0.016 0.058 ↓ 0.0 0 1

Sort (cost=22.41..22.42 rows=1 width=48) (actual time=0.058..0.058 rows=0 loops=1)

  • Sort Key: "S21.G00.3A"."S21.G00.30", e_2.code
  • Sort Method: quicksort Memory: 25kB
63. 0.001 0.042 ↓ 0.0 0 1

Nested Loop (cost=0.00..22.40 rows=1 width=48) (actual time=0.042..0.042 rows=0 loops=1)

  • Join Filter: ("S21.G00.3A".id = e_2.id)
64. 0.000 0.041 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.05 rows=1 width=32) (actual time=0.041..0.041 rows=0 loops=1)

65. 0.006 0.006 ↓ 35.0 35 1

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

66. 0.035 0.035 ↓ 0.0 0 35

Index Scan using "S21.G00.3A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.3A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.3A" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=35)

  • Index Cond: ("DECLARATION" = d_4.id)
67. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_2 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.3A'::text)
68. 0.001 0.056 ↓ 0.0 0 1

Unique (cost=22.41..22.42 rows=1 width=48) (actual time=0.056..0.056 rows=0 loops=1)

69. 0.014 0.055 ↓ 0.0 0 1

Sort (cost=22.41..22.42 rows=1 width=48) (actual time=0.055..0.055 rows=0 loops=1)

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

Nested Loop (cost=0.00..22.40 rows=1 width=48) (actual time=0.041..0.041 rows=0 loops=1)

  • Join Filter: ("S21.G00.5B".id = e_3.id)
71. 0.000 0.040 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.05 rows=1 width=32) (actual time=0.040..0.040 rows=0 loops=1)

72. 0.006 0.006 ↓ 35.0 35 1

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

73. 0.035 0.035 ↓ 0.0 0 35

Index Scan using "S21.G00.5B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.5B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5B" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=35)

  • Index Cond: ("DECLARATION" = d_5.id)
74. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_3 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.5B'::text)
75. 0.000 181.981 ↓ 0.0 0 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=181.981..181.981 rows=0 loops=1)

76. 0.014 181.981 ↓ 0.0 0 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=181.981..181.981 rows=0 loops=1)

  • Sort Key: "S21.G00.62"."S21.G00.30", e_4.code
  • Sort Method: quicksort Memory: 25kB
77. 0.000 181.967 ↓ 0.0 0 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=181.967..181.967 rows=0 loops=1)

  • Join Filter: ("S21.G00.62"."DECLARATION" = d_6.id)
78. 0.007 0.007 ↓ 35.0 35 1

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

79. 0.035 181.965 ↓ 0.0 0 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=5.199..5.199 rows=0 loops=35)

80. 181.930 181.930 ↓ 0.0 0 35

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

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

Index Scan using "S21.G00.62_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.62_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.62" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_4.id)
82. 0.000 2.934 ↓ 0.0 0 1

Unique (cost=23.54..23.54 rows=1 width=48) (actual time=2.934..2.934 rows=0 loops=1)

83. 0.006 2.934 ↓ 0.0 0 1

Sort (cost=23.54..23.54 rows=1 width=48) (actual time=2.934..2.934 rows=0 loops=1)

  • Sort Key: "S21.G00.66"."S21.G00.30", e_5.code
  • Sort Method: quicksort Memory: 25kB
84. 0.001 2.928 ↓ 0.0 0 1

Nested Loop (cost=0.00..23.52 rows=1 width=48) (actual time=2.928..2.928 rows=0 loops=1)

  • Join Filter: ("S21.G00.66".id = e_5.id)
85. 2.927 2.927 ↓ 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.927..2.927 rows=0 loops=1)

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

Materialize (cost=0.00..3.08 rows=2 width=32) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..3.07 rows=2 width=32) (never executed)

88. 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)

89. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.66_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.66_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.66" (cost=0.00..3.03 rows=2 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_7.id)
90. 0.001 0.032 ↓ 0.0 0 1

Unique (cost=22.41..22.42 rows=1 width=48) (actual time=0.032..0.032 rows=0 loops=1)

91. 0.003 0.031 ↓ 0.0 0 1

Sort (cost=22.41..22.42 rows=1 width=48) (actual time=0.031..0.031 rows=0 loops=1)

  • Sort Key: "S21.G00.5D"."S21.G00.30", e_6.code
  • Sort Method: quicksort Memory: 25kB
92. 0.000 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.00..22.40 rows=1 width=48) (actual time=0.028..0.028 rows=0 loops=1)

  • Join Filter: ("S21.G00.5D".id = e_6.id)
93. 0.024 0.028 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.05 rows=1 width=32) (actual time=0.028..0.028 rows=0 loops=1)

94. 0.004 0.004 ↓ 35.0 35 1

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

95. 0.000 0.000 ↓ 0.0 0 35

Index Scan using "S21.G00.5D_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.5D_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5D" (cost=0.00..2.02 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=35)

  • Index Cond: ("DECLARATION" = d_8.id)
96. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_6 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.5D'::text)
97. 0.035 114.570 ↓ 174.0 174 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=114.530..114.570 rows=174 loops=1)

98. 0.090 114.535 ↓ 174.0 174 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=114.527..114.535 rows=174 loops=1)

  • Sort Key: "S21.G00.53"."S21.G00.30", e_7.code
  • Sort Method: quicksort Memory: 38kB
99. 0.579 114.445 ↓ 174.0 174 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=0.255..114.445 rows=174 loops=1)

  • Join Filter: ("S21.G00.53"."DECLARATION" = d_9.id)
  • Rows Removed by Join Filter: 5916
100. 0.011 0.011 ↓ 35.0 35 1

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

101. 2.870 113.855 ↓ 34.8 174 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=0.025..3.253 rows=174 loops=35)

102. 104.895 104.895 ↓ 34.8 174 35

CTE Scan on error_codes_for_filtering e_7 (cost=0.00..20.29 rows=5 width=48) (actual time=0.024..2.997 rows=174 loops=35)

  • Filter: (subgroup = 'S21.G00.53'::text)
  • Rows Removed by Filter: 33493
103. 6.090 6.090 ↑ 1.0 1 6,090

Index Scan using "S21.G00.53_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.53_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.53" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=6,090)

  • Index Cond: (id = e_7.id)
104. 0.143 152.407 ↓ 753.0 753 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=152.228..152.407 rows=753 loops=1)

105. 0.393 152.264 ↓ 753.0 753 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=152.227..152.264 rows=753 loops=1)

  • Sort Key: "S21.G00.81"."S21.G00.30", e_8.code
  • Sort Method: quicksort Memory: 83kB
106. 2.444 151.871 ↓ 753.0 753 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=0.431..151.871 rows=753 loops=1)

  • Join Filter: ("S21.G00.81"."DECLARATION" = d_10.id)
  • Rows Removed by Join Filter: 25602
107. 0.012 0.012 ↓ 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.012 rows=35 loops=1)

108. 17.325 149.415 ↓ 150.6 753 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=0.003..4.269 rows=753 loops=35)

109. 105.735 105.735 ↓ 150.6 753 35

CTE Scan on error_codes_for_filtering e_8 (cost=0.00..20.29 rows=5 width=48) (actual time=0.001..3.021 rows=753 loops=35)

  • Filter: (subgroup = 'S21.G00.81'::text)
  • Rows Removed by Filter: 32914
110. 26.355 26.355 ↑ 1.0 1 26,355

Index Scan using "S21.G00.81_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.81_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.81" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=26,355)

  • Index Cond: (id = e_8.id)
111. 0.001 104.540 ↓ 0.0 0 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=104.540..104.540 rows=0 loops=1)

112. 0.010 104.539 ↓ 0.0 0 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=104.539..104.539 rows=0 loops=1)

  • Sort Key: "S21.G00.70"."S21.G00.30", e_9.code
  • Sort Method: quicksort Memory: 25kB
113. 0.011 104.529 ↓ 0.0 0 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=104.529..104.529 rows=0 loops=1)

  • Join Filter: ("S21.G00.70"."DECLARATION" = d_11.id)
114. 0.008 0.008 ↓ 35.0 35 1

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

115. 0.000 104.510 ↓ 0.0 0 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=2.986..2.986 rows=0 loops=35)

116. 104.510 104.510 ↓ 0.0 0 35

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

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

Index Scan using "S21.G00.70_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.70_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.70" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_9.id)
118. 0.000 2.934 ↓ 0.0 0 1

Unique (cost=23.54..23.54 rows=1 width=48) (actual time=2.934..2.934 rows=0 loops=1)

119. 0.011 2.934 ↓ 0.0 0 1

Sort (cost=23.54..23.54 rows=1 width=48) (actual time=2.934..2.934 rows=0 loops=1)

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

Nested Loop (cost=0.00..23.52 rows=1 width=48) (actual time=2.923..2.923 rows=0 loops=1)

  • Join Filter: ("S21.G00.6A".id = e_10.id)
121. 2.923 2.923 ↓ 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.922..2.923 rows=0 loops=1)

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

Materialize (cost=0.00..3.08 rows=2 width=32) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..3.07 rows=2 width=32) (never executed)

124. 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)

125. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.6A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.6A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.6A" (cost=0.00..3.03 rows=2 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_12.id)
126. 0.001 2.967 ↓ 0.0 0 1

Unique (cost=23.54..23.54 rows=1 width=48) (actual time=2.967..2.967 rows=0 loops=1)

127. 0.009 2.966 ↓ 0.0 0 1

Sort (cost=23.54..23.54 rows=1 width=48) (actual time=2.966..2.966 rows=0 loops=1)

  • Sort Key: "S21.G00.41"."S21.G00.30", e_11.code
  • Sort Method: quicksort Memory: 25kB
128. 0.001 2.957 ↓ 0.0 0 1

Nested Loop (cost=0.00..23.52 rows=1 width=48) (actual time=2.957..2.957 rows=0 loops=1)

  • Join Filter: ("S21.G00.41".id = e_11.id)
129. 2.956 2.956 ↓ 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.956..2.956 rows=0 loops=1)

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

Materialize (cost=0.00..3.08 rows=2 width=32) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..3.07 rows=2 width=32) (never executed)

132. 0.000 0.000 ↓ 0.0 0

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

133. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.41_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.41_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.41" (cost=0.00..3.03 rows=2 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_13.id)
134. 0.167 158.677 ↓ 942.0 942 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=158.465..158.677 rows=942 loops=1)

135. 0.496 158.510 ↓ 942.0 942 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=158.465..158.510 rows=942 loops=1)

  • Sort Key: "S21.G00.51"."S21.G00.30", e_12.code
  • Sort Method: quicksort Memory: 98kB
136. 3.022 158.014 ↓ 942.0 942 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=0.359..158.014 rows=942 loops=1)

  • Join Filter: ("S21.G00.51"."DECLARATION" = d_14.id)
  • Rows Removed by Join Filter: 32028
137. 0.012 0.012 ↓ 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.012 rows=35 loops=1)

138. 15.120 154.980 ↓ 188.4 942 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=0.009..4.428 rows=942 loops=35)

139. 106.890 106.890 ↓ 188.4 942 35

CTE Scan on error_codes_for_filtering e_12 (cost=0.00..20.29 rows=5 width=48) (actual time=0.007..3.054 rows=942 loops=35)

  • Filter: (subgroup = 'S21.G00.51'::text)
  • Rows Removed by Filter: 32725
140. 32.970 32.970 ↑ 1.0 1 32,970

Index Scan using "S21.G00.51_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.51_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.51" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=32,970)

  • Index Cond: (id = e_12.id)
141. 0.002 2.990 ↓ 7.0 7 1

Unique (cost=24.64..24.65 rows=1 width=48) (actual time=2.988..2.990 rows=7 loops=1)

142. 0.015 2.988 ↓ 9.0 9 1

Sort (cost=24.64..24.64 rows=1 width=48) (actual time=2.987..2.988 rows=9 loops=1)

  • Sort Key: "S21.G00.65"."S21.G00.30", e_13.code
  • Sort Method: quicksort Memory: 25kB
143. 0.013 2.973 ↓ 9.0 9 1

Nested Loop (cost=0.00..24.63 rows=1 width=48) (actual time=0.045..2.973 rows=9 loops=1)

  • Join Filter: ("S21.G00.65".id = e_13.id)
  • Rows Removed by Join Filter: 72
144. 2.897 2.897 ↓ 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.014..2.897 rows=9 loops=1)

  • Filter: (subgroup = 'S21.G00.65'::text)
  • Rows Removed by Filter: 33658
145. 0.007 0.063 ↓ 3.0 9 9

Materialize (cost=0.00..4.12 rows=3 width=32) (actual time=0.002..0.007 rows=9 loops=9)

146. 0.017 0.056 ↓ 3.0 9 1

Nested Loop (cost=0.00..4.10 rows=3 width=32) (actual time=0.011..0.056 rows=9 loops=1)

147. 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.000..0.004 rows=35 loops=1)

148. 0.035 0.035 ↓ 0.0 0 35

Index Scan using "S21.G00.65_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.65_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.65" (cost=0.00..4.05 rows=3 width=48) (actual time=0.001..0.001 rows=0 loops=35)

  • Index Cond: ("DECLARATION" = d_15.id)
149. 0.271 3,088.666 ↓ 0.0 0 1

Nested Loop (cost=0.00..20.38 rows=1 width=48) (actual time=3,088.666..3,088.666 rows=0 loops=1)

  • Join Filter: (sd."S20.G00.05" = e_14.id)
150. 48.787 48.787 ↓ 1,144.0 1,144 1

CTE Scan on selected_data sd (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..48.787 rows=1,144 loops=1)

151. 3,039.608 3,039.608 ↓ 0.0 0 1,144

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

  • Filter: (subgroup = 'S20.G00.05'::text)
  • Rows Removed by Filter: 33667
152. 0.001 0.036 ↓ 0.0 0 1

Unique (cost=22.41..22.42 rows=1 width=48) (actual time=0.036..0.036 rows=0 loops=1)

153. 0.012 0.035 ↓ 0.0 0 1

Sort (cost=22.41..22.42 rows=1 width=48) (actual time=0.035..0.035 rows=0 loops=1)

  • Sort Key: "S21.G00.7A"."S21.G00.30", e_15.code
  • Sort Method: quicksort Memory: 25kB
154. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.00..22.40 rows=1 width=48) (actual time=0.023..0.023 rows=0 loops=1)

  • Join Filter: ("S21.G00.7A".id = e_15.id)
155. 0.019 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.05 rows=1 width=32) (actual time=0.022..0.022 rows=0 loops=1)

156. 0.003 0.003 ↓ 35.0 35 1

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

157. 0.000 0.000 ↓ 0.0 0 35

Index Scan using "S21.G00.7A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.7A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.7A" (cost=0.00..2.02 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=35)

  • Index Cond: ("DECLARATION" = d_16.id)
158. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_15 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.7A'::text)
159. 0.001 2.402 ↓ 0.0 0 1

Unique (cost=23.54..23.54 rows=1 width=48) (actual time=2.402..2.402 rows=0 loops=1)

160. 0.007 2.401 ↓ 0.0 0 1

Sort (cost=23.54..23.54 rows=1 width=48) (actual time=2.401..2.401 rows=0 loops=1)

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

Nested Loop (cost=0.00..23.52 rows=1 width=48) (actual time=2.394..2.394 rows=0 loops=1)

  • Join Filter: ("S21.G00.7B".id = e_16.id)
162. 2.394 2.394 ↓ 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.394..2.394 rows=0 loops=1)

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

Materialize (cost=0.00..3.08 rows=2 width=32) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..3.07 rows=2 width=32) (never executed)

165. 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)

166. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.7B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.7B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.7B" (cost=0.00..3.03 rows=2 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_17.id)
167. 0.001 0.030 ↓ 0.0 0 1

Unique (cost=22.41..22.42 rows=1 width=48) (actual time=0.030..0.030 rows=0 loops=1)

168. 0.007 0.029 ↓ 0.0 0 1

Sort (cost=22.41..22.42 rows=1 width=48) (actual time=0.029..0.029 rows=0 loops=1)

  • Sort Key: "S21.G00.56"."S21.G00.30", e_17.code
  • Sort Method: quicksort Memory: 25kB
169. 0.000 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.00..22.40 rows=1 width=48) (actual time=0.022..0.022 rows=0 loops=1)

  • Join Filter: ("S21.G00.56".id = e_17.id)
170. 0.019 0.022 ↓ 0.0 0 1

Nested Loop (cost=0.00..2.05 rows=1 width=32) (actual time=0.022..0.022 rows=0 loops=1)

171. 0.003 0.003 ↓ 35.0 35 1

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

172. 0.000 0.000 ↓ 0.0 0 35

Index Scan using "S21.G00.56_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.56_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.56" (cost=0.00..2.02 rows=1 width=48) (actual time=0.000..0.000 rows=0 loops=35)

  • Index Cond: ("DECLARATION" = d_18.id)
173. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_17 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.56'::text)
174. 0.069 100.853 ↓ 496.0 496 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=100.767..100.853 rows=496 loops=1)

175. 0.190 100.784 ↓ 496.0 496 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=100.767..100.784 rows=496 loops=1)

  • Sort Key: "S21.G00.50"."S21.G00.30", e_18.code
  • Sort Method: quicksort Memory: 63kB
176. 1.326 100.594 ↓ 496.0 496 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=0.277..100.594 rows=496 loops=1)

  • Join Filter: ("S21.G00.50"."DECLARATION" = d_19.id)
  • Rows Removed by Join Filter: 16864
177. 0.008 0.008 ↓ 35.0 35 1

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

178. 0.140 99.260 ↓ 99.2 496 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=0.007..2.836 rows=496 loops=35)

179. 81.760 81.760 ↓ 99.2 496 35

CTE Scan on error_codes_for_filtering e_18 (cost=0.00..20.29 rows=5 width=48) (actual time=0.006..2.336 rows=496 loops=35)

  • Filter: (subgroup = 'S21.G00.50'::text)
  • Rows Removed by Filter: 33171
180. 17.360 17.360 ↑ 1.0 1 17,360

Index Scan using "S21.G00.50_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.50_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.50" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=17,360)

  • Index Cond: (id = e_18.id)
181. 0.579 2,676.678 ↓ 0.0 0 1

Nested Loop (cost=0.00..20.38 rows=1 width=48) (actual time=2,676.678..2,676.678 rows=0 loops=1)

  • Join Filter: (sd_1."S10.G00.00" = e_19.id)
182. 0.283 0.283 ↓ 1,144.0 1,144 1

CTE Scan on selected_data sd_1 (cost=0.00..0.02 rows=1 width=32) (actual time=0.000..0.283 rows=1,144 loops=1)

183. 2,675.816 2,675.816 ↓ 0.0 0 1,144

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

  • Filter: (subgroup = 'S10.G00.00'::text)
  • Rows Removed by Filter: 33667
184. 3.312 2,677.021 ↓ 2,514.0 2,514 1

Nested Loop (cost=0.00..20.38 rows=1 width=48) (actual time=0.158..2,677.021 rows=2,514 loops=1)

  • Join Filter: (sd_2."S21.G00.11" = e_20.id)
  • Rows Removed by Join Filter: 34094
185. 0.181 0.181 ↓ 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.000..0.181 rows=1,144 loops=1)

186. 2,673.528 2,673.528 ↓ 6.4 32 1,144

CTE Scan on error_codes_for_filtering e_20 (cost=0.00..20.29 rows=5 width=48) (actual time=0.014..2.337 rows=32 loops=1,144)

  • Filter: (subgroup = 'S21.G00.11'::text)
  • Rows Removed by Filter: 33635
187. 0.321 198.616 ↓ 2,418.0 2,418 1

Unique (cost=30.48..30.49 rows=1 width=48) (actual time=198.208..198.616 rows=2,418 loops=1)

188. 1.085 198.295 ↓ 2,418.0 2,418 1

Sort (cost=30.48..30.48 rows=1 width=48) (actual time=198.206..198.295 rows=2,418 loops=1)

  • Sort Key: "S21.G00.78"."S21.G00.30", e_21.code
  • Sort Method: quicksort Memory: 296kB
189. 6.555 197.210 ↓ 2,554.0 2,554 1

Nested Loop (cost=0.00..30.47 rows=1 width=48) (actual time=0.667..197.210 rows=2,554 loops=1)

  • Join Filter: ("S21.G00.78"."DECLARATION" = d_20.id)
  • Rows Removed by Join Filter: 86836
190. 0.010 0.010 ↓ 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.010 rows=35 loops=1)

191. 16.695 190.645 ↓ 510.8 2,554 35

Nested Loop (cost=0.00..30.38 rows=5 width=64) (actual time=0.003..5.447 rows=2,554 loops=35)

192. 84.560 84.560 ↓ 510.8 2,554 35

CTE Scan on error_codes_for_filtering e_21 (cost=0.00..20.29 rows=5 width=48) (actual time=0.001..2.416 rows=2,554 loops=35)

  • Filter: (subgroup = 'S21.G00.78'::text)
  • Rows Removed by Filter: 31113
193. 89.390 89.390 ↑ 1.0 1 89,390

Index Scan using "S21.G00.78_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.78_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.78" (cost=0.00..2.02 rows=1 width=48) (actual time=0.001..0.001 rows=1 loops=89,390)

  • Index Cond: (id = e_21.id)
194. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.3B"."S21.G00.30", e_22.code
196. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.3B"."DECLARATION" = d_21.id)
197. 0.000 0.000 ↓ 0.0 0

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

198. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

199. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_22 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.3B'::text)
200. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.3B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.3B_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.3B" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_22.id)
201. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.79"."S21.G00.30", e_23.code
203. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.79"."DECLARATION" = d_22.id)
204. 0.000 0.000 ↓ 0.0 0

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

205. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

206. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_23 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.79'::text)
207. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.79_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.79_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.79" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_23.id)
208. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..20.38 rows=1 width=48) (never executed)

  • Join Filter: (sd_3."S21.G00.06" = e_24.id)
209. 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)

210. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_24 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.06'::text)
211. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..20.38 rows=1 width=48) (never executed)

  • Join Filter: (sd_4.id = e_25.id)
212. 0.000 0.000 ↓ 0.0 0

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

213. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_25 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.30'::text)
214. 0.000 0.000 ↓ 0.0 0

Unique (cost=22.41..22.42 rows=1 width=48) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Sort (cost=22.41..22.42 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.31"."S21.G00.30", e_26.code
216. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..22.40 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.31".id = e_26.id)
217. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.05 rows=1 width=32) (never executed)

218. 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)

219. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.31_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.31_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.31" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_23.id)
220. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_26 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.31'::text)
221. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

222. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.52"."S21.G00.30", e_27.code
223. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.52"."DECLARATION" = d_24.id)
224. 0.000 0.000 ↓ 0.0 0

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

225. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

226. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_27 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.52'::text)
227. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.52_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.52_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.52" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_27.id)
228. 0.000 0.000 ↓ 0.0 0

Unique (cost=22.41..22.42 rows=1 width=48) (never executed)

229. 0.000 0.000 ↓ 0.0 0

Sort (cost=22.41..22.42 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.5A"."S21.G00.30", e_28.code
230. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..22.40 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.5A".id = e_28.id)
231. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.05 rows=1 width=32) (never executed)

232. 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)

233. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.5A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.5A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5A" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_25.id)
234. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_28 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.5A'::text)
235. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.54"."S21.G00.30", e_29.code
237. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.54"."DECLARATION" = d_26.id)
238. 0.000 0.000 ↓ 0.0 0

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

239. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

240. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_29 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.54'::text)
241. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.54_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.54_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.54" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_29.id)
242. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.40"."S21.G00.30", e_30.code
244. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.40"."DECLARATION" = d_27.id)
245. 0.000 0.000 ↓ 0.0 0

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

246. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

247. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_30 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.40'::text)
248. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.40_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.40_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.40" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_30.id)
249. 0.000 0.000 ↓ 0.0 0

Unique (cost=23.54..23.54 rows=1 width=48) (never executed)

250. 0.000 0.000 ↓ 0.0 0

Sort (cost=23.54..23.54 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.60"."S21.G00.30", e_31.code
251. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..23.52 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.60".id = e_31.id)
252. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_31 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.60'::text)
253. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..3.08 rows=2 width=32) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..3.07 rows=2 width=32) (never executed)

255. 0.000 0.000 ↓ 0.0 0

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

256. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.60_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.60_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.60" (cost=0.00..3.03 rows=2 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_28.id)
257. 0.000 0.000 ↓ 0.0 0

Unique (cost=22.41..22.42 rows=1 width=48) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Sort (cost=22.41..22.42 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.8A"."S21.G00.30", e_32.code
259. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..22.40 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.8A".id = e_32.id)
260. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.05 rows=1 width=32) (never executed)

261. 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)

262. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.8A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.8A_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.8A" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_29.id)
263. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_32 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.8A'::text)
264. 0.000 0.000 ↓ 0.0 0

Unique (cost=27.59..27.60 rows=1 width=48) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Sort (cost=27.59..27.60 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.34"."S21.G00.30", e_33.code
266. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=7.26..27.58 rows=1 width=48) (never executed)

  • Hash Cond: (e_33.id = "S21.G00.34".id)
267. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_33 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.34'::text)
268. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.18..7.18 rows=6 width=32) (never executed)

269. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..7.18 rows=6 width=32) (never executed)

270. 0.000 0.000 ↓ 0.0 0

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

271. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.34_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.34_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.34" (cost=0.00..7.10 rows=6 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_30.id)
272. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.71"."S21.G00.30", e_34.code
274. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.71"."DECLARATION" = d_31.id)
275. 0.000 0.000 ↓ 0.0 0

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

276. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

277. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_34 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.71'::text)
278. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.71_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.71_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.71" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_34.id)
279. 0.000 0.000 ↓ 0.0 0

Unique (cost=30.48..30.49 rows=1 width=48) (never executed)

280. 0.000 0.000 ↓ 0.0 0

Sort (cost=30.48..30.48 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.86"."S21.G00.30", e_35.code
281. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.47 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.86"."DECLARATION" = d_32.id)
282. 0.000 0.000 ↓ 0.0 0

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

283. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..30.38 rows=5 width=64) (never executed)

284. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_35 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.86'::text)
285. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.86_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_id_idx" on "S21.G00.86_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.86" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: (id = e_35.id)
286. 0.000 0.000 ↓ 0.0 0

Unique (cost=22.41..22.42 rows=1 width=48) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Sort (cost=22.41..22.42 rows=1 width=48) (never executed)

  • Sort Key: "S21.G00.5C"."S21.G00.30", e_36.code
288. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..22.40 rows=1 width=48) (never executed)

  • Join Filter: ("S21.G00.5C".id = e_36.id)
289. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..2.05 rows=1 width=32) (never executed)

290. 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)

291. 0.000 0.000 ↓ 0.0 0

Index Scan using "S21.G00.5C_9faf476a-cef8-46a7-9afe-bffae9337e46_201810_DECL_idx" on "S21.G00.5C_9faf476a-cef8-46a7-9afe-bffae9337e46_201810" "S21.G00.5C" (cost=0.00..2.02 rows=1 width=48) (never executed)

  • Index Cond: ("DECLARATION" = d_33.id)
292. 0.000 0.000 ↓ 0.0 0

CTE Scan on error_codes_for_filtering e_36 (cost=0.00..20.29 rows=5 width=48) (never executed)

  • Filter: (subgroup = 'S21.G00.5C'::text)
293.          

Initplan (forResult)

294. 0.106 9,635.176 ↑ 1.0 1 1

Aggregate (cost=1.16..1.17 rows=1 width=32) (actual time=9,635.176..9,635.176 rows=1 loops=1)

295. 66.659 9,635.070 ↓ 1,144.0 1,144 1

Nested Loop Semi Join (cost=0.00..1.16 rows=1 width=32) (actual time=329.066..9,635.070 rows=1,144 loops=1)

  • Join Filter: (selected_data.id = selected_data_by_code.id)
  • Rows Removed by Join Filter: 1158339
296. 29.739 29.739 ↓ 1,144.0 1,144 1

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

297. 9,538.672 9,538.672 ↓ 29.0 1,014 1,144

CTE Scan on selected_data_by_code (cost=0.00..0.70 rows=35 width=16) (actual time=0.262..8.338 rows=1,014 loops=1,144)

298. 0.312 0.382 ↑ 1.0 1 1

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

299. 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)