explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hb7

Settings
# exclusive inclusive rows x rows loops node
1. 0.263 311.139 ↓ 9.3 926 1

Hash Right Join (cost=118,399.55..118,405.55 rows=100 width=612) (actual time=309.678..311.139 rows=926 loops=1)

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

CTE features

3. 0.188 1.370 ↓ 9.3 926 1

Nested Loop (cost=2.18..791.51 rows=100 width=55) (actual time=0.180..1.370 rows=926 loops=1)

4. 0.206 0.256 ↓ 9.3 926 1

HashAggregate (cost=1.76..2.76 rows=100 width=4) (actual time=0.171..0.256 rows=926 loops=1)

  • Group Key: unnest('{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,29376,2937 (...)
5. 0.050 0.050 ↓ 9.3 926 1

Result (cost=0.00..0.51 rows=100 width=0) (actual time=0.003..0.050 rows=926 loops=1)

6. 0.926 0.926 ↑ 1.0 1 926

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

  • Index Cond: (id = (unnest('{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,29 (...)
7.          

CTE data_class_rule

8. 0.290 0.617 ↑ 117.0 2 1

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

9. 0.152 0.320 ↓ 12.0 1,852 1

Hash Right Join (cost=3.25..9.25 rows=154 width=16) (actual time=0.166..0.320 rows=1,852 loops=1)

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

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

11. 0.078 0.156 ↓ 9.3 926 1

Hash (cost=2.00..2.00 rows=100 width=4) (actual time=0.156..0.156 rows=926 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 41kB
12. 0.078 0.078 ↓ 9.3 926 1

CTE Scan on features f_2 (cost=0.00..2.00 rows=100 width=4) (actual time=0.000..0.078 rows=926 loops=1)

13. 0.000 0.007 ↓ 0.0 0 1

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

14. 0.002 0.007 ↓ 0.0 0 1

Hash Join (cost=30.90..49.31 rows=8 width=8) (actual time=0.007..0.007 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.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. 0.618 0.618 ↑ 116.5 2 1

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

  • Filter: (priority IS NOT NULL)
21.          

CTE snapshot_values

22. 69.421 69.421 ↓ 6.4 6,442 1

Function Scan on d_get_features_snapshot_values snv (cost=0.26..10.26 rows=1,000 width=8) (actual time=69.164..69.421 rows=6,442 loops=1)

23.          

CTE values

24. 9.621 126.318 ↑ 2.9 27,377 1

Nested Loop (cost=9.07..87,289.55 rows=78,251 width=59) (actual time=69.191..126.318 rows=27,377 loops=1)

25. 3.563 92.642 ↑ 3.1 24,055 1

Nested Loop (cost=8.65..45,635.71 rows=73,473 width=12) (actual time=69.184..92.642 rows=24,055 loops=1)

26. 69.753 69.753 ↓ 6.4 6,442 1

CTE Scan on snapshot_values snv_1 (cost=0.00..20.00 rows=1,000 width=8) (actual time=69.164..69.753 rows=6,442 loops=1)

27. 6.442 19.326 ↑ 18.2 4 6,442

Bitmap Heap Scan on value v (cost=8.65..44.89 rows=73 width=8) (actual time=0.003..0.003 rows=4 loops=6,442)

  • Recheck Cond: ((id = snv_1.id) OR (top = snv_1.id))
  • Heap Blocks: exact=6579
28. 0.000 12.884 ↓ 0.0 0 6,442

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

29. 6.442 6.442 ↑ 1.0 1 6,442

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

  • Index Cond: (id = snv_1.id)
30. 6.442 6.442 ↑ 24.0 3 6,442

Bitmap Index Scan on value_top_idx (cost=0.00..4.57 rows=72 width=0) (actual time=0.001..0.001 rows=3 loops=6,442)

  • Index Cond: (top = snv_1.id)
31. 24.055 24.055 ↑ 1.0 1 24,055

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=24,055)

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

CTE translated_prop_value

33. 0.083 18.844 ↓ 438.0 438 1

Unique (cost=282.77..282.78 rows=1 width=14) (actual time=18.747..18.844 rows=438 loops=1)

34. 0.108 18.761 ↓ 438.0 438 1

Sort (cost=282.77..282.78 rows=1 width=14) (actual time=18.747..18.761 rows=438 loops=1)

  • Sort Key: snv_2.feature_id, ((prop_name.value)::ltree), prop_translation.value
  • Sort Method: quicksort Memory: 67kB
35. 0.814 18.653 ↓ 438.0 438 1

Nested Loop (cost=253.00..282.76 rows=1 width=14) (actual time=4.924..18.653 rows=438 loops=1)

  • Join Filter: (prop_translation_lang.value = (lang.let2)::text)
  • Rows Removed by Join Filter: 450
36. 0.562 17.839 ↓ 888.0 888 1

Nested Loop (cost=253.00..281.72 rows=1 width=19) (actual time=4.914..17.839 rows=888 loops=1)

  • Join Filter: (prop_translation.value_id = prop_translation_lang.value_id)
37. 0.890 16.389 ↓ 888.0 888 1

Nested Loop (cost=252.57..281.14 rows=1 width=22) (actual time=4.910..16.389 rows=888 loops=1)

38. 0.242 12.823 ↓ 2,676.0 2,676 1

Nested Loop (cost=252.14..280.57 rows=1 width=13) (actual time=4.901..12.823 rows=2,676 loops=1)

  • Join Filter: (annots.value_id = prop_translation_v.top)
39. 0.675 11.681 ↓ 450.0 450 1

Nested Loop (cost=251.71..277.95 rows=1 width=25) (actual time=4.897..11.681 rows=450 loops=1)

40. 0.288 8.330 ↓ 2,676.0 2,676 1

Nested Loop (cost=251.29..277.38 rows=1 width=24) (actual time=4.893..8.330 rows=2,676 loops=1)

  • Join Filter: (annots.value_id = prop_name_v.top)
41. 0.000 7.142 ↓ 450.0 450 1

Nested Loop (cost=250.86..274.76 rows=1 width=16) (actual time=4.887..7.142 rows=450 loops=1)

  • Join Filter: (snv_2.id = annots.value_id)
42. 0.511 6.260 ↓ 450.0 450 1

Hash Join (cost=250.43..274.19 rows=1 width=12) (actual time=4.875..6.260 rows=450 loops=1)

  • Hash Cond: (snv_2.id = prop_purpose_v.top)
43. 0.880 0.880 ↓ 6.4 6,442 1

CTE Scan on snapshot_values snv_2 (cost=0.00..20.00 rows=1,000 width=8) (actual time=0.000..0.880 rows=6,442 loops=1)

44. 0.182 4.869 ↓ 596.3 1,789 1

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

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

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

46. 1.570 2.129 ↓ 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.644..2.129 rows=1,789 loops=1)

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

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

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

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

  • Index Cond: (short_xpath = 'annotation.purpose'::ltree)
50. 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)
51. 0.900 0.900 ↑ 1.0 1 450

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

  • Index Cond: (value_id = prop_purpose_v.top)
  • Filter: (short_xpath = 'annotation'::ltree)
52. 0.900 0.900 ↑ 12.0 6 450

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

  • Index Cond: (top = prop_purpose_v.top)
53. 2.676 2.676 ↓ 0.0 0 2,676

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

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

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

  • Index Cond: (top = prop_name_v.top)
55. 2.676 2.676 ↓ 0.0 0 2,676

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

  • Index Cond: (value_id = prop_translation_v.id)
  • Filter: (short_xpath = 'annotation.translatedNote.note'::ltree)
  • Rows Removed by Filter: 1
56. 0.888 0.888 ↑ 1.0 1 888

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

  • 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 888

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

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

CTE translated_enum_value

59. 12.950 82.266 ↓ 131.9 10,290 1

Hash Join (cost=538.76..4,556.62 rows=78 width=108) (actual time=4.079..82.266 rows=10,290 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: 82185
60. 65.257 65.257 ↑ 2.9 27,377 1

CTE Scan on values v_1 (cost=0.00..1,565.02 rows=78,251 width=84) (actual time=0.000..65.257 rows=27,377 loops=1)

61. 0.730 4.059 ↓ 2.2 5,952 1

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

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

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

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

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

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

65. 0.463 0.615 ↓ 4.1 7,407 1

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

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

67. 0.232 0.611 ↑ 1.0 2,172 1

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

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

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

CTE data_class_names

70. 0.000 0.011 ↓ 0.0 0 1

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

71. 0.000 0.011 ↓ 0.0 0 1

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

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

Hash Join (cost=5.27..7.65 rows=1 width=12) (actual time=0.011..0.011 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. 9.654 228.976 ↑ 3.5 22,490 1

Unique (cost=9,607.34..10,389.86 rows=78,252 width=132) (actual time=217.281..228.976 rows=22,490 loops=1)

80. 25.635 219.322 ↑ 2.9 27,377 1

Sort (cost=9,607.34..9,802.97 rows=78,252 width=132) (actual time=217.280..219.322 rows=27,377 loops=1)

  • Sort Key: v_2.feature_id, (COALESCE(tpv.translation, tv.name, v_2.value)), v_2.short_xpath
  • Sort Method: quicksort Memory: 4393kB
81. 1.498 193.687 ↑ 2.9 27,377 1

Append (cost=2.57..3,247.08 rows=78,252 width=132) (actual time=175.976..193.687 rows=27,377 loops=1)

82. 4.805 192.177 ↑ 2.9 27,377 1

Hash Left Join (cost=2.57..2,464.54 rows=78,251 width=132) (actual time=175.976..192.177 rows=27,377 loops=1)

  • Hash Cond: (v_2.simple_value_id = tv.simple_value_id)
83. 8.825 99.567 ↑ 2.9 27,377 1

Hash Left Join (cost=0.03..1,863.38 rows=78,251 width=104) (actual time=88.165..99.567 rows=27,377 loops=1)

  • Hash Cond: (v_2.feature_id = tpv.feature_id)
  • Join Filter: (tpv.path = v_2.short_xpath)
  • Rows Removed by Join Filter: 27548
84. 71.785 71.785 ↑ 2.9 27,377 1

CTE Scan on values v_2 (cost=0.00..1,565.02 rows=78,251 width=72) (actual time=69.194..71.785 rows=27,377 loops=1)

85. 0.057 18.957 ↓ 438.0 438 1

Hash (cost=0.02..0.02 rows=1 width=68) (actual time=18.957..18.957 rows=438 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 43kB
86. 18.900 18.900 ↓ 438.0 438 1

CTE Scan on translated_prop_value tpv (cost=0.00..0.02 rows=1 width=68) (actual time=18.748..18.900 rows=438 loops=1)

87. 1.720 87.805 ↓ 131.9 10,290 1

Hash (cost=1.56..1.56 rows=78 width=36) (actual time=87.805..87.805 rows=10,290 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 717kB
88. 86.085 86.085 ↓ 131.9 10,290 1

CTE Scan on translated_enum_value tv (cost=0.00..1.56 rows=78 width=36) (actual time=4.080..86.085 rows=10,290 loops=1)

89. 0.012 0.012 ↓ 0.0 0 1

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

90.          

CTE features_names

91. 0.963 308.966 ↓ 4.6 926 1

GroupAggregate (cost=14,531.77..14,537.69 rows=200 width=40) (actual time=307.923..308.966 rows=926 loops=1)

  • Group Key: nms.feature_id
92. 0.355 308.003 ↓ 4.1 1,851 1

Sort (cost=14,531.77..14,532.91 rows=456 width=40) (actual time=307.909..308.003 rows=1,851 loops=1)

  • Sort Key: nms.feature_id
  • Sort Method: quicksort Memory: 173kB
93. 3.831 307.648 ↓ 4.1 1,851 1

Merge Join (cost=13,526.01..14,511.63 rows=456 width=40) (actual time=303.708..307.648 rows=1,851 loops=1)

  • Merge Cond: (((nr_3.path)::text = ((nms.path)::text)) AND (nr_3.data_class_id = f_4.data_class_id))
94. 0.005 0.624 ↑ 116.5 2 1

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

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

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

96. 32.118 303.193 ↑ 3.5 22,490 1

Sort (cost=13,512.18..13,707.81 rows=78,252 width=72) (actual time=301.336..303.193 rows=22,490 loops=1)

  • Sort Key: ((nms.path)::text), f_4.data_class_id
  • Sort Method: quicksort Memory: 5173kB
97. 7.416 271.075 ↑ 3.5 22,490 1

Hash Join (cost=4,510.92..7,151.93 rows=78,252 width=72) (actual time=249.655..271.075 rows=22,490 loops=1)

  • Hash Cond: (nms.feature_id = f_4.id)
98. 231.872 231.872 ↑ 3.5 22,490 1

CTE Scan on names_merge_source nms (cost=0.00..1,565.04 rows=78,252 width=68) (actual time=217.283..231.872 rows=22,490 loops=1)

99. 18.650 31.787 ↑ 1.0 135,552 1

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

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

101. 309.129 309.129 ↓ 4.6 926 1

CTE Scan on features_names fn (cost=0.00..4.00 rows=200 width=36) (actual time=307.924..309.129 rows=926 loops=1)

102. 0.116 1.747 ↓ 9.3 926 1

Hash (cost=2.00..2.00 rows=100 width=580) (actual time=1.747..1.747 rows=926 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 77kB
103. 1.631 1.631 ↓ 9.3 926 1

CTE Scan on features f (cost=0.00..2.00 rows=100 width=580) (actual time=0.182..1.631 rows=926 loops=1)