Elasticsearch 7.10.1压测对比（8核32G*3，AMD vs Intel）

原创

岳涛

修改于 2022-05-16 15:58:05

1.3K0

修改于 2022-05-16 15:58:05

文章被收录于专栏：大数据生态大数据生态

说明

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

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

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

Elasticsearch 7.10.1集群压测报告（8核32G*3，AMD）

Elasticsearch 7.10.1集群压测报告（8核32G*3，Intel）

本文另有延续：

Elasticsearch 7.10.1压测对比（4核16G*3，AMD vs Intel）

环境配置

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

内存：32G

硬盘：SSD云硬盘 1TB

CPU个数：1

CPU核心数：8

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:8C32G_1T*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
------------------------------------  ----------------  --------  ----------------------------------------  -------------------  --------  ------------------------  ----------------  ---------------
d4067570-8dc4-4302-9d61-280ccd289108  20211021T155939Z  geonames  number_of_replicas=1, number_of_shards=3  append-no-conflicts  external  version=Intel_8C32G_1T*3  31df6b8
c8bc63d2-8429-401d-a84b-8009b9921d7f  20211021T141959Z  geonames  number_of_replicas=1, number_of_shards=3  append-no-conflicts  external  version=AMD_8C32G_1T*3    31df6b8

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

2. 对比压测报告

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

[dy@VM-1-12-centos ~]$ esrally compare --baseline=c8bc63d2-8429-401d-a84b-8009b9921d7f --contender=d4067570-8dc4-4302-9d61-280ccd289108

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


Comparing baseline
  Race ID: c8bc63d2-8429-401d-a84b-8009b9921d7f
  Race timestamp: 2021-10-21 14:19:59
  Challenge: append-no-conflicts
  Car: external
  User tags: version=AMD_8C32G_1T*3

with contender
  Race ID: d4067570-8dc4-4302-9d61-280ccd289108
  Race timestamp: 2021-10-21 15:59:39
  Challenge: append-no-conflicts
  Car: external
  User tags: version=Intel_8C32G_1T*3

压测性能对比结果

性能对比标识在最后一列，↑表示Intel比AMD性能好，↓表示Intel比AMD性能差。孰强孰弱，一目了然。通过输出的表格可以看到性能压测结果AMD远超Intel，AMD在压测过程中表现相当优秀。

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

压测指标	压测任务	AMD CPU	Intel CPU	单位	差率	性能对比
Cumulative indexing time of primary shards		15.42043333	17.89708	min	16.06%	↓
Min cumulative indexing time across primary shard		0	0	min	0.00%	-
Median cumulative indexing time across primary shard		0.001333333	0.0014	min	5.00%	↓
Max cumulative indexing time across primary shard		5.605566667	6.106967	min	8.94%	↓
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		4.104683333	4.5751	min	11.46%	↓
Cumulative merge count of primary shards		127	122		-3.94%	↑
Min cumulative merge time across primary shard		0	0	min	0.00%	-
Median cumulative merge time across primary shard		0.0014	0.001492	min	6.55%	↓
Max cumulative merge time across primary shard		1.408633333	1.520283	min	7.93%	↓
Cumulative merge throttle time of primary shards		0.87585	0.792833	min	-9.48%	↑
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.311133333	0.3203	min	2.95%	↓
Cumulative refresh time of primary shards		1.082016667	1.343233	min	24.14%	↓
Cumulative refresh count of primary shards		1053	1024		-2.75%	↑
Min cumulative refresh time across primary shard		0	0	min	0.00%	-
Median cumulative refresh time across primary shard		0.008516667	0.0092	min	8.02%	↓
Max cumulative refresh time across primary shard		0.34495	0.44665	min	29.48%	↓
Cumulative flush time of primary shards		0.288333333	0.304667	min	5.66%	↓
Cumulative flush count of primary shards		21	21		0.00%	-
Min cumulative flush time across primary shard		0	0	min	0.00%	-
Median cumulative flush time across primary shard		0.000325	0.000325	min	0.00%	-
Max cumulative flush time across primary shard		0.110533333	0.131633	min	19.09%	↓
Total Young Gen GC time		9.41	12.838	s	36.43%	↓
Total Young Gen GC count		1119	1058		-5.45%	↑
Total Old Gen GC time		0	0	s	0.00%	-
Total Old Gen GC count		0	0		0.00%	-
Store size		6.058573045	6.056773	GB	-0.03%	↑
Translog size		0.015326136	0.014312	GB	-6.62%	↑
Heap used for segments		0.888233185	0.786037	MB	-11.51%	↑
Heap used for doc values		0.187038422	0.15276	MB	-18.33%	↑
Heap used for terms		0.595230103	0.535995	MB	-9.95%	↑
Heap used for norms		0.053161621	0.049255	MB	-7.35%	↑
Heap used for points		0	0	MB	0.00%	-
Heap used for stored fields		0.05280304	0.048027	MB	-9.04%	↑
Segment count		109	99		-9.17%	↑
Min Throughput	index-append	82021.74422	66473.36	docs/s	-18.96%	↓
Mean Throughput	index-append	82462.75703	67327.31	docs/s	-18.35%	↓
Median Throughput	index-append	82386.2526	67308.61	docs/s	-18.30%	↓
Max Throughput	index-append	83125.25067	68484.41	docs/s	-17.61%	↓
50th percentile latency	index-append	301.695738	356.1304	ms	18.04%	↓
90th percentile latency	index-append	444.8365966	1044.297	ms	134.76%	↓
99th percentile latency	index-append	2023.371902	2036.473	ms	0.65%	↓
100th percentile latency	index-append	2783.085167	2761.671	ms	-0.77%	↑
50th percentile service time	index-append	301.695738	356.1304	ms	18.04%	↓
90th percentile service time	index-append	444.8365966	1044.297	ms	134.76%	↓
99th percentile service time	index-append	2023.371902	2036.473	ms	0.65%	↓
100th percentile service time	index-append	2783.085167	2761.671	ms	-0.77%	↑
error rate	index-append	0	0	%	0.00%	-
Min Throughput	index-stats	89.9967314	89.81217	ops/s	-0.21%	↓
Mean Throughput	index-stats	89.99904246	89.88727	ops/s	-0.12%	↓
Median Throughput	index-stats	89.99863388	89.89557	ops/s	-0.11%	↓
Max Throughput	index-stats	90.00340249	89.92834	ops/s	-0.08%	↓
50th percentile latency	index-stats	3.441083443	3.762317	ms	9.34%	↓
90th percentile latency	index-stats	3.984517467	4.311186	ms	8.20%	↓
99th percentile latency	index-stats	5.298997925	25.03593	ms	372.47%	↓
99.9th percentile latency	index-stats	38.00716525	87.66076	ms	130.64%	↓
100th percentile latency	index-stats	44.72224955	93.83369	ms	109.81%	↓
50th percentile service time	index-stats	2.6915535	3.010511	ms	11.85%	↓
90th percentile service time	index-stats	3.111864599	3.38244	ms	8.69%	↓
99th percentile service time	index-stats	3.987799719	4.012927	ms	0.63%	↓
99.9th percentile service time	index-stats	10.16881553	9.506333	ms	-6.51%	↑
100th percentile service time	index-stats	43.6778	93.4013	ms	113.84%	↓
error rate	index-stats	0	0	%	0.00%	-
Min Throughput	node-stats	89.97468707	89.90802	ops/s	-0.07%	↓
Mean Throughput	node-stats	89.98846323	89.9648	ops/s	-0.03%	↓
Median Throughput	node-stats	89.99231491	89.96964	ops/s	-0.03%	↓
Max Throughput	node-stats	89.99804024	89.9866	ops/s	-0.01%	↓
50th percentile latency	node-stats	3.866618779	4.040397	ms	4.49%	↓
90th percentile latency	node-stats	4.644099803	4.663325	ms	0.41%	↓
99th percentile latency	node-stats	6.031989439	5.755049	ms	-4.59%	↑
99.9th percentile latency	node-stats	7.773754192	7.727507	ms	-0.59%	↑
100th percentile latency	node-stats	11.13613511	13.60948	ms	22.21%	↓
50th percentile service time	node-stats	3.094238	3.254543	ms	5.18%	↓
90th percentile service time	node-stats	3.871352101	3.859349	ms	-0.31%	↑
99th percentile service time	node-stats	5.185550639	5.06827	ms	-2.26%	↑
99.9th percentile service time	node-stats	6.793614959	6.71758	ms	-1.12%	↑
100th percentile service time	node-stats	10.460903	13.1472	ms	25.68%	↓
error rate	node-stats	0	0	%	0.00%	-
Min Throughput	default	50.00960627	50.00787	ops/s	0.00%
Mean Throughput	default	50.01595946	50.01391	ops/s	0.00%	↓
Median Throughput	default	50.0144169	50.01238	ops/s	0.00%
Max Throughput	default	50.02897807	50.02394	ops/s	-0.01%	↓
50th percentile latency	default	3.791258499	4.357371	ms	14.93%	↓
90th percentile latency	default	4.401348202	4.881838	ms	10.92%	↓
99th percentile latency	default	5.309187091	5.544531	ms	4.43%	↓
99.9th percentile latency	default	9.950440274	7.180937	ms	-27.83%	↑
100th percentile latency	default	16.040617	9.560666	ms	-40.40%	↑
50th percentile service time	default	3.115127998	3.653902	ms	17.30%	↓
90th percentile service time	default	3.559318198	4.034333	ms	13.35%	↓
99th percentile service time	default	4.455516639	4.54517	ms	2.01%	↓
99.9th percentile service time	default	9.090977102	6.371583	ms	-29.91%	↑
100th percentile service time	default	15.386774	8.478225	ms	-44.90%	↑
error rate	default	0	0	%	0.00%	-
Min Throughput	term	99.87226769	99.95958	ops/s	0.09%	↑
Mean Throughput	term	99.92189729	99.97378	ops/s	0.05%	↑
Median Throughput	term	99.92580579	99.97571	ops/s	0.05%	↑
Max Throughput	term	99.95168796	99.98309	ops/s	0.03%	↑
50th percentile latency	term	2.959510002	3.438378	ms	16.18%	↓
90th percentile latency	term	3.478777002	3.975763	ms	14.29%	↓
99th percentile latency	term	5.968629692	4.539675	ms	-23.94%	↑
99.9th percentile latency	term	42.98653415	12.87834	ms	-70.04%	↑
100th percentile latency	term	45.27839	19.79348	ms	-56.28%	↑
50th percentile service time	term	2.210382501	2.76449	ms	25.07%	↓
90th percentile service time	term	2.645509299	3.007717	ms	13.69%	↓
99th percentile service time	term	3.263342812	3.53801	ms	8.42%	↓
99.9th percentile service time	term	22.36627116	3.926158	ms	-82.45%	↑
100th percentile service time	term	31.871917	19.47165	ms	-38.91%	↑
error rate	term	0	0	%	0.00%	-
Min Throughput	phrase	109.787216	109.7103	ops/s	-0.07%	↓
Mean Throughput	phrase	109.8688705	109.8278	ops/s	-0.04%	↓
Median Throughput	phrase	109.8767482	109.8473	ops/s	-0.03%	↓
Max Throughput	phrase	109.9146044	109.8941	ops/s	-0.02%	↓
50th percentile latency	phrase	3.465827182	3.651525	ms	5.36%	↓
90th percentile latency	phrase	4.029201999	4.115187	ms	2.13%	↓
99th percentile latency	phrase	4.791637989	4.687366	ms	-2.18%	↑
99.9th percentile latency	phrase	22.61044287	15.81304	ms	-30.06%	↑
100th percentile latency	phrase	26.78367655	21.50583	ms	-19.71%	↑
50th percentile service time	phrase	2.746376998	2.945234	ms	7.24%	↓
90th percentile service time	phrase	3.180386401	3.158314	ms	-0.69%	↑
99th percentile service time	phrase	3.841835721	3.528944	ms	-8.14%	↑
99.9th percentile service time	phrase	6.367192554	5.465716	ms	-14.16%	↑
100th percentile service time	phrase	26.455638	20.45337	ms	-22.69%	↑
error rate	phrase	0	0	%	0.00%	-
Min Throughput	country agg uncached	2.994635233	2.992194	ops/s	-0.08%	↓
Mean Throughput	country agg uncached	2.995639674	2.993943	ops/s	-0.06%	↓
Median Throughput	country agg uncached	2.995688077	2.994019	ops/s	-0.06%	↓
Max Throughput	country agg uncached	2.996421058	2.995068	ops/s	-0.05%	↓
50th percentile latency	country agg uncached	269.1492908	278.4193	ms	3.44%	↓
90th percentile latency	country agg uncached	273.0572789	338.0706	ms	23.81%	↓
99th percentile latency	country agg uncached	278.8173282	355.738	ms	27.59%	↓
100th percentile latency	country agg uncached	286.7436463	368.4426	ms	28.49%	↓
50th percentile service time	country agg uncached	268.065374	276.9003	ms	3.30%	↓
90th percentile service time	country agg uncached	272.1922702	337.805	ms	24.11%	↓
99th percentile service time	country agg uncached	278.2730288	355.3527	ms	27.70%	↓
100th percentile service time	country agg uncached	285.920954	366.9322	ms	28.33%	↓
error rate	country agg uncached	0	0	%	0.00%	-
Min Throughput	country agg cached	97.53870847	97.54486	ops/s	0.01%	↑
Mean Throughput	country agg cached	98.19003125	98.19282	ops/s	0.00%	-
Median Throughput	country agg cached	98.24957187	98.25585	ops/s	0.01%	↑
Max Throughput	country agg cached	98.6480173	98.64958	ops/s	0.00%	-
50th percentile latency	country agg cached	2.441493501	2.502596	ms	2.50%	↓
90th percentile latency	country agg cached	3.571614999	2.909202	ms	-18.55%	↑
99th percentile latency	country agg cached	4.067578791	3.903797	ms	-4.03%	↑
99.9th percentile latency	country agg cached	4.757326438	8.047072	ms	69.15%	↓
100th percentile latency	country agg cached	8.729784	8.110129	ms	-7.10%	↑
50th percentile service time	country agg cached	1.627851001	1.752804	ms	7.68%	↓
90th percentile service time	country agg cached	1.947654502	1.932574	ms	-0.77%	↑
99th percentile service time	country agg cached	2.403753928	2.152786	ms	-10.44%	↑
99.9th percentile service time	country agg cached	3.822819996	7.436497	ms	94.53%	↓
100th percentile service time	country agg cached	8.153479001	7.849558	ms	-3.73%	↑
error rate	country agg cached	0	0	%	0.00%	-
Min Throughput	scroll	20.03016039	20.02584	pages/s	-0.02%	↓
Mean Throughput	scroll	20.03662952	20.0314	pages/s	-0.03%	↓
Median Throughput	scroll	20.03613456	20.03098	pages/s	-0.03%	↓
Max Throughput	scroll	20.04508155	20.03861	pages/s	-0.03%	↓
50th percentile latency	scroll	608.429983	640.1161	ms	5.21%	↓
90th percentile latency	scroll	618.3406539	651.903	ms	5.43%	↓
99th percentile latency	scroll	630.3750427	666.913	ms	5.80%	↓
100th percentile latency	scroll	643.217888	668.9398	ms	4.00%	↓
50th percentile service time	scroll	606.853113	638.1653	ms	5.16%	↓
90th percentile service time	scroll	616.4446027	650.9767	ms	5.60%	↓
99th percentile service time	scroll	629.1856936	665.8379	ms	5.83%	↓
100th percentile service time	scroll	641.772716	667.5554	ms	4.02%	↓
error rate	scroll	0	0	%	0.00%	-
Min Throughput	expression	1.500330413	1.499332	ops/s	-0.07%	↓
Mean Throughput	expression	1.500396957	1.500076	ops/s	-0.02%	↓
Median Throughput	expression	1.500395125	1.500091	ops/s	-0.02%	↓
Max Throughput	expression	1.500487124	1.500117	ops/s	-0.02%	↓
50th percentile latency	expression	468.4566265	502.9787	ms	7.37%	↓
90th percentile latency	expression	471.8267414	568.0348	ms	20.39%	↓
99th percentile latency	expression	490.7830575	712.1116	ms	45.10%	↓
100th percentile latency	expression	494.8954007	749.7135	ms	51.49%	↓
50th percentile service time	expression	467.493572	501.5392	ms	7.28%	↓
90th percentile service time	expression	470.9279876	564.8901	ms	19.95%	↓
99th percentile service time	expression	490.0779456	711.2925	ms	45.14%	↓
100th percentile service time	expression	494.533603	748.8776	ms	51.43%	↓
error rate	expression	0	0	%	0.00%	-
Min Throughput	painless static	1.397883236	1.396882	ops/s	-0.07%	↓
Mean Throughput	painless static	1.398269413	1.397455	ops/s	-0.06%	↓
Median Throughput	painless static	1.39829437	1.397494	ops/s	-0.06%	↓
Max Throughput	painless static	1.398569189	1.397905	ops/s	-0.05%	↓
50th percentile latency	painless static	621.1584964	654.6688	ms	5.39%	↓
90th percentile latency	painless static	629.0281401	666.219	ms	5.91%	↓
99th percentile latency	painless static	641.496446	671.554	ms	4.69%	↓
100th percentile latency	painless static	649.3150601	675.3028	ms	4.00%	↓
50th percentile service time	painless static	620.261398	653.5771	ms	5.37%	↓
90th percentile service time	painless static	628.3941324	665.3855	ms	5.89%	↓
99th percentile service time	painless static	641.0634611	671.1865	ms	4.70%	↓
100th percentile service time	painless static	648.629945	674.5452	ms	4.00%	↓
error rate	painless static	0	0	%	0.00%	-
Min Throughput	painless dynamic	1.398687694	1.39922	ops/s	0.04%	↑
Mean Throughput	painless dynamic	1.398929919	1.399727	ops/s	0.06%	↑
Median Throughput	painless dynamic	1.398946531	1.399743	ops/s	0.06%	↑
Max Throughput	painless dynamic	1.399120044	1.39979	ops/s	0.05%	↑
50th percentile latency	painless dynamic	606.0788898	663.2265	ms	9.43%	↓
90th percentile latency	painless dynamic	612.4579489	700.8868	ms	14.44%	↓
99th percentile latency	painless dynamic	621.3851055	741.1494	ms	19.27%	↓
100th percentile latency	painless dynamic	636.4420481	749.1557	ms	17.71%	↓
50th percentile service time	painless dynamic	604.9652305	661.5018	ms	9.35%	↓
90th percentile service time	painless dynamic	611.4854488	698.0511	ms	14.16%	↓
99th percentile service time	painless dynamic	620.6092117	740.1696	ms	19.26%	↓
100th percentile service time	painless dynamic	635.157132	748.5696	ms	17.86%	↓
error rate	painless dynamic	0	0	%	0.00%	-
Min Throughput	decay geo gauss function score	1.001378687	1.000837	ops/s	-0.05%	↓
Mean Throughput	decay geo gauss function score	1.001673909	1.001017	ops/s	-0.07%	↓
Median Throughput	decay geo gauss function score	1.001651342	1.001003	ops/s	-0.06%	↓
Max Throughput	decay geo gauss function score	1.002059445	1.001252	ops/s	-0.08%	↓
50th percentile latency	decay geo gauss function score	553.952997	637.4229	ms	15.07%	↓
90th percentile latency	decay geo gauss function score	563.9067751	677.0838	ms	20.07%	↓
99th percentile latency	decay geo gauss function score	580.9045063	689.8385	ms	18.75%	↓
100th percentile latency	decay geo gauss function score	584.3434	692.1576	ms	18.45%	↓
50th percentile service time	decay geo gauss function score	552.8790995	636.4843	ms	15.12%	↓
90th percentile service time	decay geo gauss function score	562.3708839	675.8741	ms	20.18%	↓
99th percentile service time	decay geo gauss function score	579.4227887	688.6572	ms	18.85%	↓
100th percentile service time	decay geo gauss function score	583.145355	691.3153	ms	18.55%	↓
error rate	decay geo gauss function score	0	0	%	0.00%	-
Min Throughput	decay geo gauss script score	1.001125676	1.000621	ops/s	-0.05%	↓
Mean Throughput	decay geo gauss script score	1.001365058	1.000753	ops/s	-0.06%	↓
Median Throughput	decay geo gauss script score	1.001345731	1.000743	ops/s	-0.06%	↓
Max Throughput	decay geo gauss script score	1.001681295	1.000927	ops/s	-0.08%	↓
50th percentile latency	decay geo gauss script score	570.9081645	642.4143	ms	12.52%	↓
90th percentile latency	decay geo gauss script score	581.1222293	669.8319	ms	15.27%	↓
99th percentile latency	decay geo gauss script score	596.5302071	692.1454	ms	16.03%	↓
100th percentile latency	decay geo gauss script score	597.903441	694.3337	ms	16.13%	↓
50th percentile service time	decay geo gauss script score	570.0981175	641.5674	ms	12.54%	↓
90th percentile service time	decay geo gauss script score	579.9713089	668.5113	ms	15.27%	↓
99th percentile service time	decay geo gauss script score	594.925631	690.8543	ms	16.12%	↓
100th percentile service time	decay geo gauss script score	597.184312	693.4702	ms	16.12%	↓
error rate	decay geo gauss script score	0	0	%	0.00%	-
Min Throughput	field value function score	1.503296651	1.50299	ops/s	-0.02%	↓
Mean Throughput	field value function score	1.50400894	1.503634	ops/s	-0.02%	↓
Median Throughput	field value function score	1.503958048	1.503584	ops/s	-0.02%	↓
Max Throughput	field value function score	1.504921153	1.504468	ops/s	-0.03%	↓
50th percentile latency	field value function score	221.4061625	254.7789	ms	15.07%	↓
90th percentile latency	field value function score	230.4169463	301.6393	ms	30.91%	↓
99th percentile latency	field value function score	237.444919	344.6033	ms	45.13%	↓
100th percentile latency	field value function score	247.694789	354.7548	ms	43.22%	↓
50th percentile service time	field value function score	220.245835	252.9334	ms	14.84%	↓
90th percentile service time	field value function score	229.2599964	299.1995	ms	30.51%	↓
99th percentile service time	field value function score	236.6308268	342.2069	ms	44.62%	↓
100th percentile service time	field value function score	246.137971	352.6668	ms	43.28%	↓
error rate	field value function score	0	0	%	0.00%	-
Min Throughput	field value script score	1.502485423	1.502204	ops/s	-0.02%	↓
Mean Throughput	field value script score	1.503004585	1.502668	ops/s	-0.02%	↓
Median Throughput	field value script score	1.502967418	1.502632	ops/s	-0.02%	↓
Max Throughput	field value script score	1.503680975	1.503268	ops/s	-0.03%	↓
50th percentile latency	field value script score	292.8843847	324.4386	ms	10.77%	↓
90th percentile latency	field value script score	295.2106924	383.399	ms	29.87%	↓
99th percentile latency	field value script score	318.6949404	396.5283	ms	24.42%	↓
100th percentile latency	field value script score	371.377833	429.4596	ms	15.64%	↓
50th percentile service time	field value script score	291.864303	322.9525	ms	10.65%	↓
90th percentile service time	field value script score	294.0011664	382.2079	ms	30.00%	↓
99th percentile service time	field value script score	317.5362884	395.4737	ms	24.54%	↓
100th percentile service time	field value script score	370.159679	428.3236	ms	15.71%	↓
error rate	field value script score	0	0	%	0.00%	-
Min Throughput	large terms	1.097623696	1.004932	ops/s	-8.44%	↓
Mean Throughput	large terms	1.098069801	1.007782	ops/s	-8.22%	↓
Median Throughput	large terms	1.098095819	1.008076	ops/s	-8.20%	↓
Max Throughput	large terms	1.098407503	1.01069	ops/s	-7.99%	↓
50th percentile latency	large terms	874.2859622	21242.91	ms	2329.74%	↓
90th percentile latency	large terms	887.6476807	24030.6	ms	2607.22%	↓
99th percentile latency	large terms	896.4625328	24543.58	ms	2637.83%	↓
100th percentile latency	large terms	897.5906804	24653.48	ms	2646.63%	↓
50th percentile service time	large terms	867.6132515	1018.054	ms	17.34%	↓
90th percentile service time	large terms	880.3736673	1033.783	ms	17.43%	↓
99th percentile service time	large terms	889.6549177	1055.769	ms	18.67%	↓
100th percentile service time	large terms	889.989314	1085.811	ms	22.00%	↓
error rate	large terms	0	0	%	0.00%	-
Min Throughput	large filtered terms	1.09957656	1.037919	ops/s	-5.61%	↓
Mean Throughput	large filtered terms	1.099653601	1.039079	ops/s	-5.51%	↓
Median Throughput	large filtered terms	1.099657822	1.039274	ops/s	-5.49%	↓
Max Throughput	large filtered terms	1.099716183	1.039887	ops/s	-5.44%	↓
50th percentile latency	large filtered terms	872.4653898	13956.24	ms	1499.63%	↓
90th percentile latency	large filtered terms	884.0328258	15970.47	ms	1706.55%	↓
99th percentile latency	large filtered terms	901.3380893	16585.85	ms	1740.14%	↓
100th percentile latency	large filtered terms	911.676195	16594.67	ms	1720.24%	↓
50th percentile service time	large filtered terms	865.621577	999.665	ms	15.49%	↓
90th percentile service time	large filtered terms	876.7369915	1014.505	ms	15.71%	↓
99th percentile service time	large filtered terms	893.7938698	1030.268	ms	15.27%	↓
100th percentile service time	large filtered terms	903.582175	1052.645	ms	16.50%	↓
error rate	large filtered terms	0	0	%	0.00%	-
Min Throughput	large prohibited terms	1.100102226	0.955024	ops/s	-13.19%	↓
Mean Throughput	large prohibited terms	1.100151247	0.957352	ops/s	-12.98%	↓
Median Throughput	large prohibited terms	1.100149659	0.957049	ops/s	-13.01%	↓
Max Throughput	large prohibited terms	1.100188925	0.962053	ops/s	-12.56%	↓
50th percentile latency	large prohibited terms	873.3173536	34937.31	ms	3900.53%	↓
90th percentile latency	large prohibited terms	890.6256977	40304.5	ms	4425.41%	↓
99th percentile latency	large prohibited terms	914.1387926	41289.41	ms	4416.75%	↓
100th percentile latency	large prohibited terms	921.4004728	41383.73	ms	4391.39%	↓
50th percentile service time	large prohibited terms	865.849542	1023.825	ms	18.25%	↓
90th percentile service time	large prohibited terms	883.1817199	1125.185	ms	27.40%	↓
99th percentile service time	large prohibited terms	906.8485515	1233.243	ms	35.99%	↓
100th percentile service time	large prohibited terms	914.852154	1373.522	ms	50.14%	↓
error rate	large prohibited terms	0	0	%	0.00%	-
Min Throughput	desc sort population	1.503601179	1.503403	ops/s	-0.01%	↓
Mean Throughput	desc sort population	1.50438148	1.504141	ops/s	-0.02%	↓
Median Throughput	desc sort population	1.504328264	1.504082	ops/s	-0.02%	↓
Max Throughput	desc sort population	1.505379427	1.505089	ops/s	-0.02%	↓
50th percentile latency	desc sort population	103.3679945	113.6326	ms	9.93%	↓
90th percentile latency	desc sort population	121.5195213	188.2103	ms	54.88%	↓
99th percentile latency	desc sort population	147.3778032	205.8384	ms	39.67%	↓
100th percentile latency	desc sort population	162.057875	206.6337	ms	27.51%	↓
50th percentile service time	desc sort population	102.0622915	112.2215	ms	9.95%	↓
90th percentile service time	desc sort population	120.1791787	186.6854	ms	55.34%	↓
99th percentile service time	desc sort population	146.4293378	204.1119	ms	39.39%	↓
100th percentile service time	desc sort population	161.312086	205.1423	ms	27.17%	↓
error rate	desc sort population	0	0	%	0.00%	-
Min Throughput	asc sort population	1.503605666	1.504146	ops/s	0.04%	↑
Mean Throughput	asc sort population	1.504385355	1.50505	ops/s	0.04%	↑
Median Throughput	asc sort population	1.504334333	1.504978	ops/s	0.04%	↑
Max Throughput	asc sort population	1.505390155	1.506212	ops/s	0.05%	↑
50th percentile latency	asc sort population	106.4428507	110.3872	ms	3.71%	↓
90th percentile latency	asc sort population	118.098918	187.6956	ms	58.93%	↓
99th percentile latency	asc sort population	124.9702431	193.1705	ms	54.57%	↓
100th percentile latency	asc sort population	126.8899607	195.7228	ms	54.25%	↓
50th percentile service time	asc sort population	105.036876	109.1763	ms	3.94%	↓
90th percentile service time	asc sort population	116.5656603	186.0483	ms	59.61%	↓
99th percentile service time	asc sort population	123.970388	192.0302	ms	54.90%	↓
100th percentile service time	asc sort population	125.546471	194.8547	ms	55.21%	↓
error rate	asc sort population	0	0	%	0.00%	-
Min Throughput	asc sort with after population	1.503598757	1.503405	ops/s	-0.01%	↓
Mean Throughput	asc sort with after population	1.504378996	1.504144	ops/s	-0.02%	↓
Median Throughput	asc sort with after population	1.504323262	1.504091	ops/s	-0.02%	↓
Max Throughput	asc sort with after population	1.505384432	1.50509	ops/s	-0.02%	↓
50th percentile latency	asc sort with after population	162.769519	159.4988	ms	-2.01%	↑
90th percentile latency	asc sort with after population	178.1462409	229.4634	ms	28.81%	↓
99th percentile latency	asc sort with after population	182.5507784	250.3319	ms	37.13%	↓
100th percentile latency	asc sort with after population	184.0613573	286.1871	ms	55.48%	↓
50th percentile service time	asc sort with after population	161.5666525	158.4014	ms	-1.96%	↑
90th percentile service time	asc sort with after population	176.8755378	228.0383	ms	28.93%	↓
99th percentile service time	asc sort with after population	181.7538015	249.0411	ms	37.02%	↓
100th percentile service time	asc sort with after population	182.319437	284.5601	ms	56.08%	↓
error rate	asc sort with after population	0	0	%	0.00%	-
Min Throughput	desc sort geonameid	6.0069534	6.006078	ops/s	-0.01%	↓
Mean Throughput	desc sort geonameid	6.008310988	6.007289	ops/s	-0.02%	↓
Median Throughput	desc sort geonameid	6.008178457	6.007173	ops/s	-0.02%	↓
Max Throughput	desc sort geonameid	6.009961301	6.008761	ops/s	-0.02%	↓
50th percentile latency	desc sort geonameid	7.213735835	9.482057	ms	31.44%	↓
90th percentile latency	desc sort geonameid	7.752741437	10.42809	ms	34.51%	↓
99th percentile latency	desc sort geonameid	8.151320369	10.94109	ms	34.22%	↓
100th percentile latency	desc sort geonameid	8.151884671	11.59849	ms	42.28%	↓
50th percentile service time	desc sort geonameid	6.315623499	8.918749	ms	41.22%	↓
90th percentile service time	desc sort geonameid	7.020852001	9.418478	ms	34.15%	↓
99th percentile service time	desc sort geonameid	7.37524512	10.25718	ms	39.08%	↓
100th percentile service time	desc sort geonameid	7.413569998	10.37111	ms	39.89%	↓
error rate	desc sort geonameid	0	0	%	0.00%	-
Min Throughput	desc sort with after geonameid	6.003177611	5.99638	ops/s	-0.11%	↓
Mean Throughput	desc sort with after geonameid	6.00396136	6.002417	ops/s	-0.03%	↓
Median Throughput	desc sort with after geonameid	6.00388339	6.003709	ops/s	0.00%	↓
Max Throughput	desc sort with after geonameid	6.004761084	6.004648	ops/s	0.00%	↓
50th percentile latency	desc sort with after geonameid	131.939619	133.6885	ms	1.33%	↓
90th percentile latency	desc sort with after geonameid	140.3349329	196.8562	ms	40.28%	↓
99th percentile latency	desc sort with after geonameid	161.9925833	223.5809	ms	38.02%	↓
100th percentile latency	desc sort with after geonameid	162.6142667	235.0994	ms	44.57%	↓
50th percentile service time	desc sort with after geonameid	131.317313	132.1153	ms	0.61%	↓
90th percentile service time	desc sort with after geonameid	139.3236399	182.3075	ms	30.85%	↓
99th percentile service time	desc sort with after geonameid	161.0827598	221.3312	ms	37.40%	↓
100th percentile service time	desc sort with after geonameid	161.609713	223.0432	ms	38.01%	↓
error rate	desc sort with after geonameid	0	0	%	0.00%	-
Min Throughput	asc sort geonameid	6.018774005	6.018513	ops/s	0.00%	↓
Mean Throughput	asc sort geonameid	6.022429403	6.022177	ops/s	0.00%	↓
Median Throughput	asc sort geonameid	6.022154576	6.021871	ops/s	0.00%	↓
Max Throughput	asc sort geonameid	6.02708058	6.026625	ops/s	-0.01%	↓
50th percentile latency	asc sort geonameid	6.807151833	6.927938	ms	1.77%	↓
90th percentile latency	asc sort geonameid	7.846566468	7.68625	ms	-2.04%	↑
99th percentile latency	asc sort geonameid	8.269331409	8.046332	ms	-2.70%	↑
100th percentile latency	asc sort geonameid	8.343753998	8.130618	ms	-2.55%	↑
50th percentile service time	asc sort geonameid	6.184293001	6.308078	ms	2.00%	↓
90th percentile service time	asc sort geonameid	6.783063298	6.674597	ms	-1.60%	↑
99th percentile service time	asc sort geonameid	7.150762739	6.925733	ms	-3.15%	↑
100th percentile service time	asc sort geonameid	7.174001999	7.038535	ms	-1.89%	↑
error rate	asc sort geonameid	0	0	%	0.00%	-
Min Throughput	asc sort with after geonameid	6.003464924	5.995859	ops/s	-0.13%	↓
Mean Throughput	asc sort with after geonameid	6.004114865	6.003737	ops/s	-0.01%	↓
Median Throughput	asc sort with after geonameid	6.0040772	6.005255	ops/s	0.02%	↑
Max Throughput	asc sort with after geonameid	6.004979154	6.006858	ops/s	0.03%	↑
50th percentile latency	asc sort with after geonameid	120.3172938	125.2784	ms	4.12%	↓
90th percentile latency	asc sort with after geonameid	131.1391799	203.1638	ms	54.92%	↓
99th percentile latency	asc sort with after geonameid	136.7688437	233.5883	ms	70.79%	↓
100th percentile latency	asc sort with after geonameid	146.229647	233.875	ms	59.94%	↓
50th percentile service time	asc sort with after geonameid	119.5264715	122.8607	ms	2.79%	↓
90th percentile service time	asc sort with after geonameid	130.6161793	192.424	ms	47.32%	↓
99th percentile service time	asc sort with after geonameid	135.6317479	218.462	ms	61.07%	↓
100th percentile service time	asc sort with after geonameid	145.28255	225.7119	ms	55.36%	↓
error rate	asc sort with after geonameid	0	0	%	0.00%	-