This document compares the stress test result between a 3-node ES cluster with 4 CPU cores and 16 GB memory 200 GB SSD storage capacity and one with 8 CPU cores and 32 GB memory 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.
Description | Metric | Unit | Task | 4-core 16 GB | 8-core 32 GB | Difference Value | Difference Percentage | Performance Comparison |
---|---|---|---|---|---|---|---|---|
Total write time | Cumulative indexing time of primary shards | min | - | 16.3633 | 14.2567 | 2.1066 | 12.87% | Superior |
Total GC count and time | Total Young Gen GC time | s | - | 6.26 | 3.544 | 2.716 | 43.39% | Superior |
Total Young Gen GC count | - | - | 892 | 447 | 445 | 49.89% | Superior | |
Total Old Gen GC time | s | - | 0 | 0 | 0 | - | - | |
Total Old Gen GC count | - | - | 0 | 0 | 0 | - | - | |
Storage size | Store size | GB | - | 2.51866 | 2.59725 | -0.07859 | -3.12% | Inferior |
Heap memory usage | Heap used for segments | MB | - | 0.803783 | 0.534325 | 0.269458 | 33.52% | Superior |
Heap used for doc values | MB | - | 0.0284767 | 0.0507355 | -0.0222588 | -78.16% | Inferior | |
Heap used for terms | MB | - | 0.655075 | 0.370026 | 0.285049 | 43.51% | Superior | |
Heap used for norms | MB | - | 0.0732422 | 0.0396729 | 0.0335693 | 45.83% | Superior | |
Heap used for points | MB | - | 0 | 0 | 0 | - | - | |
Heap used for stored fields | MB | - | 0.0469894 | 0.0119553 | 0.0350341 | 74.56% | Superior | |
Total segment count | Segment count | - | - | 6 | 7 | -1 | -16.67% | Inferior |
Write throughput and time | Min Throughput | docs/s | index-append | 89331.9 | 153730 | -64398.1 | -72.09% | Superior |
Median Throughput | docs/s | index-append | 90268.8 | 159765 | -69496.2 | -76.99% | Superior | |
Max Throughput | docs/s | index-append | 90516.1 | 162791 | -72274.9 | -79.85% | Superior | |
50th percentile latency | ms | index-append | 233.258 | 130.877 | 102.381 | 43.89% | Superior | |
90th percentile latency | ms | index-append | 314.558 | 162.969 | 151.589 | 48.19% | Superior | |
99th percentile latency | ms | index-append | 341.303 | 181.428 | 159.875 | 46.84% | Superior | |
100th percentile latency | ms | index-append | 354.657 | 225.98 | 128.677 | 36.28% | Superior | |
50th percentile service time | ms | index-append | 233.258 | 130.877 | 102.381 | 43.89% | Superior | |
90th percentile service time | ms | index-append | 314.558 | 162.969 | 151.589 | 48.19% | Superior | |
99th percentile service time | ms | index-append | 341.303 | 181.428 | 159.875 | 46.84% | Superior | |
100th percentile service time | ms | index-append | 354.657 | 225.98 | 128.677 | 36.28% | Superior | |
error rate | % | index-append | 0 | 0 | 0 | - | - | |
Index metrics | Min Throughput | ops/s | index-stats | 90.04 | 90.05 | -0.01 | -0.01% | Superior |
Median Throughput | ops/s | index-stats | 90.07 | 90.06 | 0.01 | 0.01% | Superior | |
Max Throughput | ops/s | index-stats | 90.14 | 90.12 | 0.02 | 0.02% | Superior | |
50th percentile latency | ms | index-stats | 2.91003 | 2.76736 | 0.14267 | 4.90% | Superior | |
90th percentile latency | ms | index-stats | 3.82882 | 3.58235 | 0.24647 | 6.44% | Superior | |
99th percentile latency | ms | index-stats | 4.2378 | 3.95798 | 0.27982 | 6.60% | Superior | |
99.9th percentile latency | ms | index-stats | 4.34459 | 4.39377 | -0.04918 | -1.13% | Inferior | |
100th percentile latency | ms | index-stats | 8.22393 | 9.00375 | -0.77982 | -9.48% | Inferior | |
50th percentile service time | ms | index-stats | 1.78268 | 1.57744 | 0.20524 | 11.51% | Superior | |
90th percentile service time | ms | index-stats | 2.07484 | 1.8317 | 0.24314 | 11.72% | Superior | |
99th percentile service time | ms | index-stats | 2.43121 | 2.0752 | 0.35601 | 14.64% | Superior | |
99.9th percentile service time | ms | index-stats | 3.09198 | 2.24891 | 0.84307 | 27.27% | Superior | |
100th percentile service time | ms | index-stats | 7.29974 | 2.31078 | 4.98896 | 68.34% | 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.09 | 90.12 | -0.03 | -0.03% | Superior | |
Max Throughput | ops/s | node-stats | 90.34 | 90.36 | -0.02 | -0.02% | Superior | |
50th percentile latency | ms | node-stats | 3.17223 | 2.9754 | 0.19683 | 6.20% | Superior | |
90th percentile latency | ms | node-stats | 3.70681 | 4.07929 | -0.37248 | -10.05% | Inferior | |
99th percentile latency | ms | node-stats | 5.01334 | 5.0754 | -0.06206 | -1.24% | Inferior | |
99.9th percentile latency | ms | node-stats | 6.75018 | 6.53613 | 0.21405 | 3.17% | Superior | |
100th percentile latency | ms | node-stats | 7.98905 | 6.93454 | 1.05451 | 13.20% | Superior | |
50th percentile service time | ms | node-stats | 2.43876 | 2.23841 | 0.20035 | 8.22% | Superior | |
90th percentile service time | ms | node-stats | 2.78272 | 2.65367 | 0.12905 | 4.64% | Superior | |
99th percentile service time | ms | node-stats | 4.12234 | 3.92073 | 0.20161 | 4.89% | Superior | |
99.9th percentile service time | ms | node-stats | 6.35902 | 4.92842 | 1.4306 | 22.50% | Superior | |
100th percentile service time | ms | node-stats | 7.4313 | 5.92757 | 1.50373 | 20.24% | 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.89929 | 3.53894 | 0.36035 | 9.24% | Superior | |
90th percentile latency | ms | default | 4.39236 | 4.11403 | 0.27833 | 6.34% | Superior | |
99th percentile latency | ms | default | 4.78834 | 4.92737 | -0.13903 | -2.90% | Inferior | |
99.9th percentile latency | ms | default | 7.10486 | 5.74037 | 1.36449 | 19.21% | Superior | |
100th percentile latency | ms | default | 8.75822 | 7.32557 | 1.43265 | 16.36% | Superior | |
50th percentile service time | ms | default | 3.18269 | 2.7831 | 0.39959 | 12.56% | Superior | |
90th percentile service time | ms | default | 3.49347 | 3.17322 | 0.32025 | 9.17% | Superior | |
99th percentile service time | ms | default | 3.8746 | 3.77477 | 0.09983 | 2.58% | Superior | |
99.9th percentile service time | ms | default | 6.68581 | 4.19186 | 2.49395 | 37.30% | Superior | |
100th percentile service time | ms | default | 8.30396 | 6.58243 | 1.72153 | 20.73% | Superior | |
error rate | % | default | 0 | 0 | 0 | - | - | |
Term query | Min Throughput | ops/s | term | 100.05 | 99.66 | 0.39 | 0.39% | Superior |
Median Throughput | ops/s | term | 100.07 | 100.07 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | term | 100.14 | 100.11 | 0.03 | 0.03% | Superior | |
50th percentile latency | ms | term | 3.17419 | 2.83987 | 0.33432 | 10.53% | Superior | |
90th percentile latency | ms | term | 3.62229 | 3.32569 | 0.2966 | 8.19% | Superior | |
99th percentile latency | ms | term | 4.03812 | 3.96055 | 0.07757 | 1.92% | Superior | |
99.9th percentile latency | ms | term | 5.9753 | 4.33961 | 1.63569 | 27.37% | Superior | |
100th percentile latency | ms | term | 8.03321 | 5.70421 | 2.329 | 28.99% | Superior | |
50th percentile service time | ms | term | 2.49755 | 2.08935 | 0.4082 | 16.34% | Superior | |
90th percentile service time | ms | term | 2.71322 | 2.53284 | 0.18038 | 6.65% | Superior | |
99th percentile service time | ms | term | 3.20673 | 2.99484 | 0.21189 | 6.61% | Superior | |
99.9th percentile service time | ms | term | 5.17998 | 3.37709 | 1.80289 | 34.80% | Superior | |
100th percentile service time | ms | term | 6.95227 | 5.24029 | 1.71198 | 24.62% | Superior | |
error rate | % | term | 0 | 0 | 0 | - | - | |
Phrase query | Min Throughput | ops/s | phrase | 110.05 | 110.04 | 0.01 | 0.01% | Superior |
Median Throughput | ops/s | phrase | 110.07 | 110.08 | -0.01 | -0.01% | Superior | |
Max Throughput | ops/s | phrase | 110.12 | 110.11 | 0.01 | 0.01% | Superior | |
50th percentile latency | ms | phrase | 3.09905 | 2.74088 | 0.35817 | 11.56% | Superior | |
90th percentile latency | ms | phrase | 3.62549 | 3.30207 | 0.32342 | 8.92% | Superior | |
99th percentile latency | ms | phrase | 4.55457 | 4.8127 | -0.25813 | -5.67% | Inferior | |
99.9th percentile latency | ms | phrase | 8.29519 | 5.57204 | 2.72315 | 32.83% | Superior | |
100th percentile latency | ms | phrase | 9.39771 | 6.54587 | 2.85184 | 30.35% | Superior | |
50th percentile service time | ms | phrase | 2.38248 | 1.98839 | 0.39409 | 16.54% | Superior | |
90th percentile service time | ms | phrase | 2.77084 | 2.41365 | 0.35719 | 12.89% | Superior | |
99th percentile service time | ms | phrase | 3.75448 | 4.00121 | -0.24673 | -6.57% | Inferior | |
99.9th percentile service time | ms | phrase | 7.5974 | 4.70793 | 2.88947 | 38.03% | Superior | |
100th percentile service time | ms | phrase | 8.98362 | 5.67829 | 3.30533 | 36.79% | 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 | 157.466 | 130.314 | 27.152 | 17.24% | Superior | |
90th percentile latency | ms | country_agg_uncached | 217.148 | 147.567 | 69.581 | 32.04% | Superior | |
99th percentile latency | ms | country_agg_uncached | 233.185 | 165.174 | 68.011 | 29.17% | Superior | |
100th percentile latency | ms | country_agg_uncached | 233.227 | 174.015 | 59.212 | 25.39% | Superior | |
50th percentile service time | ms | country_agg_uncached | 156.197 | 129.186 | 27.011 | 17.29% | Superior | |
90th percentile service time | ms | country_agg_uncached | 215.852 | 146.921 | 68.931 | 31.93% | Superior | |
99th percentile service time | ms | country_agg_uncached | 232.177 | 164.579 | 67.598 | 29.11% | Superior | |
100th percentile service time | ms | country_agg_uncached | 232.321 | 172.827 | 59.494 | 25.61% | Superior | |
error rate | % | country_agg_uncached | 0 | 0 | 0 | - | - | |
Aggregation query with cache | Min Throughput | ops/s | country_agg_cached | 100.03 | 100.04 | -0.01 | -0.01% | Superior |
Median Throughput | ops/s | country_agg_cached | 100.05 | 100.05 | 0 | 0.00% | Superior | |
Max Throughput | ops/s | country_agg_cached | 100.08 | 100.08 | 0 | 0.00% | Superior | |
50th percentile latency | ms | country_agg_cached | 2.44457 | 2.29531 | 0.14926 | 6.11% | Superior | |
90th percentile latency | ms | country_agg_cached | 2.97922 | 3.57418 | -0.59496 | -19.97% | Inferior | |
99th percentile latency | ms | country_agg_cached | 3.96393 | 3.91685 | 0.04708 | 1.19% | Superior | |
99.9th percentile latency | ms | country_agg_cached | 5.3294 | 4.19749 | 1.13191 | 21.24% | Superior | |
100th percentile latency | ms | country_agg_cached | 7.9529 | 4.51842 | 3.43448 | 43.19% | Superior | |
50th percentile service time | ms | country_agg_cached | 1.71924 | 1.57861 | 0.14063 | 8.18% | Superior | |
90th percentile service time | ms | country_agg_cached | 1.97892 | 1.89111 | 0.08781 | 4.44% | Superior | |
99th percentile service time | ms | country_agg_cached | 2.22611 | 2.19488 | 0.03123 | 1.40% | Superior | |
99.9th percentile service time | ms | country_agg_cached | 5.0967 | 3.42563 | 1.67107 | 32.79% | Superior | |
100th percentile service time | ms | country_agg_cached | 7.02246 | 4.28971 | 2.73275 | 38.91% | 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.04 | 20.05 | -0.01 | -0.05% | Superior | |
Max Throughput | pages/s | scroll | 20.05 | 20.06 | -0.01 | -0.05% | Superior | |
50th percentile latency | ms | scroll | 576.675 | 538.421 | 38.254 | 6.63% | Superior | |
90th percentile latency | ms | scroll | 585.156 | 543.566 | 41.59 | 7.11% | Superior | |
99th percentile latency | ms | scroll | 598.95 | 582.263 | 16.687 | 2.79% | Superior | |
100th percentile latency | ms | scroll | 602.009 | 584.75 | 17.259 | 2.87% | Superior | |
50th percentile service time | ms | scroll | 575.118 | 537.068 | 38.05 | 6.62% | Superior | |
90th percentile service time | ms | scroll | 583.906 | 542.428 | 41.478 | 7.10% | Superior | |
99th percentile service time | ms | scroll | 597.482 | 580.372 | 17.11 | 2.86% | Superior | |
100th percentile service time | ms | scroll | 600.578 | 583.612 | 16.966 | 2.82% | 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 | 299.685 | 265.631 | 34.054 | 11.36% | Superior | |
90th percentile latency | ms | expression | 416.613 | 287.121 | 129.492 | 31.08% | Superior | |
99th percentile latency | ms | expression | 465.776 | 311.788 | 153.988 | 33.06% | Superior | |
100th percentile latency | ms | expression | 468.083 | 391.745 | 76.338 | 16.31% | Superior | |
50th percentile service time | ms | expression | 298.594 | 264.462 | 34.132 | 11.43% | Superior | |
90th percentile service time | ms | expression | 415.045 | 285.113 | 129.932 | 31.31% | Superior | |
99th percentile service time | ms | expression | 464.598 | 310.991 | 153.607 | 33.06% | Superior | |
100th percentile service time | ms | expression | 467.106 | 390.33 | 76.776 | 16.44% | 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 | 383.485 | 337.96 | 45.525 | 11.87% | Superior | |
90th percentile latency | ms | painless_static | 514.495 | 358.738 | 155.757 | 30.27% | Superior | |
99th percentile latency | ms | painless_static | 561.342 | 375.017 | 186.325 | 33.19% | Superior | |
100th percentile latency | ms | painless_static | 568.066 | 395.417 | 172.649 | 30.39% | Superior | |
50th percentile service time | ms | painless_static | 382.158 | 337.111 | 45.047 | 11.79% | Superior | |
90th percentile service time | ms | painless_static | 513.202 | 357.771 | 155.431 | 30.29% | Superior | |
99th percentile service time | ms | painless_static | 560.61 | 374.121 | 186.489 | 33.27% | Superior | |
100th percentile service time | ms | painless_static | 567.419 | 394.632 | 172.787 | 30.45% | 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 | 377.278 | 334.684 | 42.594 | 11.29% | Superior | |
90th percentile latency | ms | painless_dynamic | 517.496 | 354.406 | 163.09 | 31.52% | Superior | |
99th percentile latency | ms | painless_dynamic | 576.697 | 377.214 | 199.483 | 34.59% | Superior | |
100th percentile latency | ms | painless_dynamic | 580.017 | 381.276 | 198.741 | 34.26% | Superior | |
50th percentile service time | ms | painless_dynamic | 376.339 | 333.654 | 42.685 | 11.34% | Superior | |
90th percentile service time | ms | painless_dynamic | 516.407 | 353.246 | 163.161 | 31.60% | Superior | |
99th percentile service time | ms | painless_dynamic | 575.714 | 375.956 | 199.758 | 34.70% | Superior | |
100th percentile service time | ms | painless_dynamic | 579.642 | 379.75 | 199.892 | 34.49% | 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 | 348.531 | 327.972 | 20.559 | 5.90% | Superior | |
90th percentile latency | ms | decay_geo_gauss_function_score | 398.351 | 336.979 | 61.372 | 15.41% | Superior | |
99th percentile latency | ms | decay_geo_gauss_function_score | 411.483 | 343.562 | 67.921 | 16.51% | Superior | |
100th percentile latency | ms | decay_geo_gauss_function_score | 457.615 | 344.135 | 113.48 | 24.80% | Superior | |
50th percentile service time | ms | decay_geo_gauss_function_score | 346.881 | 326.554 | 20.327 | 5.86% | Superior | |
90th percentile service time | ms | decay_geo_gauss_function_score | 397.08 | 336.053 | 61.027 | 15.37% | Superior | |
99th percentile service time | ms | decay_geo_gauss_function_score | 410.421 | 342.151 | 68.27 | 16.63% | Superior | |
100th percentile service time | ms | decay_geo_gauss_function_score | 455.704 | 342.843 | 112.861 | 24.77% | 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 | 368.275 | 341.152 | 27.123 | 7.36% | Superior | |
90th percentile latency | ms | decay_geo_gauss_script_score | 414.905 | 349.94 | 64.965 | 15.66% | Superior | |
99th percentile latency | ms | decay_geo_gauss_script_score | 468.888 | 354.76 | 114.128 | 24.34% | Superior | |
100th percentile latency | ms | decay_geo_gauss_script_score | 477.25 | 364.169 | 113.081 | 23.69% | Superior | |
50th percentile service time | ms | decay_geo_gauss_script_score | 366.945 | 339.967 | 26.978 | 7.35% | Superior | |
90th percentile service time | ms | decay_geo_gauss_script_score | 413.609 | 348.493 | 65.116 | 15.74% | Superior | |
99th percentile service time | ms | decay_geo_gauss_script_score | 467.627 | 353.559 | 114.068 | 24.39% | Superior | |
100th percentile service time | ms | decay_geo_gauss_script_score | 475.367 | 362.748 | 112.619 | 23.69% | 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 | 139.661 | 120.538 | 19.123 | 13.69% | Superior | |
90th percentile latency | ms | field_value_function_score | 183.675 | 137.702 | 45.973 | 25.03% | Superior | |
99th percentile latency | ms | field_value_function_score | 197.653 | 147.851 | 49.802 | 25.20% | Superior | |
100th percentile latency | ms | field_value_function_score | 202.345 | 169.961 | 32.384 | 16.00% | Superior | |
50th percentile service time | ms | field_value_function_score | 138.423 | 119.159 | 19.264 | 13.92% | Superior | |
90th percentile service time | ms | field_value_function_score | 182.404 | 136.338 | 46.066 | 25.25% | Superior | |
99th percentile service time | ms | field_value_function_score | 196.734 | 146.981 | 49.753 | 25.29% | Superior | |
100th percentile service time | ms | field_value_function_score | 201.442 | 168.964 | 32.478 | 16.12% | 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 | 188.952 | 168.069 | 20.883 | 11.05% | Superior | |
90th percentile latency | ms | field_value_script_score | 264.095 | 178.933 | 85.162 | 32.25% | Superior | |
99th percentile latency | ms | field_value_script_score | 271.153 | 196.982 | 74.171 | 27.35% | Superior | |
100th percentile latency | ms | field_value_script_score | 271.901 | 198.722 | 73.179 | 26.91% | Superior | |
50th percentile service time | ms | field_value_script_score | 187.218 | 166.827 | 20.391 | 10.89% | Superior | |
90th percentile service time | ms | field_value_script_score | 263.207 | 177.869 | 85.338 | 32.42% | Superior | |
99th percentile service time | ms | field_value_script_score | 269.578 | 195.586 | 73.992 | 27.45% | Superior | |
100th percentile service time | ms | field_value_script_score | 270.138 | 197.054 | 73.084 | 27.05% | 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 | 265.007 | 241.322 | 23.685 | 8.94% | Superior | |
90th percentile latency | ms | large_terms | 296.009 | 252.637 | 43.372 | 14.65% | Superior | |
99th percentile latency | ms | large_terms | 310.358 | 265.807 | 44.551 | 14.35% | Superior | |
100th percentile latency | ms | large_terms | 311.049 | 272.611 | 38.438 | 12.36% | Superior | |
50th percentile service time | ms | large_terms | 256.372 | 233.129 | 23.243 | 9.07% | Superior | |
90th percentile service time | ms | large_terms | 287.851 | 244.494 | 43.357 | 15.06% | Superior | |
99th percentile service time | ms | large_terms | 301.827 | 258.894 | 42.933 | 14.22% | Superior | |
100th percentile service time | ms | large_terms | 302.251 | 264.352 | 37.899 | 12.54% | 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 | 268.135 | 233.192 | 34.943 | 13.03% | Superior | |
90th percentile latency | ms | large_filtered_terms | 304.158 | 241.102 | 63.056 | 20.73% | Superior | |
99th percentile latency | ms | large_filtered_terms | 351.209 | 251.835 | 99.374 | 28.29% | Superior | |
100th percentile latency | ms | large_filtered_terms | 352.003 | 260.27 | 91.733 | 26.06% | Superior | |
50th percentile service time | ms | large_filtered_terms | 259.546 | 225.052 | 34.494 | 13.29% | Superior | |
90th percentile service time | ms | large_filtered_terms | 295.721 | 233.16 | 62.561 | 21.16% | Superior | |
99th percentile service time | ms | large_filtered_terms | 342.342 | 243.603 | 98.739 | 28.84% | Superior | |
100th percentile service time | ms | large_filtered_terms | 343.378 | 252.129 | 91.249 | 26.57% | 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 | 270.041 | 235.179 | 34.862 | 12.91% | Superior | |
90th percentile latency | ms | large_prohibited_terms | 310.351 | 241.076 | 69.275 | 22.32% | Superior | |
99th percentile latency | ms | large_prohibited_terms | 347.414 | 255.983 | 91.431 | 26.32% | Superior | |
100th percentile latency | ms | large_prohibited_terms | 349.499 | 259.046 | 90.453 | 25.88% | Superior | |
50th percentile service time | ms | large_prohibited_terms | 261.734 | 227.487 | 34.247 | 13.08% | Superior | |
90th percentile service time | ms | large_prohibited_terms | 302.279 | 233.792 | 68.487 | 22.66% | Superior | |
99th percentile service time | ms | large_prohibited_terms | 339.278 | 248.53 | 90.748 | 26.75% | Superior | |
100th percentile service time | ms | large_prohibited_terms | 340.817 | 251.083 | 89.734 | 26.33% | 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 | 58.5828 | 48.387 | 10.1958 | 17.40% | Superior | |
90th percentile latency | ms | desc_sort_population | 77.9981 | 63.073 | 14.9251 | 19.14% | Superior | |
99th percentile latency | ms | desc_sort_population | 80.8863 | 71.7498 | 9.1365 | 11.30% | Superior | |
100th percentile latency | ms | desc_sort_population | 83.1661 | 83.3593 | -0.1932 | -0.23% | Inferior | |
50th percentile service time | ms | desc_sort_population | 57.1212 | 47.0436 | 10.0776 | 17.64% | Superior | |
90th percentile service time | ms | desc_sort_population | 76.7082 | 61.3731 | 15.3351 | 19.99% | Superior | |
99th percentile service time | ms | desc_sort_population | 79.2907 | 70.4811 | 8.8096 | 11.11% | Superior | |
100th percentile service time | ms | desc_sort_population | 81.6364 | 81.6517 | -0.0153 | -0.02% | 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 | 62.4328 | 49.2469 | 13.1859 | 21.12% | Superior | |
90th percentile latency | ms | asc_sort_population | 79.8441 | 67.5894 | 12.2547 | 15.35% | Superior | |
99th percentile latency | ms | asc_sort_population | 83.9411 | 84.6384 | -0.6973 | -0.83% | Inferior | |
100th percentile latency | ms | asc_sort_population | 84.3925 | 85.8124 | -1.4199 | -1.68% | Inferior | |
50th percentile service time | ms | asc_sort_population | 61.0637 | 47.8438 | 13.2199 | 21.65% | Superior | |
90th percentile service time | ms | asc_sort_population | 78.4101 | 66.0821 | 12.328 | 15.72% | Superior | |
99th percentile service time | ms | asc_sort_population | 82.2652 | 83.6026 | -1.3374 | -1.63% | Inferior | |
100th percentile service time | ms | asc_sort_population | 82.5616 | 84.2175 | -1.6559 | -2.01% | Inferior | |
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 | 88.1871 | 99.1943 | -11.0072 | -12.48% | Inferior | |
90th percentile latency | ms | asc_sort_with_after_population | 127.995 | 86.0298 | 41.9652 | 32.79% | Superior | |
99th percentile latency | ms | asc_sort_with_after_population | 131.171 | 102.268 | 28.903 | 22.03% | Superior | |
100th percentile latency | ms | asc_sort_with_after_population | 132.181 | 106.33 | 25.851 | 19.56% | Superior | |
50th percentile service time | ms | asc_sort_with_after_population | 87.132 | 68.2272 | 18.9048 | 21.70% | Superior | |
90th percentile service time | ms | asc_sort_with_after_population | 126.818 | 84.685 | 42.133 | 33.22% | Superior | |
99th percentile service time | ms | asc_sort_with_after_population | 129.453 | 101.133 | 28.32 | 21.88% | Superior | |
100th percentile service time | ms | asc_sort_with_after_population | 130.452 | 105.094 | 25.358 | 19.44% | 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 | 7.4659 | 5.53008 | 1.93582 | 25.93% | Superior | |
90th percentile latency | ms | desc_sort_geonameid | 8.26766 | 6.20276 | 2.0649 | 24.98% | Superior | |
99th percentile latency | ms | desc_sort_geonameid | 8.72369 | 6.67673 | 2.04696 | 23.46% | Superior | |
100th percentile latency | ms | desc_sort_geonameid | 8.79956 | 6.95103 | 1.84853 | 21.01% | Superior | |
50th percentile service time | ms | desc_sort_geonameid | 6.59986 | 4.61231 | 1.98755 | 30.12% | Superior | |
90th percentile service time | ms | desc_sort_geonameid | 7.24539 | 5.45982 | 1.78557 | 24.64% | Superior | |
99th percentile service time | ms | desc_sort_geonameid | 7.57925 | 5.65304 | 1.92621 | 25.41% | Superior | |
100th percentile service time | ms | desc_sort_geonameid | 7.64471 | 5.65578 | 1.98893 | 26.02% | 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.01 | 6.02 | -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 | 89.4587 | 56.5947 | 32.864 | 36.74% | Superior | |
90th percentile latency | ms | desc_sort_with_after_geonameid | 119.777 | 79.6503 | 40.1267 | 33.50% | Superior | |
99th percentile latency | ms | desc_sort_with_after_geonameid | 123.271 | 87.7773 | 35.4937 | 28.79% | Superior | |
100th percentile latency | ms | desc_sort_with_after_geonameid | 123.628 | 89.3947 | 34.2333 | 27.69% | Superior | |
50th percentile service time | ms | desc_sort_with_after_geonameid | 88.512 | 55.4855 | 33.0265 | 37.31% | Superior | |
90th percentile service time | ms | desc_sort_with_after_geonameid | 118.72 | 79.2349 | 39.4851 | 33.26% | Superior | |
99th percentile service time | ms | desc_sort_with_after_geonameid | 122.79 | 87.3803 | 35.4097 | 28.84% | Superior | |
100th percentile service time | ms | desc_sort_with_after_geonameid | 122.791 | 88.3606 | 34.4304 | 28.04% | 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.80593 | 5.19317 | 0.61276 | 10.55% | Superior | |
90th percentile latency | ms | asc_sort_geonameid | 6.55438 | 5.74438 | 0.81 | 12.36% | Superior | |
99th percentile latency | ms | asc_sort_geonameid | 7.36432 | 6.22846 | 1.13586 | 15.42% | Superior | |
100th percentile latency | ms | asc_sort_geonameid | 7.49672 | 11.6377 | -4.14098 | -55.24% | Inferior | |
50th percentile service time | ms | asc_sort_geonameid | 4.91916 | 4.35586 | 0.5633 | 11.45% | Superior | |
90th percentile service time | ms | asc_sort_geonameid | 5.61126 | 4.92152 | 0.68974 | 12.29% | Superior | |
99th percentile service time | ms | asc_sort_geonameid | 6.12285 | 5.38949 | 0.73336 | 11.98% | Superior | |
100th percentile service time | ms | asc_sort_geonameid | 6.51222 | 10.6436 | -4.13138 | -63.44% | 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.01 | 6.02 | -0.01 | -0.17% | Superior | |
Max Throughput | ops/s | asc_sort_with_after_geonameid | 6.01 | 6.02 | -0.01 | -0.17% | Superior | |
50th percentile latency | ms | asc_sort_with_after_geonameid | 70.994 | 58.1403 | 12.8537 | 18.11% | Superior | |
90th percentile latency | ms | asc_sort_with_after_geonameid | 104.817 | 76.5695 | 28.2475 | 26.95% | Superior | |
99th percentile latency | ms | asc_sort_with_after_geonameid | 108.797 | 91.6296 | 17.1674 | 15.78% | Superior | |
100th percentile latency | ms | asc_sort_with_after_geonameid | 108.929 | 91.6364 | 17.2926 | 15.88% | Superior | |
50th percentile service time | ms | asc_sort_with_after_geonameid | 69.7056 | 57.1683 | 12.5373 | 17.99% | Superior | |
90th percentile service time | ms | asc_sort_with_after_geonameid | 103.875 | 75.7573 | 28.1177 | 27.07% | Superior | |
99th percentile service time | ms | asc_sort_with_after_geonameid | 107.828 | 91.1533 | 16.6747 | 15.46% | Superior | |
100th percentile service time | ms | asc_sort_with_after_geonameid | 108.539 | 91.3662 | 17.1728 | 15.82% | Superior | |
error rate | % | asc_sort_with_after_geonameid | 0 | 0 | 0 | - | - |
Was this page helpful?