This document describes the performance metrics of a 3-node ES cluster with 8 CPU cores and 32 GB memory, and 200 GB SSD storage capacity.
Note:The data comes from GeoNames and contains 11,396,503 entries of geographic location data in text, long, geo, and other types stored in columns and rows with a total size of around 3 GB.
The comparison between the 8-core 32 GB SSD 200 GB 3-node ES cluster and a community edition cluster with the same specification shows that ES has better performance in all aspects thanks to its optimizations of the underlying storage model (time series merging and continuous cold shard merging), query execution plan (efficient pruning and caching), built-in scenario templates, proprietary JDK, and GC parameter tuning. For more information, please see ES Kernel Enhancement.
Description | Metric | Unit | Task | ES | Community Edition | Difference Value (Community Edition-ES) | Difference Percentage (Difference Value/Community Edition) | Performance Comparison |
---|---|---|---|---|---|---|---|---|
Total write time | Cumulative indexing time of primary shards | min | - | 14.2567 | 15.4834 | 1.2267 | 7.92% | Superior |
Total GC count and time | Total Young Gen GC time | s | - | 3.544 | 17.73 | 14.186 | 80.01% | Superior |
Total Young Gen GC count | - | - | 447 | 1084 | 637 | 58.76% | Superior | |
Total Old Gen GC time | s | - | 0 | 0 | 0 | - | - | |
Total Old Gen GC count | - | - | 0 | 0 | 0 | - | - | |
Storage size | Store size | GB | - | 2.59725 | 3.07604 | 0.47879 | 15.57% | Superior |
Heap memory usage | Heap used for segments | MB | - | 0.534325 | 0.766575 | 0.23225 | 30.30% | Superior |
Heap used for doc values | MB | - | 0.0507355 | 0.0315514 | -0.0191841 | -60.80% | Inferior | |
Heap used for terms | MB | - | 0.370026 | 0.601349 | 0.231323 | 38.47% | Superior | |
Heap used for norms | MB | - | 0.0396729 | 0.0817871 | 0.0421142 | 51.49% | Superior | |
Heap used for points | MB | - | 0 | 0 | 0 | - | - | |
Heap used for stored fields | MB | - | 0.0119553 | 0.0518875 | 0.0399322 | 76.96% | Superior | |
Total segment count | Segment count | - | - | 7 | 105 | 98 | 93.33% | Superior |
Write throughput and time | Min Throughput | docs/s | index-append | 153730 | 132776 | -20954 | -15.78% | Superior |
Median Throughput | docs/s | index-append | 159765 | 142851 | -16914 | -11.84% | Superior | |
Max Throughput | docs/s | index-append | 162791 | 148669 | -14122 | -9.50% | Superior | |
50th percentile latency | ms | index-append | 130.877 | 151.656 | 20.779 | 13.70% | Superior | |
90th percentile latency | ms | index-append | 162.969 | 187.779 | 24.81 | 13.21% | Superior | |
99th percentile latency | ms | index-append | 181.428 | 240.11 | 58.682 | 24.44% | Superior | |
100th percentile latency | ms | index-append | 225.98 | 285.137 | 59.157 | 20.75% | Superior | |
50th percentile service time | ms | index-append | 130.877 | 151.656 | 20.779 | 13.70% | Superior | |
90th percentile service time | ms | index-append | 162.969 | 187.779 | 24.81 | 13.21% | Superior | |
99th percentile service time | ms | index-append | 181.428 | 240.11 | 58.682 | 24.44% | Superior | |
100th percentile service time | ms | index-append | 225.98 | 285.137 | 59.157 | 20.75% | Superior | |
error rate | % | index-append | 0 | 0 | 0 | - | - | |
Index metrics | Min Throughput | ops/s | index-stats | 90.05 | 90.05 | 0 | 0.00% | Superior |
Median Throughput | ops/s | index-stats | 90.06 | 90.07 | 0.01 | 0.01% | Superior | |
Max Throughput | ops/s | index-stats | 90.12 | 90.13 | 0.01 | 0.01% | Superior | |
50th percentile latency | ms | index-stats | 2.76736 | 2.65897 | -0.10839 | -4.08% | Inferior | |
90th percentile latency | ms | index-stats | 3.58235 | 3.48937 | -0.09298 | -2.66% | Inferior | |
99th percentile latency | ms | index-stats | 3.95798 | 3.89304 | -0.06494 | -1.67% | Inferior | |
99.9th percentile latency | ms | index-stats | 4.39377 | 9.07619 | 4.68242 | 51.59% | Superior | |
100th percentile latency | ms | index-stats | 9.00375 | 18.123 | 9.11925 | 50.32% | Superior | |
50th percentile service time | ms | index-stats | 1.57744 | 1.45244 | -0.125 | -8.61% | Inferior | |
90th percentile service time | ms | index-stats | 1.8317 | 1.66173 | -0.16997 | -10.23% | Inferior | |
99th percentile service time | ms | index-stats | 2.0752 | 1.94615 | -0.12905 | -6.63% | Inferior | |
99.9th percentile service time | ms | index-stats | 2.24891 | 2.64752 | 0.39861 | 15.06% | Superior | |
100th percentile service time | ms | index-stats | 2.31078 | 16.5015 | 14.19072 | 86.00% | Superior | |
error rate | % | index-stats | 0 | 0 | 0 | - | - | |
Node metrics | Min Throughput | ops/s | node-stats | 90.06 | 90.06 | 0 | 0.00% | Superior |
Median Throughput | ops/s | node-stats | 90.12 | 90.12 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | node-stats | 90.36 | 90.39 | 0.03 | 0.03% | Superior | |
50th percentile latency | ms | node-stats | 2.9754 | 2.93862 | -0.03678 | -1.25% | Inferior | |
90th percentile latency | ms | node-stats | 4.07929 | 4.0283 | -0.05099 | -1.27% | Inferior | |
99th percentile latency | ms | node-stats | 5.0754 | 4.78946 | -0.28594 | -5.97% | Inferior | |
99.9th percentile latency | ms | node-stats | 6.53613 | 17.0702 | 10.53407 | 61.71% | Superior | |
100th percentile latency | ms | node-stats | 6.93454 | 24.7832 | 17.84866 | 72.02% | Superior | |
50th percentile service time | ms | node-stats | 2.23841 | 2.17713 | -0.06128 | -2.81% | Inferior | |
90th percentile service time | ms | node-stats | 2.65367 | 2.62466 | -0.02901 | -1.11% | Inferior | |
99th percentile service time | ms | node-stats | 3.92073 | 3.93043 | 0.0097 | 0.25% | Superior | |
99.9th percentile service time | ms | node-stats | 4.92842 | 4.48172 | -0.4467 | -9.97% | Inferior | |
100th percentile service time | ms | node-stats | 5.92757 | 23.7859 | 17.85833 | 75.08% | Superior | |
error rate | % | node-stats | 0 | 0 | 0 | - | - | |
Default query with all documents having a score of 1 (match_all) | Min Throughput | ops/s | default | 50.03 | 50.03 | 0 | 0.00% | Superior |
Median Throughput | ops/s | default | 50.04 | 50.04 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | default | 50.08 | 50.08 | 0 | 0.00% | Superior | |
50th percentile latency | ms | default | 3.53894 | 3.40291 | -0.13603 | -4.00% | Inferior | |
90th percentile latency | ms | default | 4.11403 | 4.57279 | 0.45876 | 10.03% | Superior | |
99th percentile latency | ms | default | 4.92737 | 5.37426 | 0.44689 | 8.32% | Superior | |
99.9th percentile latency | ms | default | 5.74037 | 25.897 | 20.15663 | 77.83% | Superior | |
100th percentile latency | ms | default | 7.32557 | 27.2085 | 19.88293 | 73.08% | Superior | |
50th percentile service time | ms | default | 2.7831 | 2.67459 | -0.10851 | -4.06% | Inferior | |
90th percentile service time | ms | default | 3.17322 | 2.97996 | -0.19326 | -6.49% | Inferior | |
99th percentile service time | ms | default | 3.77477 | 3.38794 | -0.38683 | -11.42% | Inferior | |
99.9th percentile service time | ms | default | 4.19186 | 25.1729 | 20.98104 | 83.35% | Superior | |
100th percentile service time | ms | default | 6.58243 | 26.1698 | 19.58737 | 74.85% | Superior | |
error rate | % | default | 0 | 0 | 0 | - | - | |
Term query | Min Throughput | ops/s | term | 99.66 | 100.05 | 0.39 | 0.39% | Superior |
Median Throughput | ops/s | term | 100.07 | 100.08 | 0.01 | 0.01% | Superior | |
Max Throughput | ops/s | term | 100.11 | 100.15 | 0.04 | 0.04% | Superior | |
50th percentile latency | ms | term | 2.83987 | 2.72933 | -0.11054 | -4.05% | Inferior | |
90th percentile latency | ms | term | 3.32569 | 3.16805 | -0.15764 | -4.98% | Inferior | |
99th percentile latency | ms | term | 3.96055 | 3.66753 | -0.29302 | -7.99% | Inferior | |
99.9th percentile latency | ms | term | 4.33961 | 9.62272 | 5.28311 | 54.90% | Superior | |
100th percentile latency | ms | term | 5.70421 | 16.4559 | 10.75169 | 65.34% | Superior | |
50th percentile service time | ms | term | 2.08935 | 2.00258 | -0.08677 | -4.33% | Inferior | |
90th percentile service time | ms | term | 2.53284 | 2.24384 | -0.289 | -12.88% | Inferior | |
99th percentile service time | ms | term | 2.99484 | 2.64135 | -0.35349 | -13.38% | Inferior | |
99.9th percentile service time | ms | term | 3.37709 | 6.10442 | 2.72733 | 44.68% | Superior | |
100th percentile service time | ms | term | 5.24029 | 15.8044 | 10.56411 | 66.84% | Superior | |
error rate | % | term | 0 | 0 | 0 | - | - | |
Phrase query | Min Throughput | ops/s | phrase | 110.04 | 110.06 | 0.02 | 0.02% | Superior |
Median Throughput | ops/s | phrase | 110.08 | 110.07 | -0.01 | -0.01% | Superior | |
Max Throughput | ops/s | phrase | 110.11 | 110.11 | 0 | 0.00% | Superior | |
50th percentile latency | ms | phrase | 2.74088 | 2.89197 | 0.15109 | 5.22% | Superior | |
90th percentile latency | ms | phrase | 3.30207 | 3.39345 | 0.09138 | 2.69% | Superior | |
99th percentile latency | ms | phrase | 4.8127 | 8.22389 | 3.41119 | 41.48% | Superior | |
99.9th percentile latency | ms | phrase | 5.57204 | 25.9978 | 20.42576 | 78.57% | Superior | |
100th percentile latency | ms | phrase | 6.54587 | 27.9116 | 21.36573 | 76.55% | Superior | |
50th percentile service time | ms | phrase | 1.98839 | 2.18937 | 0.20098 | 9.18% | Superior | |
90th percentile service time | ms | phrase | 2.41365 | 2.51158 | 0.09793 | 3.90% | Superior | |
99th percentile service time | ms | phrase | 4.00121 | 3.24254 | -0.75867 | -23.40% | Inferior | |
99.9th percentile service time | ms | phrase | 4.70793 | 25.7224 | 21.01447 | 81.70% | Superior | |
100th percentile service time | ms | phrase | 5.67829 | 27.4831 | 21.80481 | 79.34% | Superior | |
error rate | % | phrase | 0 | 0 | 0 | - | - | |
Aggregation query without cache | Min Throughput | ops/s | country_agg_uncached | 3.6 | 3.6 | 0 | 0.00% | Superior |
Median Throughput | ops/s | country_agg_uncached | 3.61 | 3.61 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | country_agg_uncached | 3.61 | 3.61 | 0 | 0.00% | Superior | |
50th percentile latency | ms | country_agg_uncached | 130.314 | 162.61 | 32.296 | 19.86% | Superior | |
90th percentile latency | ms | country_agg_uncached | 147.567 | 176.4 | 28.833 | 16.35% | Superior | |
99th percentile latency | ms | country_agg_uncached | 165.174 | 184.368 | 19.194 | 10.41% | Superior | |
100th percentile latency | ms | country_agg_uncached | 174.015 | 269.972 | 95.957 | 35.54% | Superior | |
50th percentile service time | ms | country_agg_uncached | 129.186 | 161.723 | 32.537 | 20.12% | Superior | |
90th percentile service time | ms | country_agg_uncached | 146.921 | 175.819 | 28.898 | 16.44% | Superior | |
99th percentile service time | ms | country_agg_uncached | 164.579 | 183.7 | 19.121 | 10.41% | Superior | |
100th percentile service time | ms | country_agg_uncached | 172.827 | 269.339 | 96.512 | 35.83% | Superior | |
error rate | % | country_agg_uncached | 0 | 0 | 0 | - | - | |
Aggregation query with cache | Min Throughput | ops/s | country_agg_cached | 100.04 | 100.03 | -0.01 | -0.01% | Superior |
Median Throughput | ops/s | country_agg_cached | 100.05 | 100.06 | 0.01 | 0.01% | Superior | |
Max Throughput | ops/s | country_agg_cached | 100.08 | 100.08 | 0 | 0.00% | Superior | |
50th percentile latency | ms | country_agg_cached | 2.29531 | 2.10251 | -0.1928 | -9.17% | Inferior | |
90th percentile latency | ms | country_agg_cached | 3.57418 | 3.49217 | -0.08201 | -2.35% | Inferior | |
99th percentile latency | ms | country_agg_cached | 3.91685 | 3.74707 | -0.16978 | -4.53% | Inferior | |
99.9th percentile latency | ms | country_agg_cached | 4.19749 | 4.05757 | -0.13992 | -3.45% | Inferior | |
100th percentile latency | ms | country_agg_cached | 4.51842 | 4.63039 | 0.11197 | 2.42% | Superior | |
50th percentile service time | ms | country_agg_cached | 1.57861 | 1.40612 | -0.17249 | -12.27% | Inferior | |
90th percentile service time | ms | country_agg_cached | 1.89111 | 1.58866 | -0.30245 | -19.04% | Inferior | |
99th percentile service time | ms | country_agg_cached | 2.19488 | 1.74583 | -0.44905 | -25.72% | Inferior | |
99.9th percentile service time | ms | country_agg_cached | 3.42563 | 3.46564 | 0.04001 | 1.15% | Superior | |
100th percentile service time | ms | country_agg_cached | 4.28971 | 3.97654 | -0.31317 | -7.88% | Superior | |
error rate | % | country_agg_cached | 0 | 0 | 0 | - | - | |
Paged pull | Min Throughput | pages/s | scroll | 20.04 | 20.04 | 0 | 0.00% | Superior |
Median Throughput | pages/s | scroll | 20.05 | 20.04 | -0.01 | -0.05% | Superior | |
Max Throughput | pages/s | scroll | 20.06 | 20.06 | 0 | 0.00% | Superior | |
50th percentile latency | ms | scroll | 538.421 | 556.145 | 17.724 | 3.19% | Superior | |
90th percentile latency | ms | scroll | 543.566 | 573.903 | 30.337 | 5.29% | Superior | |
99th percentile latency | ms | scroll | 582.263 | 585.602 | 3.339 | 0.57% | Superior | |
100th percentile latency | ms | scroll | 584.75 | 587.091 | 2.341 | 0.40% | Superior | |
50th percentile service time | ms | scroll | 537.068 | 554.325 | 17.257 | 3.11% | Superior | |
90th percentile service time | ms | scroll | 542.428 | 572.308 | 29.88 | 5.22% | Superior | |
99th percentile service time | ms | scroll | 580.372 | 583.701 | 3.329 | 0.57% | Superior | |
100th percentile service time | ms | scroll | 583.612 | 584.764 | 1.152 | 0.20% | Superior | |
error rate | % | scroll | 0 | 0 | 0 | - | - | |
Script query (using expression script) | Min Throughput | ops/s | expression | 2 | 2 | 0 | 0.00% | Superior |
Median Throughput | ops/s | expression | 2 | 2 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | expression | 2 | 2 | 0 | 0.00% | Superior | |
50th percentile latency | ms | expression | 265.631 | 277.403 | 11.772 | 4.24% | Superior | |
90th percentile latency | ms | expression | 287.121 | 299.5 | 12.379 | 4.13% | Superior | |
99th percentile latency | ms | expression | 311.788 | 434.462 | 122.674 | 28.24% | Superior | |
100th percentile latency | ms | expression | 391.745 | 446.275 | 54.53 | 12.22% | Superior | |
50th percentile service time | ms | expression | 264.462 | 276.536 | 12.074 | 4.37% | Superior | |
90th percentile service time | ms | expression | 285.113 | 298.434 | 13.321 | 4.46% | Superior | |
99th percentile service time | ms | expression | 310.991 | 434.014 | 123.023 | 28.35% | Superior | |
100th percentile service time | ms | expression | 390.33 | 445.661 | 55.331 | 12.42% | Superior | |
error rate | % | expression | 0 | 0 | 0 | - | - | |
Script query (using painless static script without dynamically getting field values) | Min Throughput | ops/s | painless_static | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | painless_static | 1.5 | 1.5 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | painless_static | 1.5 | 1.5 | 0 | 0.00% | Superior | |
50th percentile latency | ms | painless_static | 337.96 | 364.636 | 26.676 | 7.32% | Superior | |
90th percentile latency | ms | painless_static | 358.738 | 383.504 | 24.766 | 6.46% | Superior | |
99th percentile latency | ms | painless_static | 375.017 | 459.529 | 84.512 | 18.39% | Superior | |
100th percentile latency | ms | painless_static | 395.417 | 557.708 | 162.291 | 29.10% | Superior | |
50th percentile service time | ms | painless_static | 337.111 | 363.478 | 26.367 | 7.25% | Superior | |
90th percentile service time | ms | painless_static | 357.771 | 382.45 | 24.679 | 6.45% | Superior | |
99th percentile service time | ms | painless_static | 374.121 | 458.343 | 84.222 | 18.38% | Superior | |
100th percentile service time | ms | painless_static | 394.632 | 556.401 | 161.769 | 29.07% | Superior | |
error rate | % | painless_static | 0 | 0 | 0 | - | - | |
Script query (using painless static script with dynamically getting field values) | Min Throughput | ops/s | painless_dynamic | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | painless_dynamic | 1.5 | 1.5 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | painless_dynamic | 1.5 | 1.5 | 0 | 0.00% | Superior | |
50th percentile latency | ms | painless_dynamic | 334.684 | 365.354 | 30.67 | 8.39% | Superior | |
90th percentile latency | ms | painless_dynamic | 354.406 | 390.406 | 36 | 9.22% | Superior | |
99th percentile latency | ms | painless_dynamic | 377.214 | 552.417 | 175.203 | 31.72% | Superior | |
100th percentile latency | ms | painless_dynamic | 381.276 | 554.12 | 172.844 | 31.19% | Superior | |
50th percentile service time | ms | painless_dynamic | 333.654 | 364.353 | 30.699 | 8.43% | Superior | |
90th percentile service time | ms | painless_dynamic | 353.246 | 389.419 | 36.173 | 9.29% | Superior | |
99th percentile service time | ms | painless_dynamic | 375.956 | 551.619 | 175.663 | 31.84% | Superior | |
100th percentile service time | ms | painless_dynamic | 379.75 | 553.208 | 173.458 | 31.35% | Superior | |
error rate | % | painless_dynamic | 0 | 0 | 0 | - | - | |
Geographic range query (based on Gaussian decay function) | Min Throughput | ops/s | decay_geo_gauss_function_score | 1 | 1 | 0 | 0.00% | Superior |
Median Throughput | ops/s | decay_geo_gauss_function_score | 1 | 1 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | decay_geo_gauss_function_score | 1 | 1 | 0 | 0.00% | Superior | |
50th percentile latency | ms | decay_geo_gauss_function_score | 327.972 | 327.664 | -0.308 | -0.09% | Inferior | |
90th percentile latency | ms | decay_geo_gauss_function_score | 336.979 | 344.367 | 7.388 | 2.15% | Superior | |
99th percentile latency | ms | decay_geo_gauss_function_score | 343.562 | 417.386 | 73.824 | 17.69% | Superior | |
100th percentile latency | ms | decay_geo_gauss_function_score | 344.135 | 420.996 | 76.861 | 18.26% | Superior | |
50th percentile service time | ms | decay_geo_gauss_function_score | 326.554 | 326.503 | -0.051 | -0.02% | Inferior | |
90th percentile service time | ms | decay_geo_gauss_function_score | 336.053 | 343.32 | 7.267 | 2.12% | Superior | |
99th percentile service time | ms | decay_geo_gauss_function_score | 342.151 | 416.72 | 74.569 | 17.89% | Superior | |
100th percentile service time | ms | decay_geo_gauss_function_score | 342.843 | 419.488 | 76.645 | 18.27% | Superior | |
error rate | % | decay_geo_gauss_function_score | 0 | 0 | 0 | - | - | |
Geographic range query (based on Gaussian decay function with dynamically getting field values through script) | Min Throughput | ops/s | decay_geo_gauss_script_score | 1 | 1 | 0 | 0.00% | Superior |
Median Throughput | ops/s | decay_geo_gauss_script_score | 1 | 1 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | decay_geo_gauss_script_score | 1 | 1 | 0 | 0.00% | Superior | |
50th percentile latency | ms | decay_geo_gauss_script_score | 341.152 | 344.421 | 3.269 | 0.95% | Superior | |
90th percentile latency | ms | decay_geo_gauss_script_score | 349.94 | 371.575 | 21.635 | 5.82% | Superior | |
99th percentile latency | ms | decay_geo_gauss_script_score | 354.76 | 420.658 | 65.898 | 15.67% | Superior | |
100th percentile latency | ms | decay_geo_gauss_script_score | 364.169 | 438.541 | 74.372 | 16.96% | Superior | |
50th percentile service time | ms | decay_geo_gauss_script_score | 339.967 | 342.961 | 2.994 | 0.87% | Superior | |
90th percentile service time | ms | decay_geo_gauss_script_score | 348.493 | 370.146 | 21.653 | 5.85% | Superior | |
99th percentile service time | ms | decay_geo_gauss_script_score | 353.559 | 418.767 | 65.208 | 15.57% | Superior | |
100th percentile service time | ms | decay_geo_gauss_script_score | 362.748 | 437.195 | 74.447 | 17.03% | Superior | |
error rate | % | decay_geo_gauss_script_score | 0 | 0 | 0 | - | - | |
Custom scoring function query (defining function based on field value) | Min Throughput | ops/s | field_value_function_score | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | field_value_function_score | 1.5 | 1.5 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | field_value_function_score | 1.51 | 1.51 | 0 | 0.00% | Superior | |
50th percentile latency | ms | field_value_function_score | 120.538 | 129.323 | 8.785 | 6.79% | Superior | |
90th percentile latency | ms | field_value_function_score | 137.702 | 152.985 | 15.283 | 9.99% | Superior | |
99th percentile latency | ms | field_value_function_score | 147.851 | 185.772 | 37.921 | 20.41% | Superior | |
100th percentile latency | ms | field_value_function_score | 169.961 | 186.405 | 16.444 | 8.82% | Superior | |
50th percentile service time | ms | field_value_function_score | 119.159 | 128.146 | 8.987 | 7.01% | Superior | |
90th percentile service time | ms | field_value_function_score | 136.338 | 151.555 | 15.217 | 10.04% | Superior | |
99th percentile service time | ms | field_value_function_score | 146.981 | 184.934 | 37.953 | 20.52% | Superior | |
100th percentile service time | ms | field_value_function_score | 168.964 | 185.269 | 16.305 | 8.80% | Superior | |
error rate | % | field_value_function_score | 0 | 0 | 0 | - | - | |
Custom scoring function query (dynamically getting field values through script to calculate scores) | Min Throughput | ops/s | field_value_script_score | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | field_value_script_score | 1.5 | 1.5 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | field_value_script_score | 1.51 | 1.51 | 0 | 0.00% | Superior | |
50th percentile latency | ms | field_value_script_score | 168.069 | 171.907 | 3.838 | 2.23% | Superior | |
90th percentile latency | ms | field_value_script_score | 178.933 | 184.467 | 5.534 | 3.00% | Superior | |
99th percentile latency | ms | field_value_script_score | 196.982 | 200.137 | 3.155 | 1.58% | Superior | |
100th percentile latency | ms | field_value_script_score | 198.722 | 206.461 | 7.739 | 3.75% | Superior | |
50th percentile service time | ms | field_value_script_score | 166.827 | 170.653 | 3.826 | 2.24% | Superior | |
90th percentile service time | ms | field_value_script_score | 177.869 | 183.324 | 5.455 | 2.98% | Superior | |
99th percentile service time | ms | field_value_script_score | 195.586 | 199.107 | 3.521 | 1.77% | Superior | |
100th percentile service time | ms | field_value_script_score | 197.054 | 205.323 | 8.269 | 4.03% | Superior | |
error rate | % | field_value_script_score | 0 | 0 | 0 | - | - | |
Large terms query | Min Throughput | ops/s | large_terms | 1.1 | 1.1 | 0 | 0.00% | Superior |
Median Throughput | ops/s | large_terms | 1.1 | 1.1 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | large_terms | 1.1 | 1.1 | 0 | 0.00% | Superior | |
50th percentile latency | ms | large_terms | 241.322 | 597.464 | 356.142 | 59.61% | Superior | |
90th percentile latency | ms | large_terms | 252.637 | 600.941 | 348.304 | 57.96% | Superior | |
99th percentile latency | ms | large_terms | 265.807 | 749.895 | 484.088 | 64.55% | Superior | |
100th percentile latency | ms | large_terms | 272.611 | 751.444 | 478.833 | 63.72% | Superior | |
50th percentile service time | ms | large_terms | 233.129 | 589.829 | 356.7 | 60.48% | Superior | |
90th percentile service time | ms | large_terms | 244.494 | 593.562 | 349.068 | 58.81% | Superior | |
99th percentile service time | ms | large_terms | 258.894 | 742.68 | 483.786 | 65.14% | Superior | |
100th percentile service time | ms | large_terms | 264.352 | 743.9 | 479.548 | 64.46% | Superior | |
error rate | % | large_terms | 0 | 0 | 0 | - | - | |
Large filtered terms query | Min Throughput | ops/s | large_filtered_terms | 1.1 | 1.1 | 0 | 0.00% | Superior |
Median Throughput | ops/s | large_filtered_terms | 1.1 | 1.1 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | large_filtered_terms | 1.1 | 1.1 | 0 | 0.00% | Superior | |
50th percentile latency | ms | large_filtered_terms | 233.192 | 596.04 | 362.848 | 60.88% | Superior | |
90th percentile latency | ms | large_filtered_terms | 241.102 | 604.321 | 363.219 | 60.10% | Superior | |
99th percentile latency | ms | large_filtered_terms | 251.835 | 717.036 | 465.201 | 64.88% | Superior | |
100th percentile latency | ms | large_filtered_terms | 260.27 | 749.665 | 489.395 | 65.28% | Superior | |
50th percentile service time | ms | large_filtered_terms | 225.052 | 588.28 | 363.228 | 61.74% | Superior | |
90th percentile service time | ms | large_filtered_terms | 233.16 | 595.415 | 362.255 | 60.84% | Superior | |
99th percentile service time | ms | large_filtered_terms | 243.603 | 708.968 | 465.365 | 65.64% | Superior | |
100th percentile service time | ms | large_filtered_terms | 252.129 | 741.922 | 489.793 | 66.02% | Superior | |
error rate | % | large_filtered_terms | 0 | 0 | 0 | - | - | |
Large prohibited terms query | Min Throughput | ops/s | large_prohibited_terms | 1.1 | 1.1 | 0 | 0.00% | Superior |
Median Throughput | ops/s | large_prohibited_terms | 1.1 | 1.1 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | large_prohibited_terms | 1.1 | 1.1 | 0 | 0.00% | Superior | |
50th percentile latency | ms | large_prohibited_terms | 235.179 | 610.41 | 375.231 | 61.47% | Superior | |
90th percentile latency | ms | large_prohibited_terms | 241.076 | 631.544 | 390.468 | 61.83% | Superior | |
99th percentile latency | ms | large_prohibited_terms | 255.983 | 774.92 | 518.937 | 66.97% | Superior | |
100th percentile latency | ms | large_prohibited_terms | 259.046 | 779.168 | 520.122 | 66.75% | Superior | |
50th percentile service time | ms | large_prohibited_terms | 227.487 | 603.342 | 375.855 | 62.30% | Superior | |
90th percentile service time | ms | large_prohibited_terms | 233.792 | 624.55 | 390.758 | 62.57% | Superior | |
99th percentile service time | ms | large_prohibited_terms | 248.53 | 767.511 | 518.981 | 67.62% | Superior | |
100th percentile service time | ms | large_prohibited_terms | 251.083 | 771.655 | 520.572 | 67.46% | Superior | |
error rate | % | large_prohibited_terms | 0 | 0 | 0 | - | - | |
Descending order query | Min Throughput | ops/s | desc_sort_population | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | desc_sort_population | 1.51 | 1.51 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | desc_sort_population | 1.51 | 1.51 | 0 | 0.00% | Superior | |
50th percentile latency | ms | desc_sort_population | 48.387 | 56.6622 | 8.2752 | 14.60% | Superior | |
90th percentile latency | ms | desc_sort_population | 63.073 | 94.9756 | 31.9026 | 33.59% | Superior | |
99th percentile latency | ms | desc_sort_population | 71.7498 | 97.2611 | 25.5113 | 26.23% | Superior | |
100th percentile latency | ms | desc_sort_population | 83.3593 | 97.7817 | 14.4224 | 14.75% | Superior | |
50th percentile service time | ms | desc_sort_population | 47.0436 | 55.1461 | 8.1025 | 14.69% | Superior | |
90th percentile service time | ms | desc_sort_population | 61.3731 | 93.9102 | 32.5371 | 34.65% | Superior | |
99th percentile service time | ms | desc_sort_population | 70.4811 | 95.6134 | 25.1323 | 26.29% | Superior | |
100th percentile service time | ms | desc_sort_population | 81.6517 | 96.009 | 14.3573 | 14.95% | Superior | |
error rate | % | desc_sort_population | 0 | 0 | 0 | - | - | |
Ascending order query | Min Throughput | ops/s | asc_sort_population | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | asc_sort_population | 1.51 | 1.51 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | asc_sort_population | 1.51 | 1.51 | 0 | 0.00% | Superior | |
50th percentile latency | ms | asc_sort_population | 49.2469 | 57.9177 | 8.6708 | 14.97% | Superior | |
90th percentile latency | ms | asc_sort_population | 67.5894 | 76.0044 | 8.415 | 11.07% | Superior | |
99th percentile latency | ms | asc_sort_population | 84.6384 | 97.5143 | 12.8759 | 13.20% | Superior | |
100th percentile latency | ms | asc_sort_population | 85.8124 | 97.5606 | 11.7482 | 12.04% | Superior | |
50th percentile service time | ms | asc_sort_population | 47.8438 | 56.5861 | 8.7423 | 15.45% | Superior | |
90th percentile service time | ms | asc_sort_population | 66.0821 | 74.7343 | 8.6522 | 11.58% | Superior | |
99th percentile service time | ms | asc_sort_population | 83.6026 | 96.2868 | 12.6842 | 13.17% | Superior | |
100th percentile service time | ms | asc_sort_population | 84.2175 | 96.6563 | 12.4388 | 12.87% | Superior | |
error rate | % | asc_sort_population | 0 | 0 | 0 | - | - | |
search_after query with sorting in ascending order | Min Throughput | ops/s | asc_sort_with_after_population | 1.5 | 1.5 | 0 | 0.00% | Superior |
Median Throughput | ops/s | asc_sort_with_after_population | 1.51 | 1.51 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | asc_sort_with_after_population | 1.51 | 1.51 | 0 | 0.00% | Superior | |
50th percentile latency | ms | asc_sort_with_after_population | 99.1943 | 83.423 | -15.7713 | -18.91% | Inferior | |
90th percentile latency | ms | asc_sort_with_after_population | 86.0298 | 98.895 | 12.8652 | 13.01% | Superior | |
99th percentile latency | ms | asc_sort_with_after_population | 102.268 | 131.329 | 29.061 | 22.13% | Superior | |
100th percentile latency | ms | asc_sort_with_after_population | 106.33 | 132.25 | 25.92 | 19.60% | Superior | |
50th percentile service time | ms | asc_sort_with_after_population | 68.2272 | 82.1201 | 13.8929 | 16.92% | Superior | |
90th percentile service time | ms | asc_sort_with_after_population | 84.685 | 97.2085 | 12.5235 | 12.88% | Superior | |
99th percentile service time | ms | asc_sort_with_after_population | 101.133 | 130.033 | 28.9 | 22.23% | Superior | |
100th percentile service time | ms | asc_sort_with_after_population | 105.094 | 131.274 | 26.18 | 19.94% | Superior | |
error rate | % | asc_sort_with_after_population | 0 | 0 | 0 | - | - | |
Query with sorting high base fields in descending order (quickly getting topK based on DistanceFeatureQuery) | Min Throughput | ops/s | desc_sort_geonameid | 6.02 | 6.02 | 0 | 0.00% | Superior |
Median Throughput | ops/s | desc_sort_geonameid | 6.02 | 6.02 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | desc_sort_geonameid | 6.03 | 6.03 | 0 | 0.00% | Superior | |
50th percentile latency | ms | desc_sort_geonameid | 5.53008 | 5.15391 | -0.37617 | -7.30% | Inferior | |
90th percentile latency | ms | desc_sort_geonameid | 6.20276 | 6.05507 | -0.14769 | -2.44% | Inferior | |
99th percentile latency | ms | desc_sort_geonameid | 6.67673 | 7.41936 | 0.74263 | 10.01% | Superior | |
100th percentile latency | ms | desc_sort_geonameid | 6.95103 | 24.1732 | 17.22217 | 71.24% | Superior | |
50th percentile service time | ms | desc_sort_geonameid | 4.61231 | 4.38941 | -0.2229 | -5.08% | Inferior | |
90th percentile service time | ms | desc_sort_geonameid | 5.45982 | 5.20354 | -0.25628 | -4.93% | Inferior | |
99th percentile service time | ms | desc_sort_geonameid | 5.65304 | 5.75262 | 0.09958 | 1.73% | Superior | |
100th percentile service time | ms | desc_sort_geonameid | 5.65578 | 23.3192 | 17.66342 | 75.75% | Superior | |
error rate | % | desc_sort_geonameid | 0 | 0 | 0 | - | - | |
search_after query with sorting high base fields in descending order | Min Throughput | ops/s | desc_sort_with_after_geonameid | 6.01 | 6.01 | 0 | 0.00% | Superior |
Median Throughput | ops/s | desc_sort_with_after_geonameid | 6.02 | 6.01 | -0.01 | -0.17% | Superior | |
Max Throughput | ops/s | desc_sort_with_after_geonameid | 6.02 | 6.02 | 0 | 0.00% | Superior | |
50th percentile latency | ms | desc_sort_with_after_geonameid | 56.5947 | 75.9327 | 19.338 | 25.47% | Superior | |
90th percentile latency | ms | desc_sort_with_after_geonameid | 79.6503 | 88.6273 | 8.977 | 10.13% | Superior | |
99th percentile latency | ms | desc_sort_with_after_geonameid | 87.7773 | 117.763 | 29.9857 | 25.46% | Superior | |
100th percentile latency | ms | desc_sort_with_after_geonameid | 89.3947 | 118.003 | 28.6083 | 24.24% | Superior | |
50th percentile service time | ms | desc_sort_with_after_geonameid | 55.4855 | 75.1241 | 19.6386 | 26.14% | Superior | |
90th percentile service time | ms | desc_sort_with_after_geonameid | 79.2349 | 87.7269 | 8.492 | 9.68% | Superior | |
99th percentile service time | ms | desc_sort_with_after_geonameid | 87.3803 | 116.924 | 29.5437 | 25.27% | Superior | |
100th percentile service time | ms | desc_sort_with_after_geonameid | 88.3606 | 117.768 | 29.4074 | 24.97% | Superior | |
error rate | % | desc_sort_with_after_geonameid | 0 | 0 | 0 | - | - | |
Query with sorting high base fields in ascending order (quickly getting topK based on DistanceFeatureQuery) | Min Throughput | ops/s | asc_sort_geonameid | 6.02 | 6.02 | 0 | 0.00% | Superior |
Median Throughput | ops/s | asc_sort_geonameid | 6.02 | 6.02 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | asc_sort_geonameid | 6.03 | 6.03 | 0 | 0.00% | Superior | |
50th percentile latency | ms | asc_sort_geonameid | 5.19317 | 4.49108 | -0.70209 | -15.63% | Inferior | |
90th percentile latency | ms | asc_sort_geonameid | 5.74438 | 5.01747 | -0.72691 | -14.49% | Inferior | |
99th percentile latency | ms | asc_sort_geonameid | 6.22846 | 5.49664 | -0.73182 | -13.31% | Inferior | |
100th percentile latency | ms | asc_sort_geonameid | 11.6377 | 5.53539 | -6.10231 | -110.24% | Inferior | |
50th percentile service time | ms | asc_sort_geonameid | 4.35586 | 3.56597 | -0.78989 | -22.15% | Inferior | |
90th percentile service time | ms | asc_sort_geonameid | 4.92152 | 3.97107 | -0.95045 | -23.93% | Inferior | |
99th percentile service time | ms | asc_sort_geonameid | 5.38949 | 4.33548 | -1.05401 | -24.31% | Inferior | |
100th percentile service time | ms | asc_sort_geonameid | 10.6436 | 4.5666 | -6.077 | -133.07% | Inferior | |
error rate | % | asc_sort_geonameid | 0 | 0 | 0 | - | - | |
search_after query with sorting high base fields in ascending order | Min Throughput | ops/s | asc_sort_with_after_geonameid | 6.01 | 6.01 | 0 | 0.00% | Superior |
Median Throughput | ops/s | asc_sort_with_after_geonameid | 6.02 | 6.01 | -0.01 | -0.17% | Superior | |
Max Throughput | ops/s | asc_sort_with_after_geonameid | 6.02 | 6.02 | 0 | 0.00% | Superior | |
50th percentile latency | ms | asc_sort_with_after_geonameid | 58.1403 | 69.5377 | 11.3974 | 16.39% | Superior | |
90th percentile latency | ms | asc_sort_with_after_geonameid | 76.5695 | 81.7929 | 5.2234 | 6.39% | Superior | |
99th percentile latency | ms | asc_sort_with_after_geonameid | 91.6296 | 98.1089 | 6.4793 | 6.60% | Superior | |
100th percentile latency | ms | asc_sort_with_after_geonameid | 91.6364 | 104.363 | 12.7266 | 12.19% | Superior | |
50th percentile service time | ms | asc_sort_with_after_geonameid | 57.1683 | 68.532 | 11.3637 | 16.58% | Superior | |
90th percentile service time | ms | asc_sort_with_after_geonameid | 75.7573 | 81.0123 | 5.255 | 6.49% | Superior | |
99th percentile service time | ms | asc_sort_with_after_geonameid | 91.1533 | 97.807 | 6.6537 | 6.80% | Superior | |
100th percentile service time | ms | asc_sort_with_after_geonameid | 91.3662 | 103.404 | 12.0378 | 11.64% | Superior | |
error rate | % | asc_sort_with_after_geonameid | 0 | 0 | 0 | - | - |
Was this page helpful?