Elasticsearch 7.10.1压测对比（ Intel竟然压不过AMD）

岳涛 • 2023-01-02 • 云技术社区 • 270 阅读

说明

本文描述问题及解决方法同样适用于 腾讯云 Elasticsearch Service（ES）。

另外使用到：腾讯云云服务器（Cloud Virtual Machine，CVM）

本文延续前两篇压测报告：

Elasticsearch 7.10.1集群压测报告（16核64G*3 SSD云盘，AMD）

Elasticsearch 7.10.1集群压测报告（16核64G*3 本地NVMe SSD，Intel）

本文另有延续：

Elasticsearch压力测试 - 云+社区 - 腾讯云 (tencent.com)

环境配置

Esrally客户端环境

版本

Linux环境：Centos 7.9

Python：3.8.7

Pip：pip 20.2.3 from pip (python 3.8)

Java：openjdk version 1.8.0_302 (build 1.8.0_302-b08)

Git：2.7.5

Esrally：2.3.0

配置

内存：32G

硬盘：SSD云硬盘 100GB

CPU个数：1

CPU核心数：16

Elasticsearch服务端环境

版本

Linux环境：Centos 7.2

Java：openjdk version 11.0.9.1-ga (build 11.0.9.1-ga+1, mixed mode)

Elasticsearch版本：7.10.1（腾讯云 Elasticsearch Service 白金版）

配置

节点数量：3

内存：64G

硬盘：SSD云硬盘 3.5TB VS 本地NVMe SSD硬盘 3.5TB

CPU个数：1

CPU核心数：16

CPU型号：AMD EPYC 7K62 48-Core ProcessorVSIntel(R) Xeon(R) Platinum 8255C CPU @ 2.50GHz

压测

esrally 相关术语及参数

Rally 是汽车拉力赛的意思，所以关于它里面术语也是跟汽车的拉力赛有关。

track: 即赛道的意思，这里指压测用到的样本数据和压测策略，使用 esrally list tracks 列出。rally 自带的 track 可在 https://github.com/elastic/rally-tracks 中查看，每个 track 的文件名中都存在 README.md 对压测的数据类型和参数做了详细的说明。如果没有指定 track，则默认使用 geonames track 进行测试；
target-hosts：即远程elasticsearch的ip和端口，以ip:port的形式指定；
pipeline: 指一个压测流程，可以通过 esrally list pipeline 查看，其中有一个 benchmark-only 的流程，就是将 es 的管理交给用户来操作，rally 只用来做压测，如果你想针对已有的 es 进行压测，则使用该模式；
track-params：对默认的压测参数进行覆盖；
user-tag：本次压测的 tag 标记；
client-options：指定一些客户端连接选项，比如用户名和密码。

压测指令

esrally race \\
  --track=geonames \\
  --target-hosts=10.0.10.4:9200 \\
  --pipeline=benchmark-only \\
  --track-params="number_of_shards:3, number_of_replicas:1" \\
  --user-tag="version:16C64G_3.5T*3" \\
  --client-options="basic_auth_user:'elastic', basic_auth_password:'your_password'"

对比指令

1. 打印压测列表

[dy@VM-1-12-centos ~]$ esrally list races

    ____        ____
   / __ \\____ _/ / /_  __
  / /_/ / __ `/ / / / / /
 / _, _/ /_/ / / / /_/ /
/_/ |_|\\__,_/_/_/\\__, /
                /____/


Recent races:

Race ID                               Race Timestamp    Track     Track Parameters                          Challenge            Car       User Tags                 Track Revision    Team Revision
------------------------------------  ----------------  --------  ----------------------------------------  -------------------  --------  ------------------------  ----------------  ---------------
6efbb335-bda3-4d4c-9538-f317fdac1c15  20211027T120147Z  geonames  number_of_replicas=1, number_of_shards=3  append-no-conflicts  external  version=AMD_16C64G_3.5T*3         31df6b8
f38aeba7-286a-4891-80c4-3bdcfa7fddbb  20211027T105139Z  geonames  number_of_replicas=1, number_of_shards=3  append-no-conflicts  external  version=Intel_16C64G_NVMe3.5T*3  31df6b8

-------------------------------
[INFO] SUCCESS (took 6 seconds)
-------------------------------

2. 对比压测报告

baseline：基准报告
contender：需要对比的报告

[dy@VM-1-12-centos ~]$ esrally compare --baseline=6efbb335-bda3-4d4c-9538-f317fdac1c15 --contender=f38aeba7-286a-4891-80c4-3bdcfa7fddbb

    ____        ____
   / __ \\____ _/ / /_  __
  / /_/ / __ `/ / / / / /
 / _, _/ /_/ / / / /_/ /
/_/ |_|\\__,_/_/_/\\__, /
                /____/


Comparing baseline
  Race ID: 6efbb335-bda3-4d4c-9538-f317fdac1c15
  Race timestamp: 2021-10-27 12:01:47
  Challenge: append-no-conflicts
  Car: external
  User tags: version=AMD_16C64G_3.5T*3

with contender
  Race ID: f38aeba7-286a-4891-80c4-3bdcfa7fddbb
  Race timestamp: 2021-10-27 10:51:39
  Challenge: append-no-conflicts
  Car: external
  User tags: version=Intel_16C64G_NVMe3.5T*3

压测性能对比结果

性能对比标识在最后一列，↑表示Intel比AMD性能好，↓表示Intel比AMD性能差。孰强孰弱，一目了然。

通过输出的表格可以看到，即便Intel机型搭载了本地NVMe SSD这种超强IO性能的硬盘，其性能压测结果还是AMD远超Intel，可见AMD在压测过程中表现相当优秀。

但通常压测结果只能作为参考，实际的业务场景还是相较复杂的，所以线上生产环境还是得以实际业务场景为准。

压测指标	压测任务	AMD CPU	Intel CPU	单位	差率	性能对比
Cumulative indexing time of primary shards		12.13692	13.65422	min	12.50%	↓
Min cumulative indexing time across primary shard		0	0	min	0.00%	-
Median cumulative indexing time across primary shard		0.003733	0.003233	min	-13.39%	↑
Max cumulative indexing time across primary shard		4.069	4.546867	min	11.74%	↓
Cumulative indexing throttle time of primary shards		0	0	min	0.00%	-
Min cumulative indexing throttle time across primary shard		0	0	min	0.00%	-
Median cumulative indexing throttle time across primary shard		0	0	min	0.00%	-
Max cumulative indexing throttle time across primary shard		0	0	min	0.00%	-
Cumulative merge time of primary shards		3.274033	3.7998	min	16.06%	↓
Cumulative merge count of primary shards		151	116		-23.18%	↑
Min cumulative merge time across primary shard		0	0	min	0.00%	-
Median cumulative merge time across primary shard		0.002983	0.00215	min	-27.93%	↑
Max cumulative merge time across primary shard		1.136567	1.368617	min	20.42%	↓
Cumulative merge throttle time of primary shards		1.212417	0.854817	min	-29.49%	↑
Min cumulative merge throttle time across primary shard		0	0	min	0.00%	-
Median cumulative merge throttle time across primary shard		0	0	min	0.00%	-
Max cumulative merge throttle time across primary shard		0.483167	0.376867	min	-22.00%	↑
Cumulative refresh time of primary shards		0.815683	0.8684	min	6.46%	↓
Cumulative refresh count of primary shards		1254	824		-34.29%	↑
Min cumulative refresh time across primary shard		0	0	min	0.00%	-
Median cumulative refresh time across primary shard		0.01955	0.013217	min	-32.40%	↑
Max cumulative refresh time across primary shard		0.253017	0.288867	min	14.17%	↓
Cumulative flush time of primary shards		0.311517	0.231517	min	-25.68%	↑
Cumulative flush count of primary shards		15	16		6.67%	↓
Min cumulative flush time across primary shard		0	0	min	0.00%	-
Median cumulative flush time across primary shard		0	3.33E-05	min	0.00%	-
Max cumulative flush time across primary shard		0.1125	0.090117	min	-19.90%	↑
Total Young Gen GC time		7.285	5.537	s	-23.99%	↑
Total Young Gen GC count		633	428		-32.39%	↑
Total Old Gen GC time		0	0	s	0.00%	-
Total Old Gen GC count		0	0		0.00%	-
Store size		6.108621	6.086145	GB	-0.37%	↑
Translog size		0.027325	0.014669	GB	-46.32%	↑
Heap used for segments		1.162872	1.157173	MB	-0.49%	↑
Heap used for doc values		0.234993	0.233444	MB	-0.66%	↑
Heap used for terms		0.814423	0.801842	MB	-1.54%	↑
Heap used for norms		0.048035	0.052551	MB	9.40%	↓
Heap used for points		0	0	MB	0.00%	-
Heap used for stored fields		0.065422	0.069336	MB	5.98%	↓
Segment count		100	106		6.00%	↓
error rate	index-append	0	0	%	0.00%	-
Min Throughput	index-stats	90.01091	90.01046	ops/s	0.00%	↓
Mean Throughput	index-stats	90.02068	90.02054	ops/s	0.00%	↓
Median Throughput	index-stats	90.01762	90.01974	ops/s	0.00%	-
Max Throughput	index-stats	90.03801	90.03158	ops/s	-0.01%	↓
50th percentile latency	index-stats	3.172824	3.455014	ms	8.89%	↓
90th percentile latency	index-stats	3.65115	3.865103	ms	5.86%	↓
99th percentile latency	index-stats	4.334665	4.179691	ms	-3.58%	↑
99.9th percentile latency	index-stats	13.4022	6.495999	ms	-51.53%	↑
100th percentile latency	index-stats	17.7899	6.71815	ms	-62.24%	↑
50th percentile service time	index-stats	2.447953	2.740973	ms	11.97%	↓
90th percentile service time	index-stats	2.755487	2.861406	ms	3.84%	↓
99th percentile service time	index-stats	3.491778	3.228419	ms	-7.54%	↑
99.9th percentile service time	index-stats	12.41878	4.324396	ms	-65.18%	↑
100th percentile service time	index-stats	17.38639	5.646112	ms	-67.53%	↑
error rate	index-stats	0	0	%	0.00%	-
Min Throughput	node-stats	89.95297	89.84275	ops/s	-0.12%	↓
Mean Throughput	node-stats	89.98269	89.93682	ops/s	-0.05%	↓
Median Throughput	node-stats	89.98712	89.94988	ops/s	-0.04%	↓
Max Throughput	node-stats	89.99519	89.97286	ops/s	-0.02%	↓
50th percentile latency	node-stats	3.296191	3.845605	ms	16.67%	↓
90th percentile latency	node-stats	3.799131	4.411485	ms	16.12%	↓
99th percentile latency	node-stats	4.786813	7.249037	ms	51.44%	↓
99.9th percentile latency	node-stats	5.793665	30.31716	ms	423.28%	↓
100th percentile latency	node-stats	6.562565	33.79342	ms	414.94%	↓
50th percentile service time	node-stats	2.566179	3.116541	ms	21.45%	↓
90th percentile service time	node-stats	2.923253	3.478723	ms	19.00%	↓
99th percentile service time	node-stats	4.226492	5.306357	ms	25.55%	↓
99.9th percentile service time	node-stats	4.729633	29.87361	ms	531.63%	↓
100th percentile service time	node-stats	5.728788	33.57647	ms	486.10%	↓
error rate	node-stats	0	0	%	0.00%	-
Min Throughput	default	50.0152	50.01167	ops/s	-0.01%
Mean Throughput	default	50.02553	50.02001	ops/s	-0.01%	↓
Median Throughput	default	50.02303	50.01797	ops/s	-0.01%
Max Throughput	default	50.04417	50.03503	ops/s	-0.02%	↓
50th percentile latency	default	3.689626	4.064527	ms	10.16%	↓
90th percentile latency	default	4.217221	4.501827	ms	6.75%	↓
99th percentile latency	default	5.385959	4.822351	ms	-10.46%	↑
99.9th percentile latency	default	8.354142	7.446993	ms	-10.86%	↑
100th percentile latency	default	9.191337	10.88422	ms	18.42%	↓
50th percentile service time	default	3.050713	3.334971	ms	9.32%	↓
90th percentile service time	default	3.320561	3.497533	ms	5.33%	↓
99th percentile service time	default	3.761687	3.920079	ms	4.21%	↓
99.9th percentile service time	default	7.875555	6.650144	ms	-15.56%	↑
100th percentile service time	default	8.580872	9.162904	ms	6.78%	↓
error rate	default	0	0	%	0.00%	-
Min Throughput	term	99.93696	99.93645	ops/s	0.00%	↓
Mean Throughput	term	99.96058	99.95657	ops/s	0.00%	↓
Median Throughput	term	99.96228	99.95814	ops/s	0.00%	↓
Max Throughput	term	99.97236	99.97233	ops/s	0.00%	↓
50th percentile latency	term	3.069355	3.888126	ms	26.68%	↓
90th percentile latency	term	3.509827	4.309532	ms	22.78%	↓
99th percentile latency	term	3.933137	4.719402	ms	19.99%	↓
99.9th percentile latency	term	7.350553	6.680716	ms	-9.11%	↑
100th percentile latency	term	14.43949	7.289359	ms	-49.52%	↑
50th percentile service time	term	2.355179	3.183407	ms	35.17%	↓
90th percentile service time	term	2.628199	3.32198	ms	26.40%	↓
99th percentile service time	term	2.916559	3.905628	ms	33.91%	↓
99.9th percentile service time	term	6.22785	5.603055	ms	-10.03%	↑
100th percentile service time	term	13.98078	6.446593	ms	-53.89%	↑
error rate	term	0	0	%	0.00%	-
Min Throughput	phrase	109.8036	109.7394	ops/s	-0.06%	↓
Mean Throughput	phrase	109.88	109.838	ops/s	-0.04%	↓
Median Throughput	phrase	109.8902	109.8511	ops/s	-0.04%	↓
Max Throughput	phrase	109.9229	109.8946	ops/s	-0.03%	↓
50th percentile latency	phrase	3.124941	3.632957	ms	16.26%	↓
90th percentile latency	phrase	3.576734	4.082768	ms	14.15%	↓
99th percentile latency	phrase	5.013414	9.7068	ms	93.62%	↓
99.9th percentile latency	phrase	14.82175	29.8126	ms	101.14%	↓
100th percentile latency	phrase	20.64022	32.19793	ms	56.00%	↓
50th percentile service time	phrase	2.426618	2.910209	ms	19.93%	↓
90th percentile service time	phrase	2.685807	3.142375	ms	17.00%	↓
99th percentile service time	phrase	3.2294	3.984294	ms	23.38%	↓
99.9th percentile service time	phrase	14.31686	20.82108	ms	45.43%	↓
100th percentile service time	phrase	14.74916	31.94962	ms	116.62%	↓
error rate	phrase	0	0	%	0.00%	-
Min Throughput	country agg uncached	2.996914	2.994442	ops/s	-0.08%	↓
Mean Throughput	country agg uncached	2.9975	2.995465	ops/s	-0.07%	↓
Median Throughput	country agg uncached	2.997534	2.995526	ops/s	-0.07%	↓
Max Throughput	country agg uncached	2.997928	2.996255	ops/s	-0.06%	↓
50th percentile latency	country agg uncached	214.9744	251.0548	ms	16.78%	↓
90th percentile latency	country agg uncached	219.1983	257.6587	ms	17.55%	↓
99th percentile latency	country agg uncached	230.8336	309.3295	ms	34.01%	↓
100th percentile latency	country agg uncached	236.5429	325.205	ms	37.48%	↓
50th percentile service time	country agg uncached	214.0287	250.2895	ms	16.94%	↓
90th percentile service time	country agg uncached	218.2245	256.7964	ms	17.68%	↓
99th percentile service time	country agg uncached	230.3793	308.5877	ms	33.95%	↓
100th percentile service time	country agg uncached	235.6672	324.8249	ms	37.83%	↓
error rate	country agg uncached	0	0	%	0.00%	-
Min Throughput	country agg cached	97.98956	97.70321	ops/s	-0.29%	↓
Mean Throughput	country agg cached	98.51696	98.30732	ops/s	-0.21%	↓
Median Throughput	country agg cached	98.56654	98.36632	ops/s	-0.20%	↓
Max Throughput	country agg cached	98.8928	98.73491	ops/s	-0.16%	↓
50th percentile latency	country agg cached	2.276356	2.292511	ms	0.71%	↓
90th percentile latency	country agg cached	3.572794	3.606574	ms	0.95%	↓
99th percentile latency	country agg cached	3.872698	3.905657	ms	0.85%	↓
99.9th percentile latency	country agg cached	5.008591	12.49224	ms	149.42%	↓
100th percentile latency	country agg cached	6.143569	20.3865	ms	231.83%	↓
50th percentile service time	country agg cached	1.541434	1.612634	ms	4.62%	↓
90th percentile service time	country agg cached	1.754622	1.707841	ms	-2.67%	↑
99th percentile service time	country agg cached	2.226828	1.882033	ms	-15.48%	↑
99.9th percentile service time	country agg cached	4.050017	2.454973	ms	-39.38%	↑
100th percentile service time	country agg cached	5.457047	19.66166	ms	260.30%	↓
error rate	country agg cached	0	0	%	0.00%	-
Min Throughput	scroll	20.0293	20.02947	pages/s	0.00%	-
Mean Throughput	scroll	20.03556	20.03581	pages/s	0.00%	-
Median Throughput	scroll	20.03508	20.03533	pages/s	0.00%	-
Max Throughput	scroll	20.04374	20.04406	pages/s	0.00%	-
50th percentile latency	scroll	609.1409	628.2205	ms	3.13%	↓
90th percentile latency	scroll	618.4449	644.2532	ms	4.17%	↓
99th percentile latency	scroll	635.2878	650.1816	ms	2.34%	↓
100th percentile latency	scroll	661.9673	651.5163	ms	-1.58%	↑
50th percentile service time	scroll	607.3914	626.7748	ms	3.19%	↓
90th percentile service time	scroll	616.4147	642.7277	ms	4.27%	↓
99th percentile service time	scroll	634.1222	648.682	ms	2.30%	↓
100th percentile service time	scroll	659.807	649.7406	ms	-1.53%	↑
error rate	scroll	0	0	%	0.00%	-
Min Throughput	expression	1.501082	1.500279	ops/s	-0.05%	↓
Mean Throughput	expression	1.501309	1.500343	ops/s	-0.06%	↓
Median Throughput	expression	1.501298	1.500334	ops/s	-0.06%	↓
Max Throughput	expression	1.501591	1.500421	ops/s	-0.08%	↓
50th percentile latency	expression	397.77	428.8482	ms	7.81%	↓
90th percentile latency	expression	399.8934	439.8193	ms	9.98%	↓
99th percentile latency	expression	405.0504	459.0066	ms	13.32%	↓
100th percentile latency	expression	408.5626	515.3191	ms	26.13%	↓
50th percentile service time	expression	396.573	428.0562	ms	7.94%	↓
90th percentile service time	expression	398.4105	438.3464	ms	10.02%	↓
99th percentile service time	expression	403.7755	458.5918	ms	13.58%	↓
100th percentile service time	expression	407.1302	514.3834	ms	26.34%	↓
error rate	expression	0	0	%	0.00%	-
Min Throughput	painless static	1.399931	1.397837	ops/s	-0.15%	↓
Mean Throughput	painless static	1.399946	1.398238	ops/s	-0.12%	↓
Median Throughput	painless static	1.399946	1.398265	ops/s	-0.12%	↓
Max Throughput	painless static	1.399958	1.398544	ops/s	-0.10%	↓
50th percentile latency	painless static	509.4646	586.3727	ms	15.10%	↓
90th percentile latency	painless static	518.0589	596.5983	ms	15.16%	↓
99th percentile latency	painless static	523.7899	606.4033	ms	15.77%	↓
100th percentile latency	painless static	524.1136	643.5933	ms	22.80%	↓
50th percentile service time	painless static	508.8671	585.5497	ms	15.07%	↓
90th percentile service time	painless static	517.009	595.2985	ms	15.14%	↓
99th percentile service time	painless static	522.7241	604.427	ms	15.63%	↓
100th percentile service time	painless static	523.6501	642.716	ms	22.74%	↓
error rate	painless static	0	0	%	0.00%	-
Min Throughput	painless dynamic	1.401163	1.399061	ops/s	-0.15%	↓
Mean Throughput	painless dynamic	1.401418	1.399234	ops/s	-0.16%	↓
Median Throughput	painless dynamic	1.401399	1.399248	ops/s	-0.15%	↓
Max Throughput	painless dynamic	1.401741	1.399367	ops/s	-0.17%	↓
50th percentile latency	painless dynamic	494.2687	578.3319	ms	17.01%	↓
90th percentile latency	painless dynamic	503.2998	588.6542	ms	16.96%	↓
99th percentile latency	painless dynamic	509.9914	639.5249	ms	25.40%	↓
100th percentile latency	painless dynamic	510.4079	674.0815	ms	32.07%	↓
50th percentile service time	painless dynamic	493.1329	577.149	ms	17.04%	↓
90th percentile service time	painless dynamic	501.9278	586.6313	ms	16.88%	↓
99th percentile service time	painless dynamic	508.3082	637.8023	ms	25.48%	↓
100th percentile service time	painless dynamic	509.7091	673.5206	ms	32.14%	↓
error rate	painless dynamic	0	0	%	0.00%	-
Min Throughput	decay geo gauss function score	1.001444	1.00125	ops/s	-0.02%	↓
Mean Throughput	decay geo gauss function score	1.001754	1.001518	ops/s	-0.02%	↓
Median Throughput	decay geo gauss function score	1.00173	1.001498	ops/s	-0.02%	↓
Max Throughput	decay geo gauss function score	1.002159	1.001869	ops/s	-0.03%	↓
50th percentile latency	decay geo gauss function score	506.0316	596.2377	ms	17.83%	↓
90th percentile latency	decay geo gauss function score	508.5883	601.2387	ms	18.22%	↓
99th percentile latency	decay geo gauss function score	512.9382	635.3658	ms	23.87%	↓
100th percentile latency	decay geo gauss function score	515.84	638.5117	ms	23.78%	↓
50th percentile service time	decay geo gauss function score	504.7985	595.2409	ms	17.92%	↓
90th percentile service time	decay geo gauss function score	507.2829	600.2598	ms	18.33%	↓
99th percentile service time	decay geo gauss function score	511.6621	634.6131	ms	24.03%	↓
100th percentile service time	decay geo gauss function score	514.8887	637.0254	ms	23.72%	↓
error rate	decay geo gauss function score	0	0	%	0.00%	-
Min Throughput	decay geo gauss script score	1.001372	1.00099	ops/s	-0.04%	↓
Mean Throughput	decay geo gauss script score	1.001669	1.001201	ops/s	-0.05%	↓
Median Throughput	decay geo gauss script score	1.001646	1.001184	ops/s	-0.05%	↓
Max Throughput	decay geo gauss script score	1.00205	1.001475	ops/s	-0.06%	↓
50th percentile latency	decay geo gauss script score	523.8021	625.0909	ms	19.34%	↓
90th percentile latency	decay geo gauss script score	529.3986	630.8024	ms	19.15%	↓
99th percentile latency	decay geo gauss script score	555.6341	683.7971	ms	23.07%	↓
100th percentile latency	decay geo gauss script score	563.2136	707.2969	ms	25.58%	↓
50th percentile service time	decay geo gauss script score	522.5704	623.9092	ms	19.39%	↓
90th percentile service time	decay geo gauss script score	527.1288	629.5138	ms	19.42%	↓
99th percentile service time	decay geo gauss script score	554.0548	682.9332	ms	23.26%	↓
100th percentile service time	decay geo gauss script score	560.7784	705.7401	ms	25.85%	↓
error rate	decay geo gauss script score	0	0	%	0.00%	-
Min Throughput	field value function score	1.503507	1.503209	ops/s	-0.02%	↓
Mean Throughput	field value function score	1.504269	1.503901	ops/s	-0.02%	↓
Median Throughput	field value function score	1.504215	1.50385	ops/s	-0.02%	↓
Max Throughput	field value function score	1.505246	1.504796	ops/s	-0.03%	↓
50th percentile latency	field value function score	185.5918	229.5384	ms	23.68%	↓
90th percentile latency	field value function score	192.1556	233.4264	ms	21.48%	↓
99th percentile latency	field value function score	194.0047	270.197	ms	39.27%	↓
100th percentile latency	field value function score	264.4487	275.7009	ms	4.25%	↓
50th percentile service time	field value function score	183.7263	228.4334	ms	24.33%	↓
90th percentile service time	field value function score	191.0908	232.5404	ms	21.69%	↓
99th percentile service time	field value function score	192.4972	268.5176	ms	39.49%	↓
100th percentile service time	field value function score	263.5534	274.7986	ms	4.27%	↓
error rate	field value function score	0	0	%	0.00%	-
Min Throughput	field value script score	1.502349	1.50235	ops/s	0.00%	-
Mean Throughput	field value script score	1.502839	1.502846	ops/s	0.00%	-
Median Throughput	field value script score	1.502801	1.502808	ops/s	0.00%	-
Max Throughput	field value script score	1.503471	1.50349	ops/s	0.00%	-
50th percentile latency	field value script score	252.0535	310.1943	ms	23.07%	↓
90th percentile latency	field value script score	256.0499	316.5399	ms	23.62%	↓
99th percentile latency	field value script score	283.4663	370.1662	ms	30.59%	↓
100th percentile latency	field value script score	286.5056	370.396	ms	29.28%	↓
50th percentile service time	field value script score	250.1281	309.0658	ms	23.56%	↓
90th percentile service time	field value script score	253.7611	315.341	ms	24.27%	↓
99th percentile service time	field value script score	281.6927	369.2647	ms	31.09%	↓
100th percentile service time	field value script score	285.171	369.5894	ms	29.60%	↓
error rate	field value script score	0	0	%	0.00%	-
Min Throughput	large terms	1.098729	1.086445	ops/s	-1.12%	↓
Mean Throughput	large terms	1.098964	1.088385	ops/s	-0.96%	↓
Median Throughput	large terms	1.098976	1.088524	ops/s	-0.95%	↓
Max Throughput	large terms	1.099145	1.089855	ops/s	-0.85%	↓
50th percentile latency	large terms	823.0126	3019.357	ms	266.87%	↓
90th percentile latency	large terms	830.6155	3148.364	ms	279.04%	↓
99th percentile latency	large terms	835.3904	3197.829	ms	282.79%	↓
100th percentile latency	large terms	836.8937	3199.601	ms	282.32%	↓
50th percentile service time	large terms	815.8893	910.0391	ms	11.54%	↓
90th percentile service time	large terms	822.6666	959.905	ms	16.68%	↓
99th percentile service time	large terms	828.4472	968.0314	ms	16.85%	↓
100th percentile service time	large terms	829.8767	970.6093	ms	16.96%	↓
error rate	large terms	0	0	%	0.00%	-
Min Throughput	large filtered terms	1.100268	1.085975	ops/s	-1.30%	↓
Mean Throughput	large filtered terms	1.100323	1.086656	ops/s	-1.24%	↓
Median Throughput	large filtered terms	1.10032	1.08671	ops/s	-1.24%	↓
Max Throughput	large filtered terms	1.100398	1.087119	ops/s	-1.21%	↓
50th percentile latency	large filtered terms	827.2812	3620.908	ms	337.69%	↓
90th percentile latency	large filtered terms	832.8975	4020.584	ms	382.72%	↓
99th percentile latency	large filtered terms	839.1567	4116.25	ms	390.52%	↓
100th percentile latency	large filtered terms	841.8363	4132.153	ms	390.85%	↓
50th percentile service time	large filtered terms	820.1701	943.2442	ms	15.01%	↓
90th percentile service time	large filtered terms	825.8126	967.7332	ms	17.19%	↓
99th percentile service time	large filtered terms	832.2652	977.4057	ms	17.44%	↓
100th percentile service time	large filtered terms	834.1797	989.8771	ms	18.66%	↓
error rate	large filtered terms	0	0	%	0.00%	-
Min Throughput	large prohibited terms	1.100328	1.077086	ops/s	-2.11%	↓
Mean Throughput	large prohibited terms	1.100398	1.077973	ops/s	-2.04%	↓
Median Throughput	large prohibited terms	1.100393	1.077966	ops/s	-2.04%	↓
Max Throughput	large prohibited terms	1.100491	1.078743	ops/s	-1.98%	↓
50th percentile latency	large prohibited terms	815.1735	5511.526	ms	576.12%	↓
90th percentile latency	large prohibited terms	819.983	6377.11	ms	677.71%	↓
99th percentile latency	large prohibited terms	825.432	6511.666	ms	688.88%	↓
100th percentile latency	large prohibited terms	827.4997	6529.329	ms	689.04%	↓
50th percentile service time	large prohibited terms	808.3108	915.2829	ms	13.23%	↓
90th percentile service time	large prohibited terms	812.943	927.277	ms	14.06%	↓
99th percentile service time	large prohibited terms	818.3828	1003.079	ms	22.57%	↓
100th percentile service time	large prohibited terms	820.7233	1030.782	ms	25.59%	↓
error rate	large prohibited terms	0	0	%	0.00%	-
Min Throughput	desc sort population	1.504125	1.503959	ops/s	-0.01%	↓
Mean Throughput	desc sort population	1.505014	1.504813	ops/s	-0.01%	↓
Median Throughput	desc sort population	1.504952	1.504755	ops/s	-0.01%	↓
Max Throughput	desc sort population	1.506165	1.50591	ops/s	-0.02%	↓
50th percentile latency	desc sort population	83.85828	94.85391	ms	13.11%	↓
90th percentile latency	desc sort population	84.97299	98.01779	ms	15.35%	↓
99th percentile latency	desc sort population	88.00757	172.1419	ms	95.60%	↓
100th percentile latency	desc sort population	88.1269	172.3069	ms	95.52%	↓
50th percentile service time	desc sort population	82.54314	92.7393	ms	12.35%	↓
90th percentile service time	desc sort population	83.48184	95.87959	ms	14.85%	↓
99th percentile service time	desc sort population	86.93492	169.6528	ms	95.15%	↓
100th percentile service time	desc sort population	87.31277	169.8743	ms	94.56%	↓
error rate	desc sort population	0	0	%	0.00%	-
Min Throughput	asc sort population	1.504349	1.50425	ops/s	-0.01%	↓
Mean Throughput	asc sort population	1.505289	1.505159	ops/s	-0.01%	↓
Median Throughput	asc sort population	1.505208	1.505097	ops/s	-0.01%	↓
Max Throughput	asc sort population	1.506504	1.506341	ops/s	-0.01%	↓
50th percentile latency	asc sort population	85.66127	97.17846	ms	13.45%	↓
90th percentile latency	asc sort population	86.65042	99.45249	ms	14.77%	↓
99th percentile latency	asc sort population	90.16076	159.9783	ms	77.44%	↓
100th percentile latency	asc sort population	95.53816	163.9837	ms	71.64%	↓
50th percentile service time	asc sort population	84.45677	95.09642	ms	12.60%	↓
90th percentile service time	asc sort population	85.10276	96.82747	ms	13.78%	↓
99th percentile service time	asc sort population	88.91906	158.4363	ms	78.18%	↓
100th percentile service time	asc sort population	93.78454	161.4212	ms	72.12%	↓
error rate	asc sort population	0	0	%	0.00%	-
Min Throughput	asc sort with after population	1.503205	1.502314	ops/s	-0.06%	↓
Mean Throughput	asc sort with after population	1.503902	1.5028	ops/s	-0.07%	↓
Median Throughput	asc sort with after population	1.503852	1.502762	ops/s	-0.07%	↓
Max Throughput	asc sort with after population	1.504795	1.503428	ops/s	-0.09%	↓
50th percentile latency	asc sort with after population	133.8266	148.1034	ms	10.67%	↓
90th percentile latency	asc sort with after population	135.2227	151.5491	ms	12.07%	↓
99th percentile latency	asc sort with after population	136.1994	158.6421	ms	16.48%	↓
100th percentile latency	asc sort with after population	136.5529	229.5572	ms	68.11%	↓
50th percentile service time	asc sort with after population	132.9712	146.9675	ms	10.53%	↓
90th percentile service time	asc sort with after population	134.1224	150.2631	ms	12.03%	↓
99th percentile service time	asc sort with after population	135.5426	157.6524	ms	16.31%	↓
100th percentile service time	asc sort with after population	135.6862	228.7383	ms	68.58%	↓
error rate	asc sort with after population	0	0	%	0.00%	-
Min Throughput	desc sort geonameid	6.004327	6.014738	ops/s	0.17%	↑
Mean Throughput	desc sort geonameid	6.005148	6.017559	ops/s	0.21%	↑
Median Throughput	desc sort geonameid	6.005116	6.017317	ops/s	0.20%	↑
Max Throughput	desc sort geonameid	6.006107	6.021188	ops/s	0.25%	↑
50th percentile latency	desc sort geonameid	5.409995	5.803633	ms	7.28%	↓
90th percentile latency	desc sort geonameid	5.93607	6.381984	ms	7.51%	↓
99th percentile latency	desc sort geonameid	6.293108	7.265142	ms	15.45%	↓
100th percentile latency	desc sort geonameid	6.577119	7.281934	ms	10.72%	↓
50th percentile service time	desc sort geonameid	4.529794	4.946462	ms	9.20%	↓
90th percentile service time	desc sort geonameid	4.89106	5.292251	ms	8.20%	↓
99th percentile service time	desc sort geonameid	5.122794	6.245203	ms	21.91%	↓
100th percentile service time	desc sort geonameid	5.300584	6.498822	ms	22.61%	↓
error rate	desc sort geonameid	0	0	%	0.00%	-
Min Throughput	desc sort with after geonameid	6.00527	6.004851	ops/s	-0.01%	↓
Mean Throughput	desc sort with after geonameid	6.006295	6.005795	ops/s	-0.01%	↓
Median Throughput	desc sort with after geonameid	6.006218	6.005743	ops/s	-0.01%	↓
Max Throughput	desc sort with after geonameid	6.00764	6.006927	ops/s	-0.01%	↓
50th percentile latency	desc sort with after geonameid	122.7259	126.3387	ms	2.94%	↓
90th percentile latency	desc sort with after geonameid	126.947	130.6906	ms	2.95%	↓
99th percentile latency	desc sort with after geonameid	130.2797	187.8153	ms	44.16%	↓
100th percentile latency	desc sort with after geonameid	133.6721	212.0108	ms	58.61%	↓
50th percentile service time	desc sort with after geonameid	121.94	125.6293	ms	3.03%	↓
90th percentile service time	desc sort with after geonameid	126.1451	129.3063	ms	2.51%	↓
99th percentile service time	desc sort with after geonameid	130.0349	187.3283	ms	44.06%	↓
100th percentile service time	desc sort with after geonameid	133.0953	211.0367	ms	58.56%	↓
error rate	desc sort with after geonameid	0	0	%	0.00%	-
Min Throughput	asc sort geonameid	6.017931	6.01881	ops/s	0.01%	↑
Mean Throughput	asc sort geonameid	6.021499	6.022499	ops/s	0.02%	↑
Median Throughput	asc sort geonameid	6.021247	6.022249	ops/s	0.02%	↑
Max Throughput	asc sort geonameid	6.025921	6.027172	ops/s	0.02%	↑
50th percentile latency	asc sort geonameid	5.472744	5.402479	ms	-1.28%	↑
90th percentile latency	asc sort geonameid	6.21314	6.277742	ms	1.04%	↓
99th percentile latency	asc sort geonameid	6.887052	6.940019	ms	0.77%	↓
100th percentile latency	asc sort geonameid	7.244275	7.008069	ms	-3.26%	↑
50th percentile service time	asc sort geonameid	4.652755	4.530322	ms	-2.63%	↑
90th percentile service time	asc sort geonameid	5.154251	5.61592	ms	8.96%	↓
99th percentile service time	asc sort geonameid	5.818483	5.752198	ms	-1.14%	↑
100th percentile service time	asc sort geonameid	5.886902	5.764806	ms	-2.07%	↑
error rate	asc sort geonameid	0	0	%	0.00%	-
Min Throughput	asc sort with after geonameid	6.006561	6.005652	ops/s	-0.02%	↓
Mean Throughput	asc sort with after geonameid	6.007781	6.006818	ops/s	-0.02%	↓
Median Throughput	asc sort with after geonameid	6.007701	6.006702	ops/s	-0.02%	↓
Max Throughput	asc sort with after geonameid	6.009473	6.008266	ops/s	-0.02%	↓
50th percentile latency	asc sort with after geonameid	108.2379	117.4644	ms	8.52%	↓
90th percentile latency	asc sort with after geonameid	110.4991	120.7699	ms	9.29%	↓
99th percentile latency	asc sort with after geonameid	113.719	122.8115	ms	8.00%	↓
100th percentile latency	asc sort with after geonameid	117.4331	125.1218	ms	6.55%	↓
50th percentile service time	asc sort with after geonameid	107.0072	116.4327	ms	8.81%	↓
90th percentile service time	asc sort with after geonameid	109.196	119.6759	ms	9.60%	↓
99th percentile service time	asc sort with after geonameid	111.7552	122.3663	ms	9.49%	↓
100th percentile service time	asc sort with after geonameid	115.6274	123.8561	ms	7.12%	↓
error rate	asc sort with after geonameid	0	0	%	0.00%	-