# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 34.615 | 23,237.996 | ↓ 1,355.5 | 135,552 | 1 |
→
Hash Left Join (cost=54,584.75..54,587.39 rows=100 width=612) (actual time=23,192.052..23,237.996 rows=135,552 loops=1)
|
2. |
CTE features |
|||||
3. | 4.158 | 381.006 | ↓ 1,355.5 | 135,552 | 1 |
→
Nested Loop (cost=3,157.59..3,946.92 rows=100 width=55) (actual time=63.026..381.006 rows=135,552 loops=1) |
4. | 80.001 | 105.744 | ↓ 1,355.5 | 135,552 | 1 |
→
HashAggregate (cost=3,157.17..3,158.17 rows=100 width=4) (actual time=63.005..105.744 rows=135,552 loops=1)
|
5. | 8.687 | 25.743 | ↓ 1,355.5 | 135,552 | 1 |
→
Result (cost=3,155.41..3,155.92 rows=100 width=0) (actual time=17.258..25.743 rows=135,552 loops=1) |
6. |
Initplan (forResult) |
|||||
7. | 9.184 | 17.056 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=3,155.40..3,155.41 rows=1 width=4) (actual time=17.056..17.056 rows=1 loops=1) |
8. | 7.872 | 7.872 | ↑ 1.0 | 135,552 | 1 |
→
Seq Scan on feature (cost=0.00..2,816.52 rows=135,552 width=4) (actual time=0.004..7.872 rows=135,552 loops=1) |
9. | 271.104 | 271.104 | ↑ 1.0 | 1 | 135,552 |
→
Index Scan using feature_pkey on feature f_1 (cost=0.42..7.88 rows=1 width=55) (actual time=0.002..0.002 rows=1 loops=135,552)
|
10. |
CTE data_class_rule |
|||||
11. | 31.366 | 458.463 | ↑ 1.9 | 126 | 1 |
→
Recursive Union (cost=3.25..524.70 rows=234 width=20) (actual time=397.935..458.463 rows=126 loops=1) |
12. | 28.865 | 426.809 | ↓ 1,301.4 | 200,412 | 1 |
→
Hash Right Join (cost=3.25..9.25 rows=154 width=16) (actual time=397.930..426.809 rows=200,412 loops=1)
|
13. | 0.041 | 0.041 | ↑ 1.0 | 179 | 1 |
→
Seq Scan on name_rule nr (cost=0.00..3.79 rows=179 width=16) (actual time=0.008..0.041 rows=179 loops=1) |
14. | 22.064 | 397.903 | ↓ 1,355.5 | 135,552 | 1 |
→
Hash (cost=2.00..2.00 rows=100 width=4) (actual time=397.903..397.903 rows=135,552 loops=1)
|
15. | 375.839 | 375.839 | ↓ 1,355.5 | 135,552 | 1 |
→
CTE Scan on features f_2 (cost=0.00..2.00 rows=100 width=4) (actual time=0.001..375.839 rows=135,552 loops=1) |
16. | 0.009 | 0.288 | ↑ 4.0 | 2 | 4 |
→
Nested Loop Left Join (cost=31.05..51.08 rows=8 width=20) (actual time=0.027..0.072 rows=2 loops=4) |
17. | 0.133 | 0.272 | ↑ 4.0 | 2 | 4 |
→
Hash Join (cost=30.90..49.31 rows=8 width=8) (actual time=0.023..0.068 rows=2 loops=4)
|
18. | 0.123 | 0.123 | ↑ 1.0 | 751 | 3 |
→
Seq Scan on data_class dc (cost=0.00..15.51 rows=751 width=8) (actual time=0.003..0.041 rows=751 loops=3) |
19. | 0.000 | 0.016 | ↑ 4.0 | 2 | 4 |
→
Hash (cost=30.80..30.80 rows=8 width=8) (actual time=0.004..0.004 rows=2 loops=4)
|
20. | 0.016 | 0.016 | ↑ 4.0 | 2 | 4 |
→
WorkTable Scan on data_class_rule dcr (cost=0.00..30.80 rows=8 width=8) (actual time=0.003..0.004 rows=2 loops=4)
|
21. | 0.007 | 0.007 | ↓ 0.0 | 0 | 7 |
→
Index Scan using name_rule_data_class_id_priority_key on name_rule nr_1 (cost=0.14..0.20 rows=2 width=16) (actual time=0.001..0.001 rows=0 loops=7)
|
22. |
CTE name_rule |
|||||
23. | 458.513 | 458.513 | ↑ 2.0 | 116 | 1 |
→
CTE Scan on data_class_rule (cost=0.00..4.68 rows=233 width=476) (actual time=397.936..458.513 rows=116 loops=1)
|
24. |
CTE snapshot_values |
|||||
25. | 15,497.934 | 15,516.610 | ↓ 963.5 | 963,529 | 1 |
→
Function Scan on d_get_features_snapshot_values snv (cost=3,155.66..3,165.66 rows=1,000 width=8) (actual time=15,439.302..15,516.610 rows=963,529 loops=1) |
26. |
Initplan (forFunction Scan) |
|||||
27. | 10.587 | 18.676 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=3,155.40..3,155.41 rows=1 width=4) (actual time=18.676..18.676 rows=1 loops=1) |
28. | 8.089 | 8.089 | ↑ 1.0 | 135,552 | 1 |
→
Seq Scan on feature feature_1 (cost=0.00..2,816.52 rows=135,552 width=4) (actual time=0.005..8.089 rows=135,552 loops=1) |
29. |
CTE values_for_names |
|||||
30. | 182.260 | 21,728.060 | ↓ 782.5 | 178,406 | 1 |
→
Hash Join (cost=44,253.28..44,716.90 rows=228 width=59) (actual time=21,488.561..21,728.060 rows=178,406 loops=1)
|
31. | 458.556 | 458.556 | ↑ 2.0 | 116 | 1 |
→
CTE Scan on name_rule nr_2 (cost=0.00..4.66 rows=233 width=472) (actual time=397.938..458.556 rows=116 loops=1) |
32. | 637.869 | 21,087.244 | ↓ 43.4 | 1,697,998 | 1 |
→
Hash (cost=43,666.49..43,666.49 rows=39,119 width=63) (actual time=21,087.244..21,087.244 rows=1,697,998 loops=1)
|
33. | 387.555 | 20,449.375 | ↓ 43.4 | 1,697,998 | 1 |
→
Nested Loop (cost=12.32..43,666.49 rows=39,119 width=63) (actual time=15,464.772..20,449.375 rows=1,697,998 loops=1) |
34. | 641.389 | 18,463.428 | ↓ 43.5 | 1,598,392 | 1 |
→
Nested Loop (cost=11.90..22,839.85 rows=36,736 width=16) (actual time=15,464.761..18,463.428 rows=1,598,392 loops=1) |
35. | 213.211 | 15,894.981 | ↓ 1,927.1 | 963,529 | 1 |
→
Hash Join (cost=3.25..32.00 rows=500 width=12) (actual time=15,464.721..15,894.981 rows=963,529 loops=1)
|
36. | 15,656.371 | 15,656.371 | ↓ 963.5 | 963,529 | 1 |
→
CTE Scan on snapshot_values snv_1 (cost=0.00..20.00 rows=1,000 width=8) (actual time=15,439.303..15,656.371 rows=963,529 loops=1) |
37. | 11.931 | 25.399 | ↓ 1,355.5 | 135,552 | 1 |
→
Hash (cost=2.00..2.00 rows=100 width=8) (actual time=25.399..25.399 rows=135,552 loops=1)
|
38. | 13.468 | 13.468 | ↓ 1,355.5 | 135,552 | 1 |
→
CTE Scan on features f_3 (cost=0.00..2.00 rows=100 width=8) (actual time=0.002..13.468 rows=135,552 loops=1) |
39. | 0.000 | 1,927.058 | ↑ 36.5 | 2 | 963,529 |
→
Bitmap Heap Scan on value v (cost=8.65..44.89 rows=73 width=8) (actual time=0.002..0.002 rows=2 loops=963,529)
|
40. | 0.000 | 1,927.058 | ↓ 0.0 | 0 | 963,529 |
→
BitmapOr (cost=8.65..8.65 rows=73 width=0) (actual time=0.002..0.002 rows=0 loops=963,529) |
41. | 963.529 | 963.529 | ↑ 1.0 | 1 | 963,529 |
→
Bitmap Index Scan on value_pkey (cost=0.00..4.04 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=963,529)
|
42. | 963.529 | 963.529 | ↑ 72.0 | 1 | 963,529 |
→
Bitmap Index Scan on value_top_idx (cost=0.00..4.57 rows=72 width=0) (actual time=0.001..0.001 rows=1 loops=963,529)
|
43. | 1,598.392 | 1,598.392 | ↑ 1.0 | 1 | 1,598,392 |
→
Index Scan using simple_value_value_id_idx on simple_value sv (cost=0.43..0.56 rows=1 width=51) (actual time=0.001..0.001 rows=1 loops=1,598,392)
|
44. |
CTE translated_prop_value |
|||||
45. | 0.223 | 173.039 | ↓ 1,635.0 | 1,635 | 1 |
→
Unique (cost=282.76..282.78 rows=1 width=14) (actual time=172.765..173.039 rows=1,635 loops=1) |
46. | 0.345 | 172.816 | ↓ 1,635.0 | 1,635 | 1 |
→
Sort (cost=282.76..282.77 rows=1 width=14) (actual time=172.764..172.816 rows=1,635 loops=1)
|
47. | 3.066 | 172.471 | ↓ 1,635.0 | 1,635 | 1 |
→
Nested Loop (cost=252.99..282.75 rows=1 width=14) (actual time=5.696..172.471 rows=1,635 loops=1)
|
48. | 1.943 | 169.405 | ↓ 3,413.0 | 3,413 | 1 |
→
Nested Loop (cost=252.99..281.71 rows=1 width=19) (actual time=5.687..169.405 rows=3,413 loops=1)
|
49. | 3.328 | 164.049 | ↓ 3,413.0 | 3,413 | 1 |
→
Nested Loop (cost=252.56..281.14 rows=1 width=22) (actual time=5.681..164.049 rows=3,413 loops=1) |
50. | 0.804 | 150.335 | ↓ 10,386.0 | 10,386 | 1 |
→
Nested Loop (cost=252.13..280.57 rows=1 width=13) (actual time=5.673..150.335 rows=10,386 loops=1)
|
51. | 2.413 | 145.971 | ↓ 1,780.0 | 1,780 | 1 |
→
Nested Loop (cost=251.71..277.95 rows=1 width=25) (actual time=5.670..145.971 rows=1,780 loops=1) |
52. | 1.200 | 133.172 | ↓ 10,386.0 | 10,386 | 1 |
→
Nested Loop (cost=251.28..277.38 rows=1 width=24) (actual time=5.665..133.172 rows=10,386 loops=1)
|
53. | 0.042 | 128.412 | ↓ 1,780.0 | 1,780 | 1 |
→
Nested Loop (cost=250.85..274.76 rows=1 width=16) (actual time=5.657..128.412 rows=1,780 loops=1)
|
54. | 59.160 | 124.810 | ↓ 1,780.0 | 1,780 | 1 |
→
Hash Join (cost=250.42..274.18 rows=1 width=12) (actual time=5.643..124.810 rows=1,780 loops=1)
|
55. | 60.566 | 60.566 | ↓ 963.5 | 963,529 | 1 |
→
CTE Scan on snapshot_values snv_2 (cost=0.00..20.00 rows=1,000 width=8) (actual time=0.047..60.566 rows=963,529 loops=1) |
56. | 0.200 | 5.084 | ↓ 596.3 | 1,789 | 1 |
→
Hash (cost=250.39..250.39 rows=3 width=4) (actual time=5.084..5.084 rows=1,789 loops=1)
|
57. | 0.887 | 4.884 | ↓ 596.3 | 1,789 | 1 |
→
Nested Loop (cost=213.48..250.39 rows=3 width=4) (actual time=0.671..4.884 rows=1,789 loops=1) |
58. | 1.632 | 2.208 | ↓ 596.3 | 1,789 | 1 |
→
Bitmap Heap Scan on simple_value prop_purpose (cost=213.05..225.02 rows=3 width=4) (actual time=0.660..2.208 rows=1,789 loops=1)
|
59. | 0.068 | 0.576 | ↓ 0.0 | 0 | 1 |
→
BitmapAnd (cost=213.05..213.05 rows=3 width=0) (actual time=0.576..0.576 rows=0 loops=1) |
60. | 0.212 | 0.212 | ↑ 1.1 | 2,923 | 1 |
→
Bitmap Index Scan on simple_value_value_idx (cost=0.00..95.80 rows=3,173 width=0) (actual time=0.212..0.212 rows=2,923 loops=1)
|
61. | 0.296 | 0.296 | ↓ 1.2 | 1,989 | 1 |
→
Bitmap Index Scan on simple_value_short_xpath_idx (cost=0.00..117.00 rows=1,679 width=0) (actual time=0.296..0.296 rows=1,989 loops=1)
|
62. | 1.789 | 1.789 | ↑ 1.0 | 1 | 1,789 |
→
Index Scan using value_pkey on value prop_purpose_v (cost=0.43..8.45 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=1,789)
|
63. | 3.560 | 3.560 | ↑ 1.0 | 1 | 1,780 |
→
Index Scan using simple_value_value_id_idx on simple_value annots (cost=0.43..0.56 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1,780)
|
64. | 3.560 | 3.560 | ↑ 12.0 | 6 | 1,780 |
→
Index Scan using value_top_idx on value prop_name_v (cost=0.43..1.72 rows=72 width=8) (actual time=0.001..0.002 rows=6 loops=1,780)
|
65. | 10.386 | 10.386 | ↓ 0.0 | 0 | 10,386 |
→
Index Scan using simple_value_value_id_idx on simple_value prop_name (cost=0.43..0.56 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=10,386)
|
66. | 3.560 | 3.560 | ↑ 12.0 | 6 | 1,780 |
→
Index Scan using value_top_idx on value prop_translation_v (cost=0.43..1.72 rows=72 width=8) (actual time=0.001..0.002 rows=6 loops=1,780)
|
67. | 10.386 | 10.386 | ↓ 0.0 | 0 | 10,386 |
→
Index Scan using simple_value_value_id_idx on simple_value prop_translation (cost=0.43..0.56 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=10,386)
|
68. | 3.413 | 3.413 | ↑ 1.0 | 1 | 3,413 |
→
Index Scan using simple_value_value_id_idx on simple_value prop_translation_lang (cost=0.43..0.56 rows=1 width=9) (actual time=0.001..0.001 rows=1 loops=3,413)
|
69. | 0.000 | 0.000 | ↑ 1.0 | 1 | 3,413 |
→
Seq Scan on language lang (cost=0.00..1.02 rows=1 width=12) (actual time=0.000..0.000 rows=1 loops=3,413)
|
70. |
CTE translated_enum_value |
|||||
71. | 0.893 | 726.180 | ↓ 78,184.0 | 78,184 | 1 |
→
Nested Loop (cost=69.32..215.76 rows=1 width=108) (actual time=346.864..726.180 rows=78,184 loops=1) |
72. | 231.531 | 646.003 | ↓ 79,284.0 | 79,284 | 1 |
→
Merge Join (cost=69.04..215.34 rows=1 width=88) (actual time=346.853..646.003 rows=79,284 loops=1)
|
73. | 0.396 | 0.396 | ↑ 1.1 | 2,470 | 1 |
→
Index Scan using data_type_enumeration_element_data_type_id_sort_key on data_type_enumeration_element dtee (cost=0.28..129.48 rows=2,827 width=15) (actual time=0.009..0.396 rows=2,470 loops=1) |
74. | 98.921 | 414.076 | ↓ 8,745.5 | 1,993,965 | 1 |
→
Sort (cost=68.75..69.32 rows=228 width=88) (actual time=343.961..414.076 rows=1,993,965 loops=1)
|
75. | 30.077 | 315.155 | ↓ 782.5 | 178,406 | 1 |
→
Hash Join (cost=52.13..59.83 rows=228 width=88) (actual time=0.332..315.155 rows=178,406 loops=1)
|
76. | 284.751 | 284.751 | ↓ 782.5 | 178,406 | 1 |
→
CTE Scan on values_for_names v_1 (cost=0.00..4.56 rows=228 width=84) (actual time=0.000..284.751 rows=178,406 loops=1) |
77. | 0.148 | 0.327 | ↑ 1.0 | 1,828 | 1 |
→
Hash (cost=29.28..29.28 rows=1,828 width=8) (actual time=0.327..0.327 rows=1,828 loops=1)
|
78. | 0.179 | 0.179 | ↑ 1.0 | 1,828 | 1 |
→
Seq Scan on complex_data_type_part cdtp (cost=0.00..29.28 rows=1,828 width=8) (actual time=0.005..0.179 rows=1,828 loops=1) |
79. | 79.284 | 79.284 | ↑ 1.0 | 1 | 79,284 |
→
Index Scan using data_type_enumeration_element_language_id_data_type_enumera_key on data_type_enumeration_element tdtee (cost=0.28..0.41 rows=1 width=28) (actual time=0.001..0.001 rows=1 loops=79,284)
|
80. |
CTE data_class_names |
|||||
81. | 0.001 | 0.035 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=5.68..8.66 rows=1 width=495) (actual time=0.035..0.035 rows=0 loops=1) |
82. | 0.000 | 0.034 | ↓ 0.0 | 0 | 1 |
→
Nested Loop (cost=5.54..8.48 rows=1 width=31) (actual time=0.034..0.034 rows=0 loops=1)
|
83. | 0.014 | 0.034 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=5.27..7.65 rows=1 width=12) (actual time=0.034..0.034 rows=0 loops=1)
|
84. | 0.000 | 0.000 | ↑ 100.0 | 1 | 1 |
→
CTE Scan on features f_4 (cost=0.00..2.00 rows=100 width=8) (actual time=0.000..0.000 rows=1 loops=1) |
85. | 0.000 | 0.020 | ↓ 0.0 | 0 | 1 |
→
Hash (cost=5.24..5.24 rows=2 width=4) (actual time=0.020..0.020 rows=0 loops=1)
|
86. | 0.020 | 0.020 | ↓ 0.0 | 0 | 1 |
→
CTE Scan on name_rule nr_3 (cost=0.00..5.24 rows=2 width=4) (actual time=0.020..0.020 rows=0 loops=1)
|
87. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using data_class_pkey on data_class dc_1 (cost=0.28..0.81 rows=1 width=31) (never executed)
|
|
88. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using namespace_pkey on namespace n (cost=0.14..0.17 rows=1 width=472) (never executed)
|
|
89. |
CTE names_merge_source |
|||||
90. | 36.657 | 22,629.592 | ↓ 779.1 | 178,406 | 1 |
→
Unique (cost=17.64..19.93 rows=229 width=132) (actual time=22,581.027..22,629.592 rows=178,406 loops=1) |
91. | 77.698 | 22,592.935 | ↓ 779.1 | 178,406 | 1 |
→
Sort (cost=17.64..18.22 rows=229 width=132) (actual time=22,581.025..22,592.935 rows=178,406 loops=1)
|
92. | 9.449 | 22,515.237 | ↓ 779.1 | 178,406 | 1 |
→
Append (cost=0.07..8.67 rows=229 width=132) (actual time=22,422.129..22,515.237 rows=178,406 loops=1) |
93. | 41.982 | 22,505.752 | ↓ 782.5 | 178,406 | 1 |
→
Hash Left Join (cost=0.07..6.36 rows=228 width=132) (actual time=22,422.127..22,505.752 rows=178,406 loops=1)
|
94. | 25.326 | 21,703.684 | ↓ 782.5 | 178,406 | 1 |
→
Hash Left Join (cost=0.03..5.46 rows=228 width=104) (actual time=21,662.027..21,703.684 rows=178,406 loops=1)
|
95. | 21,504.912 | 21,504.912 | ↓ 782.5 | 178,406 | 1 |
→
CTE Scan on values_for_names v_2 (cost=0.00..4.56 rows=228 width=72) (actual time=21,488.563..21,504.912 rows=178,406 loops=1) |
96. | 0.190 | 173.446 | ↓ 1,635.0 | 1,635 | 1 |
→
Hash (cost=0.02..0.02 rows=1 width=68) (actual time=173.446..173.446 rows=1,635 loops=1)
|
97. | 173.256 | 173.256 | ↓ 1,635.0 | 1,635 | 1 |
→
CTE Scan on translated_prop_value tpv (cost=0.00..0.02 rows=1 width=68) (actual time=172.767..173.256 rows=1,635 loops=1) |
98. | 9.494 | 760.086 | ↓ 78,184.0 | 78,184 | 1 |
→
Hash (cost=0.02..0.02 rows=1 width=36) (actual time=760.086..760.086 rows=78,184 loops=1)
|
99. | 750.592 | 750.592 | ↓ 78,184.0 | 78,184 | 1 |
→
CTE Scan on translated_enum_value tv (cost=0.00..0.02 rows=1 width=36) (actual time=346.867..750.592 rows=78,184 loops=1) |
100. | 0.036 | 0.036 | ↓ 0.0 | 0 | 1 |
→
CTE Scan on data_class_names dcn (cost=0.00..0.02 rows=1 width=36) (actual time=0.036..0.036 rows=0 loops=1) |
101. |
CTE features_names |
|||||
102. | 106.878 | 23,087.668 | ↓ 133,500.0 | 133,500 | 1 |
→
GroupAggregate (cost=1,698.71..1,698.74 rows=1 width=40) (actual time=22,973.122..23,087.668 rows=133,500 loops=1)
|
103. | 54.066 | 22,980.790 | ↓ 178,406.0 | 178,406 | 1 |
→
Sort (cost=1,698.71..1,698.72 rows=1 width=40) (actual time=22,973.103..22,980.790 rows=178,406 loops=1)
|
104. | 69.857 | 22,926.724 | ↓ 178,406.0 | 178,406 | 1 |
→
Hash Join (cost=8.57..1,698.70 rows=1 width=40) (actual time=22,581.122..22,926.724 rows=178,406 loops=1)
|
105. | 21.775 | 22,856.829 | ↓ 779.1 | 178,406 | 1 |
→
Nested Loop (cost=0.42..1,663.06 rows=229 width=72) (actual time=22,581.061..22,856.829 rows=178,406 loops=1) |
106. | 22,656.648 | 22,656.648 | ↓ 779.1 | 178,406 | 1 |
→
CTE Scan on names_merge_source nms (cost=0.00..4.58 rows=229 width=68) (actual time=22,581.028..22,656.648 rows=178,406 loops=1) |
107. | 178.406 | 178.406 | ↑ 1.0 | 1 | 178,406 |
→
Index Scan using feature_pkey on feature f_5 (cost=0.42..7.23 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=178,406)
|
108. | 0.010 | 0.038 | ↑ 2.0 | 116 | 1 |
→
Hash (cost=4.66..4.66 rows=233 width=476) (actual time=0.038..0.038 rows=116 loops=1)
|
109. | 0.028 | 0.028 | ↑ 2.0 | 116 | 1 |
→
CTE Scan on name_rule nr_4 (cost=0.00..4.66 rows=233 width=476) (actual time=0.002..0.028 rows=116 loops=1) |
110. | 74.373 | 74.373 | ↓ 1,355.5 | 135,552 | 1 |
→
CTE Scan on features f (cost=0.00..2.00 rows=100 width=580) (actual time=63.028..74.373 rows=135,552 loops=1) |
111. | 15.831 | 23,129.008 | ↓ 133,500.0 | 133,500 | 1 |
→
Hash (cost=0.02..0.02 rows=1 width=36) (actual time=23,129.008..23,129.008 rows=133,500 loops=1)
|
112. | 23,113.177 | 23,113.177 | ↓ 133,500.0 | 133,500 | 1 |
→
CTE Scan on features_names fn (cost=0.00..0.02 rows=1 width=36) (actual time=22,973.124..23,113.177 rows=133,500 loops=1) |