# Elasticsearch性能测试 使用ESRally工具对CSS服务的Elasticsearch集群进行基准测试。 #### 压测配置 表1压测配置说明 | 项目 | 说明 | |:---|:---| | 集群配置 | - 集群版本：7.10.2 - 镜像版本：7.10.2_25.9.0_1211 - 数据节点： - CPU架构：X86计算 - 节点规格：ess.spec-4u16g - 节点存储类型：超高I/O - 节点存储容量：100GB - 节点数量：3 - 其他类型的节点：不涉及 | | ESRally配置 | - 工具版本：esrally 2.11.1 - track：geonames - 自定义参数：number_of_shards:6,number_of_replicas:0,max_num_segments:1 | | 数据集 | 使用官方提供的geonames数据集。 - 数据集中的文档总数：11396503 - 数据集大小（forcemerge后）：2.75GB | | bulk_size | 每次批量操作提交5000个文档。 | | bulk_indexing_clients | 同时执行批量索引操作的客户端数量为8个。 | #### 基准压测报告 下表中的性能指标说明请参见官方文档。 表2基准压测报告（Elasticsearch 7.10.2） | Metric | Task | Value | Unit | |:---|:---|:---|:---| | Cumulative indexing time of primary shards | - | 12.31042222 | min | | Min cumulative indexing time across primary shards | - | 0.000016667 | min | | Median cumulative indexing time across primary shards | - | 1.96905 | min | | Max cumulative indexing time across primary shards | - | 2.314361111 | min | | Cumulative indexing throttle time of primary shards | - | 0 | min | | Min cumulative indexing throttle time across primary shards | - | 0 | min | | Median cumulative indexing throttle time across primary shards | - | 0 | min | | Max cumulative indexing throttle time across primary shards | - | 0 | min | | Cumulative merge time of primary shards | - | 4.049222222 | min | | Cumulative merge count of primary shards | - | 17 | - | | Min cumulative merge time across primary shards | - | 0 | min | | Median cumulative merge time across primary shards | - | 0.673238889 | min | | Max cumulative merge time across primary shards | - | 0.704661111 | min | | Cumulative merge throttle time of primary shards | - | 0.01495 | min | | Min cumulative merge throttle time across primary shards | - | 0 | min | | Median cumulative merge throttle time across primary shards | - | 0 | min | | Max cumulative merge throttle time across primary shards | - | 0.005827778 | min | | Cumulative refresh time of primary shards | - | 1.880555556 | min | | Cumulative refresh count of primary shards | - | 101.3333333 | - | | Min cumulative refresh time across primary shards | - | 0.000133333 | min | | Median cumulative refresh time across primary shards | - | 0.281944444 | min | | Max cumulative refresh time across primary shards | - | 0.363255556 | min | | Cumulative flush time of primary shards | - | 0.6524 | min | | Cumulative flush count of primary shards | - | 13 | - | | Min cumulative flush time across primary shards | - | 0.0003 | min | | Median cumulative flush time across primary shards | - | 0.061066667 | min | | Max cumulative flush time across primary shards | - | 0.178994444 | min | | Total Young Gen GC time | - | 3.578 | s | | Total Young Gen GC count | - | 282.3333333 | - | | Total Old Gen GC time | - | 0 | s | | Total Old Gen GC count | - | 0 | - | | Store size | - | 2.751080632 | GB | | Translog size | - | 0.00000041 | GB | | Heap used for segments | - | 0.045238495 | MB | | Heap used for doc values | - | 0.000507355 | MB | | Heap used for terms | - | 0.036102295 | MB | | Heap used for norms | - | 0.004821777 | MB | | Heap used for points | - | 0 | MB | | Heap used for stored fields | - | 0.003807068 | MB | | Segment count | - | 7 | - | | Total Ingest Pipeline count | - | 0 | - | | Total Ingest Pipeline time | - | 0 | s | | Total Ingest Pipeline failed | - | 0 | - | | Min Throughput | index-append | 126760.8967 | docs/s | | Mean Throughput | index-append | 130096.49 | docs/s | | Median Throughput | index-append | 130139.5267 | docs/s | | Max Throughput | index-append | 133081.9433 | docs/s | | 50th percentile latency | index-append | 187.3826678 | ms | | 90th percentile latency | index-append | 243.9505544 | ms | | 99th percentile latency | index-append | 618.8086778 | ms | | 100th percentile latency | index-append | 2014.837716 | ms | | 50th percentile service time | index-append | 187.3826678 | ms | | 90th percentile service time | index-append | 243.9505544 | ms | | 99th percentile service time | index-append | 618.8086778 | ms | | 100th percentile service time | index-append | 2014.837716 | ms | | error rate | index-append | 0 | % | | Min Throughput | index-stats | 90.03333333 | ops/s | | Mean Throughput | index-stats | 90.05333333 | ops/s | | Median Throughput | index-stats | 90.04333333 | ops/s | | Max Throughput | index-stats | 90.08666667 | ops/s | | 50th percentile latency | index-stats | 3.100986873 | ms | | 90th percentile latency | index-stats | 4.148539843 | ms | | 99th percentile latency | index-stats | 4.575353858 | ms | | 99.9th percentile latency | index-stats | 4.865101046 | ms | | 100th percentile latency | index-stats | 5.291679776 | ms | | 50th percentile service time | index-stats | 2.0514815 | ms | | 90th percentile service time | index-stats | 2.343616667 | ms | | 99th percentile service time | index-stats | 2.6258886 | ms | | 99.9th percentile service time | index-stats | 3.233192693 | ms | | 100th percentile service time | index-stats | 3.489291999 | ms | | error rate | index-stats | 0 | % | | Min Throughput | node-stats | 234.7766667 | ops/s | | Mean Throughput | node-stats | 245.2566667 | ops/s | | Median Throughput | node-stats | 246.2733333 | ops/s | | Max Throughput | node-stats | 253.6933333 | ops/s | | 50th percentile latency | node-stats | 2.749793665 | ms | | 90th percentile latency | node-stats | 3.227543565 | ms | | 99th percentile latency | node-stats | 4.153439789 | ms | | 99.9th percentile latency | node-stats | 6.072787497 | ms | | 100th percentile latency | node-stats | 7.508847336 | ms | | 50th percentile service time | node-stats | 2.749793665 | ms | | 90th percentile service time | node-stats | 3.227543565 | ms | | 99th percentile service time | node-stats | 4.153439789 | ms | | 99.9th percentile service time | node-stats | 6.072787497 | ms | | 100th percentile service time | node-stats | 7.508847336 | ms | | error rate | node-stats | 0 | % | | Min Throughput | default | 49.9 | ops/s | | Mean Throughput | default | 49.96 | ops/s | | Median Throughput | default | 49.96333333 | ops/s | | Max Throughput | default | 50.00666667 | ops/s | | 50th percentile latency | default | 5.19255 | ms | | 90th percentile latency | default | 5.959379567 | ms | | 99th percentile latency | default | 6.712874007 | ms | | 99.9th percentile latency | default | 14.28694382 | ms | | 100th percentile latency | default | 29.72031567 | ms | | 50th percentile service time | default | 4.047244499 | ms | | 90th percentile service time | default | 4.577604268 | ms | | 99th percentile service time | default | 5.004963147 | ms | | 99.9th percentile service time | default | 6.016352069 | ms | | 100th percentile service time | default | 7.591514 | ms | | error rate | default | 0 | % | | Min Throughput | term | 99.97 | ops/s | | Mean Throughput | term | 100.0033333 | ops/s | | Median Throughput | term | 100.0033333 | ops/s | | Max Throughput | term | 100.0366667 | ops/s | | 50th percentile latency | term | 4.553375664 | ms | | 90th percentile latency | term | 5.199086801 | ms | | 99th percentile latency | term | 5.954032631 | ms | | 99.9th percentile latency | term | 9.005212437 | ms | | 100th percentile latency | term | 10.973681 | ms | | 50th percentile service time | term | 3.493170498 | ms | | 90th percentile service time | term | 4.066317335 | ms | | 99th percentile service time | term | 4.540046248 | ms | | 99.9th percentile service time | term | 6.972413262 | ms | | 100th percentile service time | term | 9.473506331 | ms | | error rate | term | 0 | % | | Min Throughput | phrase | 109.7966667 | ops/s | | Mean Throughput | phrase | 109.8933333 | ops/s | | Median Throughput | phrase | 109.9066667 | ops/s | | Max Throughput | phrase | 109.9533333 | ops/s | | 50th percentile latency | phrase | 3.785079817 | ms | | 90th percentile latency | phrase | 4.362262003 | ms | | 99th percentile latency | phrase | 5.009087362 | ms | | 99.9th percentile latency | phrase | 9.091072139 | ms | | 100th percentile latency | phrase | 12.77982515 | ms | | 50th percentile service time | phrase | 2.773058833 | ms | | 90th percentile service time | phrase | 3.169956803 | ms | | 99th percentile service time | phrase | 3.67130051 | ms | | 99.9th percentile service time | phrase | 6.67277636 | ms | | 100th percentile service time | phrase | 11.991483 | ms | | error rate | phrase | 0 | % | | Min Throughput | country_agg_uncached | 2.996666667 | ops/s | | Mean Throughput | country_agg_uncached | 2.996666667 | ops/s | | Median Throughput | country_agg_uncached | 2.996666667 | ops/s | | Max Throughput | country_agg_uncached | 3 | ops/s | | 50th percentile latency | country_agg_uncached | 194.294368 | ms | | 90th percentile latency | country_agg_uncached | 206.217168 | ms | | 99th percentile latency | country_agg_uncached | 234.837679 | ms | | 100th percentile latency | country_agg_uncached | 262.9905401 | ms | | 50th percentile service time | country_agg_uncached | 192.8686407 | ms | | 90th percentile service time | country_agg_uncached | 204.1252074 | ms | | 99th percentile service time | country_agg_uncached | 233.4852451 | ms | | 100th percentile service time | country_agg_uncached | 261.6650133 | ms | | error rate | country_agg_uncached | 0 | % | | Min Throughput | country_agg_cached | 98.38333333 | ops/s | | Mean Throughput | country_agg_cached | 98.80666667 | ops/s | | Median Throughput | country_agg_cached | 98.85 | ops/s | | Max Throughput | country_agg_cached | 99.11333333 | ops/s | | 50th percentile latency | country_agg_cached | 3.243380167 | ms | | 90th percentile latency | country_agg_cached | 3.749686196 | ms | | 99th percentile latency | country_agg_cached | 4.253172651 | ms | | 99.9th percentile latency | country_agg_cached | 5.705571015 | ms | | 100th percentile latency | country_agg_cached | 7.010277668 | ms | | 50th percentile service time | country_agg_cached | 2.186430832 | ms | | 90th percentile service time | country_agg_cached | 2.488967734 | ms | | 99th percentile service time | country_agg_cached | 2.888552542 | ms | | 99.9th percentile service time | country_agg_cached | 4.248056678 | ms | | 100th percentile service time | country_agg_cached | 5.173143 | ms | | error rate | country_agg_cached | 0 | % | | Min Throughput | scroll | 20.04666667 | pages/s | | Mean Throughput | scroll | 20.05333333 | pages/s | | Median Throughput | scroll | 20.05333333 | pages/s | | Max Throughput | scroll | 20.06333333 | pages/s | | 50th percentile latency | scroll | 359.0003272 | ms | | 90th percentile latency | scroll | 370.2860177 | ms | | 99th percentile latency | scroll | 385.4784393 | ms | | 100th percentile latency | scroll | 390.5158533 | ms | | 50th percentile service time | scroll | 356.787065 | ms | | 90th percentile service time | scroll | 367.7776303 | ms | | 99th percentile service time | scroll | 382.8828378 | ms | | 100th percentile service time | scroll | 388.439586 | ms | | error rate | scroll | 0 | % | | Min Throughput | expression | 1.5 | ops/s | | Mean Throughput | expression | 1.5 | ops/s | | Median Throughput | expression | 1.5 | ops/s | | Max Throughput | expression | 1.5 | ops/s | | 50th percentile latency | expression | 375.8937726 | ms | | 90th percentile latency | expression | 405.6159797 | ms | | 99th percentile latency | expression | 420.5669943 | ms | | 100th percentile latency | expression | 427.1508171 | ms | | 50th percentile service time | expression | 374.395163 | ms | | 90th percentile service time | expression | 404.1657729 | ms | | 99th percentile service time | expression | 419.11997 | ms | | 100th percentile service time | expression | 425.4059783 | ms | | error rate | expression | 0 | % | | Min Throughput | painless_static | 1.1 | ops/s | | Mean Throughput | painless_static | 1.1 | ops/s | | Median Throughput | painless_static | 1.1 | ops/s | | Max Throughput | painless_static | 1.1 | ops/s | | 50th percentile latency | painless_static | 424.3545877 | ms | | 90th percentile latency | painless_static | 457.348646 | ms | | 99th percentile latency | painless_static | 486.2774302 | ms | | 100th percentile latency | painless_static | 498.6695846 | ms | | 50th percentile service time | painless_static | 422.9974162 | ms | | 90th percentile service time | painless_static | 455.4353071 | ms | | 99th percentile service time | painless_static | 484.7111407 | ms | | 100th percentile service time | painless_static | 496.6055323 | ms | | error rate | painless_static | 0 | % | | Min Throughput | painless_dynamic | 1.4 | ops/s | | Mean Throughput | painless_dynamic | 1.4 | ops/s | | Median Throughput | painless_dynamic | 1.4 | ops/s | | Max Throughput | painless_dynamic | 1.4 | ops/s | | 50th percentile latency | painless_dynamic | 430.8580456 | ms | | 90th percentile latency | painless_dynamic | 449.6414627 | ms | | 99th percentile latency | painless_dynamic | 471.2971106 | ms | | 100th percentile latency | painless_dynamic | 483.8500424 | ms | | 50th percentile service time | painless_dynamic | 429.2400345 | ms | | 90th percentile service time | painless_dynamic | 447.9020767 | ms | | 99th percentile service time | painless_dynamic | 469.7201718 | ms | | 100th percentile service time | painless_dynamic | 482.5095697 | ms | | error rate | painless_dynamic | 0 | % | | Min Throughput | decay_geo_gauss_function_score | 1 | ops/s | | Mean Throughput | decay_geo_gauss_function_score | 1 | ops/s | | Median Throughput | decay_geo_gauss_function_score | 1 | ops/s | | Max Throughput | decay_geo_gauss_function_score | 1 | ops/s | | 50th percentile latency | decay_geo_gauss_function_score | 379.4606487 | ms | | 90th percentile latency | decay_geo_gauss_function_score | 394.6172123 | ms | | 99th percentile latency | decay_geo_gauss_function_score | 410.5565794 | ms | | 100th percentile latency | decay_geo_gauss_function_score | 412.840945 | ms | | 50th percentile service time | decay_geo_gauss_function_score | 377.640898 | ms | | 90th percentile service time | decay_geo_gauss_function_score | 392.8345389 | ms | | 99th percentile service time | decay_geo_gauss_function_score | 409.2532537 | ms | | 100th percentile service time | decay_geo_gauss_function_score | 411.0499427 | ms | | error rate | decay_geo_gauss_function_score | 0 | % | | Min Throughput | decay_geo_gauss_script_score | 1 | ops/s | | Mean Throughput | decay_geo_gauss_script_score | 1 | ops/s | | Median Throughput | decay_geo_gauss_script_score | 1 | ops/s | | Max Throughput | decay_geo_gauss_script_score | 1 | ops/s | | 50th percentile latency | decay_geo_gauss_script_score | 376.504393 | ms | | 90th percentile latency | decay_geo_gauss_script_score | 407.0843836 | ms | | 99th percentile latency | decay_geo_gauss_script_score | 423.7632021 | ms | | 100th percentile latency | decay_geo_gauss_script_score | 427.37156 | ms | | 50th percentile service time | decay_geo_gauss_script_score | 374.8681098 | ms | | 90th percentile service time | decay_geo_gauss_script_score | 405.4612817 | ms | | 99th percentile service time | decay_geo_gauss_script_score | 421.9504708 | ms | | 100th percentile service time | decay_geo_gauss_script_score | 425.505508 | ms | | error rate | decay_geo_gauss_script_score | 0 | % | | Min Throughput | field_value_function_score | 1.5 | ops/s | | Mean Throughput | field_value_function_score | 1.5 | ops/s | | Median Throughput | field_value_function_score | 1.5 | ops/s | | Max Throughput | field_value_function_score | 1.51 | ops/s | | 50th percentile latency | field_value_function_score | 140.6765242 | ms | | 90th percentile latency | field_value_function_score | 152.2805769 | ms | | 99th percentile latency | field_value_function_score | 156.2631877 | ms | | 100th percentile latency | field_value_function_score | 160.6401028 | ms | | 50th percentile service time | field_value_function_score | 138.9778815 | ms | | 90th percentile service time | field_value_function_score | 150.4736819 | ms | | 99th percentile service time | field_value_function_score | 154.6686209 | ms | | 100th percentile service time | field_value_function_score | 159.3371253 | ms | | error rate | field_value_function_score | 0 | % | | Min Throughput | field_value_script_score | 1.5 | ops/s | | Mean Throughput | field_value_script_score | 1.5 | ops/s | | Median Throughput | field_value_script_score | 1.5 | ops/s | | Max Throughput | field_value_script_score | 1.506666667 | ops/s | | 50th percentile latency | field_value_script_score | 189.9546912 | ms | | 90th percentile latency | field_value_script_score | 202.6722559 | ms | | 99th percentile latency | field_value_script_score | 224.9620045 | ms | | 100th percentile latency | field_value_script_score | 233.3698371 | ms | | 50th percentile service time | field_value_script_score | 188.0719465 | ms | | 90th percentile service time | field_value_script_score | 201.0620121 | ms | | 99th percentile service time | field_value_script_score | 222.9692869 | ms | | 100th percentile service time | field_value_script_score | 231.9895913 | ms | | error rate | field_value_script_score | 0 | % | | Min Throughput | large_terms | 1.1 | ops/s | | Mean Throughput | large_terms | 1.1 | ops/s | | Median Throughput | large_terms | 1.1 | ops/s | | Max Throughput | large_terms | 1.1 | ops/s | | 50th percentile latency | large_terms | 350.4594768 | ms | | 90th percentile latency | large_terms | 377.0829389 | ms | | 99th percentile latency | large_terms | 409.3069686 | ms | | 100th percentile latency | large_terms | 442.5652459 | ms | | 50th percentile service time | large_terms | 339.7396153 | ms | | 90th percentile service time | large_terms | 366.434742 | ms | | 99th percentile service time | large_terms | 399.2487295 | ms | | 100th percentile service time | large_terms | 431.9105927 | ms | | error rate | large_terms | 0 | % | | Min Throughput | large_filtered_terms | 1.1 | ops/s | | Mean Throughput | large_filtered_terms | 1.1 | ops/s | | Median Throughput | large_filtered_terms | 1.1 | ops/s | | Max Throughput | large_filtered_terms | 1.1 | ops/s | | 50th percentile latency | large_filtered_terms | 350.1823309 | ms | | 90th percentile latency | large_filtered_terms | 375.9554269 | ms | | 99th percentile latency | large_filtered_terms | 434.9195663 | ms | | 100th percentile latency | large_filtered_terms | 449.3505292 | ms | | 50th percentile service time | large_filtered_terms | 339.6236282 | ms | | 90th percentile service time | large_filtered_terms | 365.844992 | ms | | 99th percentile service time | large_filtered_terms | 422.6582859 | ms | | 100th percentile service time | large_filtered_terms | 439.250248 | ms | | error rate | large_filtered_terms | 0 | % | | Min Throughput | large_prohibited_terms | 1.1 | ops/s | | Mean Throughput | large_prohibited_terms | 1.1 | ops/s | | Median Throughput | large_prohibited_terms | 1.1 | ops/s | | Max Throughput | large_prohibited_terms | 1.1 | ops/s | | 50th percentile latency | large_prohibited_terms | 344.1306525 | ms | | 90th percentile latency | large_prohibited_terms | 368.6548167 | ms | | 99th percentile latency | large_prohibited_terms | 414.7196019 | ms | | 100th percentile latency | large_prohibited_terms | 425.8111396 | ms | | 50th percentile service time | large_prohibited_terms | 334.7599193 | ms | | 90th percentile service time | large_prohibited_terms | 359.2125969 | ms | | 99th percentile service time | large_prohibited_terms | 404.5206609 | ms | | 100th percentile service time | large_prohibited_terms | 416.5932693 | ms | | error rate | large_prohibited_terms | 0 | % | | Min Throughput | desc_sort_population | 1.5 | ops/s | | Mean Throughput | desc_sort_population | 1.506666667 | ops/s | | Median Throughput | desc_sort_population | 1.506666667 | ops/s | | Max Throughput | desc_sort_population | 1.51 | ops/s | | 50th percentile latency | desc_sort_population | 71.66287106 | ms | | 90th percentile latency | desc_sort_population | 81.395746 | ms | | 99th percentile latency | desc_sort_population | 84.8646292 | ms | | 100th percentile latency | desc_sort_population | 86.42266711 | ms | | 50th percentile service time | desc_sort_population | 70.03674417 | ms | | 90th percentile service time | desc_sort_population | 79.82605967 | ms | | 99th percentile service time | desc_sort_population | 82.95071923 | ms | | 100th percentile service time | desc_sort_population | 84.77815033 | ms | | error rate | desc_sort_population | 0 | % | | Min Throughput | desc_sort_population_can_match_shortcut | 1.5 | ops/s | | Mean Throughput | desc_sort_population_can_match_shortcut | 1.51 | ops/s | | Median Throughput | desc_sort_population_can_match_shortcut | 1.51 | ops/s | | Max Throughput | desc_sort_population_can_match_shortcut | 1.51 | ops/s | | 50th percentile latency | desc_sort_population_can_match_shortcut | 32.38385772 | ms | | 90th percentile latency | desc_sort_population_can_match_shortcut | 36.9526356 | ms | | 99th percentile latency | desc_sort_population_can_match_shortcut | 39.08307921 | ms | | 100th percentile latency | desc_sort_population_can_match_shortcut | 39.69251011 | ms | | 50th percentile service time | desc_sort_population_can_match_shortcut | 30.4762275 | ms | | 90th percentile service time | desc_sort_population_can_match_shortcut | 35.22205756 | ms | | 99th percentile service time | desc_sort_population_can_match_shortcut | 37.13762387 | ms | | 100th percentile service time | desc_sort_population_can_match_shortcut | 37.66458767 | ms | | error rate | desc_sort_population_can_match_shortcut | 0 | % | | Min Throughput | desc_sort_population_no_can_match_shortcut | 1.5 | ops/s | | Mean Throughput | desc_sort_population_no_can_match_shortcut | 1.51 | ops/s | | Median Throughput | desc_sort_population_no_can_match_shortcut | 1.51 | ops/s | | Max Throughput | desc_sort_population_no_can_match_shortcut | 1.51 | ops/s | | 50th percentile latency | desc_sort_population_no_can_match_shortcut | 31.59214889 | ms | | 90th percentile latency | desc_sort_population_no_can_match_shortcut | 36.37145882 | ms | | 99th percentile latency | desc_sort_population_no_can_match_shortcut | 37.7443767 | ms | | 100th percentile latency | desc_sort_population_no_can_match_shortcut | 38.33259422 | ms | | 50th percentile service time | desc_sort_population_no_can_match_shortcut | 29.71695234 | ms | | 90th percentile service time | desc_sort_population_no_can_match_shortcut | 34.68235983 | ms | | 99th percentile service time | desc_sort_population_no_can_match_shortcut | 35.84155154 | ms | | 100th percentile service time | desc_sort_population_no_can_match_shortcut | 36.45791267 | ms | | error rate | desc_sort_population_no_can_match_shortcut | 0 | % | | Min Throughput | asc_sort_population | 1.5 | ops/s | | Mean Throughput | asc_sort_population | 1.51 | ops/s | | Median Throughput | asc_sort_population | 1.51 | ops/s | | Max Throughput | asc_sort_population | 1.51 | ops/s | | 50th percentile latency | asc_sort_population | 73.83230722 | ms | | 90th percentile latency | asc_sort_population | 84.61493712 | ms | | 99th percentile latency | asc_sort_population | 91.17825009 | ms | | 100th percentile latency | asc_sort_population | 101.009751 | ms | | 50th percentile service time | asc_sort_population | 71.92867383 | ms | | 90th percentile service time | asc_sort_population | 83.12438266 | ms | | 99th percentile service time | asc_sort_population | 87.9405254 | ms | | 100th percentile service time | asc_sort_population | 96.66358666 | ms | | error rate | asc_sort_population | 0 | % | | Min Throughput | asc_sort_with_after_population | 1.5 | ops/s | | Mean Throughput | asc_sort_with_after_population | 1.503333333 | ops/s | | Median Throughput | asc_sort_with_after_population | 1.503333333 | ops/s | | Max Throughput | asc_sort_with_after_population | 1.506666667 | ops/s | | 50th percentile latency | asc_sort_with_after_population | 93.95375872 | ms | | 90th percentile latency | asc_sort_with_after_population | 109.0064055 | ms | | 99th percentile latency | asc_sort_with_after_population | 114.0758574 | ms | | 100th percentile latency | asc_sort_with_after_population | 114.6008134 | ms | | 50th percentile service time | asc_sort_with_after_population | 91.82346034 | ms | | 90th percentile service time | asc_sort_with_after_population | 106.7002043 | ms | | 99th percentile service time | asc_sort_with_after_population | 111.9943091 | ms | | 100th percentile service time | asc_sort_with_after_population | 112.365203 | ms | | error rate | asc_sort_with_after_population | 0 | % | | Min Throughput | desc_sort_geonameid | 6.016666667 | ops/s | | Mean Throughput | desc_sort_geonameid | 6.016666667 | ops/s | | Median Throughput | desc_sort_geonameid | 6.016666667 | ops/s | | Max Throughput | desc_sort_geonameid | 6.023333333 | ops/s | | 50th percentile latency | desc_sort_geonameid | 10.46998039 | ms | | 90th percentile latency | desc_sort_geonameid | 11.51738944 | ms | | 99th percentile latency | desc_sort_geonameid | 12.9053071 | ms | | 100th percentile latency | desc_sort_geonameid | 18.18306133 | ms | | 50th percentile service time | desc_sort_geonameid | 9.182756834 | ms | | 90th percentile service time | desc_sort_geonameid | 10.15802633 | ms | | 99th percentile service time | desc_sort_geonameid | 11.35822414 | ms | | 100th percentile service time | desc_sort_geonameid | 16.693381 | ms | | error rate | desc_sort_geonameid | 0 | % | | Min Throughput | desc_sort_with_after_geonameid | 6.006666667 | ops/s | | Mean Throughput | desc_sort_with_after_geonameid | 6.006666667 | ops/s | | Median Throughput | desc_sort_with_after_geonameid | 6.006666667 | ops/s | | Max Throughput | desc_sort_with_after_geonameid | 6.006666667 | ops/s | | 50th percentile latency | desc_sort_with_after_geonameid | 82.01750772 | ms | | 90th percentile latency | desc_sort_with_after_geonameid | 91.85847737 | ms | | 99th percentile latency | desc_sort_with_after_geonameid | 99.89321558 | ms | | 100th percentile latency | desc_sort_with_after_geonameid | 102.3148577 | ms | | 50th percentile service time | desc_sort_with_after_geonameid | 80.6696315 | ms | | 90th percentile service time | desc_sort_with_after_geonameid | 90.46680664 | ms | | 99th percentile service time | desc_sort_with_after_geonameid | 98.72122986 | ms | | 100th percentile service time | desc_sort_with_after_geonameid | 101.0189073 | ms | | error rate | desc_sort_with_after_geonameid | 0 | % | | Min Throughput | asc_sort_geonameid | 6.02 | ops/s | | Mean Throughput | asc_sort_geonameid | 6.02 | ops/s | | Median Throughput | asc_sort_geonameid | 6.02 | ops/s | | Max Throughput | asc_sort_geonameid | 6.03 | ops/s | | 50th percentile latency | asc_sort_geonameid | 8.686778888 | ms | | 90th percentile latency | asc_sort_geonameid | 9.453473945 | ms | | 99th percentile latency | asc_sort_geonameid | 10.04335858 | ms | | 100th percentile latency | asc_sort_geonameid | 10.418373 | ms | | 50th percentile service time | asc_sort_geonameid | 7.331896501 | ms | | 90th percentile service time | asc_sort_geonameid | 7.931728934 | ms | | 99th percentile service time | asc_sort_geonameid | 8.647927066 | ms | | 100th percentile service time | asc_sort_geonameid | 9.124289001 | ms | | error rate | asc_sort_geonameid | 0 | % | | Min Throughput | asc_sort_with_after_geonameid | 6.01 | ops/s | | Mean Throughput | asc_sort_with_after_geonameid | 6.013333333 | ops/s | | Median Throughput | asc_sort_with_after_geonameid | 6.013333333 | ops/s | | Max Throughput | asc_sort_with_after_geonameid | 6.02 | ops/s | | 50th percentile latency | asc_sort_with_after_geonameid | 76.41251783 | ms | | 90th percentile latency | asc_sort_with_after_geonameid | 83.72178781 | ms | | 99th percentile latency | asc_sort_with_after_geonameid | 93.21201088 | ms | | 100th percentile latency | asc_sort_with_after_geonameid | 94.46623 | ms | | 50th percentile service time | asc_sort_with_after_geonameid | 75.04055567 | ms | | 90th percentile service time | asc_sort_with_after_geonameid | 82.3863604 | ms | | 99th percentile service time | asc_sort_with_after_geonameid | 91.94089643 | ms | | 100th percentile service time | asc_sort_with_after_geonameid | 93.11979833 | ms | | error rate | asc_sort_with_after_geonameid | 0 | % | | Min Throughput | sort_country_code_can_match_shortcut | 1.5 | ops/s | | Mean Throughput | sort_country_code_can_match_shortcut | 1.506666667 | ops/s | | Median Throughput | sort_country_code_can_match_shortcut | 1.506666667 | ops/s | | Max Throughput | sort_country_code_can_match_shortcut | 1.51 | ops/s | | 50th percentile latency | sort_country_code_can_match_shortcut | 35.35022839 | ms | | 90th percentile latency | sort_country_code_can_match_shortcut | 40.26248151 | ms | | 99th percentile latency | sort_country_code_can_match_shortcut | 42.36048238 | ms | | 100th percentile latency | sort_country_code_can_match_shortcut | 48.88996667 | ms | | 50th percentile service time | sort_country_code_can_match_shortcut | 33.63301033 | ms | | 90th percentile service time | sort_country_code_can_match_shortcut | 38.5126567 | ms | | 99th percentile service time | sort_country_code_can_match_shortcut | 40.4475762 | ms | | 100th percentile service time | sort_country_code_can_match_shortcut | 40.86728967 | ms | | error rate | sort_country_code_can_match_shortcut | 0 | % | | Min Throughput | sort_country_code_no_can_match_shortcut | 1.5 | ops/s | | Mean Throughput | sort_country_code_no_can_match_shortcut | 1.51 | ops/s | | Median Throughput | sort_country_code_no_can_match_shortcut | 1.51 | ops/s | | Max Throughput | sort_country_code_no_can_match_shortcut | 1.51 | ops/s | | 50th percentile latency | sort_country_code_no_can_match_shortcut | 34.99810956 | ms | | 90th percentile latency | sort_country_code_no_can_match_shortcut | 39.54523391 | ms | | 99th percentile latency | sort_country_code_no_can_match_shortcut | 41.40731835 | ms | | 100th percentile latency | sort_country_code_no_can_match_shortcut | 42.38540756 | ms | | 50th percentile service time | sort_country_code_no_can_match_shortcut | 33.01238117 | ms | | 90th percentile service time | sort_country_code_no_can_match_shortcut | 37.85981237 | ms | | 99th percentile service time | sort_country_code_no_can_match_shortcut | 40.01267123 | ms | | 100th percentile service time | sort_country_code_no_can_match_shortcut | 40.652927 | ms | | error rate | sort_country_code_no_can_match_shortcut | 0 | % |