# OpenSearch性能测试 使用ESRally工具对CSS服务的OpenSearch集群进行基准测试。 #### 压测配置 表1压测配置说明 | 项目 | 说明 | |:---|:---| | 集群配置 | - 集群版本：2.19.0 - 镜像版本：2.19.0_25.9.0_1210 - 数据节点： - 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基准压测报告（OpenSearch 2.19.0） | Metric | Task | Value | Unit | |:---|:---|:---|:---| | Cumulative indexing time of primary shards | - | 13.49772778 | min | | Min cumulative indexing time across primary shards | - | 0 | min | | Median cumulative indexing time across primary shards | - | 1.779208333 | min | | Max cumulative indexing time across primary shards | - | 2.046516667 | 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 | - | 3.213422222 | min | | Cumulative merge count of primary shards | - | 22 | - | | Min cumulative merge time across primary shards | - | 0 | min | | Median cumulative merge time across primary shards | - | 0.432091667 | min | | Max cumulative merge time across primary shards | - | 0.517527778 | min | | Cumulative merge throttle time of primary shards | - | 0.154783333 | 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.13705 | min | | Cumulative refresh time of primary shards | - | 2.364644444 | min | | Cumulative refresh count of primary shards | - | 204.6666667 | - | | Min cumulative refresh time across primary shards | - | 0 | min | | Median cumulative refresh time across primary shards | - | 0.267808333 | min | | Max cumulative refresh time across primary shards | - | 0.407966667 | min | | Cumulative flush time of primary shards | - | 1.212922222 | min | | Cumulative flush count of primary shards | - | 31.33333333 | - | | Min cumulative flush time across primary shards | - | 0 | min | | Median cumulative flush time across primary shards | - | 0.086627778 | min | | Max cumulative flush time across primary shards | - | 0.307111111 | min | | Total Young Gen GC time | - | 2.994666667 | s | | Total Young Gen GC count | - | 222.3333333 | - | | Total Old Gen GC time | - | 0 | s | | Total Old Gen GC count | - | 0 | - | | Store size | - | 4.244530447 | GB | | Translog size | - | 0.578840129 | GB | | Heap used for segments | - | 0 | MB | | Heap used for doc values | - | 0 | MB | | Heap used for terms | - | 0 | MB | | Heap used for norms | - | 0 | MB | | Heap used for points | - | 0 | MB | | Heap used for stored fields | - | 0 | MB | | Segment count | - | 27.66666667 | - | | Total Ingest Pipeline count | - | 0 | - | | Total Ingest Pipeline time | - | 0 | s | | Total Ingest Pipeline failed | - | 0 | - | | Min Throughput | index-append | 145432.8633 | docs/s | | Mean Throughput | index-append | 146135.0533 | docs/s | | Median Throughput | index-append | 145971.4033 | docs/s | | Max Throughput | index-append | 147108.4633 | docs/s | | 50th percentile latency | index-append | 154.0281727 | ms | | 90th percentile latency | index-append | 246.3528123 | ms | | 99th percentile latency | index-append | 266.303119 | ms | | 100th percentile latency | index-append | 496.907832 | ms | | 50th percentile service time | index-append | 154.0281727 | ms | | 90th percentile service time | index-append | 217.0974408 | ms | | 99th percentile service time | index-append | 320.1613297 | ms | | 100th percentile service time | index-append | 496.907832 | ms | | error rate | index-append | 0 | % | | Min Throughput | index-stats | 90.02333333 | ops/s | | Mean Throughput | index-stats | 90.03666667 | ops/s | | Median Throughput | index-stats | 90.03666667 | ops/s | | Max Throughput | index-stats | 90.07 | ops/s | | 50th percentile latency | index-stats | 3.330445073 | ms | | 90th percentile latency | index-stats | 3.785025301 | ms | | 99th percentile latency | index-stats | 4.122935611 | ms | | 99.9th percentile latency | index-stats | 6.108052635 | ms | | 100th percentile latency | index-stats | 7.302159404 | ms | | 50th percentile service time | index-stats | 2.558618668 | ms | | 90th percentile service time | index-stats | 2.786850101 | ms | | 99th percentile service time | index-stats | 3.158801109 | ms | | 99.9th percentile service time | index-stats | 5.199402759 | ms | | 100th percentile service time | index-stats | 6.819206666 | ms | | error rate | index-stats | 0 | % | | Min Throughput | node-stats | 183.2766667 | ops/s | | Mean Throughput | node-stats | 197.01 | ops/s | | Median Throughput | node-stats | 199.3266667 | ops/s | | Max Throughput | node-stats | 205.34 | ops/s | | 50th percentile latency | node-stats | 3.428979499 | ms | | 90th percentile latency | node-stats | 3.833978598 | ms | | 99th percentile latency | node-stats | 4.899026879 | ms | | 99.9th percentile latency | node-stats | 6.365344979 | ms | | 100th percentile latency | node-stats | 7.069617331 | ms | | 50th percentile service time | node-stats | 3.428979499 | ms | | 90th percentile service time | node-stats | 3.833978598 | ms | | 99th percentile service time | node-stats | 4.899026879 | ms | | 99.9th percentile service time | node-stats | 6.365344979 | ms | | 100th percentile service time | node-stats | 7.069617331 | ms | | error rate | node-stats | 0 | % | | Min Throughput | default | 50.00333333 | ops/s | | Mean Throughput | default | 50.01333333 | ops/s | | Median Throughput | default | 50.01333333 | ops/s | | Max Throughput | default | 50.02666667 | ops/s | | 50th percentile latency | default | 3.948677835 | ms | | 90th percentile latency | default | 4.546912869 | ms | | 99th percentile latency | default | 5.465409541 | ms | | 99.9th percentile latency | default | 8.357761321 | ms | | 100th percentile latency | default | 24.90284867 | ms | | 50th percentile service time | default | 3.070336833 | ms | | 90th percentile service time | default | 3.3827955 | ms | | 99th percentile service time | default | 3.809038742 | ms | | 99.9th percentile service time | default | 4.978160167 | ms | | 100th percentile service time | default | 5.757550337 | ms | | error rate | default | 0 | % | | Min Throughput | term | 99.83666667 | ops/s | | Mean Throughput | term | 99.89666667 | ops/s | | Median Throughput | term | 99.90666667 | ops/s | | Max Throughput | term | 99.93333333 | ops/s | | 50th percentile latency | term | 3.796740832 | ms | | 90th percentile latency | term | 4.286568201 | ms | | 99th percentile latency | term | 4.844526896 | ms | | 99.9th percentile latency | term | 18.10017896 | ms | | 100th percentile latency | term | 24.753809 | ms | | 50th percentile service time | term | 2.909011668 | ms | | 90th percentile service time | term | 3.196365067 | ms | | 99th percentile service time | term | 3.578036543 | ms | | 99.9th percentile service time | term | 4.539963684 | ms | | 100th percentile service time | term | 5.607244668 | ms | | error rate | term | 0 | % | | Min Throughput | phrase | 109.8533333 | ops/s | | Mean Throughput | phrase | 109.92 | ops/s | | Median Throughput | phrase | 109.93 | ops/s | | Max Throughput | phrase | 109.97 | ops/s | | 50th percentile latency | phrase | 3.579206879 | ms | | 90th percentile latency | phrase | 4.043781699 | ms | | 99th percentile latency | phrase | 4.643590413 | ms | | 99.9th percentile latency | phrase | 6.714905382 | ms | | 100th percentile latency | phrase | 6.901101847 | ms | | 50th percentile service time | phrase | 2.674459334 | ms | | 90th percentile service time | phrase | 2.911044634 | ms | | 99th percentile service time | phrase | 3.508857829 | ms | | 99.9th percentile service time | phrase | 5.944256135 | ms | | 100th percentile service time | phrase | 6.129541 | ms | | error rate | phrase | 0 | % | | Min Throughput | country_agg_uncached | 3 | ops/s | | Mean Throughput | country_agg_uncached | 3 | ops/s | | Median Throughput | country_agg_uncached | 3 | ops/s | | Max Throughput | country_agg_uncached | 3 | ops/s | | 50th percentile latency | country_agg_uncached | 166.0956941 | ms | | 90th percentile latency | country_agg_uncached | 181.9295586 | ms | | 99th percentile latency | country_agg_uncached | 202.4280783 | ms | | 100th percentile latency | country_agg_uncached | 212.536012 | ms | | 50th percentile service time | country_agg_uncached | 164.6899067 | ms | | 90th percentile service time | country_agg_uncached | 180.6473268 | ms | | 99th percentile service time | country_agg_uncached | 201.2444378 | ms | | 100th percentile service time | country_agg_uncached | 211.3636743 | ms | | error rate | country_agg_uncached | 0 | % | | Min Throughput | country_agg_cached | 98.46666667 | ops/s | | Mean Throughput | country_agg_cached | 98.87333333 | ops/s | | Median Throughput | country_agg_cached | 98.91333333 | ops/s | | Max Throughput | country_agg_cached | 99.15666667 | ops/s | | 50th percentile latency | country_agg_cached | 3.198243164 | ms | | 90th percentile latency | country_agg_cached | 3.633324833 | ms | | 99th percentile latency | country_agg_cached | 4.102123842 | ms | | 99.9th percentile latency | country_agg_cached | 7.142918757 | ms | | 100th percentile latency | country_agg_cached | 9.367448333 | ms | | 50th percentile service time | country_agg_cached | 2.289982834 | ms | | 90th percentile service time | country_agg_cached | 2.4758842 | ms | | 99th percentile service time | country_agg_cached | 2.809824274 | ms | | 99.9th percentile service time | country_agg_cached | 6.020744674 | ms | | 100th percentile service time | country_agg_cached | 8.438331331 | ms | | error rate | country_agg_cached | 0 | % | | Min Throughput | scroll | 20.04666667 | pages/s | | Mean Throughput | scroll | 20.05666667 | pages/s | | Median Throughput | scroll | 20.05666667 | pages/s | | Max Throughput | scroll | 20.06666667 | pages/s | | 50th percentile latency | scroll | 307.1768787 | ms | | 90th percentile latency | scroll | 314.0546297 | ms | | 99th percentile latency | scroll | 326.7921287 | ms | | 100th percentile latency | scroll | 339.5051557 | ms | | 50th percentile service time | scroll | 304.5752775 | ms | | 90th percentile service time | scroll | 311.0165824 | ms | | 99th percentile service time | scroll | 324.1737244 | ms | | 100th percentile service time | scroll | 337.4770563 | 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 | 328.7313712 | ms | | 90th percentile latency | expression | 343.7046595 | ms | | 99th percentile latency | expression | 362.7078301 | ms | | 100th percentile latency | expression | 375.2330851 | ms | | 50th percentile service time | expression | 327.1585565 | ms | | 90th percentile service time | expression | 342.0958638 | ms | | 99th percentile service time | expression | 361.2666818 | ms | | 100th percentile service time | expression | 373.6905337 | 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 | 349.2539682 | ms | | 90th percentile latency | painless_static | 367.8082071 | ms | | 99th percentile latency | painless_static | 390.4631335 | ms | | 100th percentile latency | painless_static | 445.2997574 | ms | | 50th percentile service time | painless_static | 347.903836 | ms | | 90th percentile service time | painless_static | 366.418019 | ms | | 99th percentile service time | painless_static | 388.9409541 | ms | | 100th percentile service time | painless_static | 442.8602247 | 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 | 339.9176001 | ms | | 90th percentile latency | painless_dynamic | 356.6682269 | ms | | 99th percentile latency | painless_dynamic | 378.1133763 | ms | | 100th percentile latency | painless_dynamic | 384.430469 | ms | | 50th percentile service time | painless_dynamic | 338.4962593 | ms | | 90th percentile service time | painless_dynamic | 355.1688886 | ms | | 99th percentile service time | painless_dynamic | 376.2751371 | ms | | 100th percentile service time | painless_dynamic | 382.6866807 | 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 | 322.4600802 | ms | | 90th percentile latency | decay_geo_gauss_function_score | 335.5379398 | ms | | 99th percentile latency | decay_geo_gauss_function_score | 349.3771684 | ms | | 100th percentile latency | decay_geo_gauss_function_score | 357.3219623 | ms | | 50th percentile service time | decay_geo_gauss_function_score | 320.4353308 | ms | | 90th percentile service time | decay_geo_gauss_function_score | 333.9074892 | ms | | 99th percentile service time | decay_geo_gauss_function_score | 347.3976356 | ms | | 100th percentile service time | decay_geo_gauss_function_score | 355.465869 | 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 | 331.1781238 | ms | | 90th percentile latency | decay_geo_gauss_script_score | 342.2428335 | ms | | 99th percentile latency | decay_geo_gauss_script_score | 355.6498643 | ms | | 100th percentile latency | decay_geo_gauss_script_score | 361.597086 | ms | | 50th percentile service time | decay_geo_gauss_script_score | 329.4374955 | ms | | 90th percentile service time | decay_geo_gauss_script_score | 340.5747497 | ms | | 99th percentile service time | decay_geo_gauss_script_score | 353.7402016 | ms | | 100th percentile service time | decay_geo_gauss_script_score | 359.823414 | 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.506666667 | ops/s | | 50th percentile latency | field_value_function_score | 114.2087543 | ms | | 90th percentile latency | field_value_function_score | 122.6462985 | ms | | 99th percentile latency | field_value_function_score | 139.7563598 | ms | | 100th percentile latency | field_value_function_score | 144.1202787 | ms | | 50th percentile service time | field_value_function_score | 112.496028 | ms | | 90th percentile service time | field_value_function_score | 121.0230033 | ms | | 99th percentile service time | field_value_function_score | 138.435151 | ms | | 100th percentile service time | field_value_function_score | 142.1894247 | 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 | 157.0228327 | ms | | 90th percentile latency | field_value_script_score | 165.9453082 | ms | | 99th percentile latency | field_value_script_score | 184.5909569 | ms | | 100th percentile latency | field_value_script_score | 194.3044724 | ms | | 50th percentile service time | field_value_script_score | 155.5278968 | ms | | 90th percentile service time | field_value_script_score | 164.3130029 | ms | | 99th percentile service time | field_value_script_score | 183.1545899 | ms | | 100th percentile service time | field_value_script_score | 192.337097 | 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 | 205.7521689 | ms | | 90th percentile latency | large_terms | 245.7037544 | ms | | 99th percentile latency | large_terms | 291.4207451 | ms | | 100th percentile latency | large_terms | 308.2440337 | ms | | 50th percentile service time | large_terms | 195.7842497 | ms | | 90th percentile service time | large_terms | 235.6044365 | ms | | 99th percentile service time | large_terms | 281.7826323 | ms | | 100th percentile service time | large_terms | 298.43813 | 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 | 206.0984478 | ms | | 90th percentile latency | large_filtered_terms | 244.3679208 | ms | | 99th percentile latency | large_filtered_terms | 306.1387914 | ms | | 100th percentile latency | large_filtered_terms | 326.9923481 | ms | | 50th percentile service time | large_filtered_terms | 196.1887743 | ms | | 90th percentile service time | large_filtered_terms | 234.541148 | ms | | 99th percentile service time | large_filtered_terms | 295.7485276 | ms | | 100th percentile service time | large_filtered_terms | 316.7899857 | 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 | 205.5377842 | ms | | 90th percentile latency | large_prohibited_terms | 226.6288856 | ms | | 99th percentile latency | large_prohibited_terms | 273.0833591 | ms | | 100th percentile latency | large_prohibited_terms | 303.6207828 | ms | | 50th percentile service time | large_prohibited_terms | 195.710545 | ms | | 90th percentile service time | large_prohibited_terms | 216.7939406 | ms | | 99th percentile service time | large_prohibited_terms | 263.4008624 | ms | | 100th percentile service time | large_prohibited_terms | 293.934974 | ms | | error rate | large_prohibited_terms | 0 | % | | Min Throughput | desc_sort_population | 1.5 | ops/s | | Mean Throughput | desc_sort_population | 1.51 | ops/s | | Median Throughput | desc_sort_population | 1.51 | ops/s | | Max Throughput | desc_sort_population | 1.51 | ops/s | | 50th percentile latency | desc_sort_population | 7.236514833 | ms | | 90th percentile latency | desc_sort_population | 8.049583914 | ms | | 99th percentile latency | desc_sort_population | 8.907363299 | ms | | 100th percentile latency | desc_sort_population | 9.938346222 | ms | | 50th percentile service time | desc_sort_population | 5.488842497 | ms | | 90th percentile service time | desc_sort_population | 6.116563597 | ms | | 99th percentile service time | desc_sort_population | 7.104587877 | ms | | 100th percentile service time | desc_sort_population | 7.771506002 | 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 | 7.724448003 | ms | | 90th percentile latency | desc_sort_population_can_match_shortcut | 8.474902755 | ms | | 99th percentile latency | desc_sort_population_can_match_shortcut | 9.169254942 | ms | | 100th percentile latency | desc_sort_population_can_match_shortcut | 9.327792446 | ms | | 50th percentile service time | desc_sort_population_can_match_shortcut | 5.976380166 | ms | | 90th percentile service time | desc_sort_population_can_match_shortcut | 6.642148233 | ms | | 99th percentile service time | desc_sort_population_can_match_shortcut | 7.343319151 | ms | | 100th percentile service time | desc_sort_population_can_match_shortcut | 7.384056 | 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 | 7.154217891 | ms | | 90th percentile latency | desc_sort_population_no_can_match_shortcut | 7.674822111 | ms | | 99th percentile latency | desc_sort_population_no_can_match_shortcut | 8.523005287 | ms | | 100th percentile latency | desc_sort_population_no_can_match_shortcut | 15.44498134 | ms | | 50th percentile service time | desc_sort_population_no_can_match_shortcut | 5.368766334 | ms | | 90th percentile service time | desc_sort_population_no_can_match_shortcut | 5.672249334 | ms | | 99th percentile service time | desc_sort_population_no_can_match_shortcut | 6.605149933 | ms | | 100th percentile service time | desc_sort_population_no_can_match_shortcut | 13.57698733 | 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 | 5.386522166 | ms | | 90th percentile latency | asc_sort_population | 5.858688911 | ms | | 99th percentile latency | asc_sort_population | 6.263395399 | ms | | 100th percentile latency | asc_sort_population | 6.520274 | ms | | 50th percentile service time | asc_sort_population | 3.6434065 | ms | | 90th percentile service time | asc_sort_population | 3.884312034 | ms | | 99th percentile service time | asc_sort_population | 4.402650239 | ms | | 100th percentile service time | asc_sort_population | 4.732970664 | 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.51 | ops/s | | Median Throughput | asc_sort_with_after_population | 1.51 | ops/s | | Max Throughput | asc_sort_with_after_population | 1.51 | ops/s | | 50th percentile latency | asc_sort_with_after_population | 5.872991222 | ms | | 90th percentile latency | asc_sort_with_after_population | 6.513266598 | ms | | 99th percentile latency | asc_sort_with_after_population | 7.159494164 | ms | | 100th percentile latency | asc_sort_with_after_population | 7.719157334 | ms | | 50th percentile service time | asc_sort_with_after_population | 4.143721 | ms | | 90th percentile service time | asc_sort_with_after_population | 4.523904798 | ms | | 99th percentile service time | asc_sort_with_after_population | 5.36004264 | ms | | 100th percentile service time | asc_sort_with_after_population | 6.001065003 | ms | | error rate | asc_sort_with_after_population | 0 | % | | Min Throughput | desc_sort_geonameid | 6.02 | ops/s | | Mean Throughput | desc_sort_geonameid | 6.02 | ops/s | | Median Throughput | desc_sort_geonameid | 6.02 | ops/s | | Max Throughput | desc_sort_geonameid | 6.03 | ops/s | | 50th percentile latency | desc_sort_geonameid | 9.164063222 | ms | | 90th percentile latency | desc_sort_geonameid | 9.714385933 | ms | | 99th percentile latency | desc_sort_geonameid | 10.91654102 | ms | | 100th percentile latency | desc_sort_geonameid | 11.33415789 | ms | | 50th percentile service time | desc_sort_geonameid | 7.882162498 | ms | | 90th percentile service time | desc_sort_geonameid | 8.311441534 | ms | | 99th percentile service time | desc_sort_geonameid | 9.600953423 | ms | | 100th percentile service time | desc_sort_geonameid | 10.105961 | ms | | error rate | desc_sort_geonameid | 0 | % | | Min Throughput | desc_sort_with_after_geonameid | 6.016666667 | ops/s | | Mean Throughput | desc_sort_with_after_geonameid | 6.02 | ops/s | | Median Throughput | desc_sort_with_after_geonameid | 6.02 | ops/s | | Max Throughput | desc_sort_with_after_geonameid | 6.026666667 | ops/s | | 50th percentile latency | desc_sort_with_after_geonameid | 16.63857706 | ms | | 90th percentile latency | desc_sort_with_after_geonameid | 18.20860423 | ms | | 99th percentile latency | desc_sort_with_after_geonameid | 21.97696012 | ms | | 100th percentile latency | desc_sort_with_after_geonameid | 23.04049611 | ms | | 50th percentile service time | desc_sort_with_after_geonameid | 15.0262465 | ms | | 90th percentile service time | desc_sort_with_after_geonameid | 16.4586571 | ms | | 99th percentile service time | desc_sort_with_after_geonameid | 20.65385393 | ms | | 100th percentile service time | desc_sort_with_after_geonameid | 21.48934067 | 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 | 6.777215112 | ms | | 90th percentile latency | asc_sort_geonameid | 7.382828146 | ms | | 99th percentile latency | asc_sort_geonameid | 8.005859848 | ms | | 100th percentile latency | asc_sort_geonameid | 8.237174776 | ms | | 50th percentile service time | asc_sort_geonameid | 5.503057834 | ms | | 90th percentile service time | asc_sort_geonameid | 5.976093132 | ms | | 99th percentile service time | asc_sort_geonameid | 6.638824808 | ms | | 100th percentile service time | asc_sort_geonameid | 6.779055664 | ms | | error rate | asc_sort_geonameid | 0 | % | | Min Throughput | asc_sort_with_after_geonameid | 6.02 | ops/s | | Mean Throughput | asc_sort_with_after_geonameid | 6.02 | ops/s | | Median Throughput | asc_sort_with_after_geonameid | 6.02 | ops/s | | Max Throughput | asc_sort_with_after_geonameid | 6.03 | ops/s | | 50th percentile latency | asc_sort_with_after_geonameid | 13.58878483 | ms | | 90th percentile latency | asc_sort_with_after_geonameid | 15.38058759 | ms | | 99th percentile latency | asc_sort_with_after_geonameid | 24.72792548 | ms | | 100th percentile latency | asc_sort_with_after_geonameid | 26.87194967 | ms | | 50th percentile service time | asc_sort_with_after_geonameid | 12.30645 | ms | | 90th percentile service time | asc_sort_with_after_geonameid | 14.08940257 | ms | | 99th percentile service time | asc_sort_with_after_geonameid | 22.94765654 | ms | | 100th percentile service time | asc_sort_with_after_geonameid | 25.671233 | 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.51 | ops/s | | Median Throughput | sort_country_code_can_match_shortcut | 1.51 | ops/s | | Max Throughput | sort_country_code_can_match_shortcut | 1.51 | ops/s | | 50th percentile latency | sort_country_code_can_match_shortcut | 5.918777058 | ms | | 90th percentile latency | sort_country_code_can_match_shortcut | 6.491629559 | ms | | 99th percentile latency | sort_country_code_can_match_shortcut | 7.106437654 | ms | | 100th percentile latency | sort_country_code_can_match_shortcut | 7.45727011 | ms | | 50th percentile service time | sort_country_code_can_match_shortcut | 4.248485834 | ms | | 90th percentile service time | sort_country_code_can_match_shortcut | 4.601421534 | ms | | 99th percentile service time | sort_country_code_can_match_shortcut | 4.960774693 | ms | | 100th percentile service time | sort_country_code_can_match_shortcut | 5.119738332 | 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 | 5.53882672 | ms | | 90th percentile latency | sort_country_code_no_can_match_shortcut | 6.069942232 | ms | | 99th percentile latency | sort_country_code_no_can_match_shortcut | 6.414377524 | ms | | 100th percentile latency | sort_country_code_no_can_match_shortcut | 6.565415219 | ms | | 50th percentile service time | sort_country_code_no_can_match_shortcut | 3.820458501 | ms | | 90th percentile service time | sort_country_code_no_can_match_shortcut | 4.076078534 | ms | | 99th percentile service time | sort_country_code_no_can_match_shortcut | 4.632001587 | ms | | 100th percentile service time | sort_country_code_no_can_match_shortcut | 4.822700669 | ms | | error rate | sort_country_code_no_can_match_shortcut | 0 | % |