explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aokV

Settings
# exclusive inclusive rows x rows loops node
1. 0.751 557.170 ↓ 22.8 2,280 1

Hash Right Join (cost=118,395.63..118,401.63 rows=100 width=612) (actual time=553.374..557.170 rows=2,280 loops=1)

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

CTE features

3. 0.508 3.488 ↓ 22.8 2,280 1

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

4. 0.562 0.700 ↓ 22.8 2,280 1

HashAggregate (cost=1.76..2.76 rows=100 width=4) (actual time=0.422..0.700 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.138 0.138 ↓ 22.8 2,280 1

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

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

9. 0.370 0.761 ↓ 29.6 4,560 1

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

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

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

11. 0.188 0.377 ↓ 22.8 2,280 1

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

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

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

13. 0.000 0.009 ↓ 0.0 0 1

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

14. 0.003 0.009 ↓ 0.0 0 1

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

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

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

16. 0.000 0.002 ↓ 0.0 0 1

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

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

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

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

  • Filter: (priority IS NOT NULL)
21.          

CTE snapshot_values

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

23.          

CTE values

24. 22.128 246.983 ↑ 1.6 47,777 1

Nested Loop (cost=9.07..87,289.55 rows=78,239 width=59) (actual time=134.695..246.983 rows=47,777 loops=1)

25. 10.152 183.303 ↑ 1.8 41,552 1

Nested Loop (cost=8.65..45,635.71 rows=73,473 width=12) (actual time=134.686..183.303 rows=41,552 loops=1)

26. 135.906 135.906 ↓ 12.4 12,415 1

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

27. 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.003..0.003 rows=3 loops=12,415)

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

29. 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)
30. 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)
31. 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)
32.          

CTE translated_prop_value

33. 0.068 25.654 ↓ 462.0 462 1

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

34. 0.127 25.586 ↓ 462.0 462 1

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

  • Sort Key: snv_2.feature_id, ((prop_name.value)::ltree), prop_translation.value
  • Sort Method: quicksort Memory: 69kB
35. 0.973 25.459 ↓ 462.0 462 1

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

  • Join Filter: (prop_translation_lang.value = (lang.let2)::text)
  • Rows Removed by Join Filter: 594
36. 0.693 24.486 ↓ 1,056.0 1,056 1

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

  • Join Filter: (prop_translation.value_id = prop_translation_lang.value_id)
37. 1.273 22.737 ↓ 1,056.0 1,056 1

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

38. 0.264 18.160 ↓ 3,304.0 3,304 1

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

  • Join Filter: (annots.value_id = prop_translation_v.top)
39. 0.876 16.704 ↓ 596.0 596 1

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

40. 0.387 12.524 ↓ 3,304.0 3,304 1

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

  • Join Filter: (annots.value_id = prop_name_v.top)
41. 0.089 10.945 ↓ 596.0 596 1

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

  • Join Filter: (snv_2.id = annots.value_id)
42. 1.049 9.664 ↓ 596.0 596 1

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

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

44. 0.396 6.663 ↓ 596.3 1,789 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 79kB
45. 0.116 6.267 ↓ 596.3 1,789 1

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

46. 1.944 2.573 ↓ 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.727..2.573 rows=1,789 loops=1)

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

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

48. 0.220 0.220 ↑ 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.220..0.220 rows=2,923 loops=1)

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

  • Index Cond: (short_xpath = 'annotation.purpose'::ltree)
50. 3.578 3.578 ↑ 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.002..0.002 rows=1 loops=1,789)

  • Index Cond: (id = prop_purpose.value_id)
51. 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)
52. 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)
53. 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
54. 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)
55. 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
56. 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
57. 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
58.          

CTE translated_enum_value

59. 26.847 158.584 ↓ 234.1 18,261 1

Hash Join (cost=538.76..4,556.01 rows=78 width=108) (actual time=4.127..158.584 rows=18,261 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: 164546
60. 127.673 127.673 ↑ 1.6 47,777 1

CTE Scan on values v_1 (cost=0.00..1,564.78 rows=78,239 width=84) (actual time=0.006..127.673 rows=47,777 loops=1)

61. 0.717 4.064 ↓ 2.2 5,952 1

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

  • Buckets: 8192 (originally 4096) Batches: 1 (originally 1) Memory Usage: 454kB
62. 0.913 3.347 ↓ 2.2 5,952 1

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

  • Hash Cond: (dtee.id = tdtee.data_type_enumeration_element_id)
63. 0.874 1.808 ↓ 1.8 6,607 1

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

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

65. 0.421 0.577 ↓ 4.1 7,407 1

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

  • Sort Key: cdtp.data_type_id
  • Sort Method: quicksort Memory: 134kB
66. 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.003..0.156 rows=1,828 loops=1)

67. 0.228 0.626 ↑ 1.0 2,172 1

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

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

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

CTE data_class_names

70. 0.000 0.015 ↓ 0.0 0 1

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

71. 0.001 0.015 ↓ 0.0 0 1

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

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

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

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

74. 0.000 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
75. 0.004 0.004 ↓ 0.0 0 1

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

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

CTE names_merge_source

79. 17.227 416.317 ↑ 1.9 41,230 1

Unique (cost=9,605.78..10,388.18 rows=78,240 width=132) (actual time=395.801..416.317 rows=41,230 loops=1)

80. 39.129 399.090 ↑ 1.6 47,777 1

Sort (cost=9,605.78..9,801.38 rows=78,240 width=132) (actual time=395.801..399.090 rows=47,777 loops=1)

  • Sort Key: v_2.feature_id, (COALESCE(tpv.translation, tv.name, v_2.value)), v_2.short_xpath
  • Sort Method: quicksort Memory: 7802kB
81. 2.517 359.961 ↑ 1.6 47,777 1

Append (cost=2.57..3,246.58 rows=78,240 width=132) (actual time=329.983..359.961 rows=47,777 loops=1)

82. 10.478 357.428 ↑ 1.6 47,777 1

Hash Left Join (cost=2.57..2,464.16 rows=78,239 width=132) (actual time=329.983..357.428 rows=47,777 loops=1)

  • Hash Cond: (v_2.simple_value_id = tv.simple_value_id)
83. 11.631 177.483 ↑ 1.6 47,777 1

Hash Left Join (cost=0.03..1,863.10 rows=78,239 width=104) (actual time=160.504..177.483 rows=47,777 loops=1)

  • Hash Cond: (v_2.feature_id = tpv.feature_id)
  • Join Filter: (tpv.path = v_2.short_xpath)
  • Rows Removed by Join Filter: 28684
84. 140.055 140.055 ↑ 1.6 47,777 1

CTE Scan on values v_2 (cost=0.00..1,564.78 rows=78,239 width=72) (actual time=134.697..140.055 rows=47,777 loops=1)

85. 0.060 25.797 ↓ 462.0 462 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
86. 25.737 25.737 ↓ 462.0 462 1

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

87. 3.319 169.467 ↓ 234.1 18,261 1

Hash (cost=1.56..1.56 rows=78 width=36) (actual time=169.467..169.467 rows=18,261 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1313kB
88. 166.148 166.148 ↓ 234.1 18,261 1

CTE Scan on translated_enum_value tv (cost=0.00..1.56 rows=78 width=36) (actual time=4.128..166.148 rows=18,261 loops=1)

89. 0.016 0.016 ↓ 0.0 0 1

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

90.          

CTE features_names

91. 2.351 551.512 ↓ 11.4 2,277 1

GroupAggregate (cost=14,530.15..14,536.07 rows=200 width=40) (actual time=548.858..551.512 rows=2,277 loops=1)

  • Group Key: nms.feature_id
92. 1.025 549.161 ↓ 10.0 4,551 1

Sort (cost=14,530.15..14,531.29 rows=456 width=40) (actual time=548.842..549.161 rows=4,551 loops=1)

  • Sort Key: nms.feature_id
  • Sort Method: quicksort Memory: 486kB
93. 7.751 548.136 ↓ 10.0 4,551 1

Merge Join (cost=13,524.54..14,510.01 rows=456 width=40) (actual time=537.679..548.136 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))
94. 0.009 1.529 ↑ 116.5 2 1

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

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

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

96. 66.915 538.856 ↑ 1.9 41,228 1

Sort (cost=13,510.72..13,706.32 rows=78,240 width=72) (actual time=533.301..538.856 rows=41,228 loops=1)

  • Sort Key: ((nms.path)::text), f_4.data_class_id
  • Sort Method: quicksort Memory: 9752kB
97. 13.857 471.941 ↑ 1.9 41,230 1

Hash Join (cost=4,510.92..7,151.52 rows=78,240 width=72) (actual time=432.517..471.941 rows=41,230 loops=1)

  • Hash Cond: (nms.feature_id = f_4.id)
98. 422.136 422.136 ↑ 1.9 41,230 1

CTE Scan on names_merge_source nms (cost=0.00..1,564.80 rows=78,240 width=68) (actual time=395.803..422.136 rows=41,230 loops=1)

99. 21.620 35.948 ↑ 1.0 135,552 1

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

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

101. 551.911 551.911 ↓ 11.4 2,277 1

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

102. 0.332 4.508 ↓ 22.8 2,280 1

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

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

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