explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tNOc

Settings
# exclusive inclusive rows x rows loops node
1. 0.414 320.840 ↓ 22.8 2,280 1

Hash Left Join (cost=48,273.93..48,276.56 rows=100 width=612) (actual time=320.285..320.840 rows=2,280 loops=1)

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

CTE features

3. 0.542 3.641 ↓ 22.8 2,280 1

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

4. 0.691 0.819 ↓ 22.8 2,280 1

HashAggregate (cost=1.76..2.76 rows=100 width=4) (actual time=0.569..0.819 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.128 0.128 ↓ 22.8 2,280 1

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.004..0.128 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.703 5.144 ↑ 117.0 2 1

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

9. 0.412 4.418 ↓ 29.6 4,560 1

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

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

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

11. 0.272 3.986 ↓ 22.8 2,280 1

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

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

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

13. 0.000 0.023 ↓ 0.0 0 1

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

14. 0.013 0.023 ↓ 0.0 0 1

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

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

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

16. 0.000 0.004 ↓ 0.0 0 1

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

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

WorkTable Scan on data_class_rule dcr (cost=0.00..30.80 rows=8 width=8) (actual time=0.004..0.004 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. 5.149 5.149 ↑ 116.5 2 1

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

  • Filter: (priority IS NOT NULL)
21.          

CTE snapshot_values

22. 134.401 134.401 ↓ 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=133.489..134.401 rows=12,415 loops=1)

23.          

CTE values_for_names

24. 1.657 257.846 ↓ 20.0 4,551 1

Hash Join (cost=44,253.28..44,716.90 rows=228 width=59) (actual time=255.230..257.846 rows=4,551 loops=1)

  • Hash Cond: ((nr_2.data_class_id = f_3.data_class_id) AND ((nr_2.path)::text = (sv.short_xpath)::text))
25. 5.150 5.150 ↑ 116.5 2 1

CTE Scan on name_rule nr_2 (cost=0.00..4.66 rows=233 width=472) (actual time=4.008..5.150 rows=2 loops=1)

26. 17.674 251.039 ↓ 1.2 47,777 1

Hash (cost=43,666.49..43,666.49 rows=39,119 width=63) (actual time=251.039..251.039 rows=47,777 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 5948kB
27. 13.037 233.365 ↓ 1.2 47,777 1

Nested Loop (cost=12.32..43,666.49 rows=39,119 width=63) (actual time=133.946..233.365 rows=47,777 loops=1)

28. 2.554 178.776 ↓ 1.1 41,552 1

Nested Loop (cost=11.90..22,839.85 rows=36,736 width=16) (actual time=133.936..178.776 rows=41,552 loops=1)

29. 2.699 138.977 ↓ 24.8 12,415 1

Hash Join (cost=3.25..32.00 rows=500 width=12) (actual time=133.914..138.977 rows=12,415 loops=1)

  • Hash Cond: (snv_1.feature_id = f_3.id)
30. 135.869 135.869 ↓ 12.4 12,415 1

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

31. 0.202 0.409 ↓ 22.8 2,280 1

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

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 122kB
32. 0.207 0.207 ↓ 22.8 2,280 1

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

33. 12.415 37.245 ↑ 24.3 3 12,415

Bitmap Heap Scan on value v (cost=8.65..44.89 rows=73 width=8) (actual time=0.002..0.003 rows=3 loops=12,415)

  • Recheck Cond: ((id = snv_1.id) OR (top = snv_1.id))
  • Heap Blocks: exact=12657
34. 0.000 24.830 ↓ 0.0 0 12,415

BitmapOr (cost=8.65..8.65 rows=73 width=0) (actual time=0.002..0.002 rows=0 loops=12,415)

35. 12.415 12.415 ↑ 1.0 1 12,415

Bitmap Index Scan on value_pkey (cost=0.00..4.04 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=12,415)

  • Index Cond: (id = snv_1.id)
36. 12.415 12.415 ↑ 36.0 2 12,415

Bitmap Index Scan on value_top_idx (cost=0.00..4.57 rows=72 width=0) (actual time=0.001..0.001 rows=2 loops=12,415)

  • Index Cond: (top = snv_1.id)
37. 41.552 41.552 ↑ 1.0 1 41,552

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=41,552)

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

CTE translated_prop_value

39. 0.061 21.918 ↓ 462.0 462 1

Unique (cost=282.76..282.78 rows=1 width=14) (actual time=21.846..21.918 rows=462 loops=1)

40. 0.105 21.857 ↓ 462.0 462 1

Sort (cost=282.76..282.77 rows=1 width=14) (actual time=21.845..21.857 rows=462 loops=1)

  • Sort Key: snv_2.feature_id, ((prop_name.value)::ltree), prop_translation.value
  • Sort Method: quicksort Memory: 69kB
41. 0.941 21.752 ↓ 462.0 462 1

Nested Loop (cost=252.99..282.75 rows=1 width=14) (actual time=4.979..21.752 rows=462 loops=1)

  • Join Filter: (prop_translation_lang.value = (lang.let2)::text)
  • Rows Removed by Join Filter: 594
42. 0.607 20.811 ↓ 1,056.0 1,056 1

Nested Loop (cost=252.99..281.71 rows=1 width=19) (actual time=4.965..20.811 rows=1,056 loops=1)

  • Join Filter: (prop_translation.value_id = prop_translation_lang.value_id)
43. 1.071 19.148 ↓ 1,056.0 1,056 1

Nested Loop (cost=252.56..281.14 rows=1 width=22) (actual time=4.961..19.148 rows=1,056 loops=1)

44. 0.261 14.773 ↓ 3,304.0 3,304 1

Nested Loop (cost=252.13..280.57 rows=1 width=13) (actual time=4.951..14.773 rows=3,304 loops=1)

  • Join Filter: (annots.value_id = prop_translation_v.top)
45. 0.810 13.320 ↓ 596.0 596 1

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

46. 0.335 9.206 ↓ 3,304.0 3,304 1

Nested Loop (cost=251.28..277.38 rows=1 width=24) (actual time=4.943..9.206 rows=3,304 loops=1)

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

Nested Loop (cost=250.85..274.76 rows=1 width=16) (actual time=4.936..7.679 rows=596 loops=1)

  • Join Filter: (snv_2.id = annots.value_id)
48. 0.919 6.518 ↓ 596.0 596 1

Hash Join (cost=250.42..274.18 rows=1 width=12) (actual time=4.925..6.518 rows=596 loops=1)

  • Hash Cond: (snv_2.id = prop_purpose_v.top)
49. 0.682 0.682 ↓ 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.000..0.682 rows=12,415 loops=1)

50. 0.199 4.917 ↓ 596.3 1,789 1

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

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

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

52. 1.520 2.061 ↓ 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.625..2.061 rows=1,789 loops=1)

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

BitmapAnd (cost=213.05..213.05 rows=3 width=0) (actual time=0.541..0.541 rows=0 loops=1)

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

  • Index Cond: (value = 'OTHER:TRANSLATION'::text)
55. 0.279 0.279 ↓ 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.279..0.279 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. 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)
58. 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)
59. 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
60. 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)
61. 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
62. 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
63. 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
64.          

CTE translated_enum_value

65. 0.583 26.338 ↓ 2,276.0 2,276 1

Nested Loop (cost=69.32..215.76 rows=1 width=108) (actual time=6.296..26.338 rows=2,276 loops=1)

66. 13.637 23.479 ↓ 2,276.0 2,276 1

Merge Join (cost=69.04..215.34 rows=1 width=88) (actual time=6.281..23.479 rows=2,276 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: 100144
67. 0.187 0.187 ↑ 1.9 1,475 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.187 rows=1,475 loops=1)

68. 4.977 9.655 ↓ 459.0 104,651 1

Sort (cost=68.75..69.32 rows=228 width=88) (actual time=5.455..9.655 rows=104,651 loops=1)

  • Sort Key: cdtp.data_type_id
  • Sort Method: quicksort Memory: 690kB
69. 0.753 4.678 ↓ 20.0 4,551 1

Hash Join (cost=52.13..59.83 rows=228 width=88) (actual time=0.309..4.678 rows=4,551 loops=1)

  • Hash Cond: (v_1.complex_data_type_part_id = cdtp.id)
70. 3.621 3.621 ↓ 20.0 4,551 1

CTE Scan on values_for_names v_1 (cost=0.00..4.56 rows=228 width=84) (actual time=0.000..3.621 rows=4,551 loops=1)

71. 0.148 0.304 ↑ 1.0 1,828 1

Hash (cost=29.28..29.28 rows=1,828 width=8) (actual time=0.304..0.304 rows=1,828 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 88kB
72. 0.156 0.156 ↑ 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.156 rows=1,828 loops=1)

73. 2.276 2.276 ↑ 1.0 1 2,276

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=2,276)

  • Index Cond: ((language_id = 1) AND (data_type_enumeration_element_id = dtee.id))
74.          

CTE data_class_names

75. 0.000 0.014 ↓ 0.0 0 1

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

76. 0.001 0.014 ↓ 0.0 0 1

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

  • Join Filter: (nr_3.data_class_id = dc_1.id)
77. 0.008 0.013 ↓ 0.0 0 1

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

  • Hash Cond: (f_4.data_class_id = nr_3.data_class_id)
78. 0.001 0.001 ↑ 100.0 1 1

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

79. 0.001 0.004 ↓ 0.0 0 1

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

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

CTE Scan on name_rule nr_3 (cost=0.00..5.24 rows=2 width=4) (actual time=0.003..0.003 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_4.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. 0.897 308.910 ↓ 19.9 4,551 1

Unique (cost=17.64..19.93 rows=229 width=132) (actual time=307.748..308.910 rows=4,551 loops=1)

85. 1.245 308.013 ↓ 19.9 4,551 1

Sort (cost=17.64..18.22 rows=229 width=132) (actual time=307.747..308.013 rows=4,551 loops=1)

  • Sort Key: v_2.feature_id, (COALESCE(tpv.translation, tv.name, v_2.value)), v_2.short_xpath
  • Sort Method: quicksort Memory: 612kB
86. 0.246 306.768 ↓ 19.9 4,551 1

Append (cost=0.07..8.67 rows=229 width=132) (actual time=304.882..306.768 rows=4,551 loops=1)

87. 0.611 306.508 ↓ 20.0 4,551 1

Hash Left Join (cost=0.07..6.36 rows=228 width=132) (actual time=304.882..306.508 rows=4,551 loops=1)

  • Hash Cond: (v_2.simple_value_id = tv.simple_value_id)
88. 0.692 278.339 ↓ 20.0 4,551 1

Hash Left Join (cost=0.03..5.46 rows=228 width=104) (actual time=277.309..278.339 rows=4,551 loops=1)

  • Hash Cond: (v_2.feature_id = tpv.feature_id)
  • Join Filter: (tpv.path = v_2.short_xpath)
  • Rows Removed by Join Filter: 685
89. 255.583 255.583 ↓ 20.0 4,551 1

CTE Scan on values_for_names v_2 (cost=0.00..4.56 rows=228 width=72) (actual time=255.231..255.583 rows=4,551 loops=1)

90. 0.073 22.064 ↓ 462.0 462 1

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

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

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

92. 0.375 27.558 ↓ 2,276.0 2,276 1

Hash (cost=0.02..0.02 rows=1 width=36) (actual time=27.558..27.558 rows=2,276 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 166kB
93. 27.183 27.183 ↓ 2,276.0 2,276 1

CTE Scan on translated_enum_value tv (cost=0.00..0.02 rows=1 width=36) (actual time=6.297..27.183 rows=2,276 loops=1)

94. 0.014 0.014 ↓ 0.0 0 1

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

95.          

CTE features_names

96. 2.110 318.986 ↓ 2,277.0 2,277 1

GroupAggregate (cost=1,698.71..1,698.74 rows=1 width=40) (actual time=316.707..318.986 rows=2,277 loops=1)

  • Group Key: nms.feature_id
97. 0.726 316.876 ↓ 4,551.0 4,551 1

Sort (cost=1,698.71..1,698.72 rows=1 width=40) (actual time=316.691..316.876 rows=4,551 loops=1)

  • Sort Key: nms.feature_id
  • Sort Method: quicksort Memory: 486kB
98. 1.719 316.150 ↓ 4,551.0 4,551 1

Hash Join (cost=8.57..1,698.70 rows=1 width=40) (actual time=307.781..316.150 rows=4,551 loops=1)

  • Hash Cond: (((nms.path)::text = (nr_4.path)::text) AND (f_5.data_class_id = nr_4.data_class_id))
99. 0.492 314.429 ↓ 19.9 4,551 1

Nested Loop (cost=0.42..1,663.06 rows=229 width=72) (actual time=307.768..314.429 rows=4,551 loops=1)

100. 309.386 309.386 ↓ 19.9 4,551 1

CTE Scan on names_merge_source nms (cost=0.00..4.58 rows=229 width=68) (actual time=307.749..309.386 rows=4,551 loops=1)

101. 4.551 4.551 ↑ 1.0 1 4,551

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=4,551)

  • Index Cond: (id = nms.feature_id)
102. 0.002 0.002 ↑ 116.5 2 1

Hash (cost=4.66..4.66 rows=233 width=476) (actual time=0.002..0.002 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
103. 0.000 0.000 ↑ 116.5 2 1

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

104. 0.740 0.740 ↓ 22.8 2,280 1

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

105. 0.275 319.686 ↓ 2,277.0 2,277 1

Hash (cost=0.02..0.02 rows=1 width=36) (actual time=319.686..319.686 rows=2,277 loops=1)

  • Buckets: 4096 (originally 1024) Batches: 1 (originally 1) Memory Usage: 191kB
106. 319.411 319.411 ↓ 2,277.0 2,277 1

CTE Scan on features_names fn (cost=0.00..0.02 rows=1 width=36) (actual time=316.709..319.411 rows=2,277 loops=1)