文档中心>Elasticsearch Service>产品简介>产品性能>4核16G 3节点与8核32G 3节点集群压测结果比较

4核16G 3节点与8核32G 3节点集群压测结果比较

最近更新时间:2024-10-12 21:50:11

我的收藏
本文提供4核16G SSD 200G 3个节点与8核32G SSD 200G 3个节点规格的腾讯云 Elasticsearch Service 集群的压测比较结果。
说明
数据为官方提供的 geonames,包含11396503条地理位置信息,总大小接近3GB,包含了 text、long、geo 等类型数据,覆盖行列存。
说明
Metric
Unit
Task
4核16GB
8核32GB
差异值
差异百分比
效果比较
写入总耗时
Cumulative indexing time of primary shards
min
-
16.3633
14.2567
2.1066
12.87%
GC 总次数、耗时统计
Total Young Gen GC time
s
-
6.26
3.544
2.716
43.39%
Total Young Gen GC count
-
892
447
445
49.89%
Total Old Gen GC time
s
-
0
0
0
-
-
Total Old Gen GC count
-
0
0
0
-
-
存储大小
Store size
GB
-
2.51866
2.59725
-0.07859
-3.12%
堆内存使用量
Heap used for segments
MB
-
0.803783
0.534325
0.269458
33.52%
Heap used for doc values
MB
-
0.0284767
0.0507355
-0.0222588
-78.16%
Heap used for terms
MB
-
0.655075
0.370026
0.285049
43.51%
Heap used for norms
MB
-
0.0732422
0.0396729
0.0335693
45.83%
Heap used for points
MB
-
0
0
0
-
-
Heap used for stored fields
MB
-
0.0469894
0.0119553
0.0350341
74.56%
segment 总数量
Segment count
-
6
7
-1
-16.67%
写入吞吐、耗时统计
Min Throughput
docs/s
index-append
89331.9
153730
-64398.1
-72.09%
Median Throughput
docs/s
index-append
90268.8
159765
-69496.2
-76.99%
Max Throughput
docs/s
index-append
90516.1
162791
-72274.9
-79.85%
50th percentile latency
ms
index-append
233.258
130.877
102.381
43.89%
90th percentile latency
ms
index-append
314.558
162.969
151.589
48.19%
99th percentile latency
ms
index-append
341.303
181.428
159.875
46.84%
100th percentile latency
ms
index-append
354.657
225.98
128.677
36.28%
50th percentile service time
ms
index-append
233.258
130.877
102.381
43.89%
90th percentile service time
ms
index-append
314.558
162.969
151.589
48.19%
99th percentile service time
ms
index-append
341.303
181.428
159.875
46.84%
100th percentile service time
ms
index-append
354.657
225.98
128.677
36.28%
error rate
%
index-append
0
0
0
-
-
index 指标统计
Min Throughput
ops/s
index-stats
90.04
90.05
-0.01
-0.01%
Median Throughput
ops/s
index-stats
90.07
90.06
0.01
0.01%
Max Throughput
ops/s
index-stats
90.14
90.12
0.02
0.02%
50th percentile latency
ms
index-stats
2.91003
2.76736
0.14267
4.90%
90th percentile latency
ms
index-stats
3.82882
3.58235
0.24647
6.44%
99th percentile latency
ms
index-stats
4.2378
3.95798
0.27982
6.60%
99.9th percentile latency
ms
index-stats
4.34459
4.39377
-0.04918
-1.13%
100th percentile latency
ms
index-stats
8.22393
9.00375
-0.77982
-9.48%
50th percentile service time
ms
index-stats
1.78268
1.57744
0.20524
11.51%
90th percentile service time
ms
index-stats
2.07484
1.8317
0.24314
11.72%
99th percentile service time
ms
index-stats
2.43121
2.0752
0.35601
14.64%
99.9th percentile service time
ms
index-stats
3.09198
2.24891
0.84307
27.27%
100th percentile service time
ms
index-stats
7.29974
2.31078
4.98896
68.34%
error rate
%
index-stats
0
0
0
-
-
node 指标统计
Min Throughput
ops/s
node-stats
90.06
90.06
0
0.00%
Median Throughput
ops/s
node-stats
90.09
90.12
-0.03
-0.03%
Max Throughput
ops/s
node-stats
90.34
90.36
-0.02
-0.02%
50th percentile latency
ms
node-stats
3.17223
2.9754
0.19683
6.20%
90th percentile latency
ms
node-stats
3.70681
4.07929
-0.37248
-10.05%
99th percentile latency
ms
node-stats
5.01334
5.0754
-0.06206
-1.24%
99.9th percentile latency
ms
node-stats
6.75018
6.53613
0.21405
3.17%
100th percentile latency
ms
node-stats
7.98905
6.93454
1.05451
13.20%
50th percentile service time
ms
node-stats
2.43876
2.23841
0.20035
8.22%
90th percentile service time
ms
node-stats
2.78272
2.65367
0.12905
4.64%
99th percentile service time
ms
node-stats
4.12234
3.92073
0.20161
4.89%
99.9th percentile service time
ms
node-stats
6.35902
4.92842
1.4306
22.50%
100th percentile service time
ms
node-stats
7.4313
5.92757
1.50373
20.24%
error rate
%
node-stats
0
0
0
-
-
默认查询,所有文档 score 为1(match_all)
Min Throughput
ops/s
default
50.03
50.03
0
0.00%
Median Throughput
ops/s
default
50.04
50.04
0
0.00%
Max Throughput
ops/s
default
50.08
50.08
0
0.00%
50th percentile latency
ms
default
3.89929
3.53894
0.36035
9.24%
90th percentile latency
ms
default
4.39236
4.11403
0.27833
6.34%
99th percentile latency
ms
default
4.78834
4.92737
-0.13903
-2.90%
99.9th percentile latency
ms
default
7.10486
5.74037
1.36449
19.21%
100th percentile latency
ms
default
8.75822
7.32557
1.43265
16.36%
50th percentile service time
ms
default
3.18269
2.7831
0.39959
12.56%
90th percentile service time
ms
default
3.49347
3.17322
0.32025
9.17%
99th percentile service time
ms
default
3.8746
3.77477
0.09983
2.58%
99.9th percentile service time
ms
default
6.68581
4.19186
2.49395
37.30%
100th percentile service time
ms
default
8.30396
6.58243
1.72153
20.73%
error rate
%
default
0
0
0
-
-
term 条件查询
Min Throughput
ops/s
term
100.05
99.66
0.39
0.39%
Median Throughput
ops/s
term
100.07
100.07
0
0.00%
Max Throughput
ops/s
term
100.14
100.11
0.03
0.03%
50th percentile latency
ms
term
3.17419
2.83987
0.33432
10.53%
90th percentile latency
ms
term
3.62229
3.32569
0.2966
8.19%
99th percentile latency
ms
term
4.03812
3.96055
0.07757
1.92%
99.9th percentile latency
ms
term
5.9753
4.33961
1.63569
27.37%
100th percentile latency
ms
term
8.03321
5.70421
2.329
28.99%
50th percentile service time
ms
term
2.49755
2.08935
0.4082
16.34%
90th percentile service time
ms
term
2.71322
2.53284
0.18038
6.65%
99th percentile service time
ms
term
3.20673
2.99484
0.21189
6.61%
99.9th percentile service time
ms
term
5.17998
3.37709
1.80289
34.80%
100th percentile service time
ms
term
6.95227
5.24029
1.71198
24.62%
error rate
%
term
0
0
0
-
-
词组查询(query)
Min Throughput
ops/s
phrase
110.05
110.04
0.01
0.01%
Median Throughput
ops/s
phrase
110.07
110.08
-0.01
-0.01%
Max Throughput
ops/s
phrase
110.12
110.11
0.01
0.01%
50th percentile latency
ms
phrase
3.09905
2.74088
0.35817
11.56%
90th percentile latency
ms
phrase
3.62549
3.30207
0.32342
8.92%
99th percentile latency
ms
phrase
4.55457
4.8127
-0.25813
-5.67%
99.9th percentile latency
ms
phrase
8.29519
5.57204
2.72315
32.83%
100th percentile latency
ms
phrase
9.39771
6.54587
2.85184
30.35%
50th percentile service time
ms
phrase
2.38248
1.98839
0.39409
16.54%
90th percentile service time
ms
phrase
2.77084
2.41365
0.35719
12.89%
99th percentile service time
ms
phrase
3.75448
4.00121
-0.24673
-6.57%
99.9th percentile service time
ms
phrase
7.5974
4.70793
2.88947
38.03%
100th percentile service time
ms
phrase
8.98362
5.67829
3.30533
36.79%
error rate
%
phrase
0
0
0
-
-
不带缓存的聚合查询(aggregation)
Min Throughput
ops/s
country_agg_uncached
3.6
3.6
0
0.00%
Median Throughput
ops/s
country_agg_uncached
3.61
3.61
0
0.00%
Max Throughput
ops/s
country_agg_uncached
3.61
3.61
0
0.00%
50th percentile latency
ms
country_agg_uncached
157.466
130.314
27.152
17.24%
90th percentile latency
ms
country_agg_uncached
217.148
147.567
69.581
32.04%
99th percentile latency
ms
country_agg_uncached
233.185
165.174
68.011
29.17%
100th percentile latency
ms
country_agg_uncached
233.227
174.015
59.212
25.39%
50th percentile service time
ms
country_agg_uncached
156.197
129.186
27.011
17.29%
90th percentile service time
ms
country_agg_uncached
215.852
146.921
68.931
31.93%
99th percentile service time
ms
country_agg_uncached
232.177
164.579
67.598
29.11%
100th percentile service time
ms
country_agg_uncached
232.321
172.827
59.494
25.61%
error rate
%
country_agg_uncached
0
0
0
-
-
带缓存的聚合查询(aggregation)
Min Throughput
ops/s
country_agg_cached
100.03
100.04
-0.01
-0.01%
Median Throughput
ops/s
country_agg_cached
100.05
100.05
0
0.00%
Max Throughput
ops/s
country_agg_cached
100.08
100.08
0
0.00%
50th percentile latency
ms
country_agg_cached
2.44457
2.29531
0.14926
6.11%
90th percentile latency
ms
country_agg_cached
2.97922
3.57418
-0.59496
-19.97%
99th percentile latency
ms
country_agg_cached
3.96393
3.91685
0.04708
1.19%
99.9th percentile latency
ms
country_agg_cached
5.3294
4.19749
1.13191
21.24%
100th percentile latency
ms
country_agg_cached
7.9529
4.51842
3.43448
43.19%
50th percentile service time
ms
country_agg_cached
1.71924
1.57861
0.14063
8.18%
90th percentile service time
ms
country_agg_cached
1.97892
1.89111
0.08781
4.44%
99th percentile service time
ms
country_agg_cached
2.22611
2.19488
0.03123
1.40%
99.9th percentile service time
ms
country_agg_cached
5.0967
3.42563
1.67107
32.79%
100th percentile service time
ms
country_agg_cached
7.02246
4.28971
2.73275
38.91%
error rate
%
country_agg_cached
0
0
0
-
-
分页拉取
Min Throughput
pages/s
scroll
20.04
20.04
0
0.00%
Median Throughput
pages/s
scroll
20.04
20.05
-0.01
-0.05%
Max Throughput
pages/s
scroll
20.05
20.06
-0.01
-0.05%
50th percentile latency
ms
scroll
576.675
538.421
38.254
6.63%
90th percentile latency
ms
scroll
585.156
543.566
41.59
7.11%
99th percentile latency
ms
scroll
598.95
582.263
16.687
2.79%
100th percentile latency
ms
scroll
602.009
584.75
17.259
2.87%
50th percentile service time
ms
scroll
575.118
537.068
38.05
6.62%
90th percentile service time
ms
scroll
583.906
542.428
41.478
7.10%
99th percentile service time
ms
scroll
597.482
580.372
17.11
2.86%
100th percentile service time
ms
scroll
600.578
583.612
16.966
2.82%
error rate
%
scroll
0
0
0
-
-
脚本查询(使用 expression 脚本)
Min Throughput
ops/s
expression
2
2
0
0.00%
Median Throughput
ops/s
expression
2
2
0
0.00%
Max Throughput
ops/s
expression
2
2
0
0.00%
50th percentile latency
ms
expression
299.685
265.631
34.054
11.36%
90th percentile latency
ms
expression
416.613
287.121
129.492
31.08%
99th percentile latency
ms
expression
465.776
311.788
153.988
33.06%
100th percentile latency
ms
expression
468.083
391.745
76.338
16.31%
50th percentile service time
ms
expression
298.594
264.462
34.132
11.43%
90th percentile service time
ms
expression
415.045
285.113
129.932
31.31%
99th percentile service time
ms
expression
464.598
310.991
153.607
33.06%
100th percentile service time
ms
expression
467.106
390.33
76.776
16.44%
error rate
%
expression
0
0
0
-
-
脚本查询(使用 painless 静态脚本,不动态取字段值)
Min Throughput
ops/s
painless_static
1.5
1.5
0
0.00%
Median Throughput
ops/s
painless_static
1.5
1.5
0
0.00%
Max Throughput
ops/s
painless_static
1.5
1.5
0
0.00%
50th percentile latency
ms
painless_static
383.485
337.96
45.525
11.87%
90th percentile latency
ms
painless_static
514.495
358.738
155.757
30.27%
99th percentile latency
ms
painless_static
561.342
375.017
186.325
33.19%
100th percentile latency
ms
painless_static
568.066
395.417
172.649
30.39%
50th percentile service time
ms
painless_static
382.158
337.111
45.047
11.79%
90th percentile service time
ms
painless_static
513.202
357.771
155.431
30.29%
99th percentile service time
ms
painless_static
560.61
374.121
186.489
33.27%
100th percentile service time
ms
painless_static
567.419
394.632
172.787
30.45%
error rate
%
painless_static
0
0
0
-
-
脚本查询(使用 painless 静态脚本,动态获取字段值)
Min Throughput
ops/s
painless_dynamic
1.5
1.5
0
0.00%
Median Throughput
ops/s
painless_dynamic
1.5
1.5
0
0.00%
Max Throughput
ops/s
painless_dynamic
1.5
1.5
0
0.00%
50th percentile latency
ms
painless_dynamic
377.278
334.684
42.594
11.29%
90th percentile latency
ms
painless_dynamic
517.496
354.406
163.09
31.52%
99th percentile latency
ms
painless_dynamic
576.697
377.214
199.483
34.59%
100th percentile latency
ms
painless_dynamic
580.017
381.276
198.741
34.26%
50th percentile service time
ms
painless_dynamic
376.339
333.654
42.685
11.34%
90th percentile service time
ms
painless_dynamic
516.407
353.246
163.161
31.60%
99th percentile service time
ms
painless_dynamic
575.714
375.956
199.758
34.70%
100th percentile service time
ms
painless_dynamic
579.642
379.75
199.892
34.49%
error rate
%
painless_dynamic
0
0
0
-
-
地理范围查询(基于高斯衰减函数)
Min Throughput
ops/s
decay_geo_gauss_function_score
1
1
0
0.00%
Median Throughput
ops/s
decay_geo_gauss_function_score
1
1
0
0.00%
Max Throughput
ops/s
decay_geo_gauss_function_score
1
1
0
0.00%
50th percentile latency
ms
decay_geo_gauss_function_score
348.531
327.972
20.559
5.90%
90th percentile latency
ms
decay_geo_gauss_function_score
398.351
336.979
61.372
15.41%
99th percentile latency
ms
decay_geo_gauss_function_score
411.483
343.562
67.921
16.51%
100th percentile latency
ms
decay_geo_gauss_function_score
457.615
344.135
113.48
24.80%
50th percentile service time
ms
decay_geo_gauss_function_score
346.881
326.554
20.327
5.86%
90th percentile service time
ms
decay_geo_gauss_function_score
397.08
336.053
61.027
15.37%
99th percentile service time
ms
decay_geo_gauss_function_score
410.421
342.151
68.27
16.63%
100th percentile service time
ms
decay_geo_gauss_function_score
455.704
342.843
112.861
24.77%
error rate
%
decay_geo_gauss_function_score
0
0
0
-
-
地理范围查询(基于高斯衰减函数,且脚本动态获取字段值)
Min Throughput
ops/s
decay_geo_gauss_script_score
1
1
0
0.00%
Median Throughput
ops/s
decay_geo_gauss_script_score
1
1
0
0.00%
Max Throughput
ops/s
decay_geo_gauss_script_score
1
1
0
0.00%
50th percentile latency
ms
decay_geo_gauss_script_score
368.275
341.152
27.123
7.36%
90th percentile latency
ms
decay_geo_gauss_script_score
414.905
349.94
64.965
15.66%
99th percentile latency
ms
decay_geo_gauss_script_score
468.888
354.76
114.128
24.34%
100th percentile latency
ms
decay_geo_gauss_script_score
477.25
364.169
113.081
23.69%
50th percentile service time
ms
decay_geo_gauss_script_score
366.945
339.967
26.978
7.35%
90th percentile service time
ms
decay_geo_gauss_script_score
413.609
348.493
65.116
15.74%
99th percentile service time
ms
decay_geo_gauss_script_score
467.627
353.559
114.068
24.39%
100th percentile service time
ms
decay_geo_gauss_script_score
475.367
362.748
112.619
23.69%
error rate
%
decay_geo_gauss_script_score
0
0
0
-
-
自定义评分函数查询(基于字段值定义函数)
Min Throughput
ops/s
field_value_function_score
1.5
1.5
0
0.00%
Median Throughput
ops/s
field_value_function_score
1.5
1.5
0
0.00%
Max Throughput
ops/s
field_value_function_score
1.51
1.51
0
0.00%
50th percentile latency
ms
field_value_function_score
139.661
120.538
19.123
13.69%
90th percentile latency
ms
field_value_function_score
183.675
137.702
45.973
25.03%
99th percentile latency
ms
field_value_function_score
197.653
147.851
49.802
25.20%
100th percentile latency
ms
field_value_function_score
202.345
169.961
32.384
16.00%
50th percentile service time
ms
field_value_function_score
138.423
119.159
19.264
13.92%
90th percentile service time
ms
field_value_function_score
182.404
136.338
46.066
25.25%
99th percentile service time
ms
field_value_function_score
196.734
146.981
49.753
25.29%
100th percentile service time
ms
field_value_function_score
201.442
168.964
32.478
16.12%
error rate
%
field_value_function_score
0
0
0
-
-
自定义评分函数查询(通过脚本动态获取字段值计算评分)
Min Throughput
ops/s
field_value_script_score
1.5
1.5
0
0.00%
Median Throughput
ops/s
field_value_script_score
1.5
1.5
0
0.00%
Max Throughput
ops/s
field_value_script_score
1.51
1.51
0
0.00%
50th percentile latency
ms
field_value_script_score
188.952
168.069
20.883
11.05%
90th percentile latency
ms
field_value_script_score
264.095
178.933
85.162
32.25%
99th percentile latency
ms
field_value_script_score
271.153
196.982
74.171
27.35%
100th percentile latency
ms
field_value_script_score
271.901
198.722
73.179
26.91%
50th percentile service time
ms
field_value_script_score
187.218
166.827
20.391
10.89%
90th percentile service time
ms
field_value_script_score
263.207
177.869
85.338
32.42%
99th percentile service time
ms
field_value_script_score
269.578
195.586
73.992
27.45%
100th percentile service time
ms
field_value_script_score
270.138
197.054
73.084
27.05%
error rate
%
field_value_script_score
0
0
0
-
-
大量 terms 条件查询(query)
Min Throughput
ops/s
large_terms
1.1
1.1
0
0.00%
Median Throughput
ops/s
large_terms
1.1
1.1
0
0.00%
Max Throughput
ops/s
large_terms
1.1
1.1
0
0.00%
50th percentile latency
ms
large_terms
265.007
241.322
23.685
8.94%
90th percentile latency
ms
large_terms
296.009
252.637
43.372
14.65%
99th percentile latency
ms
large_terms
310.358
265.807
44.551
14.35%
100th percentile latency
ms
large_terms
311.049
272.611
38.438
12.36%
50th percentile service time
ms
large_terms
256.372
233.129
23.243
9.07%
90th percentile service time
ms
large_terms
287.851
244.494
43.357
15.06%
99th percentile service time
ms
large_terms
301.827
258.894
42.933
14.22%
100th percentile service time
ms
large_terms
302.251
264.352
37.899
12.54%
error rate
%
large_terms
0
0
0
-
-
大量 terms 条件过滤查询(query、filter)
Min Throughput
ops/s
large_filtered_terms
1.1
1.1
0
0.00%
Median Throughput
ops/s
large_filtered_terms
1.1
1.1
0
0.00%
Max Throughput
ops/s
large_filtered_terms
1.1
1.1
0
0.00%
50th percentile latency
ms
large_filtered_terms
268.135
233.192
34.943
13.03%
90th percentile latency
ms
large_filtered_terms
304.158
241.102
63.056
20.73%
99th percentile latency
ms
large_filtered_terms
351.209
251.835
99.374
28.29%
100th percentile latency
ms
large_filtered_terms
352.003
260.27
91.733
26.06%
50th percentile service time
ms
large_filtered_terms
259.546
225.052
34.494
13.29%
90th percentile service time
ms
large_filtered_terms
295.721
233.16
62.561
21.16%
99th percentile service time
ms
large_filtered_terms
342.342
243.603
98.739
28.84%
100th percentile service time
ms
large_filtered_terms
343.378
252.129
91.249
26.57%
error rate
%
large_filtered_terms
0
0
0
-
-
大量条件取反查询(query、must not)
Min Throughput
ops/s
large_prohibited_terms
1.1
1.1
0
0.00%
Median Throughput
ops/s
large_prohibited_terms
1.1
1.1
0
0.00%
Max Throughput
ops/s
large_prohibited_terms
1.1
1.1
0
0.00%
50th percentile latency
ms
large_prohibited_terms
270.041
235.179
34.862
12.91%
90th percentile latency
ms
large_prohibited_terms
310.351
241.076
69.275
22.32%
99th percentile latency
ms
large_prohibited_terms
347.414
255.983
91.431
26.32%
100th percentile latency
ms
large_prohibited_terms
349.499
259.046
90.453
25.88%
50th percentile service time
ms
large_prohibited_terms
261.734
227.487
34.247
13.08%
90th percentile service time
ms
large_prohibited_terms
302.279
233.792
68.487
22.66%
99th percentile service time
ms
large_prohibited_terms
339.278
248.53
90.748
26.75%
100th percentile service time
ms
large_prohibited_terms
340.817
251.083
89.734
26.33%
error rate
%
large_prohibited_terms
0
0
0
-
-
降序排序查询
Min Throughput
ops/s
desc_sort_population
1.5
1.5
0
0.00%
Median Throughput
ops/s
desc_sort_population
1.51
1.51
0
0.00%
Max Throughput
ops/s
desc_sort_population
1.51
1.51
0
0.00%
50th percentile latency
ms
desc_sort_population
58.5828
48.387
10.1958
17.40%
90th percentile latency
ms
desc_sort_population
77.9981
63.073
14.9251
19.14%
99th percentile latency
ms
desc_sort_population
80.8863
71.7498
9.1365
11.30%
100th percentile latency
ms
desc_sort_population
83.1661
83.3593
-0.1932
-0.23%
50th percentile service time
ms
desc_sort_population
57.1212
47.0436
10.0776
17.64%
90th percentile service time
ms
desc_sort_population
76.7082
61.3731
15.3351
19.99%
99th percentile service time
ms
desc_sort_population
79.2907
70.4811
8.8096
11.11%
100th percentile service time
ms
desc_sort_population
81.6364
81.6517
-0.0153
-0.02%
error rate
%
desc_sort_population
0
0
0
-
-
升序排序查询
Min Throughput
ops/s
asc_sort_population
1.5
1.5
0
0.00%
Median Throughput
ops/s
asc_sort_population
1.51
1.51
0
0.00%
Max Throughput
ops/s
asc_sort_population
1.51
1.51
0
0.00%
50th percentile latency
ms
asc_sort_population
62.4328
49.2469
13.1859
21.12%
90th percentile latency
ms
asc_sort_population
79.8441
67.5894
12.2547
15.35%
99th percentile latency
ms
asc_sort_population
83.9411
84.6384
-0.6973
-0.83%
100th percentile latency
ms
asc_sort_population
84.3925
85.8124
-1.4199
-1.68%
50th percentile service time
ms
asc_sort_population
61.0637
47.8438
13.2199
21.65%
90th percentile service time
ms
asc_sort_population
78.4101
66.0821
12.328
15.72%
99th percentile service time
ms
asc_sort_population
82.2652
83.6026
-1.3374
-1.63%
100th percentile service time
ms
asc_sort_population
82.5616
84.2175
-1.6559
-2.01%
error rate
%
asc_sort_population
0
0
0
-
-
升序排序后 after 跳转查询
Min Throughput
ops/s
asc_sort_with_after_population
1.5
1.5
0
0.00%
Median Throughput
ops/s
asc_sort_with_after_population
1.51
1.51
0
0.00%
Max Throughput
ops/s
asc_sort_with_after_population
1.51
1.51
0
0.00%
50th percentile latency
ms
asc_sort_with_after_population
88.1871
99.1943
-11.0072
-12.48%
90th percentile latency
ms
asc_sort_with_after_population
127.995
86.0298
41.9652
32.79%
99th percentile latency
ms
asc_sort_with_after_population
131.171
102.268
28.903
22.03%
100th percentile latency
ms
asc_sort_with_after_population
132.181
106.33
25.851
19.56%
50th percentile service time
ms
asc_sort_with_after_population
87.132
68.2272
18.9048
21.70%
90th percentile service time
ms
asc_sort_with_after_population
126.818
84.685
42.133
33.22%
99th percentile service time
ms
asc_sort_with_after_population
129.453
101.133
28.32
21.88%
100th percentile service time
ms
asc_sort_with_after_population
130.452
105.094
25.358
19.44%
error rate
%
asc_sort_with_after_population
0
0
0
-
-
高基字段降序排序查询(基于 DistanceFeatureQuery 快速取 topK)
Min Throughput
ops/s
desc_sort_geonameid
6.02
6.02
0
0.00%
Median Throughput
ops/s
desc_sort_geonameid
6.02
6.02
0
0.00%
Max Throughput
ops/s
desc_sort_geonameid
6.03
6.03
0
0.00%
50th percentile latency
ms
desc_sort_geonameid
7.4659
5.53008
1.93582
25.93%
90th percentile latency
ms
desc_sort_geonameid
8.26766
6.20276
2.0649
24.98%
99th percentile latency
ms
desc_sort_geonameid
8.72369
6.67673
2.04696
23.46%
100th percentile latency
ms
desc_sort_geonameid
8.79956
6.95103
1.84853
21.01%
50th percentile service time
ms
desc_sort_geonameid
6.59986
4.61231
1.98755
30.12%
90th percentile service time
ms
desc_sort_geonameid
7.24539
5.45982
1.78557
24.64%
99th percentile service time
ms
desc_sort_geonameid
7.57925
5.65304
1.92621
25.41%
100th percentile service time
ms
desc_sort_geonameid
7.64471
5.65578
1.98893
26.02%
error rate
%
desc_sort_geonameid
0
0
0
-
-
高基字段降序排序 after 跳转查询
Min Throughput
ops/s
desc_sort_with_after_geonameid
6.01
6.01
0
0.00%
Median Throughput
ops/s
desc_sort_with_after_geonameid
6.01
6.02
-0.01
-0.17%
Max Throughput
ops/s
desc_sort_with_after_geonameid
6.02
6.02
0
0.00%
50th percentile latency
ms
desc_sort_with_after_geonameid
89.4587
56.5947
32.864
36.74%
90th percentile latency
ms
desc_sort_with_after_geonameid
119.777
79.6503
40.1267
33.50%
99th percentile latency
ms
desc_sort_with_after_geonameid
123.271
87.7773
35.4937
28.79%
100th percentile latency
ms
desc_sort_with_after_geonameid
123.628
89.3947
34.2333
27.69%
50th percentile service time
ms
desc_sort_with_after_geonameid
88.512
55.4855
33.0265
37.31%
90th percentile service time
ms
desc_sort_with_after_geonameid
118.72
79.2349
39.4851
33.26%
99th percentile service time
ms
desc_sort_with_after_geonameid
122.79
87.3803
35.4097
28.84%
100th percentile service time
ms
desc_sort_with_after_geonameid
122.791
88.3606
34.4304
28.04%
error rate
%
desc_sort_with_after_geonameid
0
0
0
-
-
高基字段升序排序查询(基于 DistanceFeatureQuery 快速取 topK)
Min Throughput
ops/s
asc_sort_geonameid
6.02
6.02
0
0.00%
Median Throughput
ops/s
asc_sort_geonameid
6.02
6.02
0
0.00%
Max Throughput
ops/s
asc_sort_geonameid
6.03
6.03
0
0.00%
50th percentile latency
ms
asc_sort_geonameid
5.80593
5.19317
0.61276
10.55%
90th percentile latency
ms
asc_sort_geonameid
6.55438
5.74438
0.81
12.36%
99th percentile latency
ms
asc_sort_geonameid
7.36432
6.22846
1.13586
15.42%
100th percentile latency
ms
asc_sort_geonameid
7.49672
11.6377
-4.14098
-55.24%
50th percentile service time
ms
asc_sort_geonameid
4.91916
4.35586
0.5633
11.45%
90th percentile service time
ms
asc_sort_geonameid
5.61126
4.92152
0.68974
12.29%
99th percentile service time
ms
asc_sort_geonameid
6.12285
5.38949
0.73336
11.98%
100th percentile service time
ms
asc_sort_geonameid
6.51222
10.6436
-4.13138
-63.44%
error rate
%
asc_sort_geonameid
0
0
0
-
-
高基字段升序排序 after 跳转查询
Min Throughput
ops/s
asc_sort_with_after_geonameid
6.01
6.01
0
0.00%
Median Throughput
ops/s
asc_sort_with_after_geonameid
6.01
6.02
-0.01
-0.17%
Max Throughput
ops/s
asc_sort_with_after_geonameid
6.01
6.02
-0.01
-0.17%
50th percentile latency
ms
asc_sort_with_after_geonameid
70.994
58.1403
12.8537
18.11%
90th percentile latency
ms
asc_sort_with_after_geonameid
104.817
76.5695
28.2475
26.95%
99th percentile latency
ms
asc_sort_with_after_geonameid
108.797
91.6296
17.1674
15.78%
100th percentile latency
ms
asc_sort_with_after_geonameid
108.929
91.6364
17.2926
15.88%
50th percentile service time
ms
asc_sort_with_after_geonameid
69.7056
57.1683
12.5373
17.99%
90th percentile service time
ms
asc_sort_with_after_geonameid
103.875
75.7573
28.1177
27.07%
99th percentile service time
ms
asc_sort_with_after_geonameid
107.828
91.1533
16.6747
15.46%
100th percentile service time
ms
asc_sort_with_after_geonameid
108.539
91.3662
17.1728
15.82%
error rate
%
asc_sort_with_after_geonameid
0
0
0
-
-