explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UZGt

Settings
# exclusive inclusive rows x rows loops node
1. 0.589 1,332.471 ↓ 22.8 2,280 1

Hash Right Join (cost=160,242.55..160,248.55 rows=100 width=612) (actual time=1,329.047..1,332.471 rows=2,280 loops=1)

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

CTE features

3. 0.755 3.838 ↓ 22.8 2,280 1

Nested Loop (cost=2.18..791.51 rows=100 width=55) (actual time=0.518..3.838 rows=2,280 loops=1)

4. 0.650 0.803 ↓ 22.8 2,280 1

HashAggregate (cost=1.76..2.76 rows=100 width=4) (actual time=0.502..0.803 rows=2,280 loops=1)

  • Group Key: unnest('{19173,29268,29272,29274,29276,29284,29288,29290,29292,29293,29294,29295,29296,29297,29298,29300,29306,29314,29319,29327,29332,29334,29336,29338,29340,29342,29345,29348,29352,29355,29361,29363,29366,29368,29370,29372,2937 (...)
5. 0.153 0.153 ↓ 22.8 2,280 1

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.005..0.153 rows=2,280 loops=1)

6. 2.280 2.280 ↑ 1.0 1 2,280

Index Scan using feature_pkey on feature f_1 (cost=0.42..7.88 rows=1 width=55) (actual time=0.001..0.001 rows=1 loops=2,280)

  • Index Cond: (id = (unnest('{19173,29268,29272,29274,29276,29284,29288,29290,29292,29293,29294,29295,29296,29297,29298,29300,29306,29314,29319,29327,29332,29334,29336,29338,29340,29342,29345,29348,29352,29355,29361,29363,29366,29368,29370,29 (...)
7.          

CTE data_class_rule

8. 0.715 1.586 ↑ 117.0 2 1

Recursive Union (cost=3.25..524.70 rows=234 width=20) (actual time=0.465..1.586 rows=2 loops=1)

9. 0.388 0.854 ↓ 29.6 4,560 1

Hash Right Join (cost=3.25..9.25 rows=154 width=16) (actual time=0.462..0.854 rows=4,560 loops=1)

  • Hash Cond: (nr.data_class_id = f_2.data_class_id)
10. 0.019 0.019 ↑ 1.0 179 1

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

11. 0.224 0.447 ↓ 22.8 2,280 1

Hash (cost=2.00..2.00 rows=100 width=4) (actual time=0.447..0.447 rows=2,280 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 113kB
12. 0.223 0.223 ↓ 22.8 2,280 1

CTE Scan on features f_2 (cost=0.00..2.00 rows=100 width=4) (actual time=0.001..0.223 rows=2,280 loops=1)

13. 0.002 0.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.05..51.08 rows=8 width=20) (actual time=0.017..0.017 rows=0 loops=1)

14. 0.009 0.015 ↓ 0.0 0 1

Hash Join (cost=30.90..49.31 rows=8 width=8) (actual time=0.015..0.015 rows=0 loops=1)

  • Hash Cond: (dc.id = dcr.data_class_id)
15. 0.005 0.005 ↑ 751.0 1 1

Seq Scan on data_class dc (cost=0.00..15.51 rows=751 width=8) (actual time=0.005..0.005 rows=1 loops=1)

16. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=30.80..30.80 rows=8 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
17. 0.001 0.001 ↓ 0.0 0 1

WorkTable Scan on data_class_rule dcr (cost=0.00..30.80 rows=8 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (priority IS NULL)
  • Rows Removed by Filter: 2
18. 0.000 0.000 ↓ 0.0 0

Index Scan using name_rule_data_class_id_priority_key on name_rule nr_1 (cost=0.14..0.20 rows=2 width=16) (never executed)

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

CTE name_rule

20. 1.589 1.589 ↑ 116.5 2 1

CTE Scan on data_class_rule (cost=0.00..4.68 rows=233 width=476) (actual time=0.467..1.589 rows=2 loops=1)

  • Filter: (priority IS NOT NULL)
21.          

CTE snapshot_values

22. 133.928 133.928 ↓ 12.4 12,415 1

Function Scan on d_get_features_snapshot_values snv (cost=0.25..10.25 rows=1,000 width=8) (actual time=132.985..133.928 rows=12,415 loops=1)

23.          

CTE pre_values

24. 19.754 192.094 ↑ 1.8 41,552 1

HashAggregate (cost=18,980.28..19,715.01 rows=73,473 width=12) (actual time=181.955..192.094 rows=41,552 loops=1)

  • Group Key: snv_1.feature_id, snv_1.id, v.id
25. 2.463 172.340 ↑ 1.8 41,552 1

Append (cost=0.43..18,429.23 rows=73,473 width=12) (actual time=133.030..172.340 rows=41,552 loops=1)

26. 3.961 151.732 ↓ 12.4 12,415 1

Nested Loop (cost=0.43..7,871.00 rows=1,000 width=12) (actual time=133.029..151.732 rows=12,415 loops=1)

27. 135.356 135.356 ↓ 12.4 12,415 1

CTE Scan on snapshot_values snv_1 (cost=0.00..20.00 rows=1,000 width=8) (actual time=132.988..135.356 rows=12,415 loops=1)

28. 12.415 12.415 ↑ 1.0 1 12,415

Index Only Scan using value_pkey on value v (cost=0.43..7.84 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=12,415)

  • Index Cond: (id = snv_1.id)
  • Heap Fetches: 12415
29. 4.589 18.145 ↑ 2.5 29,137 1

Nested Loop (cost=0.43..9,823.50 rows=72,473 width=12) (actual time=0.012..18.145 rows=29,137 loops=1)

30. 1.141 1.141 ↓ 12.4 12,415 1

CTE Scan on snapshot_values snv_2 (cost=0.00..20.00 rows=1,000 width=8) (actual time=0.001..1.141 rows=12,415 loops=1)

31. 12.415 12.415 ↑ 36.0 2 12,415

Index Scan using value_top_idx on value v_1 (cost=0.43..9.08 rows=72 width=8) (actual time=0.001..0.001 rows=2 loops=12,415)

  • Index Cond: (top = snv_2.id)
32.          

CTE values

33. 110.683 939.667 ↑ 2.2 47,777 1

Merge Join (cost=7,408.32..100,659.40 rows=104,485 width=59) (actual time=364.422..939.667 rows=47,777 loops=1)

  • Merge Cond: (sv.value_id = snv_3.value_id)
34. 618.092 618.092 ↑ 1.0 1,762,750 1

Index Scan using simple_value_value_id_idx on simple_value sv (cost=0.43..87,276.70 rows=1,763,017 width=51) (actual time=0.009..618.092 rows=1,762,750 loops=1)

35. 12.446 210.892 ↑ 1.5 47,777 1

Sort (cost=7,407.89..7,591.57 rows=73,473 width=12) (actual time=204.394..210.892 rows=47,777 loops=1)

  • Sort Key: snv_3.value_id
  • Sort Method: quicksort Memory: 3484kB
36. 198.446 198.446 ↑ 1.8 41,552 1

CTE Scan on pre_values snv_3 (cost=0.00..1,469.46 rows=73,473 width=12) (actual time=181.957..198.446 rows=41,552 loops=1)

37.          

CTE translated_prop_value

38. 0.067 22.569 ↓ 462.0 462 1

Unique (cost=282.77..282.78 rows=1 width=14) (actual time=22.493..22.569 rows=462 loops=1)

39. 0.158 22.502 ↓ 462.0 462 1

Sort (cost=282.77..282.78 rows=1 width=14) (actual time=22.493..22.502 rows=462 loops=1)

  • Sort Key: snv_4.feature_id, ((prop_name.value)::ltree), prop_translation.value
  • Sort Method: quicksort Memory: 69kB
40. 0.990 22.344 ↓ 462.0 462 1

Nested Loop (cost=253.00..282.76 rows=1 width=14) (actual time=5.054..22.344 rows=462 loops=1)

  • Join Filter: (prop_translation_lang.value = (lang.let2)::text)
  • Rows Removed by Join Filter: 594
41. 0.665 21.354 ↓ 1,056.0 1,056 1

Nested Loop (cost=253.00..281.72 rows=1 width=19) (actual time=5.040..21.354 rows=1,056 loops=1)

  • Join Filter: (prop_translation.value_id = prop_translation_lang.value_id)
42. 1.184 19.633 ↓ 1,056.0 1,056 1

Nested Loop (cost=252.57..281.14 rows=1 width=22) (actual time=5.034..19.633 rows=1,056 loops=1)

43. 0.265 15.145 ↓ 3,304.0 3,304 1

Nested Loop (cost=252.14..280.57 rows=1 width=13) (actual time=5.024..15.145 rows=3,304 loops=1)

  • Join Filter: (annots.value_id = prop_translation_v.top)
44. 0.842 13.688 ↓ 596.0 596 1

Nested Loop (cost=251.71..277.95 rows=1 width=25) (actual time=5.019..13.688 rows=596 loops=1)

45. 0.446 9.542 ↓ 3,304.0 3,304 1

Nested Loop (cost=251.29..277.38 rows=1 width=24) (actual time=5.015..9.542 rows=3,304 loops=1)

  • Join Filter: (annots.value_id = prop_name_v.top)
46. 0.000 7.904 ↓ 596.0 596 1

Nested Loop (cost=250.86..274.76 rows=1 width=16) (actual time=5.008..7.904 rows=596 loops=1)

  • Join Filter: (snv_4.id = annots.value_id)
47. 1.001 6.714 ↓ 596.0 596 1

Hash Join (cost=250.43..274.19 rows=1 width=12) (actual time=4.998..6.714 rows=596 loops=1)

  • Hash Cond: (snv_4.id = prop_purpose_v.top)
48. 0.726 0.726 ↓ 12.4 12,415 1

CTE Scan on snapshot_values snv_4 (cost=0.00..20.00 rows=1,000 width=8) (actual time=0.001..0.726 rows=12,415 loops=1)

49. 0.188 4.987 ↓ 596.3 1,789 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 79kB
50. 0.849 4.799 ↓ 596.3 1,789 1

Nested Loop (cost=213.49..250.39 rows=3 width=4) (actual time=0.712..4.799 rows=1,789 loops=1)

51. 1.549 2.161 ↓ 596.3 1,789 1

Bitmap Heap Scan on simple_value prop_purpose (cost=213.06..225.03 rows=3 width=4) (actual time=0.697..2.161 rows=1,789 loops=1)

  • Recheck Cond: ((value = 'OTHER:TRANSLATION'::text) AND (short_xpath = 'annotation.purpose'::ltree))
  • Heap Blocks: exact=1045
52. 0.074 0.612 ↓ 0.0 0 1

BitmapAnd (cost=213.06..213.06 rows=3 width=0) (actual time=0.612..0.612 rows=0 loops=1)

53. 0.224 0.224 ↑ 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.224..0.224 rows=2,923 loops=1)

  • Index Cond: (value = 'OTHER:TRANSLATION'::text)
54. 0.314 0.314 ↓ 1.2 1,989 1

Bitmap Index Scan on simple_value_short_xpath_idx (cost=0.00..117.01 rows=1,680 width=0) (actual time=0.314..0.314 rows=1,989 loops=1)

  • Index Cond: (short_xpath = 'annotation.purpose'::ltree)
55. 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)
56. 1.192 1.192 ↑ 1.0 1 596

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=596)

  • Index Cond: (value_id = prop_purpose_v.top)
  • Filter: (short_xpath = 'annotation'::ltree)
57. 1.192 1.192 ↑ 12.0 6 596

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=596)

  • Index Cond: (top = prop_purpose_v.top)
58. 3.304 3.304 ↓ 0.0 0 3,304

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=3,304)

  • Index Cond: (value_id = prop_name_v.id)
  • Filter: (short_xpath = 'annotation.propertyName'::ltree)
  • Rows Removed by Filter: 1
59. 1.192 1.192 ↑ 12.0 6 596

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=596)

  • Index Cond: (top = prop_name_v.top)
60. 3.304 3.304 ↓ 0.0 0 3,304

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=3,304)

  • Index Cond: (value_id = prop_translation_v.id)
  • Filter: (short_xpath = 'annotation.translatedNote.note'::ltree)
  • Rows Removed by Filter: 1
61. 1.056 1.056 ↑ 1.0 1 1,056

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=1,056)

  • Index Cond: (value_id = prop_translation_v.id)
  • Filter: (short_xpath = 'annotation.translatedNote.note.0lang'::ltree)
  • Rows Removed by Filter: 1
62. 0.000 0.000 ↑ 1.0 1 1,056

Seq Scan on language lang (cost=0.00..1.02 rows=1 width=12) (actual time=0.000..0.000 rows=1 loops=1,056)

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

CTE translated_enum_value

64. 26.888 658.019 ↓ 175.6 18,261 1

Hash Join (cost=538.76..5,903.62 rows=104 width=108) (actual time=4.290..658.019 rows=18,261 loops=1)

  • Hash Cond: (v_2.complex_data_type_part_id = cdtp.id)
  • Join Filter: (((dtee.value)::text = v_2.value) OR (dtee.other AND (('OTHER:'::text || (dtee.value)::text) = v_2.value)))
  • Rows Removed by Join Filter: 164546
65. 626.864 626.864 ↑ 2.2 47,777 1

CTE Scan on values v_2 (cost=0.00..2,089.70 rows=104,485 width=84) (actual time=0.000..626.864 rows=47,777 loops=1)

66. 0.741 4.267 ↓ 2.2 5,952 1

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

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 454kB
67. 0.963 3.526 ↓ 2.2 5,952 1

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

  • Hash Cond: (dtee.id = tdtee.data_type_enumeration_element_id)
68. 0.920 1.908 ↓ 1.8 6,607 1

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

  • Merge Cond: (dtee.data_type_id = cdtp.data_type_id)
69. 0.359 0.359 ↑ 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.359 rows=2,827 loops=1)

70. 0.459 0.629 ↓ 4.1 7,407 1

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

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

72. 0.250 0.655 ↑ 1.0 2,172 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 157kB
73. 0.405 0.405 ↑ 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.405 rows=2,172 loops=1)

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

CTE data_class_names

75. 0.000 0.016 ↓ 0.0 0 1

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

76. 0.001 0.016 ↓ 0.0 0 1

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

  • Join Filter: (nr_2.data_class_id = dc_1.id)
77. 0.009 0.015 ↓ 0.0 0 1

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

  • Hash Cond: (f_3.data_class_id = nr_2.data_class_id)
78. 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)

79. 0.000 0.005 ↓ 0.0 0 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
80. 0.005 0.005 ↓ 0.0 0 1

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

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

CTE names_merge_source

84. 16.539 1,169.807 ↑ 2.5 41,230 1

Unique (cost=13,181.92..14,226.78 rows=104,486 width=132) (actual time=1,150.177..1,169.807 rows=41,230 loops=1)

85. 68.618 1,153.268 ↑ 2.2 47,777 1

Sort (cost=13,181.92..13,443.14 rows=104,486 width=132) (actual time=1,150.177..1,153.268 rows=47,777 loops=1)

  • Sort Key: v_3.feature_id, (COALESCE(tpv.translation, tv.name, v_3.value)), v_3.short_xpath
  • Sort Method: quicksort Memory: 7802kB
86. 2.554 1,084.650 ↑ 2.2 47,777 1

Append (cost=3.41..4,471.47 rows=104,486 width=132) (actual time=1,055.956..1,084.650 rows=47,777 loops=1)

87. 9.927 1,082.079 ↑ 2.2 47,777 1

Hash Left Join (cost=3.41..3,426.59 rows=104,485 width=132) (actual time=1,055.955..1,082.079 rows=47,777 loops=1)

  • Hash Cond: (v_3.simple_value_id = tv.simple_value_id)
88. 11.309 403.353 ↑ 2.2 47,777 1

Hash Left Join (cost=0.03..2,488.08 rows=104,485 width=104) (actual time=387.146..403.353 rows=47,777 loops=1)

  • Hash Cond: (v_3.feature_id = tpv.feature_id)
  • Join Filter: (tpv.path = v_3.short_xpath)
  • Rows Removed by Join Filter: 28684
89. 369.338 369.338 ↑ 2.2 47,777 1

CTE Scan on values v_3 (cost=0.00..2,089.70 rows=104,485 width=72) (actual time=364.426..369.338 rows=47,777 loops=1)

90. 0.068 22.706 ↓ 462.0 462 1

Hash (cost=0.02..0.02 rows=1 width=68) (actual time=22.706..22.706 rows=462 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
91. 22.638 22.638 ↓ 462.0 462 1

CTE Scan on translated_prop_value tpv (cost=0.00..0.02 rows=1 width=68) (actual time=22.495..22.638 rows=462 loops=1)

92. 3.268 668.799 ↓ 175.6 18,261 1

Hash (cost=2.08..2.08 rows=104 width=36) (actual time=668.799..668.799 rows=18,261 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1313kB
93. 665.531 665.531 ↓ 175.6 18,261 1

CTE Scan on translated_enum_value tv (cost=0.00..2.08 rows=104 width=36) (actual time=4.291..665.531 rows=18,261 loops=1)

94. 0.017 0.017 ↓ 0.0 0 1

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

95.          

CTE features_names

96. 2.182 1,326.586 ↓ 11.4 2,277 1

GroupAggregate (cost=18,104.84..18,111.91 rows=200 width=40) (actual time=1,324.135..1,326.586 rows=2,277 loops=1)

  • Group Key: nms.feature_id
97. 0.979 1,324.404 ↓ 7.5 4,551 1

Sort (cost=18,104.84..18,106.36 rows=609 width=40) (actual time=1,324.120..1,324.404 rows=4,551 loops=1)

  • Sort Key: nms.feature_id
  • Sort Method: quicksort Memory: 486kB
98. 7.371 1,323.425 ↓ 7.5 4,551 1

Merge Join (cost=16,761.59..18,076.67 rows=609 width=40) (actual time=1,313.479..1,323.425 rows=4,551 loops=1)

  • Merge Cond: (((nr_3.path)::text = ((nms.path)::text)) AND (nr_3.data_class_id = f_4.data_class_id))
99. 0.010 1.600 ↑ 116.5 2 1

Sort (cost=13.82..14.40 rows=233 width=476) (actual time=1.598..1.600 rows=2 loops=1)

  • Sort Key: nr_3.path, nr_3.data_class_id
  • Sort Method: quicksort Memory: 25kB
100. 1.590 1.590 ↑ 116.5 2 1

CTE Scan on name_rule nr_3 (cost=0.00..4.66 rows=233 width=476) (actual time=0.468..1.590 rows=2 loops=1)

101. 62.904 1,314.454 ↑ 2.5 41,228 1

Sort (cost=16,747.77..17,008.99 rows=104,486 width=72) (actual time=1,309.344..1,314.454 rows=41,228 loops=1)

  • Sort Key: ((nms.path)::text), f_4.data_class_id
  • Sort Method: quicksort Memory: 9761kB
102. 13.486 1,251.550 ↑ 2.5 41,230 1

Hash Join (cost=4,510.92..8,037.32 rows=104,486 width=72) (actual time=1,182.150..1,251.550 rows=41,230 loops=1)

  • Hash Cond: (nms.feature_id = f_4.id)
103. 1,206.761 1,206.761 ↑ 2.5 41,230 1

CTE Scan on names_merge_source nms (cost=0.00..2,089.72 rows=104,486 width=68) (actual time=1,150.180..1,206.761 rows=41,230 loops=1)

104. 18.182 31.303 ↑ 1.0 135,552 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 7343kB
105. 13.121 13.121 ↑ 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.007..13.121 rows=135,552 loops=1)

106. 1,326.983 1,326.983 ↓ 11.4 2,277 1

CTE Scan on features_names fn (cost=0.00..4.00 rows=200 width=36) (actual time=1,324.137..1,326.983 rows=2,277 loops=1)

107. 0.401 4.899 ↓ 22.8 2,280 1

Hash (cost=2.00..2.00 rows=100 width=580) (actual time=4.899..4.899 rows=2,280 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 201kB
108. 4.498 4.498 ↓ 22.8 2,280 1

CTE Scan on features f (cost=0.00..2.00 rows=100 width=580) (actual time=0.518..4.498 rows=2,280 loops=1)