explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hllm

Settings
# 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)

  • Hash Cond: (f.id = fn.feature_id)
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)

  • Group Key: unnest($0)
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)

  • Index Cond: (id = (unnest($0)))
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)

  • Hash Cond: (nr.data_class_id = f_2.data_class_id)
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)

  • Buckets: 262144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 6814kB
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)

  • Hash Cond: (dc.id = dcr.data_class_id)
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)

  • 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.003..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. 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)

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

  • Hash Cond: ((nr_2.data_class_id = f_3.data_class_id) AND ((nr_2.path)::text = (sv.short_xpath)::text))
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)

  • Buckets: 524288 (originally 65536) Batches: 4 (originally 1) Memory Usage: 46357kB
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)

  • Hash Cond: (snv_1.feature_id = f_3.id)
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)

  • Buckets: 262144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 7343kB
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)

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

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

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

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

  • Sort Key: snv_2.feature_id, ((prop_name.value)::ltree), prop_translation.value
  • Sort Method: quicksort Memory: 196kB
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)

  • Join Filter: (prop_translation_lang.value = (lang.let2)::text)
  • Rows Removed by Join Filter: 1778
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)

  • Join Filter: (prop_translation.value_id = prop_translation_lang.value_id)
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)

  • Join Filter: (annots.value_id = prop_translation_v.top)
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)

  • Join Filter: (annots.value_id = prop_name_v.top)
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)

  • Join Filter: (snv_2.id = annots.value_id)
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)

  • Hash Cond: (snv_2.id = prop_purpose_v.top)
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)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 79kB
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)

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

  • Index Cond: (value = 'OTHER:TRANSLATION'::text)
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)

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

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

  • Index Cond: (value_id = prop_purpose_v.top)
  • Filter: (short_xpath = 'annotation'::ltree)
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)

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

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

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

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

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

  • Filter: (id = 1)
  • Rows Removed by Filter: 1
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)

  • Merge Cond: (dtee.data_type_id = cdtp.data_type_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: 1815971
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)

  • Sort Key: cdtp.data_type_id
  • Sort Method: quicksort Memory: 24742kB
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)

  • Hash Cond: (v_1.complex_data_type_part_id = cdtp.id)
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)

  • Buckets: 2048 Batches: 1 Memory Usage: 88kB
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)

  • Index Cond: ((language_id = 1) AND (data_type_enumeration_element_id = dtee.id))
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)

  • Join Filter: (nr_3.data_class_id = dc_1.id)
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)

  • Hash Cond: (f_4.data_class_id = nr_3.data_class_id)
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)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
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)

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

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

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

  • Sort Key: v_2.feature_id, (COALESCE(tpv.translation, tv.name, v_2.value)), v_2.short_xpath
  • Sort Method: quicksort Memory: 20170kB
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)

  • Hash Cond: (v_2.simple_value_id = tv.simple_value_id)
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)

  • Hash Cond: (v_2.feature_id = tpv.feature_id)
  • Join Filter: (tpv.path = v_2.short_xpath)
  • Rows Removed by Join Filter: 2219
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)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 134kB
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)

  • Buckets: 131072 (originally 1024) Batches: 1 (originally 1) Memory Usage: 3952kB
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)

  • Group Key: nms.feature_id
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)

  • Sort Key: nms.feature_id
  • Sort Method: quicksort Memory: 15002kB
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)

  • Hash Cond: (((nms.path)::text = (nr_4.path)::text) AND (f_5.data_class_id = nr_4.data_class_id))
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)

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
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)

  • Buckets: 262144 (originally 1024) Batches: 1 (originally 1) Memory Usage: 7947kB
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)