explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZKOo

Settings
# exclusive inclusive rows x rows loops node
1. 55.953 35,206.072 ↓ 1,355.5 135,552 1

Hash Right Join (cost=124,706.45..124,712.45 rows=100 width=612) (actual time=34,996.404..35,206.072 rows=135,552 loops=1)

  • Hash Cond: (fn.feature_id = f.id)
2.          

CTE features

3. 0.000 516.392 ↓ 1,355.5 135,552 1

Nested Loop (cost=3,157.59..3,946.92 rows=100 width=55) (actual time=77.258..516.392 rows=135,552 loops=1)

4. 92.921 118.539 ↓ 1,355.5 135,552 1

HashAggregate (cost=3,157.17..3,158.17 rows=100 width=4) (actual time=77.229..118.539 rows=135,552 loops=1)

  • Group Key: unnest($0)
5. 8.335 25.618 ↓ 1,355.5 135,552 1

Result (cost=3,155.41..3,155.92 rows=100 width=0) (actual time=17.374..25.618 rows=135,552 loops=1)

6.          

Initplan (forResult)

7. 9.433 17.283 ↑ 1.0 1 1

Aggregate (cost=3,155.40..3,155.41 rows=1 width=4) (actual time=17.283..17.283 rows=1 loops=1)

8. 7.850 7.850 ↑ 1.0 135,552 1

Seq Scan on feature (cost=0.00..2,816.52 rows=135,552 width=4) (actual time=0.005..7.850 rows=135,552 loops=1)

9. 406.656 406.656 ↑ 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.003..0.003 rows=1 loops=135,552)

  • Index Cond: (id = (unnest($0)))
10.          

CTE data_class_rule

11. 31.297 87.680 ↑ 1.9 126 1

Recursive Union (cost=3.25..524.70 rows=234 width=20) (actual time=27.895..87.680 rows=126 loops=1)

12. 28.163 56.071 ↓ 1,301.4 200,412 1

Hash Right Join (cost=3.25..9.25 rows=154 width=16) (actual time=27.891..56.071 rows=200,412 loops=1)

  • Hash Cond: (nr.data_class_id = f_2.data_class_id)
13. 0.039 0.039 ↑ 1.0 179 1

Seq Scan on name_rule nr (cost=0.00..3.79 rows=179 width=16) (actual time=0.008..0.039 rows=179 loops=1)

14. 12.777 27.869 ↓ 1,355.5 135,552 1

Hash (cost=2.00..2.00 rows=100 width=4) (actual time=27.869..27.869 rows=135,552 loops=1)

  • Buckets: 262144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 6814kB
15. 15.092 15.092 ↓ 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..15.092 rows=135,552 loops=1)

16. 0.013 0.312 ↑ 4.0 2 4

Nested Loop Left Join (cost=31.05..51.08 rows=8 width=20) (actual time=0.030..0.078 rows=2 loops=4)

17. 0.134 0.292 ↑ 4.0 2 4

Hash Join (cost=30.90..49.31 rows=8 width=8) (actual time=0.026..0.073 rows=2 loops=4)

  • Hash Cond: (dc.id = dcr.data_class_id)
18. 0.138 0.138 ↑ 1.0 751 3

Seq Scan on data_class dc (cost=0.00..15.51 rows=751 width=8) (actual time=0.003..0.046 rows=751 loops=3)

19. 0.004 0.020 ↑ 4.0 2 4

Hash (cost=30.80..30.80 rows=8 width=8) (actual time=0.005..0.005 rows=2 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
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.004..0.004 rows=2 loops=4)

  • Filter: (priority IS NULL)
  • Rows Removed by Filter: 29
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)

  • Index Cond: (data_class_id = dc.base_id)
22.          

CTE name_rule

23. 87.736 87.736 ↑ 2.0 116 1

CTE Scan on data_class_rule (cost=0.00..4.68 rows=233 width=476) (actual time=27.897..87.736 rows=116 loops=1)

  • Filter: (priority IS NOT NULL)
  • Rows Removed by Filter: 10
24.          

CTE snapshot_values

25. 15,656.107 15,674.206 ↓ 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,612.066..15,674.206 rows=963,529 loops=1)

26.          

Initplan (forFunction Scan)

27. 9.819 18.099 ↑ 1.0 1 1

Aggregate (cost=3,155.40..3,155.41 rows=1 width=4) (actual time=18.099..18.099 rows=1 loops=1)

28. 8.280 8.280 ↑ 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.004..8.280 rows=135,552 loops=1)

29.          

CTE values

30. 573.696 20,734.130 ↓ 21.7 1,697,998 1

Nested Loop (cost=9.07..87,289.55 rows=78,239 width=59) (actual time=15,612.138..20,734.130 rows=1,697,998 loops=1)

31. 925.743 18,562.042 ↓ 21.8 1,598,392 1

Nested Loop (cost=8.65..45,635.71 rows=73,473 width=12) (actual time=15,612.111..18,562.042 rows=1,598,392 loops=1)

32. 15,709.241 15,709.241 ↓ 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,612.067..15,709.241 rows=963,529 loops=1)

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

  • Recheck Cond: ((id = snv_1.id) OR (top = snv_1.id))
  • Heap Blocks: exact=968306
34. 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)

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

  • Index Cond: (id = snv_1.id)
36. 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)

  • Index Cond: (top = snv_1.id)
37. 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)

  • Index Cond: (value_id = v.id)
38.          

CTE translated_prop_value

39. 0.235 304.071 ↓ 1,635.0 1,635 1

Unique (cost=282.76..282.78 rows=1 width=14) (actual time=303.782..304.071 rows=1,635 loops=1)

40. 0.414 303.836 ↓ 1,635.0 1,635 1

Sort (cost=282.76..282.77 rows=1 width=14) (actual time=303.782..303.836 rows=1,635 loops=1)

  • Sort Key: snv_2.feature_id, ((prop_name.value)::ltree), prop_translation.value
  • Sort Method: quicksort Memory: 196kB
41. 3.161 303.422 ↓ 1,635.0 1,635 1

Nested Loop (cost=252.99..282.75 rows=1 width=14) (actual time=6.027..303.422 rows=1,635 loops=1)

  • Join Filter: (prop_translation_lang.value = (lang.let2)::text)
  • Rows Removed by Join Filter: 1778
42. 2.030 300.261 ↓ 3,413.0 3,413 1

Nested Loop (cost=252.99..281.71 rows=1 width=19) (actual time=6.015..300.261 rows=3,413 loops=1)

  • Join Filter: (prop_translation.value_id = prop_translation_lang.value_id)
43. 3.374 294.818 ↓ 3,413.0 3,413 1

Nested Loop (cost=252.56..281.14 rows=1 width=22) (actual time=6.008..294.818 rows=3,413 loops=1)

44. 0.932 281.058 ↓ 10,386.0 10,386 1

Nested Loop (cost=252.13..280.57 rows=1 width=13) (actual time=5.997..281.058 rows=10,386 loops=1)

  • Join Filter: (annots.value_id = prop_translation_v.top)
45. 2.606 276.566 ↓ 1,780.0 1,780 1

Nested Loop (cost=251.71..277.95 rows=1 width=25) (actual time=5.993..276.566 rows=1,780 loops=1)

46. 1.362 263.574 ↓ 10,386.0 10,386 1

Nested Loop (cost=251.28..277.38 rows=1 width=24) (actual time=5.989..263.574 rows=10,386 loops=1)

  • Join Filter: (annots.value_id = prop_name_v.top)
47. 0.580 244.412 ↓ 1,780.0 1,780 1

Nested Loop (cost=250.85..274.76 rows=1 width=16) (actual time=5.978..244.412 rows=1,780 loops=1)

  • Join Filter: (snv_2.id = annots.value_id)
48. 61.539 240.272 ↓ 1,780.0 1,780 1

Hash Join (cost=250.42..274.18 rows=1 width=12) (actual time=5.957..240.272 rows=1,780 loops=1)

  • Hash Cond: (snv_2.id = prop_purpose_v.top)
49. 173.672 173.672 ↓ 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.001..173.672 rows=963,529 loops=1)

50. 0.261 5.061 ↓ 596.3 1,789 1

Hash (cost=250.39..250.39 rows=3 width=4) (actual time=5.061..5.061 rows=1,789 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 79kB
51. 0.847 4.800 ↓ 596.3 1,789 1

Nested Loop (cost=213.48..250.39 rows=3 width=4) (actual time=0.673..4.800 rows=1,789 loops=1)

52. 1.588 2.164 ↓ 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.665..2.164 rows=1,789 loops=1)

  • Recheck Cond: ((value = 'OTHER:TRANSLATION'::text) AND (short_xpath = 'annotation.purpose'::ltree))
  • Heap Blocks: exact=1045
53. 0.079 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)

54. 0.210 0.210 ↑ 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.210..0.210 rows=2,923 loops=1)

  • Index Cond: (value = 'OTHER:TRANSLATION'::text)
55. 0.287 0.287 ↓ 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.287..0.287 rows=1,989 loops=1)

  • Index Cond: (short_xpath = 'annotation.purpose'::ltree)
56. 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)

  • Index Cond: (id = prop_purpose.value_id)
57. 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)

  • Index Cond: (value_id = prop_purpose_v.top)
  • Filter: (short_xpath = 'annotation'::ltree)
58. 17.800 17.800 ↑ 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.009..0.010 rows=6 loops=1,780)

  • Index Cond: (top = prop_purpose_v.top)
59. 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)

  • Index Cond: (value_id = prop_name_v.id)
  • Filter: (short_xpath = 'annotation.propertyName'::ltree)
  • Rows Removed by Filter: 1
60. 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)

  • Index Cond: (top = prop_name_v.top)
61. 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)

  • Index Cond: (value_id = prop_translation_v.id)
  • Filter: (short_xpath = 'annotation.translatedNote.note'::ltree)
  • Rows Removed by Filter: 1
62. 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)

  • Index Cond: (value_id = prop_translation_v.id)
  • Filter: (short_xpath = 'annotation.translatedNote.note.0lang'::ltree)
  • Rows Removed by Filter: 1
63. 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)

  • Filter: (id = 1)
  • Rows Removed by Filter: 1
64.          

CTE translated_enum_value

65. 705.946 6,483.136 ↓ 7,577.7 591,057 1

Hash Join (cost=538.76..4,556.01 rows=78 width=108) (actual time=4.171..6,483.136 rows=591,057 loops=1)

  • Hash Cond: (v_1.complex_data_type_part_id = cdtp.id)
  • Join Filter: (((dtee.value)::text = v_1.value) OR (dtee.other AND (('OTHER:'::text || (dtee.value)::text) = v_1.value)))
  • Rows Removed by Join Filter: 3666107
66. 5,773.099 5,773.099 ↓ 21.7 1,697,998 1

CTE Scan on values v_1 (cost=0.00..1,564.78 rows=78,239 width=84) (actual time=0.001..5,773.099 rows=1,697,998 loops=1)

67. 0.739 4.091 ↓ 2.2 5,952 1

Hash (cost=504.36..504.36 rows=2,752 width=35) (actual time=4.091..4.091 rows=5,952 loops=1)

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 454kB
68. 0.920 3.352 ↓ 2.2 5,952 1

Hash Join (cost=269.15..504.36 rows=2,752 width=35) (actual time=0.987..3.352 rows=5,952 loops=1)

  • Hash Cond: (dtee.id = tdtee.data_type_enumeration_element_id)
69. 0.854 1.794 ↓ 1.8 6,607 1

Merge Join (cost=128.66..318.44 rows=3,582 width=15) (actual time=0.344..1.794 rows=6,607 loops=1)

  • Merge Cond: (dtee.data_type_id = cdtp.data_type_id)
70. 0.326 0.326 ↑ 1.0 2,827 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.008..0.326 rows=2,827 loops=1)

71. 0.465 0.614 ↓ 4.1 7,407 1

Sort (cost=128.32..132.89 rows=1,828 width=8) (actual time=0.333..0.614 rows=7,407 loops=1)

  • Sort Key: cdtp.data_type_id
  • Sort Method: quicksort Memory: 134kB
72. 0.149 0.149 ↑ 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.004..0.149 rows=1,828 loops=1)

73. 0.227 0.638 ↑ 1.0 2,172 1

Hash (cost=113.34..113.34 rows=2,172 width=28) (actual time=0.638..0.638 rows=2,172 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 157kB
74. 0.411 0.411 ↑ 1.0 2,172 1

Seq Scan on data_type_enumeration_element tdtee (cost=0.00..113.34 rows=2,172 width=28) (actual time=0.006..0.411 rows=2,172 loops=1)

  • Filter: (language_id = 1)
  • Rows Removed by Filter: 1775
75.          

CTE data_class_names

76. 0.001 0.034 ↓ 0.0 0 1

Nested Loop (cost=5.68..8.66 rows=1 width=495) (actual time=0.034..0.034 rows=0 loops=1)

77. 0.000 0.033 ↓ 0.0 0 1

Nested Loop (cost=5.54..8.48 rows=1 width=31) (actual time=0.033..0.033 rows=0 loops=1)

  • Join Filter: (nr_2.data_class_id = dc_1.id)
78. 0.013 0.033 ↓ 0.0 0 1

Hash Join (cost=5.27..7.65 rows=1 width=12) (actual time=0.033..0.033 rows=0 loops=1)

  • Hash Cond: (f_3.data_class_id = nr_2.data_class_id)
79. 0.001 0.001 ↑ 100.0 1 1

CTE Scan on features f_3 (cost=0.00..2.00 rows=100 width=8) (actual time=0.001..0.001 rows=1 loops=1)

80. 0.000 0.019 ↓ 0.0 0 1

Hash (cost=5.24..5.24 rows=2 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
81. 0.019 0.019 ↓ 0.0 0 1

CTE Scan on name_rule nr_2 (cost=0.00..5.24 rows=2 width=4) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((path IS NULL) OR ((path)::text = ''::text))
  • Rows Removed by Filter: 116
82. 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)

  • Index Cond: (id = f_3.data_class_id)
83. 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)

  • Index Cond: (id = dc_1.namespace_id)
84.          

CTE names_merge_source

85. 354.755 26,132.361 ↓ 19.4 1,514,423 1

Unique (cost=9,605.78..10,388.18 rows=78,240 width=132) (actual time=25,588.431..26,132.361 rows=1,514,423 loops=1)

86. 1,761.377 25,777.606 ↓ 21.7 1,697,998 1

Sort (cost=9,605.78..9,801.38 rows=78,240 width=132) (actual time=25,588.430..25,777.606 rows=1,697,998 loops=1)

  • Sort Key: v_2.feature_id, (COALESCE(tpv.translation, tv.name, v_2.value)), v_2.short_xpath
  • Sort Method: external sort Disk: 92520kB
87. 92.777 24,016.229 ↓ 21.7 1,697,998 1

Append (cost=2.57..3,246.58 rows=78,240 width=132) (actual time=22,806.444..24,016.229 rows=1,697,998 loops=1)

88. 638.658 23,923.417 ↓ 21.7 1,697,998 1

Hash Left Join (cost=2.57..2,464.16 rows=78,239 width=132) (actual time=22,806.443..23,923.417 rows=1,697,998 loops=1)

  • Hash Cond: (v_2.simple_value_id = tv.simple_value_id)
89. 284.160 16,394.988 ↓ 21.7 1,697,998 1

Hash Left Join (cost=0.03..1,863.10 rows=78,239 width=104) (actual time=15,916.662..16,394.988 rows=1,697,998 loops=1)

  • Hash Cond: (v_2.feature_id = tpv.feature_id)
  • Join Filter: (tpv.path = v_2.short_xpath)
  • Rows Removed by Join Filter: 79118
90. 15,806.317 15,806.317 ↓ 21.7 1,697,998 1

CTE Scan on values v_2 (cost=0.00..1,564.78 rows=78,239 width=72) (actual time=15,612.141..15,806.317 rows=1,697,998 loops=1)

91. 0.188 304.511 ↓ 1,635.0 1,635 1

Hash (cost=0.02..0.02 rows=1 width=68) (actual time=304.511..304.511 rows=1,635 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 134kB
92. 304.323 304.323 ↓ 1,635.0 1,635 1

CTE Scan on translated_prop_value tpv (cost=0.00..0.02 rows=1 width=68) (actual time=303.784..304.323 rows=1,635 loops=1)

93. 108.524 6,889.771 ↓ 7,577.7 591,057 1

Hash (cost=1.56..1.56 rows=78 width=36) (actual time=6,889.771..6,889.771 rows=591,057 loops=1)

  • Buckets: 1048576 (originally 1024) Batches: 1 (originally 1) Memory Usage: 39609kB
94. 6,781.247 6,781.247 ↓ 7,577.7 591,057 1

CTE Scan on translated_enum_value tv (cost=0.00..1.56 rows=78 width=36) (actual time=4.172..6,781.247 rows=591,057 loops=1)

95. 0.035 0.035 ↓ 0.0 0 1

CTE Scan on data_class_names dcn (cost=0.00..0.02 rows=1 width=36) (actual time=0.035..0.035 rows=0 loops=1)

96.          

CTE features_names

97. 112.696 34,474.720 ↓ 667.5 133,500 1

GroupAggregate (cost=14,530.15..14,536.07 rows=200 width=40) (actual time=34,344.377..34,474.720 rows=133,500 loops=1)

  • Group Key: nms.feature_id
98. 51.234 34,362.024 ↓ 391.2 178,406 1

Sort (cost=14,530.15..14,531.29 rows=456 width=40) (actual time=34,344.357..34,362.024 rows=178,406 loops=1)

  • Sort Key: nms.feature_id
  • Sort Method: quicksort Memory: 15002kB
99. 174.602 34,310.790 ↓ 391.2 178,406 1

Merge Join (cost=13,524.54..14,510.01 rows=456 width=40) (actual time=33,982.313..34,310.790 rows=178,406 loops=1)

  • Merge Cond: (((nr_3.path)::text = ((nms.path)::text)) AND (nr_3.data_class_id = f_4.data_class_id))
100. 0.115 87.880 ↑ 2.0 116 1

Sort (cost=13.82..14.40 rows=233 width=476) (actual time=87.850..87.880 rows=116 loops=1)

  • Sort Key: nr_3.path, nr_3.data_class_id
  • Sort Method: quicksort Memory: 32kB
101. 87.765 87.765 ↑ 2.0 116 1

CTE Scan on name_rule nr_3 (cost=0.00..4.66 rows=233 width=476) (actual time=27.898..87.765 rows=116 loops=1)

102. 7,112.490 34,048.308 ↓ 19.4 1,514,423 1

Sort (cost=13,510.72..13,706.32 rows=78,240 width=72) (actual time=33,878.829..34,048.308 rows=1,514,423 loops=1)

  • Sort Key: ((nms.path)::text), f_4.data_class_id
  • Sort Method: external sort Disk: 126480kB
103. 464.694 26,935.818 ↓ 19.4 1,514,423 1

Hash Join (cost=4,510.92..7,151.52 rows=78,240 width=72) (actual time=25,620.676..26,935.818 rows=1,514,423 loops=1)

  • Hash Cond: (nms.feature_id = f_4.id)
104. 26,439.087 26,439.087 ↓ 19.4 1,514,423 1

CTE Scan on names_merge_source nms (cost=0.00..1,564.80 rows=78,240 width=68) (actual time=25,588.433..26,439.087 rows=1,514,423 loops=1)

105. 18.347 32.037 ↑ 1.0 135,552 1

Hash (cost=2,816.52..2,816.52 rows=135,552 width=8) (actual time=32.037..32.037 rows=135,552 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 7343kB
106. 13.690 13.690 ↑ 1.0 135,552 1

Seq Scan on feature f_4 (cost=0.00..2,816.52 rows=135,552 width=8) (actual time=0.009..13.690 rows=135,552 loops=1)

107. 34,498.105 34,498.105 ↓ 667.5 133,500 1

CTE Scan on features_names fn (cost=0.00..4.00 rows=200 width=36) (actual time=34,344.381..34,498.105 rows=133,500 loops=1)

108. 47.156 652.014 ↓ 1,355.5 135,552 1

Hash (cost=2.00..2.00 rows=100 width=580) (actual time=652.014..652.014 rows=135,552 loops=1)

  • Buckets: 262144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 13173kB
109. 604.858 604.858 ↓ 1,355.5 135,552 1

CTE Scan on features f (cost=0.00..2.00 rows=100 width=580) (actual time=77.260..604.858 rows=135,552 loops=1)