Introduction
This is a report for the insert benchmark with 800M docs and 1 client(s). It is generated by scripts (bash, awk, sed) and Tufte might not be impressed. An overview of the insert benchmark is here and a short update is here. Below, by DBMS, I mean DBMS+version.config. An example is my8020.c10b40 where my means MySQL, 8020 is version 8.0.20 and c10b40 is the name for the configuration file.
The test server has 8 AMD cores, 16G RAM and an NVMe SSD. It is described here as the Beelink. The benchmark was run with 1 client and there were 1 or 3 connections per client (1 for queries or inserts without rate limits, 1+1 for rate limited inserts+deletes). It uses 1 table. It loads 800M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 5m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 1800s each that do queries as fast as possible with 100,100,500,500,1000,1000 inserts/s and the same for deletes/s per client concurrent with the queries. The database is cached in memory. Clients and the DBMS share one server. The per-database configs are in the per-database subdirectories here.
The tested DBMS are:
- pg9023_def.cx9a2_bee - Postgres 9.0.23, x9a2 config
- pg9124_def.cx9a2_bee - Postgres 9.1.24, x9a2 config
- pg9224_def.cx9a2_bee - Postgres 9.2.24, x9a2 config
- pg9325_def.cx9a2_bee - Postgres 9.3.25, x9a2 config
- pg9426_def.cx9a2_bee - Postgres 9.4.26, x9a2 config
- pg9525_def.cx9a2_bee - Postgres 9.5.25, x9a2 config
- pg9624_def.cx9a2_bee - Postgres 9.6.24, x9a2 config
- pg1023_def.cx9a2_bee - Postgres 10.23, x9a2 config
- pg1122_def.cx9a2_bee - Postgres 11.22, x9a2 config
- pg1217_def.cx9a2_bee - Postgres 12.17, x9a2 config
- pg1313_def.cx9a2_bee - Postgres 13.13, x9a2 config
- pg1410_def.cx9a2_bee - Postgres 14.10, x9a2 config
- pg155_def.cx9a2_bee - Postgres 15.5, x9a2 config
- pg161_def.cx9a2_bee - Postgres 16.1, x9a2 config
Contents
- Summary
- l.i0: load without secondary indexes
- l.x: create secondary indexes
- l.i1: continue load after secondary indexes created with 50 inserts per transaction
- l.i2: continue load after secondary indexes created with 5 inserts per transaction
- qr100.L1: range queries with 100 insert/s per client
- qp100.L2: point queries with 100 insert/s per client
- qr500.L3: range queries with 500 insert/s per client
- qp500.L4: point queries with 500 insert/s per client
- qr1000.L5: range queries with 1000 insert/s per client
- qp1000.L6: point queries with 1000 insert/s per client
Summary
The numbers are inserts/s for l.i0, l.i1 and l.i2, indexed docs (or rows) /s for l.x and queries/s for qr100, qp100 thru qr1000, qp1000" The values are the average rate over the entire test for inserts (IPS) and queries (QPS). The range of values for IPS and QPS is split into 3 parts: bottom 25%, middle 50%, top 25%. Values in the bottom 25% have a red background, values in the top 25% have a green background and values in the middle have no color. A gray background is used for values that can be ignored because the DBMS did not sustain the target insert rate. Red backgrounds are not used when the minimum value is within 80% of the max value.
| dbms | l.i0 | l.x | l.i1 | l.i2 | qr100 | qp100 | qr500 | qp500 | qr1000 | qp1000 |
|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 62126 | 85034 | 1131 | 55 | 7315 | 401 | 6601 | 383 | 5134 | 365 |
| pg9124_def.cx9a2_bee | 64072 | 82043 | 1188 | 58 | 7588 | 393 | 7010 | 378 | 5386 | 357 |
| pg9224_def.cx9a2_bee | 62402 | 85671 | 1060 | 51 | 8141 | 396 | 7363 | 367 | 5399 | 358 |
| pg9325_def.cx9a2_bee | 64031 | 83403 | 1104 | 53 | 8073 | 393 | 7389 | 363 | 5584 | 348 |
| pg9426_def.cx9a2_bee | 65035 | 94073 | 1118 | 54 | 8366 | 396 | 7407 | 371 | 5614 | 349 |
| pg9525_def.cx9a2_bee | 65248 | 112724 | 1181 | 56 | 8227 | 400 | 7375 | 379 | 5519 | 358 |
| pg9624_def.cx9a2_bee | 62957 | 126203 | 1159 | 54 | 8203 | 396 | 7595 | 381 | 5626 | 369 |
| pg1023_def.cx9a2_bee | 63286 | 186003 | 1139 | 52 | 7904 | 395 | 7342 | 379 | 5364 | 368 |
| pg1122_def.cx9a2_bee | 74543 | 179816 | 1136 | 53 | 8552 | 395 | 7761 | 380 | 5737 | 369 |
| pg1217_def.cx9a2_bee | 72747 | 182774 | 2243 | 115 | 8445 | 397 | 8067 | 385 | 7162 | 362 |
| pg1313_def.cx9a2_bee | 75365 | 183655 | 2116 | 109 | 8338 | 394 | 8102 | 381 | 7090 | 360 |
| pg1410_def.cx9a2_bee | 73394 | 185057 | 2099 | 107 | 5823 | 392 | 5918 | 371 | 5139 | 365 |
| pg155_def.cx9a2_bee | 75529 | 192678 | 2040 | 103 | 5855 | 391 | 5847 | 369 | 5156 | 365 |
| pg161_def.cx9a2_bee | 75779 | 197287 | 2065 | 103 | 5939 | 391 | 5861 | 369 | 5160 | 365 |
This table has relative throughput, throughput for the DBMS relative to the DBMS in the first line, using the absolute throughput from the previous table. Values less than 0.95 have a yellow background. Values greater than 1.05 have a blue background.
| dbms | l.i0 | l.x | l.i1 | l.i2 | qr100 | qp100 | qr500 | qp500 | qr1000 | qp1000 |
|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| pg9124_def.cx9a2_bee | 1.03 | 0.96 | 1.05 | 1.05 | 1.04 | 0.98 | 1.06 | 0.99 | 1.05 | 0.98 |
| pg9224_def.cx9a2_bee | 1.00 | 1.01 | 0.94 | 0.93 | 1.11 | 0.99 | 1.12 | 0.96 | 1.05 | 0.98 |
| pg9325_def.cx9a2_bee | 1.03 | 0.98 | 0.98 | 0.96 | 1.10 | 0.98 | 1.12 | 0.95 | 1.09 | 0.95 |
| pg9426_def.cx9a2_bee | 1.05 | 1.11 | 0.99 | 0.98 | 1.14 | 0.99 | 1.12 | 0.97 | 1.09 | 0.96 |
| pg9525_def.cx9a2_bee | 1.05 | 1.33 | 1.04 | 1.02 | 1.12 | 1.00 | 1.12 | 0.99 | 1.07 | 0.98 |
| pg9624_def.cx9a2_bee | 1.01 | 1.48 | 1.02 | 0.98 | 1.12 | 0.99 | 1.15 | 0.99 | 1.10 | 1.01 |
| pg1023_def.cx9a2_bee | 1.02 | 2.19 | 1.01 | 0.95 | 1.08 | 0.99 | 1.11 | 0.99 | 1.04 | 1.01 |
| pg1122_def.cx9a2_bee | 1.20 | 2.11 | 1.00 | 0.96 | 1.17 | 0.99 | 1.18 | 0.99 | 1.12 | 1.01 |
| pg1217_def.cx9a2_bee | 1.17 | 2.15 | 1.98 | 2.09 | 1.15 | 0.99 | 1.22 | 1.01 | 1.40 | 0.99 |
| pg1313_def.cx9a2_bee | 1.21 | 2.16 | 1.87 | 1.98 | 1.14 | 0.98 | 1.23 | 0.99 | 1.38 | 0.99 |
| pg1410_def.cx9a2_bee | 1.18 | 2.18 | 1.86 | 1.95 | 0.80 | 0.98 | 0.90 | 0.97 | 1.00 | 1.00 |
| pg155_def.cx9a2_bee | 1.22 | 2.27 | 1.80 | 1.87 | 0.80 | 0.98 | 0.89 | 0.96 | 1.00 | 1.00 |
| pg161_def.cx9a2_bee | 1.22 | 2.32 | 1.83 | 1.87 | 0.81 | 0.98 | 0.89 | 0.96 | 1.01 | 1.00 |
This lists the average rate of inserts/s for the tests that do inserts concurrent with queries. For such tests the query rate is listed in the table above. The read+write tests are setup so that the insert rate should match the target rate every second. Cells that are not at least 95% of the target have a red background to indicate a failure to satisfy the target.
| dbms | qr100.L1 | qp100.L2 | qr500.L3 | qp500.L4 | qr1000.L5 | qp1000.L6 |
|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 100 | 100 | 499 | 499 | 796 | 503 |
| pg9124_def.cx9a2_bee | 100 | 100 | 499 | 499 | 825 | 526 |
| pg9224_def.cx9a2_bee | 100 | 100 | 499 | 499 | 742 | 467 |
| pg9325_def.cx9a2_bee | 100 | 100 | 499 | 499 | 767 | 483 |
| pg9426_def.cx9a2_bee | 100 | 100 | 499 | 498 | 779 | 491 |
| pg9525_def.cx9a2_bee | 100 | 100 | 499 | 499 | 797 | 506 |
| pg9624_def.cx9a2_bee | 100 | 100 | 499 | 499 | 780 | 495 |
| pg1023_def.cx9a2_bee | 100 | 100 | 499 | 499 | 760 | 481 |
| pg1122_def.cx9a2_bee | 100 | 100 | 499 | 499 | 767 | 485 |
| pg1217_def.cx9a2_bee | 100 | 100 | 498 | 499 | 998 | 979 |
| pg1313_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 954 |
| pg1410_def.cx9a2_bee | 100 | 100 | 499 | 499 | 611 | 494 |
| pg155_def.cx9a2_bee | 100 | 100 | 499 | 499 | 588 | 476 |
| pg161_def.cx9a2_bee | 100 | 100 | 499 | 499 | 590 | 478 |
| target | 100 | 100 | 500 | 500 | 1000 | 1000 |
l.i0
l.i0: load without secondary indexes. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 99.079 | 0.721 | 0.200 | 0.051 | |||||||
| pg9124_def.cx9a2_bee | 99.892 | 0.108 | nonzero | 0.058 | |||||||
| pg9224_def.cx9a2_bee | 99.892 | 0.098 | 0.011 | nonzero | 0.083 | ||||||
| pg9325_def.cx9a2_bee | 99.884 | 0.101 | 0.015 | nonzero | 0.076 | ||||||
| pg9426_def.cx9a2_bee | 99.884 | 0.100 | 0.016 | nonzero | 0.072 | ||||||
| pg9525_def.cx9a2_bee | 99.998 | 0.001 | nonzero | 0.060 | |||||||
| pg9624_def.cx9a2_bee | 99.999 | 0.001 | nonzero | 0.056 | |||||||
| pg1023_def.cx9a2_bee | 99.999 | 0.001 | nonzero | 0.056 | |||||||
| pg1122_def.cx9a2_bee | 99.999 | 0.001 | nonzero | 0.055 | |||||||
| pg1217_def.cx9a2_bee | 99.999 | 0.001 | nonzero | 0.057 | |||||||
| pg1313_def.cx9a2_bee | 99.998 | 0.002 | 0.001 | 0.057 | |||||||
| pg1410_def.cx9a2_bee | 99.998 | 0.002 | 0.001 | nonzero | 0.085 | ||||||
| pg155_def.cx9a2_bee | 99.997 | 0.003 | 0.001 | nonzero | 0.067 | ||||||
| pg161_def.cx9a2_bee | 99.998 | 0.001 | nonzero | 0.056 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 62126 0 28 0.2 127.2 20.9 0.000 0.004 0.002 0.345 6631 20.5 0.107 26 76.5 76.7 0.3 0.051 62729 57379 pg9023_def.cx9a2_bee 64072 0 29 0.2 129.7 21.6 0.000 0.004 0.002 0.345 6823 21.5 0.106 27 76.5 76.7 10.2 0.058 65516 58834 pg9124_def.cx9a2_bee 62402 0 28 0.2 686.0 21.1 0.000 0.004 0.011 0.346 8367 22.1 0.134 28 76.5 76.7 0.1 0.083 63726 56983 pg9224_def.cx9a2_bee 64031 0 28 0.2 627.6 22.1 0.000 0.004 0.010 0.354 8383 21.7 0.131 27 76.5 76.7 0.1 0.076 65390 57929 pg9325_def.cx9a2_bee 65035 0 29 0.2 631.3 22.5 0.000 0.004 0.010 0.354 8457 22.4 0.130 28 76.5 76.8 0.1 0.072 65251 62131 pg9426_def.cx9a2_bee 65248 0 30 0.2 624.0 27.1 0.000 0.004 0.010 0.425 8448 22.5 0.129 28 76.5 116.6 9.5 0.060 65346 63656 pg9525_def.cx9a2_bee 62957 0 28 0.2 120.1 26.1 0.000 0.004 0.002 0.425 7942 23.1 0.126 29 76.5 116.6 9.7 0.056 63129 61315 pg9624_def.cx9a2_bee 63286 0 29 0.2 120.7 26.3 0.000 0.004 0.002 0.425 7838 23.0 0.124 29 76.5 116.6 9.7 0.056 63429 61730 pg1023_def.cx9a2_bee 74543 0 32 0.3 137.2 30.1 0.000 0.004 0.002 0.413 9137 23.1 0.123 25 76.5 110.3 9.0 0.055 74816 72618 pg1122_def.cx9a2_bee 72747 0 33 0.3 133.8 29.4 0.000 0.004 0.002 0.413 8929 23.1 0.123 25 76.5 109.4 8.9 0.057 72919 70878 pg1217_def.cx9a2_bee 75365 0 32 0.3 103.8 30.6 0.000 0.003 0.001 0.416 9229 23.3 0.122 25 76.5 112.9 1.5 0.057 75518 73413 pg1313_def.cx9a2_bee 73394 0 32 0.3 103.8 30.3 0.000 0.004 0.001 0.422 8973 22.8 0.122 25 76.5 116.6 2.5 0.085 73619 71420 pg1410_def.cx9a2_bee 75529 0 32 0.3 109.3 31.2 0.000 0.003 0.001 0.423 9161 23.1 0.121 24 76.5 116.6 2.7 0.067 75715 73695 pg155_def.cx9a2_bee 75779 0 31 0.2 107.6 31.1 0.000 0.003 0.001 0.421 9198 23.0 0.121 24 76.5 116.6 1.7 0.056 75962 73918 pg161_def.cx9a2_bee
l.x
l.x: create secondary indexes.
Average throughput:
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 85034 0 358 42.8 179.8 48.5 0.004 0.516 0.002 0.584 384 12.3 0.005 12 153.8 154.0 8.9 0.012 NA NA pg9023_def.cx9a2_bee 82043 0 344 41.3 172.2 46.8 0.004 0.516 0.002 0.584 393 12.4 0.005 12 153.8 154.0 7.6 0.013 NA NA pg9124_def.cx9a2_bee 85671 0 362 43.1 180.4 48.9 0.004 0.516 0.002 0.584 354 12.5 0.004 12 153.8 154.0 6.4 0.004 NA NA pg9224_def.cx9a2_bee 83403 0 370 42.1 189.8 53.3 0.004 0.517 0.002 0.655 364 12.5 0.004 12 153.8 154.0 7.7 0.004 NA NA pg9325_def.cx9a2_bee 94073 0 260 31.9 167.3 43.3 0.003 0.347 0.002 0.472 288 12.5 0.003 11 153.8 154.0 10.3 0.004 NA NA pg9426_def.cx9a2_bee 112724 0 312 38.2 199.4 52.5 0.003 0.347 0.002 0.477 274 12.7 0.002 9 153.8 193.8 10.3 0.004 NA NA pg9525_def.cx9a2_bee 126203 0 393 48.1 277.4 64.1 0.003 0.390 0.002 0.520 305 12.8 0.002 8 153.8 193.8 10.3 0.003 NA NA pg9624_def.cx9a2_bee 186003 0 561 69.2 402.1 92.8 0.003 0.381 0.002 0.511 461 12.8 0.002 6 153.8 193.8 10.3 0.005 NA NA pg1023_def.cx9a2_bee 179816 0 541 66.9 388.3 91.7 0.003 0.381 0.002 0.522 455 12.7 0.003 6 153.8 193.8 10.3 0.006 NA NA pg1122_def.cx9a2_bee 182774 0 552 68.0 413.7 93.1 0.003 0.381 0.002 0.521 459 12.7 0.003 6 153.8 193.8 10.3 0.004 NA NA pg1217_def.cx9a2_bee 183655 0 545 67.6 185.2 67.2 0.003 0.377 0.001 0.374 374 12.5 0.002 5 153.6 190.0 10.2 0.005 NA NA pg1313_def.cx9a2_bee 185057 0 549 68.1 183.6 67.4 0.003 0.377 0.001 0.373 382 12.4 0.002 5 153.6 193.7 10.2 0.006 NA NA pg1410_def.cx9a2_bee 192678 0 584 72.5 191.2 71.8 0.003 0.385 0.001 0.381 402 12.4 0.002 5 153.6 193.7 10.2 0.004 NA NA pg155_def.cx9a2_bee 197287 0 598 74.2 203.4 73.6 0.003 0.385 0.001 0.382 404 12.5 0.002 5 153.6 193.7 10.3 0.006 NA NA pg161_def.cx9a2_bee
l.i1
l.i1: continue load after secondary indexes created with 50 inserts per transaction. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 2.570 | 97.282 | 0.147 | 0.228 | |||||||
| pg9124_def.cx9a2_bee | 7.337 | 92.578 | 0.085 | 0.199 | |||||||
| pg9224_def.cx9a2_bee | 4.617 | 95.270 | 0.112 | 0.231 | |||||||
| pg9325_def.cx9a2_bee | 3.208 | 96.761 | 0.031 | 0.098 | |||||||
| pg9426_def.cx9a2_bee | 4.001 | 95.975 | 0.024 | 0.078 | |||||||
| pg9525_def.cx9a2_bee | 84.154 | 15.764 | 0.083 | 0.103 | |||||||
| pg9624_def.cx9a2_bee | 95.877 | 4.120 | 0.003 | 0.124 | |||||||
| pg1023_def.cx9a2_bee | 94.935 | 5.065 | 0.056 | ||||||||
| pg1122_def.cx9a2_bee | 93.856 | 6.143 | 0.001 | 0.117 | |||||||
| pg1217_def.cx9a2_bee | 90.531 | 9.467 | 0.001 | 0.072 | |||||||
| pg1313_def.cx9a2_bee | 86.225 | 13.774 | 0.001 | 0.066 | |||||||
| pg1410_def.cx9a2_bee | 87.093 | 12.907 | 0.063 | ||||||||
| pg155_def.cx9a2_bee | 89.821 | 10.179 | 0.064 | ||||||||
| pg161_def.cx9a2_bee | 93.510 | 6.490 | 0.058 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 0.334 | 2.948 | 12.296 | 63.504 | 20.919 | 0.093 | |||||
| pg9124_def.cx9a2_bee | 0.363 | 3.069 | 13.720 | 65.692 | 17.156 | 0.082 | |||||
| pg9224_def.cx9a2_bee | 0.314 | 2.708 | 11.934 | 58.421 | 26.624 | 0.092 | |||||
| pg9325_def.cx9a2_bee | 0.398 | 2.789 | 12.415 | 60.708 | 23.691 | 0.089 | |||||
| pg9426_def.cx9a2_bee | 0.481 | 2.855 | 13.969 | 59.656 | 23.039 | 0.090 | |||||
| pg9525_def.cx9a2_bee | 0.513 | 2.562 | 16.344 | 60.093 | 20.489 | 0.085 | |||||
| pg9624_def.cx9a2_bee | 0.361 | 2.826 | 15.565 | 58.294 | 22.954 | 0.123 | |||||
| pg1023_def.cx9a2_bee | 0.248 | 2.711 | 15.431 | 57.009 | 24.601 | 0.089 | |||||
| pg1122_def.cx9a2_bee | 0.316 | 2.488 | 15.757 | 56.876 | 24.562 | 0.110 | |||||
| pg1217_def.cx9a2_bee | 0.004 | 0.431 | 6.149 | 35.110 | 58.306 | 0.040 | |||||
| pg1313_def.cx9a2_bee | 0.003 | 0.446 | 6.054 | 32.001 | 61.496 | 0.043 | |||||
| pg1410_def.cx9a2_bee | 0.004 | 0.685 | 5.170 | 32.216 | 61.925 | 0.048 | |||||
| pg155_def.cx9a2_bee | 0.616 | 5.410 | 30.289 | 63.685 | 0.046 | ||||||
| pg161_def.cx9a2_bee | 0.670 | 5.299 | 30.378 | 63.654 | 0.046 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1131 0 1880 15.0 2392.7 37.7 1.662 13.563 2.116 34.166 4909 14.6 4.340 1033 154.5 154.6 9.9 0.228 899 599 pg9023_def.cx9a2_bee 1188 0 1974 15.7 2514.3 39.6 1.663 13.570 2.117 34.162 5106 14.8 4.300 997 154.5 154.7 10.0 0.199 949 649 pg9124_def.cx9a2_bee 1060 0 1762 14.0 2286.8 35.4 1.662 13.564 2.157 34.147 4864 14.7 4.589 1109 154.5 154.7 10.0 0.231 849 549 pg9224_def.cx9a2_bee 1104 0 1818 14.5 2387.1 36.9 1.647 13.432 2.163 34.255 4894 14.8 4.435 1073 154.5 154.7 10.2 0.098 850 599 pg9325_def.cx9a2_bee 1118 0 1839 14.6 2413.5 37.3 1.644 13.401 2.158 34.190 4880 14.8 4.364 1059 154.5 154.7 10.2 0.078 899 599 pg9426_def.cx9a2_bee 1181 0 1942 15.4 1998.1 30.0 1.645 13.327 1.692 25.980 4880 14.0 4.134 949 154.5 194.5 10.0 0.103 899 599 pg9525_def.cx9a2_bee 1159 0 1906 15.1 1944.4 29.6 1.644 13.324 1.677 26.178 4813 14.4 4.152 994 154.5 194.5 9.9 0.124 849 599 pg9624_def.cx9a2_bee 1139 0 1874 14.8 1882.3 29.1 1.645 13.334 1.652 26.165 4704 14.3 4.130 1004 154.5 194.5 9.1 0.056 849 599 pg1023_def.cx9a2_bee 1136 0 1875 14.8 1882.9 28.0 1.651 13.379 1.657 25.281 4712 14.4 4.148 1014 154.5 194.5 9.8 0.117 849 599 pg1122_def.cx9a2_bee 2243 0 3684 29.2 3691.4 53.3 1.642 13.317 1.645 24.344 8979 15.7 4.002 560 154.4 194.5 9.5 0.072 1948 1298 pg1217_def.cx9a2_bee 2116 0 3524 27.9 3589.0 52.6 1.665 13.503 1.696 25.447 8540 15.6 4.035 590 154.3 194.3 9.3 0.066 1798 1198 pg1313_def.cx9a2_bee 2099 0 3491 27.6 3554.0 51.5 1.664 13.487 1.693 25.112 8309 15.1 3.959 576 154.3 194.3 9.5 0.063 1798 1198 pg1410_def.cx9a2_bee 2040 0 3395 26.9 3446.1 49.9 1.664 13.489 1.690 25.042 7972 15.0 3.909 588 154.3 194.3 9.8 0.064 1699 1148 pg155_def.cx9a2_bee 2065 0 3450 27.3 3485.0 50.9 1.671 13.541 1.688 25.262 8037 15.2 3.892 589 154.3 194.3 10.1 0.058 1698 1149 pg161_def.cx9a2_bee
l.i2
l.i2: continue load after secondary indexes created with 5 inserts per transaction. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 83.459 | 16.496 | 0.045 | 0.050 | |||||||
| pg9124_def.cx9a2_bee | 84.408 | 15.590 | 0.002 | 0.036 | |||||||
| pg9224_def.cx9a2_bee | 85.043 | 14.957 | 0.001 | 0.019 | |||||||
| pg9325_def.cx9a2_bee | 89.076 | 10.924 | 0.001 | 0.016 | |||||||
| pg9426_def.cx9a2_bee | 92.674 | 7.324 | 0.002 | 0.033 | |||||||
| pg9525_def.cx9a2_bee | 0.003 | 98.201 | 1.795 | 0.001 | 0.017 | ||||||
| pg9624_def.cx9a2_bee | 0.002 | 94.686 | 5.300 | 0.013 | 0.029 | ||||||
| pg1023_def.cx9a2_bee | 0.001 | 94.030 | 5.957 | 0.013 | 0.039 | ||||||
| pg1122_def.cx9a2_bee | 0.006 | 93.420 | 6.561 | 0.013 | 0.027 | ||||||
| pg1217_def.cx9a2_bee | 0.003 | 97.033 | 2.955 | 0.009 | 0.021 | ||||||
| pg1313_def.cx9a2_bee | 0.003 | 98.108 | 1.880 | 0.009 | 0.027 | ||||||
| pg1410_def.cx9a2_bee | 0.007 | 99.510 | 0.471 | 0.012 | 0.034 | ||||||
| pg155_def.cx9a2_bee | 0.003 | 98.466 | 1.515 | 0.015 | 0.034 | ||||||
| pg161_def.cx9a2_bee | 0.005 | 98.938 | 1.044 | 0.013 | 0.032 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 100.000 | 0.183 | |||||||||
| pg9124_def.cx9a2_bee | 100.000 | 0.176 | |||||||||
| pg9224_def.cx9a2_bee | 100.000 | 0.187 | |||||||||
| pg9325_def.cx9a2_bee | 100.000 | 0.168 | |||||||||
| pg9426_def.cx9a2_bee | 100.000 | 0.164 | |||||||||
| pg9525_def.cx9a2_bee | 100.000 | 0.135 | |||||||||
| pg9624_def.cx9a2_bee | 100.000 | 0.154 | |||||||||
| pg1023_def.cx9a2_bee | 100.000 | 0.153 | |||||||||
| pg1122_def.cx9a2_bee | 100.000 | 0.134 | |||||||||
| pg1217_def.cx9a2_bee | 99.999 | 0.001 | 0.107 | ||||||||
| pg1313_def.cx9a2_bee | 99.999 | 0.001 | 0.102 | ||||||||
| pg1410_def.cx9a2_bee | 99.999 | 0.001 | 0.111 | ||||||||
| pg155_def.cx9a2_bee | 99.999 | 0.001 | 0.110 | ||||||||
| pg161_def.cx9a2_bee | 99.999 | 0.001 | 0.108 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 55 0 89 0.7 124.0 1.9 1.609 13.122 2.247 34.370 643 12.4 11.643 17971 154.6 154.8 0.4 0.050 55 50 pg9023_def.cx9a2_bee 58 0 93 0.7 129.0 1.9 1.610 13.126 2.236 34.341 670 12.4 11.608 17192 154.6 154.8 0.3 0.036 60 50 pg9124_def.cx9a2_bee 51 0 82 0.7 128.2 1.7 1.609 13.121 2.509 34.372 665 12.4 13.020 19413 154.6 154.8 10.0 0.019 50 45 pg9224_def.cx9a2_bee 53 0 86 0.7 134.0 1.8 1.609 13.121 2.519 34.454 696 12.4 13.087 18647 154.6 154.8 0.9 0.016 55 45 pg9325_def.cx9a2_bee 54 0 87 0.7 135.7 1.8 1.612 13.140 2.522 34.505 702 12.4 13.047 18439 154.6 154.8 0.9 0.033 55 45 pg9426_def.cx9a2_bee 56 0 89 0.7 162.9 1.9 1.608 13.011 2.935 35.576 691 12.4 12.459 17874 154.6 182.2 10.2 0.017 55 50 pg9525_def.cx9a2_bee 54 0 86 0.7 133.5 1.8 1.609 13.022 2.491 35.020 791 12.5 14.755 18657 154.6 180.8 10.1 0.029 55 45 pg9624_def.cx9a2_bee 52 0 84 0.7 132.7 1.8 1.611 13.039 2.538 35.398 740 12.5 14.153 19120 154.6 182.0 10.1 0.039 50 45 pg1023_def.cx9a2_bee 53 0 85 0.7 135.6 1.8 1.610 13.051 2.577 35.910 729 12.5 13.856 19011 154.6 182.3 10.1 0.027 50 45 pg1122_def.cx9a2_bee 115 0 185 1.5 258.8 3.7 1.608 13.044 2.248 33.155 1279 12.9 11.116 8966 154.6 187.0 10.1 0.021 115 100 pg1217_def.cx9a2_bee 109 0 175 1.4 243.5 3.5 1.608 13.043 2.234 33.251 1219 12.7 11.188 9321 154.5 185.1 10.1 0.027 110 95 pg1313_def.cx9a2_bee 107 0 172 1.4 225.0 3.3 1.607 13.036 2.108 32.125 1074 12.5 10.067 9372 154.5 186.5 10.1 0.034 105 95 pg1410_def.cx9a2_bee 103 0 165 1.3 219.7 3.3 1.606 13.030 2.137 32.432 990 12.4 9.626 9650 154.5 186.7 10.1 0.034 100 90 pg155_def.cx9a2_bee 103 0 166 1.3 220.5 3.3 1.607 13.033 2.139 32.399 997 12.4 9.667 9622 154.5 186.6 10.1 0.032 105 90 pg161_def.cx9a2_bee
qr100.L1
qr100.L1: range queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 99.803 | 0.113 | 0.083 | 0.002 | 0.011 | ||||||
| pg9124_def.cx9a2_bee | 99.797 | 0.121 | 0.080 | 0.002 | 0.011 | ||||||
| pg9224_def.cx9a2_bee | 99.881 | 0.117 | 0.001 | 0.001 | 0.010 | ||||||
| pg9325_def.cx9a2_bee | 99.873 | 0.126 | 0.001 | nonzero | 0.010 | ||||||
| pg9426_def.cx9a2_bee | 99.890 | 0.109 | nonzero | nonzero | 0.010 | ||||||
| pg9525_def.cx9a2_bee | 99.892 | 0.107 | nonzero | 0.001 | 0.010 | ||||||
| pg9624_def.cx9a2_bee | 99.875 | 0.123 | 0.001 | 0.001 | 0.010 | ||||||
| pg1023_def.cx9a2_bee | 99.871 | 0.128 | nonzero | nonzero | 0.010 | ||||||
| pg1122_def.cx9a2_bee | 99.900 | 0.099 | nonzero | 0.001 | 0.010 | ||||||
| pg1217_def.cx9a2_bee | 99.881 | 0.118 | nonzero | 0.001 | 0.010 | ||||||
| pg1313_def.cx9a2_bee | 99.885 | 0.114 | nonzero | 0.001 | 0.010 | ||||||
| pg1410_def.cx9a2_bee | 93.546 | 6.448 | 0.001 | 0.005 | nonzero | nonzero | nonzero | 0.714 | |||
| pg155_def.cx9a2_bee | 93.886 | 6.107 | 0.001 | 0.006 | nonzero | nonzero | nonzero | 0.732 | |||
| pg161_def.cx9a2_bee | 94.030 | 5.964 | 0.001 | 0.006 | nonzero | nonzero | nonzero | 0.732 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 2.528 | 97.472 | 0.040 | ||||||||
| pg9124_def.cx9a2_bee | 8.389 | 91.611 | 0.035 | ||||||||
| pg9224_def.cx9a2_bee | 0.417 | 99.583 | 0.037 | ||||||||
| pg9325_def.cx9a2_bee | 0.028 | 99.944 | 0.028 | 0.071 | |||||||
| pg9426_def.cx9a2_bee | 1.056 | 98.944 | 0.037 | ||||||||
| pg9525_def.cx9a2_bee | 47.500 | 52.500 | 0.032 | ||||||||
| pg9624_def.cx9a2_bee | 49.583 | 50.417 | 0.046 | ||||||||
| pg1023_def.cx9a2_bee | 51.500 | 48.500 | 0.031 | ||||||||
| pg1122_def.cx9a2_bee | 51.167 | 48.833 | 0.031 | ||||||||
| pg1217_def.cx9a2_bee | 52.389 | 47.611 | 0.030 | ||||||||
| pg1313_def.cx9a2_bee | 52.250 | 47.750 | 0.030 | ||||||||
| pg1410_def.cx9a2_bee | 57.028 | 42.972 | 0.031 | ||||||||
| pg155_def.cx9a2_bee | 56.139 | 43.861 | 0.031 | ||||||||
| pg161_def.cx9a2_bee | 60.778 | 39.222 | 0.030 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 10.944 | 65.556 | 23.500 | 0.010 | |||||||
| pg9124_def.cx9a2_bee | 11.361 | 68.444 | 20.194 | 0.009 | |||||||
| pg9224_def.cx9a2_bee | 9.389 | 60.611 | 30.000 | 0.009 | |||||||
| pg9325_def.cx9a2_bee | 10.472 | 60.778 | 28.750 | 0.009 | |||||||
| pg9426_def.cx9a2_bee | 9.889 | 62.667 | 27.444 | 0.011 | |||||||
| pg9525_def.cx9a2_bee | 10.111 | 63.417 | 26.472 | 0.010 | |||||||
| pg9624_def.cx9a2_bee | 10.556 | 63.333 | 26.111 | 0.009 | |||||||
| pg1023_def.cx9a2_bee | 9.306 | 62.028 | 28.667 | 0.010 | |||||||
| pg1122_def.cx9a2_bee | 10.000 | 61.694 | 28.306 | 0.009 | |||||||
| pg1217_def.cx9a2_bee | 27.222 | 72.667 | 0.111 | 0.009 | |||||||
| pg1313_def.cx9a2_bee | 25.222 | 74.333 | 0.444 | 0.009 | |||||||
| pg1410_def.cx9a2_bee | 99.944 | 0.056 | 0.114 | ||||||||
| pg155_def.cx9a2_bee | 99.917 | 0.083 | 0.126 | ||||||||
| pg161_def.cx9a2_bee | 99.944 | 0.056 | 0.126 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 100 7315 226 1.8 223.0 3.4 0.031 0.251 2.234 34.750 28605 12.7 3.910 139 154.7 154.8 0.2 0.011 7110 4621 pg9023_def.cx9a2_bee 100 7588 226 1.8 222.0 3.4 0.030 0.242 2.227 34.810 29666 12.5 3.909 132 154.7 154.8 0.2 0.011 7448 4347 pg9124_def.cx9a2_bee 100 8141 167 1.3 227.1 3.4 0.020 0.169 2.278 34.749 31660 12.6 3.889 124 154.7 154.8 9.8 0.010 7768 7465 pg9224_def.cx9a2_bee 100 8073 167 1.3 247.6 3.5 0.021 0.170 2.483 35.796 31470 12.5 3.898 124 154.7 154.8 0.7 0.010 7833 7589 pg9325_def.cx9a2_bee 100 8366 167 1.3 245.9 3.5 0.020 0.162 2.468 35.717 32623 12.9 3.900 123 154.7 154.8 0.7 0.010 7863 7575 pg9426_def.cx9a2_bee 100 8227 167 1.4 19.7 1.5 0.020 0.169 0.198 15.381 31958 12.8 3.885 124 154.7 194.7 10.2 0.010 7753 7432 pg9525_def.cx9a2_bee 100 8203 167 1.4 15.3 1.5 0.020 0.169 0.153 15.516 31867 13.4 3.885 131 154.7 194.7 10.2 0.010 7815 7542 pg9624_def.cx9a2_bee 100 7904 167 1.4 15.2 1.5 0.021 0.175 0.153 15.544 30752 12.6 3.891 128 154.7 194.7 10.2 0.010 7662 7462 pg1023_def.cx9a2_bee 100 8552 167 1.4 15.5 1.5 0.020 0.162 0.155 15.565 33222 13.5 3.885 126 154.7 194.7 10.2 0.010 8092 7817 pg1122_def.cx9a2_bee 100 8445 167 1.4 15.6 1.5 0.020 0.164 0.156 15.556 32832 13.2 3.888 125 154.6 194.7 10.2 0.010 8088 7877 pg1217_def.cx9a2_bee 100 8338 166 1.4 15.2 1.5 0.020 0.166 0.152 15.486 32427 12.9 3.889 124 154.5 190.5 10.2 0.010 8061 7863 pg1313_def.cx9a2_bee 100 5823 184 1.6 72.1 2.1 0.032 0.285 0.723 21.640 22808 13.8 3.917 190 154.5 182.5 10.1 0.714 5789 5462 pg1410_def.cx9a2_bee 100 5855 183 1.6 71.1 2.1 0.031 0.284 0.712 21.530 22874 14.0 3.907 191 154.5 181.3 10.1 0.732 5757 5480 pg155_def.cx9a2_bee 100 5939 184 1.6 71.0 2.1 0.031 0.280 0.712 21.561 23215 14.0 3.909 189 154.5 181.7 10.1 0.732 5832 5435 pg161_def.cx9a2_bee
qp100.L2
qp100.L2: point queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 99.502 | 0.498 | 0.015 | ||||||||
| pg9124_def.cx9a2_bee | 99.387 | 0.613 | 0.014 | ||||||||
| pg9224_def.cx9a2_bee | nonzero | 99.134 | 0.866 | nonzero | 0.042 | ||||||
| pg9325_def.cx9a2_bee | nonzero | 98.493 | 1.506 | 0.001 | 0.039 | ||||||
| pg9426_def.cx9a2_bee | nonzero | 99.494 | 0.506 | 0.014 | |||||||
| pg9525_def.cx9a2_bee | nonzero | 99.471 | 0.529 | 0.016 | |||||||
| pg9624_def.cx9a2_bee | nonzero | 99.693 | 0.306 | nonzero | 0.016 | ||||||
| pg1023_def.cx9a2_bee | 99.637 | 0.363 | 0.015 | ||||||||
| pg1122_def.cx9a2_bee | nonzero | 99.686 | 0.313 | nonzero | 0.019 | ||||||
| pg1217_def.cx9a2_bee | nonzero | 99.651 | 0.349 | 0.012 | |||||||
| pg1313_def.cx9a2_bee | nonzero | 99.680 | 0.320 | 0.013 | |||||||
| pg1410_def.cx9a2_bee | nonzero | 99.712 | 0.287 | 0.011 | |||||||
| pg155_def.cx9a2_bee | 0.001 | 99.699 | 0.300 | 0.011 | |||||||
| pg161_def.cx9a2_bee | nonzero | 99.690 | 0.310 | 0.015 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 100.000 | 0.044 | |||||||||
| pg9124_def.cx9a2_bee | 100.000 | 0.044 | |||||||||
| pg9224_def.cx9a2_bee | 100.000 | 0.051 | |||||||||
| pg9325_def.cx9a2_bee | 100.000 | 0.046 | |||||||||
| pg9426_def.cx9a2_bee | 100.000 | 0.037 | |||||||||
| pg9525_def.cx9a2_bee | 8.111 | 91.889 | 0.029 | ||||||||
| pg9624_def.cx9a2_bee | 17.472 | 82.528 | 0.032 | ||||||||
| pg1023_def.cx9a2_bee | 16.944 | 83.056 | 0.032 | ||||||||
| pg1122_def.cx9a2_bee | 17.722 | 82.278 | 0.037 | ||||||||
| pg1217_def.cx9a2_bee | 21.611 | 78.389 | 0.038 | ||||||||
| pg1313_def.cx9a2_bee | 20.250 | 79.750 | 0.031 | ||||||||
| pg1410_def.cx9a2_bee | 16.417 | 83.583 | 0.029 | ||||||||
| pg155_def.cx9a2_bee | 13.194 | 86.806 | 0.030 | ||||||||
| pg161_def.cx9a2_bee | 16.806 | 83.194 | 0.029 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 0.139 | 99.833 | 0.028 | 0.016 | |||||||
| pg9124_def.cx9a2_bee | 0.556 | 99.417 | 0.028 | 0.016 | |||||||
| pg9224_def.cx9a2_bee | 99.917 | 0.083 | 0.017 | ||||||||
| pg9325_def.cx9a2_bee | 0.056 | 99.833 | 0.111 | 0.017 | |||||||
| pg9426_def.cx9a2_bee | 0.028 | 99.917 | 0.056 | 0.016 | |||||||
| pg9525_def.cx9a2_bee | 0.056 | 99.944 | 0.015 | ||||||||
| pg9624_def.cx9a2_bee | 0.250 | 99.750 | 0.015 | ||||||||
| pg1023_def.cx9a2_bee | 100.000 | 0.013 | |||||||||
| pg1122_def.cx9a2_bee | 100.000 | 0.013 | |||||||||
| pg1217_def.cx9a2_bee | 65.917 | 34.083 | 0.011 | ||||||||
| pg1313_def.cx9a2_bee | 54.611 | 45.389 | 0.009 | ||||||||
| pg1410_def.cx9a2_bee | 99.972 | 0.028 | 0.118 | ||||||||
| pg155_def.cx9a2_bee | 99.917 | 0.083 | 0.124 | ||||||||
| pg161_def.cx9a2_bee | 99.944 | 0.056 | 0.115 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 100 401 6936 54.8 216.1 3.3 17.283 139.898 2.165 34.226 15273 4.0 38.058 797 154.7 154.8 1.5 0.015 400 336 pg9023_def.cx9a2_bee 100 393 6806 53.8 215.1 3.3 17.311 140.138 2.155 34.240 14984 4.0 38.107 814 154.7 154.8 0.6 0.014 400 335 pg9124_def.cx9a2_bee 100 396 6851 54.2 218.7 3.3 17.287 140.004 2.191 34.241 15092 3.9 38.081 787 154.7 154.9 9.8 0.042 400 336 pg9224_def.cx9a2_bee 100 393 6793 53.7 223.8 3.4 17.302 140.154 2.244 34.601 15007 3.9 38.226 795 154.7 154.9 1.5 0.039 400 320 pg9325_def.cx9a2_bee 100 396 6854 54.2 223.9 3.4 17.303 140.148 2.245 34.609 15110 3.9 38.146 788 154.7 154.8 1.0 0.014 400 335 pg9426_def.cx9a2_bee 100 400 6903 54.5 392.6 4.5 17.279 139.805 3.934 45.919 15188 4.0 38.017 801 154.7 194.7 10.2 0.016 400 336 pg9525_def.cx9a2_bee 100 396 6841 54.1 392.7 4.5 17.287 139.891 3.935 45.778 15142 4.2 38.265 849 154.7 194.7 10.1 0.016 400 336 pg9624_def.cx9a2_bee 100 395 6832 54.0 392.4 4.5 17.305 140.046 3.935 45.808 15061 4.1 38.147 831 154.7 194.7 10.1 0.015 400 320 pg1023_def.cx9a2_bee 100 395 6833 54.0 391.4 4.5 17.303 140.012 3.926 45.766 15059 4.1 38.134 831 154.7 193.0 10.1 0.019 400 336 pg1122_def.cx9a2_bee 100 397 6844 53.9 391.5 4.5 17.238 139.131 3.927 45.723 15080 4.0 37.985 806 154.6 193.0 10.2 0.012 400 335 pg1217_def.cx9a2_bee 100 394 6782 53.5 392.2 4.5 17.235 139.126 3.930 45.737 14948 4.0 37.987 813 154.5 190.5 10.2 0.013 400 320 pg1313_def.cx9a2_bee 100 392 6793 53.6 335.0 4.1 17.316 139.801 3.363 42.504 14919 4.9 38.030 999 154.5 181.0 10.1 0.011 400 320 pg1410_def.cx9a2_bee 100 391 6766 53.4 336.1 4.1 17.301 139.685 3.371 42.547 14797 4.9 37.833 1002 154.5 179.7 10.1 0.011 400 334 pg155_def.cx9a2_bee 100 391 6767 53.3 335.8 4.1 17.294 139.599 3.364 42.489 14809 4.9 37.847 1002 154.5 180.1 10.1 0.015 400 335 pg161_def.cx9a2_bee
qr500.L3
qr500.L3: range queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 98.320 | 1.584 | 0.094 | 0.003 | nonzero | 0.031 | |||||
| pg9124_def.cx9a2_bee | 98.983 | 0.927 | 0.088 | 0.002 | nonzero | 0.022 | |||||
| pg9224_def.cx9a2_bee | 99.202 | 0.794 | 0.003 | 0.001 | nonzero | 0.028 | |||||
| pg9325_def.cx9a2_bee | 99.456 | 0.538 | 0.006 | nonzero | nonzero | 0.043 | |||||
| pg9426_def.cx9a2_bee | 99.451 | 0.544 | 0.005 | nonzero | nonzero | 0.031 | |||||
| pg9525_def.cx9a2_bee | 99.397 | 0.597 | 0.003 | 0.003 | nonzero | 0.020 | |||||
| pg9624_def.cx9a2_bee | 99.687 | 0.308 | 0.003 | 0.002 | nonzero | 0.035 | |||||
| pg1023_def.cx9a2_bee | 99.496 | 0.498 | 0.003 | 0.003 | nonzero | 0.027 | |||||
| pg1122_def.cx9a2_bee | 99.717 | 0.278 | 0.002 | 0.003 | nonzero | 0.024 | |||||
| pg1217_def.cx9a2_bee | 99.798 | 0.198 | 0.002 | 0.002 | nonzero | 0.031 | |||||
| pg1313_def.cx9a2_bee | 99.798 | 0.197 | 0.002 | 0.002 | nonzero | 0.037 | |||||
| pg1410_def.cx9a2_bee | 93.344 | 6.644 | 0.008 | 0.004 | nonzero | 0.023 | |||||
| pg155_def.cx9a2_bee | 93.048 | 6.939 | 0.008 | 0.004 | nonzero | 0.020 | |||||
| pg161_def.cx9a2_bee | 93.002 | 6.986 | 0.008 | 0.004 | nonzero | 0.025 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 9.722 | 90.278 | 0.044 | ||||||||
| pg9124_def.cx9a2_bee | 20.372 | 79.628 | 0.046 | ||||||||
| pg9224_def.cx9a2_bee | 1.172 | 98.828 | 0.046 | ||||||||
| pg9325_def.cx9a2_bee | 0.167 | 99.800 | 0.033 | 0.089 | |||||||
| pg9426_def.cx9a2_bee | 2.050 | 97.950 | 0.040 | ||||||||
| pg9525_def.cx9a2_bee | 66.072 | 33.928 | 0.039 | ||||||||
| pg9624_def.cx9a2_bee | 79.322 | 20.678 | 0.048 | ||||||||
| pg1023_def.cx9a2_bee | 83.083 | 16.917 | 0.037 | ||||||||
| pg1122_def.cx9a2_bee | 79.700 | 20.300 | 0.058 | ||||||||
| pg1217_def.cx9a2_bee | 81.056 | 18.939 | 0.006 | 0.064 | |||||||
| pg1313_def.cx9a2_bee | 80.150 | 19.844 | 0.006 | 0.085 | |||||||
| pg1410_def.cx9a2_bee | 81.711 | 18.289 | 0.034 | ||||||||
| pg155_def.cx9a2_bee | 82.750 | 17.250 | 0.034 | ||||||||
| pg161_def.cx9a2_bee | 80.578 | 19.422 | 0.034 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 38.311 | 61.689 | 0.037 | ||||||||
| pg9124_def.cx9a2_bee | 42.500 | 57.500 | 0.035 | ||||||||
| pg9224_def.cx9a2_bee | 33.328 | 66.672 | 0.044 | ||||||||
| pg9325_def.cx9a2_bee | 36.250 | 63.750 | 0.039 | ||||||||
| pg9426_def.cx9a2_bee | 37.239 | 62.761 | 0.037 | ||||||||
| pg9525_def.cx9a2_bee | 39.156 | 60.844 | 0.036 | ||||||||
| pg9624_def.cx9a2_bee | 40.167 | 59.833 | 0.036 | ||||||||
| pg1023_def.cx9a2_bee | 38.050 | 61.950 | 0.036 | ||||||||
| pg1122_def.cx9a2_bee | 37.272 | 62.728 | 0.034 | ||||||||
| pg1217_def.cx9a2_bee | 0.183 | 99.661 | 0.156 | 0.021 | |||||||
| pg1313_def.cx9a2_bee | 0.028 | 98.383 | 1.589 | 0.022 | |||||||
| pg1410_def.cx9a2_bee | 97.028 | 2.972 | 0.130 | ||||||||
| pg155_def.cx9a2_bee | 77.883 | 22.117 | 0.125 | ||||||||
| pg161_def.cx9a2_bee | 79.544 | 20.456 | 0.118 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 499 6601 943 7.6 1126.6 17.3 0.143 1.172 2.257 35.440 27578 15.7 4.178 190 154.8 154.9 0.7 0.031 6534 3711 pg9023_def.cx9a2_bee 499 7010 943 7.6 1125.9 17.3 0.135 1.103 2.257 35.496 29137 15.7 4.156 179 154.8 154.9 0.7 0.022 6967 4107 pg9124_def.cx9a2_bee 499 7363 884 7.1 1139.3 17.1 0.120 0.990 2.285 35.106 30498 16.2 4.142 176 154.8 154.9 10.1 0.028 7192 6243 pg9224_def.cx9a2_bee 499 7389 884 7.1 1233.2 17.7 0.120 0.986 2.472 36.254 30892 16.1 4.181 174 154.8 154.9 1.5 0.043 7223 6425 pg9325_def.cx9a2_bee 499 7407 884 7.1 1243.6 17.7 0.119 0.984 2.494 36.279 31035 16.1 4.190 174 154.8 154.9 9.6 0.031 7286 6450 pg9426_def.cx9a2_bee 499 7375 884 7.1 630.7 11.0 0.120 0.980 1.264 22.669 30410 15.7 4.124 170 154.8 192.3 9.6 0.020 7192 6295 pg9525_def.cx9a2_bee 499 7595 885 7.1 614.6 11.1 0.116 0.953 1.232 22.841 31257 16.0 4.116 169 154.8 192.3 9.5 0.035 7335 6536 pg9624_def.cx9a2_bee 499 7342 884 7.1 615.5 11.1 0.120 0.985 1.234 22.876 30278 16.1 4.124 175 154.8 192.3 9.4 0.027 7108 6265 pg1023_def.cx9a2_bee 499 7761 884 7.1 614.7 11.1 0.114 0.932 1.233 22.892 31908 16.2 4.111 167 154.8 190.6 9.5 0.024 7543 6792 pg1122_def.cx9a2_bee 498 8067 883 7.1 613.3 11.1 0.109 0.895 1.231 22.870 33065 15.1 4.099 150 154.7 190.6 9.6 0.031 7768 7303 pg1217_def.cx9a2_bee 499 8102 883 7.1 615.6 11.1 0.109 0.892 1.233 22.822 33136 15.2 4.090 150 154.6 188.1 9.6 0.037 7782 7304 pg1313_def.cx9a2_bee 499 5918 886 7.2 643.1 11.8 0.150 1.240 1.289 24.201 24803 20.3 4.191 274 154.7 178.6 9.6 0.023 5769 5343 pg1410_def.cx9a2_bee 499 5847 885 7.2 642.4 11.8 0.151 1.254 1.288 24.189 24464 20.6 4.184 282 154.7 177.3 9.6 0.020 5702 5330 pg155_def.cx9a2_bee 499 5861 885 7.2 641.7 11.8 0.151 1.252 1.287 24.177 24531 20.6 4.185 281 154.7 177.7 9.4 0.025 5708 5327 pg161_def.cx9a2_bee
qp500.L4
qp500.L4: point queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 98.395 | 1.604 | 0.001 | 0.038 | |||||||
| pg9124_def.cx9a2_bee | nonzero | 98.642 | 1.358 | nonzero | 0.022 | ||||||
| pg9224_def.cx9a2_bee | 95.004 | 4.992 | 0.004 | 0.042 | |||||||
| pg9325_def.cx9a2_bee | 94.347 | 5.648 | 0.005 | 0.047 | |||||||
| pg9426_def.cx9a2_bee | 97.344 | 2.654 | 0.001 | 0.032 | |||||||
| pg9525_def.cx9a2_bee | nonzero | 98.440 | 1.554 | 0.006 | 0.045 | ||||||
| pg9624_def.cx9a2_bee | 99.020 | 0.979 | 0.001 | 0.023 | |||||||
| pg1023_def.cx9a2_bee | nonzero | 98.867 | 1.132 | 0.001 | 0.036 | ||||||
| pg1122_def.cx9a2_bee | 98.957 | 1.042 | 0.001 | 0.035 | |||||||
| pg1217_def.cx9a2_bee | nonzero | 99.061 | 0.938 | 0.001 | 0.035 | ||||||
| pg1313_def.cx9a2_bee | nonzero | 98.980 | 1.019 | 0.001 | 0.047 | ||||||
| pg1410_def.cx9a2_bee | 98.915 | 1.084 | 0.001 | 0.030 | |||||||
| pg155_def.cx9a2_bee | 98.980 | 1.020 | 0.001 | 0.033 | |||||||
| pg161_def.cx9a2_bee | 99.092 | 0.907 | 0.001 | 0.033 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 0.694 | 99.306 | 0.050 | ||||||||
| pg9124_def.cx9a2_bee | 10.517 | 89.483 | 0.040 | ||||||||
| pg9224_def.cx9a2_bee | 0.006 | 99.989 | 0.006 | 0.067 | |||||||
| pg9325_def.cx9a2_bee | 99.978 | 0.022 | 0.078 | ||||||||
| pg9426_def.cx9a2_bee | 0.106 | 99.894 | 0.055 | ||||||||
| pg9525_def.cx9a2_bee | 88.361 | 11.589 | 0.050 | 0.081 | |||||||
| pg9624_def.cx9a2_bee | 97.056 | 2.944 | 0.059 | ||||||||
| pg1023_def.cx9a2_bee | 96.450 | 3.550 | 0.048 | ||||||||
| pg1122_def.cx9a2_bee | 97.156 | 2.844 | 0.041 | ||||||||
| pg1217_def.cx9a2_bee | 97.917 | 2.083 | 0.034 | ||||||||
| pg1313_def.cx9a2_bee | 97.378 | 2.617 | 0.006 | 0.093 | |||||||
| pg1410_def.cx9a2_bee | 97.400 | 2.600 | 0.041 | ||||||||
| pg155_def.cx9a2_bee | 97.761 | 2.239 | 0.037 | ||||||||
| pg161_def.cx9a2_bee | 97.911 | 2.089 | 0.037 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 99.983 | 0.017 | 0.081 | ||||||||
| pg9124_def.cx9a2_bee | 99.994 | 0.006 | 0.076 | ||||||||
| pg9224_def.cx9a2_bee | 99.939 | 0.061 | 0.068 | ||||||||
| pg9325_def.cx9a2_bee | 99.989 | 0.011 | 0.077 | ||||||||
| pg9426_def.cx9a2_bee | 99.994 | 0.006 | 0.075 | ||||||||
| pg9525_def.cx9a2_bee | 100.000 | 0.062 | |||||||||
| pg9624_def.cx9a2_bee | 99.994 | 0.006 | 0.066 | ||||||||
| pg1023_def.cx9a2_bee | 100.000 | 0.061 | |||||||||
| pg1122_def.cx9a2_bee | 99.994 | 0.006 | 0.067 | ||||||||
| pg1217_def.cx9a2_bee | 37.217 | 62.783 | 0.046 | ||||||||
| pg1313_def.cx9a2_bee | 25.517 | 74.483 | 0.048 | ||||||||
| pg1410_def.cx9a2_bee | 4.233 | 95.767 | 0.146 | ||||||||
| pg155_def.cx9a2_bee | 0.011 | 99.989 | 0.159 | ||||||||
| pg161_def.cx9a2_bee | 0.006 | 99.994 | 0.139 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 499 383 7493 59.1 1068.1 16.7 19.565 158.136 2.140 34.199 16657 9.6 43.491 2005 154.8 155.0 0.7 0.038 384 335 pg9023_def.cx9a2_bee 499 378 7406 58.4 1068.2 16.7 19.618 158.549 2.142 34.227 16464 9.3 43.614 1971 154.8 155.0 0.7 0.022 384 320 pg9124_def.cx9a2_bee 499 367 7224 57.0 1089.8 16.7 19.689 159.185 2.185 34.263 16187 9.5 44.118 2071 154.8 155.0 10.1 0.042 368 319 pg9224_def.cx9a2_bee 499 363 7161 56.6 1100.7 16.7 19.723 159.487 2.207 34.377 16093 9.5 44.322 2093 154.8 155.0 4.3 0.047 368 303 pg9325_def.cx9a2_bee 498 371 7304 57.7 1101.9 16.8 19.677 159.117 2.211 34.422 16410 9.5 44.208 2047 154.8 155.0 9.2 0.032 384 319 pg9426_def.cx9a2_bee 499 379 7417 58.4 1338.7 16.8 19.586 157.976 2.682 34.484 16348 9.1 43.169 1922 154.8 191.2 9.2 0.045 384 320 pg9525_def.cx9a2_bee 499 381 7457 58.7 1327.6 16.8 19.576 157.915 2.660 34.371 16437 9.4 43.152 1974 154.8 191.2 8.8 0.023 384 320 pg9624_def.cx9a2_bee 499 379 7428 58.5 1325.8 16.7 19.608 158.183 2.659 34.356 16319 9.4 43.080 1985 154.8 191.0 8.8 0.036 384 320 pg1023_def.cx9a2_bee 499 380 7439 58.6 1327.7 16.7 19.598 158.102 2.663 34.370 16346 9.4 43.062 1981 154.8 188.2 8.7 0.035 384 320 pg1122_def.cx9a2_bee 499 385 7504 59.0 1329.6 16.7 19.505 156.995 2.666 34.362 16468 7.0 42.807 1456 154.8 188.1 8.7 0.035 384 320 pg1217_def.cx9a2_bee 499 381 7440 58.5 1326.9 16.7 19.537 157.233 2.660 34.349 16341 7.1 42.911 1492 154.7 186.6 8.9 0.047 384 320 pg1313_def.cx9a2_bee 499 371 7287 57.2 1300.6 16.6 19.662 158.186 2.607 34.099 15949 13.0 43.036 2806 154.8 176.2 9.3 0.030 368 320 pg1410_def.cx9a2_bee 499 369 7252 57.0 1299.8 16.6 19.664 158.200 2.606 34.074 15816 13.2 42.886 2863 154.8 176.2 9.4 0.033 368 320 pg155_def.cx9a2_bee 499 369 7264 57.1 1300.4 16.6 19.668 158.205 2.607 34.078 15837 13.2 42.885 2859 154.8 175.9 9.0 0.033 368 320 pg161_def.cx9a2_bee
qr1000.L5
qr1000.L5: range queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 82.605 | 17.292 | 0.100 | 0.002 | nonzero | nonzero | 0.124 | ||||
| pg9124_def.cx9a2_bee | 85.616 | 14.285 | 0.097 | 0.002 | nonzero | nonzero | 0.130 | ||||
| pg9224_def.cx9a2_bee | 84.213 | 15.781 | 0.005 | nonzero | nonzero | nonzero | 0.193 | ||||
| pg9325_def.cx9a2_bee | 88.875 | 11.116 | 0.008 | 0.002 | nonzero | nonzero | 0.203 | ||||
| pg9426_def.cx9a2_bee | 89.541 | 10.450 | 0.008 | 0.001 | nonzero | nonzero | 0.120 | ||||
| pg9525_def.cx9a2_bee | 87.839 | 12.153 | 0.007 | 0.001 | nonzero | nonzero | 0.138 | ||||
| pg9624_def.cx9a2_bee | 90.928 | 9.066 | 0.006 | nonzero | nonzero | nonzero | 0.146 | ||||
| pg1023_def.cx9a2_bee | 85.665 | 14.329 | 0.006 | nonzero | nonzero | nonzero | 0.139 | ||||
| pg1122_def.cx9a2_bee | 91.577 | 8.417 | 0.006 | nonzero | nonzero | nonzero | 0.148 | ||||
| pg1217_def.cx9a2_bee | 98.443 | 1.545 | 0.007 | 0.004 | nonzero | nonzero | 0.148 | ||||
| pg1313_def.cx9a2_bee | 98.230 | 1.758 | 0.008 | 0.004 | nonzero | nonzero | 0.133 | ||||
| pg1410_def.cx9a2_bee | 77.966 | 22.029 | 0.004 | nonzero | nonzero | nonzero | 0.115 | ||||
| pg155_def.cx9a2_bee | 78.067 | 21.929 | 0.004 | nonzero | nonzero | nonzero | 0.109 | ||||
| pg161_def.cx9a2_bee | 77.544 | 22.451 | 0.004 | 0.001 | nonzero | nonzero | 0.122 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 5.772 | 94.219 | 0.008 | 0.072 | |||||||
| pg9124_def.cx9a2_bee | 17.233 | 82.764 | 0.003 | 0.067 | |||||||
| pg9224_def.cx9a2_bee | 1.406 | 98.578 | 0.017 | 0.073 | |||||||
| pg9325_def.cx9a2_bee | 0.253 | 99.708 | 0.039 | 0.093 | |||||||
| pg9426_def.cx9a2_bee | 6.803 | 93.164 | 0.033 | 0.082 | |||||||
| pg9525_def.cx9a2_bee | 88.619 | 11.303 | 0.078 | 0.101 | |||||||
| pg9624_def.cx9a2_bee | 90.511 | 9.489 | 0.046 | ||||||||
| pg1023_def.cx9a2_bee | 90.156 | 9.842 | 0.003 | 0.097 | |||||||
| pg1122_def.cx9a2_bee | 91.519 | 8.475 | 0.006 | 0.079 | |||||||
| pg1217_def.cx9a2_bee | 89.422 | 10.575 | 0.003 | 0.075 | |||||||
| pg1313_def.cx9a2_bee | 90.861 | 9.133 | 0.006 | 0.088 | |||||||
| pg1410_def.cx9a2_bee | 89.950 | 10.050 | 0.053 | ||||||||
| pg155_def.cx9a2_bee | 90.450 | 9.550 | 0.054 | ||||||||
| pg161_def.cx9a2_bee | 88.611 | 11.389 | 0.041 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 54.775 | 45.225 | 0.116 | ||||||||
| pg9124_def.cx9a2_bee | 62.933 | 37.067 | 0.093 | ||||||||
| pg9224_def.cx9a2_bee | 41.461 | 58.539 | 0.117 | ||||||||
| pg9325_def.cx9a2_bee | 47.558 | 52.442 | 0.100 | ||||||||
| pg9426_def.cx9a2_bee | 50.428 | 49.572 | 0.089 | ||||||||
| pg9525_def.cx9a2_bee | 55.292 | 44.708 | 0.085 | ||||||||
| pg9624_def.cx9a2_bee | 50.792 | 49.208 | 0.087 | ||||||||
| pg1023_def.cx9a2_bee | 46.219 | 53.781 | 0.099 | ||||||||
| pg1122_def.cx9a2_bee | 47.997 | 52.003 | 0.097 | ||||||||
| pg1217_def.cx9a2_bee | 99.997 | 0.003 | 0.069 | ||||||||
| pg1313_def.cx9a2_bee | 100.000 | 0.057 | |||||||||
| pg1410_def.cx9a2_bee | 100.000 | 0.157 | |||||||||
| pg155_def.cx9a2_bee | 100.000 | 0.159 | |||||||||
| pg161_def.cx9a2_bee | 100.000 | 0.160 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 796 5134 1406 11.3 1788.0 27.8 0.274 2.260 2.247 35.797 23203 26.6 4.520 415 155.0 155.2 1.1 0.124 5083 3436 pg9023_def.cx9a2_bee 825 5386 1457 11.7 1853.7 28.8 0.271 2.231 2.247 35.790 24308 26.6 4.514 395 155.0 155.2 1.1 0.130 5356 3493 pg9124_def.cx9a2_bee 742 5399 1251 10.1 1693.1 25.4 0.232 1.920 2.283 35.128 24064 26.6 4.457 394 155.0 155.2 10.1 0.193 5322 4829 pg9224_def.cx9a2_bee 767 5584 1294 10.5 1910.9 27.3 0.232 1.921 2.491 36.411 25430 26.9 4.554 385 155.0 155.2 2.4 0.203 5515 4959 pg9325_def.cx9a2_bee 779 5614 1314 10.6 1930.2 27.6 0.234 1.941 2.477 36.315 25628 27.0 4.565 385 155.0 155.2 2.5 0.120 5513 5033 pg9426_def.cx9a2_bee 797 5519 1346 10.8 1310.4 19.9 0.244 2.001 1.645 25.548 24595 26.1 4.457 378 155.0 190.8 9.4 0.138 5403 4922 pg9525_def.cx9a2_bee 780 5626 1317 10.6 1229.5 19.3 0.234 1.922 1.576 25.347 24965 26.6 4.438 378 155.0 190.8 9.2 0.146 5498 5034 pg9624_def.cx9a2_bee 760 5364 1284 10.3 1196.9 18.8 0.239 1.965 1.574 25.329 23812 26.5 4.439 395 155.0 190.7 9.2 0.139 5322 4826 pg1023_def.cx9a2_bee 767 5737 1295 10.4 1208.6 18.8 0.226 1.855 1.576 25.158 25263 26.5 4.403 370 155.0 186.9 9.0 0.148 5643 5050 pg1122_def.cx9a2_bee 998 7162 1683 13.5 1558.6 23.4 0.235 1.931 1.561 23.982 31477 22.0 4.395 246 154.9 186.8 8.6 0.148 6968 6029 pg1217_def.cx9a2_bee 998 7090 1683 13.5 1556.1 23.3 0.237 1.951 1.560 23.953 31208 22.4 4.402 253 154.8 185.4 8.8 0.133 6904 5898 pg1313_def.cx9a2_bee 611 5139 1036 8.3 978.5 16.6 0.202 1.660 1.602 27.884 22250 25.8 4.330 402 155.1 180.3 9.1 0.115 5146 4824 pg1410_def.cx9a2_bee 588 5156 996 8.0 942.5 15.9 0.193 1.589 1.603 27.673 22146 25.7 4.295 399 155.1 179.8 9.3 0.109 5147 4806 pg155_def.cx9a2_bee 590 5160 1001 8.0 948.1 16.1 0.194 1.597 1.606 27.876 22189 25.7 4.300 398 155.1 179.8 8.9 0.122 5162 4811 pg161_def.cx9a2_bee
qp1000.L6
qp1000.L6: point queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 96.326 | 3.671 | 0.003 | 0.041 | |||||||
| pg9124_def.cx9a2_bee | nonzero | 95.920 | 4.076 | 0.004 | 0.042 | ||||||
| pg9224_def.cx9a2_bee | nonzero | 95.452 | 4.544 | 0.004 | 0.038 | ||||||
| pg9325_def.cx9a2_bee | nonzero | 93.838 | 6.157 | 0.005 | 0.042 | ||||||
| pg9426_def.cx9a2_bee | nonzero | 93.856 | 6.139 | 0.005 | 0.042 | ||||||
| pg9525_def.cx9a2_bee | nonzero | 96.238 | 3.748 | 0.014 | 0.050 | ||||||
| pg9624_def.cx9a2_bee | 97.932 | 2.066 | 0.003 | 0.043 | |||||||
| pg1023_def.cx9a2_bee | 97.915 | 2.082 | 0.003 | 0.035 | |||||||
| pg1122_def.cx9a2_bee | 98.007 | 1.990 | 0.002 | 0.041 | |||||||
| pg1217_def.cx9a2_bee | 97.701 | 2.296 | 0.003 | 0.038 | |||||||
| pg1313_def.cx9a2_bee | 97.702 | 2.295 | 0.004 | 0.040 | |||||||
| pg1410_def.cx9a2_bee | 98.008 | 1.990 | 0.003 | 0.036 | |||||||
| pg155_def.cx9a2_bee | nonzero | 98.035 | 1.962 | 0.002 | 0.036 | ||||||
| pg161_def.cx9a2_bee | 98.038 | 1.960 | 0.003 | 0.035 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 0.003 | 99.983 | 0.014 | 0.078 | |||||||
| pg9124_def.cx9a2_bee | 0.208 | 99.778 | 0.014 | 0.077 | |||||||
| pg9224_def.cx9a2_bee | 99.997 | 0.003 | 0.085 | ||||||||
| pg9325_def.cx9a2_bee | 99.994 | 0.006 | 0.072 | ||||||||
| pg9426_def.cx9a2_bee | 0.003 | 99.983 | 0.014 | 0.081 | |||||||
| pg9525_def.cx9a2_bee | 72.800 | 26.986 | 0.214 | 0.097 | |||||||
| pg9624_def.cx9a2_bee | 89.656 | 10.344 | 0.042 | ||||||||
| pg1023_def.cx9a2_bee | 66.242 | 33.756 | 0.003 | 0.082 | |||||||
| pg1122_def.cx9a2_bee | 77.558 | 22.442 | 0.056 | ||||||||
| pg1217_def.cx9a2_bee | 97.803 | 2.192 | 0.006 | 0.068 | |||||||
| pg1313_def.cx9a2_bee | 98.575 | 1.422 | 0.003 | 0.083 | |||||||
| pg1410_def.cx9a2_bee | 87.031 | 12.969 | 0.041 | ||||||||
| pg155_def.cx9a2_bee | 86.547 | 13.453 | 0.039 | ||||||||
| pg161_def.cx9a2_bee | 85.964 | 14.036 | 0.054 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg9023_def.cx9a2_bee | 100.000 | 0.176 | |||||||||
| pg9124_def.cx9a2_bee | 100.000 | 0.180 | |||||||||
| pg9224_def.cx9a2_bee | 100.000 | 0.170 | |||||||||
| pg9325_def.cx9a2_bee | 100.000 | 0.159 | |||||||||
| pg9426_def.cx9a2_bee | 100.000 | 0.166 | |||||||||
| pg9525_def.cx9a2_bee | 100.000 | 0.158 | |||||||||
| pg9624_def.cx9a2_bee | 100.000 | 0.145 | |||||||||
| pg1023_def.cx9a2_bee | 100.000 | 0.137 | |||||||||
| pg1122_def.cx9a2_bee | 100.000 | 0.155 | |||||||||
| pg1217_def.cx9a2_bee | 99.997 | 0.003 | 0.092 | ||||||||
| pg1313_def.cx9a2_bee | 99.997 | 0.003 | 0.095 | ||||||||
| pg1410_def.cx9a2_bee | 100.000 | 0.206 | |||||||||
| pg155_def.cx9a2_bee | 100.000 | 0.199 | |||||||||
| pg161_def.cx9a2_bee | 100.000 | 0.191 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 503 365 7180 56.6 1088.4 16.9 19.687 159.059 2.165 34.514 16262 17.3 44.591 3795 155.2 155.4 8.1 0.041 368 304 pg9023_def.cx9a2_bee 526 357 7100 56.0 1138.6 17.7 19.899 160.762 2.166 34.514 16121 17.3 45.183 3879 155.2 155.4 7.4 0.042 368 304 pg9124_def.cx9a2_bee 467 358 6976 55.1 1027.1 15.7 19.513 157.758 2.200 34.517 15924 17.1 44.542 3827 155.2 155.4 10.0 0.038 368 304 pg9224_def.cx9a2_bee 483 348 6870 54.2 1103.2 16.5 19.714 159.377 2.283 34.972 15830 17.1 45.423 3925 155.2 155.4 5.3 0.042 352 303 pg9325_def.cx9a2_bee 491 349 6894 54.4 1120.0 16.8 19.755 159.686 2.281 34.935 15914 17.1 45.600 3920 155.2 155.4 6.0 0.042 352 288 pg9426_def.cx9a2_bee 506 358 7074 55.7 1235.5 15.9 19.777 159.450 2.443 32.138 15801 17.1 44.175 3824 155.2 191.1 9.4 0.050 368 288 pg9525_def.cx9a2_bee 495 369 7237 57.0 1186.2 15.6 19.597 158.036 2.398 32.345 16131 17.5 43.681 3791 155.2 191.0 9.2 0.043 368 304 pg9624_def.cx9a2_bee 481 368 7192 56.7 1157.6 15.3 19.538 157.606 2.406 32.480 15966 17.4 43.373 3782 155.2 190.9 9.2 0.035 368 304 pg1023_def.cx9a2_bee 485 369 7215 56.8 1165.8 15.4 19.568 157.832 2.403 32.467 16010 17.3 43.422 3754 155.2 185.7 9.0 0.041 368 304 pg1122_def.cx9a2_bee 979 362 8147 64.0 2278.9 29.0 22.480 180.725 2.329 30.355 18020 17.2 49.724 3797 155.2 187.0 8.2 0.038 368 320 pg1217_def.cx9a2_bee 954 360 8057 63.3 2231.0 28.8 22.400 180.093 2.339 30.939 17859 17.5 49.649 3892 155.0 186.3 8.3 0.040 368 304 pg1313_def.cx9a2_bee 494 365 7172 56.4 1179.1 15.7 19.633 157.977 2.384 32.437 15823 17.0 43.316 3723 155.4 180.6 9.1 0.036 368 304 pg1410_def.cx9a2_bee 476 365 7117 55.9 1134.4 15.1 19.514 157.029 2.383 32.516 15646 16.9 42.901 3707 155.4 180.1 9.2 0.036 368 304 pg155_def.cx9a2_bee 478 365 7134 56.0 1139.4 15.2 19.529 157.111 2.384 32.524 15668 16.8 42.891 3679 155.4 180.1 9.0 0.035 368 304 pg161_def.cx9a2_bee
l.i0
l.i0: load without secondary indexes
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 62126 0 28 0.2 127.2 20.9 0.000 0.004 0.002 0.345 6631 20.5 0.107 26 76.5 76.7 0.3 0.051 62729 57379 pg9023_def.cx9a2_bee 64072 0 29 0.2 129.7 21.6 0.000 0.004 0.002 0.345 6823 21.5 0.106 27 76.5 76.7 10.2 0.058 65516 58834 pg9124_def.cx9a2_bee 62402 0 28 0.2 686.0 21.1 0.000 0.004 0.011 0.346 8367 22.1 0.134 28 76.5 76.7 0.1 0.083 63726 56983 pg9224_def.cx9a2_bee 64031 0 28 0.2 627.6 22.1 0.000 0.004 0.010 0.354 8383 21.7 0.131 27 76.5 76.7 0.1 0.076 65390 57929 pg9325_def.cx9a2_bee 65035 0 29 0.2 631.3 22.5 0.000 0.004 0.010 0.354 8457 22.4 0.130 28 76.5 76.8 0.1 0.072 65251 62131 pg9426_def.cx9a2_bee 65248 0 30 0.2 624.0 27.1 0.000 0.004 0.010 0.425 8448 22.5 0.129 28 76.5 116.6 9.5 0.060 65346 63656 pg9525_def.cx9a2_bee 62957 0 28 0.2 120.1 26.1 0.000 0.004 0.002 0.425 7942 23.1 0.126 29 76.5 116.6 9.7 0.056 63129 61315 pg9624_def.cx9a2_bee 63286 0 29 0.2 120.7 26.3 0.000 0.004 0.002 0.425 7838 23.0 0.124 29 76.5 116.6 9.7 0.056 63429 61730 pg1023_def.cx9a2_bee 74543 0 32 0.3 137.2 30.1 0.000 0.004 0.002 0.413 9137 23.1 0.123 25 76.5 110.3 9.0 0.055 74816 72618 pg1122_def.cx9a2_bee 72747 0 33 0.3 133.8 29.4 0.000 0.004 0.002 0.413 8929 23.1 0.123 25 76.5 109.4 8.9 0.057 72919 70878 pg1217_def.cx9a2_bee 75365 0 32 0.3 103.8 30.6 0.000 0.003 0.001 0.416 9229 23.3 0.122 25 76.5 112.9 1.5 0.057 75518 73413 pg1313_def.cx9a2_bee 73394 0 32 0.3 103.8 30.3 0.000 0.004 0.001 0.422 8973 22.8 0.122 25 76.5 116.6 2.5 0.085 73619 71420 pg1410_def.cx9a2_bee 75529 0 32 0.3 109.3 31.2 0.000 0.003 0.001 0.423 9161 23.1 0.121 24 76.5 116.6 2.7 0.067 75715 73695 pg155_def.cx9a2_bee 75779 0 31 0.2 107.6 31.1 0.000 0.003 0.001 0.421 9198 23.0 0.121 24 76.5 116.6 1.7 0.056 75962 73918 pg161_def.cx9a2_bee
l.x
l.x: create secondary indexes
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 85034 0 358 42.8 179.8 48.5 0.004 0.516 0.002 0.584 384 12.3 0.005 12 153.8 154.0 8.9 0.012 NA NA pg9023_def.cx9a2_bee 82043 0 344 41.3 172.2 46.8 0.004 0.516 0.002 0.584 393 12.4 0.005 12 153.8 154.0 7.6 0.013 NA NA pg9124_def.cx9a2_bee 85671 0 362 43.1 180.4 48.9 0.004 0.516 0.002 0.584 354 12.5 0.004 12 153.8 154.0 6.4 0.004 NA NA pg9224_def.cx9a2_bee 83403 0 370 42.1 189.8 53.3 0.004 0.517 0.002 0.655 364 12.5 0.004 12 153.8 154.0 7.7 0.004 NA NA pg9325_def.cx9a2_bee 94073 0 260 31.9 167.3 43.3 0.003 0.347 0.002 0.472 288 12.5 0.003 11 153.8 154.0 10.3 0.004 NA NA pg9426_def.cx9a2_bee 112724 0 312 38.2 199.4 52.5 0.003 0.347 0.002 0.477 274 12.7 0.002 9 153.8 193.8 10.3 0.004 NA NA pg9525_def.cx9a2_bee 126203 0 393 48.1 277.4 64.1 0.003 0.390 0.002 0.520 305 12.8 0.002 8 153.8 193.8 10.3 0.003 NA NA pg9624_def.cx9a2_bee 186003 0 561 69.2 402.1 92.8 0.003 0.381 0.002 0.511 461 12.8 0.002 6 153.8 193.8 10.3 0.005 NA NA pg1023_def.cx9a2_bee 179816 0 541 66.9 388.3 91.7 0.003 0.381 0.002 0.522 455 12.7 0.003 6 153.8 193.8 10.3 0.006 NA NA pg1122_def.cx9a2_bee 182774 0 552 68.0 413.7 93.1 0.003 0.381 0.002 0.521 459 12.7 0.003 6 153.8 193.8 10.3 0.004 NA NA pg1217_def.cx9a2_bee 183655 0 545 67.6 185.2 67.2 0.003 0.377 0.001 0.374 374 12.5 0.002 5 153.6 190.0 10.2 0.005 NA NA pg1313_def.cx9a2_bee 185057 0 549 68.1 183.6 67.4 0.003 0.377 0.001 0.373 382 12.4 0.002 5 153.6 193.7 10.2 0.006 NA NA pg1410_def.cx9a2_bee 192678 0 584 72.5 191.2 71.8 0.003 0.385 0.001 0.381 402 12.4 0.002 5 153.6 193.7 10.2 0.004 NA NA pg155_def.cx9a2_bee 197287 0 598 74.2 203.4 73.6 0.003 0.385 0.001 0.382 404 12.5 0.002 5 153.6 193.7 10.3 0.006 NA NA pg161_def.cx9a2_bee
l.i1
l.i1: continue load after secondary indexes created with 50 inserts per transaction
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1131 0 1880 15.0 2392.7 37.7 1.662 13.563 2.116 34.166 4909 14.6 4.340 1033 154.5 154.6 9.9 0.228 899 599 pg9023_def.cx9a2_bee 1188 0 1974 15.7 2514.3 39.6 1.663 13.570 2.117 34.162 5106 14.8 4.300 997 154.5 154.7 10.0 0.199 949 649 pg9124_def.cx9a2_bee 1060 0 1762 14.0 2286.8 35.4 1.662 13.564 2.157 34.147 4864 14.7 4.589 1109 154.5 154.7 10.0 0.231 849 549 pg9224_def.cx9a2_bee 1104 0 1818 14.5 2387.1 36.9 1.647 13.432 2.163 34.255 4894 14.8 4.435 1073 154.5 154.7 10.2 0.098 850 599 pg9325_def.cx9a2_bee 1118 0 1839 14.6 2413.5 37.3 1.644 13.401 2.158 34.190 4880 14.8 4.364 1059 154.5 154.7 10.2 0.078 899 599 pg9426_def.cx9a2_bee 1181 0 1942 15.4 1998.1 30.0 1.645 13.327 1.692 25.980 4880 14.0 4.134 949 154.5 194.5 10.0 0.103 899 599 pg9525_def.cx9a2_bee 1159 0 1906 15.1 1944.4 29.6 1.644 13.324 1.677 26.178 4813 14.4 4.152 994 154.5 194.5 9.9 0.124 849 599 pg9624_def.cx9a2_bee 1139 0 1874 14.8 1882.3 29.1 1.645 13.334 1.652 26.165 4704 14.3 4.130 1004 154.5 194.5 9.1 0.056 849 599 pg1023_def.cx9a2_bee 1136 0 1875 14.8 1882.9 28.0 1.651 13.379 1.657 25.281 4712 14.4 4.148 1014 154.5 194.5 9.8 0.117 849 599 pg1122_def.cx9a2_bee 2243 0 3684 29.2 3691.4 53.3 1.642 13.317 1.645 24.344 8979 15.7 4.002 560 154.4 194.5 9.5 0.072 1948 1298 pg1217_def.cx9a2_bee 2116 0 3524 27.9 3589.0 52.6 1.665 13.503 1.696 25.447 8540 15.6 4.035 590 154.3 194.3 9.3 0.066 1798 1198 pg1313_def.cx9a2_bee 2099 0 3491 27.6 3554.0 51.5 1.664 13.487 1.693 25.112 8309 15.1 3.959 576 154.3 194.3 9.5 0.063 1798 1198 pg1410_def.cx9a2_bee 2040 0 3395 26.9 3446.1 49.9 1.664 13.489 1.690 25.042 7972 15.0 3.909 588 154.3 194.3 9.8 0.064 1699 1148 pg155_def.cx9a2_bee 2065 0 3450 27.3 3485.0 50.9 1.671 13.541 1.688 25.262 8037 15.2 3.892 589 154.3 194.3 10.1 0.058 1698 1149 pg161_def.cx9a2_bee
l.i2
l.i2: continue load after secondary indexes created with 5 inserts per transaction
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 55 0 89 0.7 124.0 1.9 1.609 13.122 2.247 34.370 643 12.4 11.643 17971 154.6 154.8 0.4 0.050 55 50 pg9023_def.cx9a2_bee 58 0 93 0.7 129.0 1.9 1.610 13.126 2.236 34.341 670 12.4 11.608 17192 154.6 154.8 0.3 0.036 60 50 pg9124_def.cx9a2_bee 51 0 82 0.7 128.2 1.7 1.609 13.121 2.509 34.372 665 12.4 13.020 19413 154.6 154.8 10.0 0.019 50 45 pg9224_def.cx9a2_bee 53 0 86 0.7 134.0 1.8 1.609 13.121 2.519 34.454 696 12.4 13.087 18647 154.6 154.8 0.9 0.016 55 45 pg9325_def.cx9a2_bee 54 0 87 0.7 135.7 1.8 1.612 13.140 2.522 34.505 702 12.4 13.047 18439 154.6 154.8 0.9 0.033 55 45 pg9426_def.cx9a2_bee 56 0 89 0.7 162.9 1.9 1.608 13.011 2.935 35.576 691 12.4 12.459 17874 154.6 182.2 10.2 0.017 55 50 pg9525_def.cx9a2_bee 54 0 86 0.7 133.5 1.8 1.609 13.022 2.491 35.020 791 12.5 14.755 18657 154.6 180.8 10.1 0.029 55 45 pg9624_def.cx9a2_bee 52 0 84 0.7 132.7 1.8 1.611 13.039 2.538 35.398 740 12.5 14.153 19120 154.6 182.0 10.1 0.039 50 45 pg1023_def.cx9a2_bee 53 0 85 0.7 135.6 1.8 1.610 13.051 2.577 35.910 729 12.5 13.856 19011 154.6 182.3 10.1 0.027 50 45 pg1122_def.cx9a2_bee 115 0 185 1.5 258.8 3.7 1.608 13.044 2.248 33.155 1279 12.9 11.116 8966 154.6 187.0 10.1 0.021 115 100 pg1217_def.cx9a2_bee 109 0 175 1.4 243.5 3.5 1.608 13.043 2.234 33.251 1219 12.7 11.188 9321 154.5 185.1 10.1 0.027 110 95 pg1313_def.cx9a2_bee 107 0 172 1.4 225.0 3.3 1.607 13.036 2.108 32.125 1074 12.5 10.067 9372 154.5 186.5 10.1 0.034 105 95 pg1410_def.cx9a2_bee 103 0 165 1.3 219.7 3.3 1.606 13.030 2.137 32.432 990 12.4 9.626 9650 154.5 186.7 10.1 0.034 100 90 pg155_def.cx9a2_bee 103 0 166 1.3 220.5 3.3 1.607 13.033 2.139 32.399 997 12.4 9.667 9622 154.5 186.6 10.1 0.032 105 90 pg161_def.cx9a2_bee
qr100.L1
qr100.L1: range queries with 100 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 100 7315 226 1.8 223.0 3.4 0.031 0.251 2.234 34.750 28605 12.7 3.910 139 154.7 154.8 0.2 0.011 7110 4621 pg9023_def.cx9a2_bee 100 7588 226 1.8 222.0 3.4 0.030 0.242 2.227 34.810 29666 12.5 3.909 132 154.7 154.8 0.2 0.011 7448 4347 pg9124_def.cx9a2_bee 100 8141 167 1.3 227.1 3.4 0.020 0.169 2.278 34.749 31660 12.6 3.889 124 154.7 154.8 9.8 0.010 7768 7465 pg9224_def.cx9a2_bee 100 8073 167 1.3 247.6 3.5 0.021 0.170 2.483 35.796 31470 12.5 3.898 124 154.7 154.8 0.7 0.010 7833 7589 pg9325_def.cx9a2_bee 100 8366 167 1.3 245.9 3.5 0.020 0.162 2.468 35.717 32623 12.9 3.900 123 154.7 154.8 0.7 0.010 7863 7575 pg9426_def.cx9a2_bee 100 8227 167 1.4 19.7 1.5 0.020 0.169 0.198 15.381 31958 12.8 3.885 124 154.7 194.7 10.2 0.010 7753 7432 pg9525_def.cx9a2_bee 100 8203 167 1.4 15.3 1.5 0.020 0.169 0.153 15.516 31867 13.4 3.885 131 154.7 194.7 10.2 0.010 7815 7542 pg9624_def.cx9a2_bee 100 7904 167 1.4 15.2 1.5 0.021 0.175 0.153 15.544 30752 12.6 3.891 128 154.7 194.7 10.2 0.010 7662 7462 pg1023_def.cx9a2_bee 100 8552 167 1.4 15.5 1.5 0.020 0.162 0.155 15.565 33222 13.5 3.885 126 154.7 194.7 10.2 0.010 8092 7817 pg1122_def.cx9a2_bee 100 8445 167 1.4 15.6 1.5 0.020 0.164 0.156 15.556 32832 13.2 3.888 125 154.6 194.7 10.2 0.010 8088 7877 pg1217_def.cx9a2_bee 100 8338 166 1.4 15.2 1.5 0.020 0.166 0.152 15.486 32427 12.9 3.889 124 154.5 190.5 10.2 0.010 8061 7863 pg1313_def.cx9a2_bee 100 5823 184 1.6 72.1 2.1 0.032 0.285 0.723 21.640 22808 13.8 3.917 190 154.5 182.5 10.1 0.714 5789 5462 pg1410_def.cx9a2_bee 100 5855 183 1.6 71.1 2.1 0.031 0.284 0.712 21.530 22874 14.0 3.907 191 154.5 181.3 10.1 0.732 5757 5480 pg155_def.cx9a2_bee 100 5939 184 1.6 71.0 2.1 0.031 0.280 0.712 21.561 23215 14.0 3.909 189 154.5 181.7 10.1 0.732 5832 5435 pg161_def.cx9a2_bee
qp100.L2
qp100.L2: point queries with 100 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 100 401 6936 54.8 216.1 3.3 17.283 139.898 2.165 34.226 15273 4.0 38.058 797 154.7 154.8 1.5 0.015 400 336 pg9023_def.cx9a2_bee 100 393 6806 53.8 215.1 3.3 17.311 140.138 2.155 34.240 14984 4.0 38.107 814 154.7 154.8 0.6 0.014 400 335 pg9124_def.cx9a2_bee 100 396 6851 54.2 218.7 3.3 17.287 140.004 2.191 34.241 15092 3.9 38.081 787 154.7 154.9 9.8 0.042 400 336 pg9224_def.cx9a2_bee 100 393 6793 53.7 223.8 3.4 17.302 140.154 2.244 34.601 15007 3.9 38.226 795 154.7 154.9 1.5 0.039 400 320 pg9325_def.cx9a2_bee 100 396 6854 54.2 223.9 3.4 17.303 140.148 2.245 34.609 15110 3.9 38.146 788 154.7 154.8 1.0 0.014 400 335 pg9426_def.cx9a2_bee 100 400 6903 54.5 392.6 4.5 17.279 139.805 3.934 45.919 15188 4.0 38.017 801 154.7 194.7 10.2 0.016 400 336 pg9525_def.cx9a2_bee 100 396 6841 54.1 392.7 4.5 17.287 139.891 3.935 45.778 15142 4.2 38.265 849 154.7 194.7 10.1 0.016 400 336 pg9624_def.cx9a2_bee 100 395 6832 54.0 392.4 4.5 17.305 140.046 3.935 45.808 15061 4.1 38.147 831 154.7 194.7 10.1 0.015 400 320 pg1023_def.cx9a2_bee 100 395 6833 54.0 391.4 4.5 17.303 140.012 3.926 45.766 15059 4.1 38.134 831 154.7 193.0 10.1 0.019 400 336 pg1122_def.cx9a2_bee 100 397 6844 53.9 391.5 4.5 17.238 139.131 3.927 45.723 15080 4.0 37.985 806 154.6 193.0 10.2 0.012 400 335 pg1217_def.cx9a2_bee 100 394 6782 53.5 392.2 4.5 17.235 139.126 3.930 45.737 14948 4.0 37.987 813 154.5 190.5 10.2 0.013 400 320 pg1313_def.cx9a2_bee 100 392 6793 53.6 335.0 4.1 17.316 139.801 3.363 42.504 14919 4.9 38.030 999 154.5 181.0 10.1 0.011 400 320 pg1410_def.cx9a2_bee 100 391 6766 53.4 336.1 4.1 17.301 139.685 3.371 42.547 14797 4.9 37.833 1002 154.5 179.7 10.1 0.011 400 334 pg155_def.cx9a2_bee 100 391 6767 53.3 335.8 4.1 17.294 139.599 3.364 42.489 14809 4.9 37.847 1002 154.5 180.1 10.1 0.015 400 335 pg161_def.cx9a2_bee
qr500.L3
qr500.L3: range queries with 500 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 499 6601 943 7.6 1126.6 17.3 0.143 1.172 2.257 35.440 27578 15.7 4.178 190 154.8 154.9 0.7 0.031 6534 3711 pg9023_def.cx9a2_bee 499 7010 943 7.6 1125.9 17.3 0.135 1.103 2.257 35.496 29137 15.7 4.156 179 154.8 154.9 0.7 0.022 6967 4107 pg9124_def.cx9a2_bee 499 7363 884 7.1 1139.3 17.1 0.120 0.990 2.285 35.106 30498 16.2 4.142 176 154.8 154.9 10.1 0.028 7192 6243 pg9224_def.cx9a2_bee 499 7389 884 7.1 1233.2 17.7 0.120 0.986 2.472 36.254 30892 16.1 4.181 174 154.8 154.9 1.5 0.043 7223 6425 pg9325_def.cx9a2_bee 499 7407 884 7.1 1243.6 17.7 0.119 0.984 2.494 36.279 31035 16.1 4.190 174 154.8 154.9 9.6 0.031 7286 6450 pg9426_def.cx9a2_bee 499 7375 884 7.1 630.7 11.0 0.120 0.980 1.264 22.669 30410 15.7 4.124 170 154.8 192.3 9.6 0.020 7192 6295 pg9525_def.cx9a2_bee 499 7595 885 7.1 614.6 11.1 0.116 0.953 1.232 22.841 31257 16.0 4.116 169 154.8 192.3 9.5 0.035 7335 6536 pg9624_def.cx9a2_bee 499 7342 884 7.1 615.5 11.1 0.120 0.985 1.234 22.876 30278 16.1 4.124 175 154.8 192.3 9.4 0.027 7108 6265 pg1023_def.cx9a2_bee 499 7761 884 7.1 614.7 11.1 0.114 0.932 1.233 22.892 31908 16.2 4.111 167 154.8 190.6 9.5 0.024 7543 6792 pg1122_def.cx9a2_bee 498 8067 883 7.1 613.3 11.1 0.109 0.895 1.231 22.870 33065 15.1 4.099 150 154.7 190.6 9.6 0.031 7768 7303 pg1217_def.cx9a2_bee 499 8102 883 7.1 615.6 11.1 0.109 0.892 1.233 22.822 33136 15.2 4.090 150 154.6 188.1 9.6 0.037 7782 7304 pg1313_def.cx9a2_bee 499 5918 886 7.2 643.1 11.8 0.150 1.240 1.289 24.201 24803 20.3 4.191 274 154.7 178.6 9.6 0.023 5769 5343 pg1410_def.cx9a2_bee 499 5847 885 7.2 642.4 11.8 0.151 1.254 1.288 24.189 24464 20.6 4.184 282 154.7 177.3 9.6 0.020 5702 5330 pg155_def.cx9a2_bee 499 5861 885 7.2 641.7 11.8 0.151 1.252 1.287 24.177 24531 20.6 4.185 281 154.7 177.7 9.4 0.025 5708 5327 pg161_def.cx9a2_bee
qp500.L4
qp500.L4: point queries with 500 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 499 383 7493 59.1 1068.1 16.7 19.565 158.136 2.140 34.199 16657 9.6 43.491 2005 154.8 155.0 0.7 0.038 384 335 pg9023_def.cx9a2_bee 499 378 7406 58.4 1068.2 16.7 19.618 158.549 2.142 34.227 16464 9.3 43.614 1971 154.8 155.0 0.7 0.022 384 320 pg9124_def.cx9a2_bee 499 367 7224 57.0 1089.8 16.7 19.689 159.185 2.185 34.263 16187 9.5 44.118 2071 154.8 155.0 10.1 0.042 368 319 pg9224_def.cx9a2_bee 499 363 7161 56.6 1100.7 16.7 19.723 159.487 2.207 34.377 16093 9.5 44.322 2093 154.8 155.0 4.3 0.047 368 303 pg9325_def.cx9a2_bee 498 371 7304 57.7 1101.9 16.8 19.677 159.117 2.211 34.422 16410 9.5 44.208 2047 154.8 155.0 9.2 0.032 384 319 pg9426_def.cx9a2_bee 499 379 7417 58.4 1338.7 16.8 19.586 157.976 2.682 34.484 16348 9.1 43.169 1922 154.8 191.2 9.2 0.045 384 320 pg9525_def.cx9a2_bee 499 381 7457 58.7 1327.6 16.8 19.576 157.915 2.660 34.371 16437 9.4 43.152 1974 154.8 191.2 8.8 0.023 384 320 pg9624_def.cx9a2_bee 499 379 7428 58.5 1325.8 16.7 19.608 158.183 2.659 34.356 16319 9.4 43.080 1985 154.8 191.0 8.8 0.036 384 320 pg1023_def.cx9a2_bee 499 380 7439 58.6 1327.7 16.7 19.598 158.102 2.663 34.370 16346 9.4 43.062 1981 154.8 188.2 8.7 0.035 384 320 pg1122_def.cx9a2_bee 499 385 7504 59.0 1329.6 16.7 19.505 156.995 2.666 34.362 16468 7.0 42.807 1456 154.8 188.1 8.7 0.035 384 320 pg1217_def.cx9a2_bee 499 381 7440 58.5 1326.9 16.7 19.537 157.233 2.660 34.349 16341 7.1 42.911 1492 154.7 186.6 8.9 0.047 384 320 pg1313_def.cx9a2_bee 499 371 7287 57.2 1300.6 16.6 19.662 158.186 2.607 34.099 15949 13.0 43.036 2806 154.8 176.2 9.3 0.030 368 320 pg1410_def.cx9a2_bee 499 369 7252 57.0 1299.8 16.6 19.664 158.200 2.606 34.074 15816 13.2 42.886 2863 154.8 176.2 9.4 0.033 368 320 pg155_def.cx9a2_bee 499 369 7264 57.1 1300.4 16.6 19.668 158.205 2.607 34.078 15837 13.2 42.885 2859 154.8 175.9 9.0 0.033 368 320 pg161_def.cx9a2_bee
qr1000.L5
qr1000.L5: range queries with 1000 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 796 5134 1406 11.3 1788.0 27.8 0.274 2.260 2.247 35.797 23203 26.6 4.520 415 155.0 155.2 1.1 0.124 5083 3436 pg9023_def.cx9a2_bee 825 5386 1457 11.7 1853.7 28.8 0.271 2.231 2.247 35.790 24308 26.6 4.514 395 155.0 155.2 1.1 0.130 5356 3493 pg9124_def.cx9a2_bee 742 5399 1251 10.1 1693.1 25.4 0.232 1.920 2.283 35.128 24064 26.6 4.457 394 155.0 155.2 10.1 0.193 5322 4829 pg9224_def.cx9a2_bee 767 5584 1294 10.5 1910.9 27.3 0.232 1.921 2.491 36.411 25430 26.9 4.554 385 155.0 155.2 2.4 0.203 5515 4959 pg9325_def.cx9a2_bee 779 5614 1314 10.6 1930.2 27.6 0.234 1.941 2.477 36.315 25628 27.0 4.565 385 155.0 155.2 2.5 0.120 5513 5033 pg9426_def.cx9a2_bee 797 5519 1346 10.8 1310.4 19.9 0.244 2.001 1.645 25.548 24595 26.1 4.457 378 155.0 190.8 9.4 0.138 5403 4922 pg9525_def.cx9a2_bee 780 5626 1317 10.6 1229.5 19.3 0.234 1.922 1.576 25.347 24965 26.6 4.438 378 155.0 190.8 9.2 0.146 5498 5034 pg9624_def.cx9a2_bee 760 5364 1284 10.3 1196.9 18.8 0.239 1.965 1.574 25.329 23812 26.5 4.439 395 155.0 190.7 9.2 0.139 5322 4826 pg1023_def.cx9a2_bee 767 5737 1295 10.4 1208.6 18.8 0.226 1.855 1.576 25.158 25263 26.5 4.403 370 155.0 186.9 9.0 0.148 5643 5050 pg1122_def.cx9a2_bee 998 7162 1683 13.5 1558.6 23.4 0.235 1.931 1.561 23.982 31477 22.0 4.395 246 154.9 186.8 8.6 0.148 6968 6029 pg1217_def.cx9a2_bee 998 7090 1683 13.5 1556.1 23.3 0.237 1.951 1.560 23.953 31208 22.4 4.402 253 154.8 185.4 8.8 0.133 6904 5898 pg1313_def.cx9a2_bee 611 5139 1036 8.3 978.5 16.6 0.202 1.660 1.602 27.884 22250 25.8 4.330 402 155.1 180.3 9.1 0.115 5146 4824 pg1410_def.cx9a2_bee 588 5156 996 8.0 942.5 15.9 0.193 1.589 1.603 27.673 22146 25.7 4.295 399 155.1 179.8 9.3 0.109 5147 4806 pg155_def.cx9a2_bee 590 5160 1001 8.0 948.1 16.1 0.194 1.597 1.606 27.876 22189 25.7 4.300 398 155.1 179.8 8.9 0.122 5162 4811 pg161_def.cx9a2_bee
qp1000.L6
qp1000.L6: point queries with 1000 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 503 365 7180 56.6 1088.4 16.9 19.687 159.059 2.165 34.514 16262 17.3 44.591 3795 155.2 155.4 8.1 0.041 368 304 pg9023_def.cx9a2_bee 526 357 7100 56.0 1138.6 17.7 19.899 160.762 2.166 34.514 16121 17.3 45.183 3879 155.2 155.4 7.4 0.042 368 304 pg9124_def.cx9a2_bee 467 358 6976 55.1 1027.1 15.7 19.513 157.758 2.200 34.517 15924 17.1 44.542 3827 155.2 155.4 10.0 0.038 368 304 pg9224_def.cx9a2_bee 483 348 6870 54.2 1103.2 16.5 19.714 159.377 2.283 34.972 15830 17.1 45.423 3925 155.2 155.4 5.3 0.042 352 303 pg9325_def.cx9a2_bee 491 349 6894 54.4 1120.0 16.8 19.755 159.686 2.281 34.935 15914 17.1 45.600 3920 155.2 155.4 6.0 0.042 352 288 pg9426_def.cx9a2_bee 506 358 7074 55.7 1235.5 15.9 19.777 159.450 2.443 32.138 15801 17.1 44.175 3824 155.2 191.1 9.4 0.050 368 288 pg9525_def.cx9a2_bee 495 369 7237 57.0 1186.2 15.6 19.597 158.036 2.398 32.345 16131 17.5 43.681 3791 155.2 191.0 9.2 0.043 368 304 pg9624_def.cx9a2_bee 481 368 7192 56.7 1157.6 15.3 19.538 157.606 2.406 32.480 15966 17.4 43.373 3782 155.2 190.9 9.2 0.035 368 304 pg1023_def.cx9a2_bee 485 369 7215 56.8 1165.8 15.4 19.568 157.832 2.403 32.467 16010 17.3 43.422 3754 155.2 185.7 9.0 0.041 368 304 pg1122_def.cx9a2_bee 979 362 8147 64.0 2278.9 29.0 22.480 180.725 2.329 30.355 18020 17.2 49.724 3797 155.2 187.0 8.2 0.038 368 320 pg1217_def.cx9a2_bee 954 360 8057 63.3 2231.0 28.8 22.400 180.093 2.339 30.939 17859 17.5 49.649 3892 155.0 186.3 8.3 0.040 368 304 pg1313_def.cx9a2_bee 494 365 7172 56.4 1179.1 15.7 19.633 157.977 2.384 32.437 15823 17.0 43.316 3723 155.4 180.6 9.1 0.036 368 304 pg1410_def.cx9a2_bee 476 365 7117 55.9 1134.4 15.1 19.514 157.029 2.383 32.516 15646 16.9 42.901 3707 155.4 180.1 9.2 0.036 368 304 pg155_def.cx9a2_bee 478 365 7134 56.0 1139.4 15.2 19.529 157.111 2.384 32.524 15668 16.8 42.891 3679 155.4 180.1 9.0 0.035 368 304 pg161_def.cx9a2_bee
l.i0
- l.i0: load without secondary indexes
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 99.079 0.721 0.200 0.000 0.000 0.000 0.000 0.000 0.051 pg9023_def.cx9a2_bee 0.000 0.000 99.892 0.108 nonzero 0.000 0.000 0.000 0.000 0.000 0.058 pg9124_def.cx9a2_bee 0.000 0.000 99.892 0.098 0.011 nonzero 0.000 0.000 0.000 0.000 0.083 pg9224_def.cx9a2_bee 0.000 0.000 99.884 0.101 0.015 nonzero 0.000 0.000 0.000 0.000 0.076 pg9325_def.cx9a2_bee 0.000 0.000 99.884 0.100 0.016 nonzero 0.000 0.000 0.000 0.000 0.072 pg9426_def.cx9a2_bee 0.000 0.000 99.998 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.060 pg9525_def.cx9a2_bee 0.000 0.000 99.999 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.056 pg9624_def.cx9a2_bee 0.000 0.000 99.999 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.056 pg1023_def.cx9a2_bee 0.000 0.000 99.999 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.055 pg1122_def.cx9a2_bee 0.000 0.000 99.999 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.057 pg1217_def.cx9a2_bee 0.000 0.000 99.998 0.002 0.001 0.000 0.000 0.000 0.000 0.000 0.057 pg1313_def.cx9a2_bee 0.000 0.000 99.998 0.002 0.001 nonzero 0.000 0.000 0.000 0.000 0.085 pg1410_def.cx9a2_bee 0.000 0.000 99.997 0.003 0.001 nonzero 0.000 0.000 0.000 0.000 0.067 pg155_def.cx9a2_bee 0.000 0.000 99.998 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.056 pg161_def.cx9a2_bee
l.x
- l.x: create secondary indexes
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
TODO - determine whether there is data for create index response time
l.i1
- l.i1: continue load after secondary indexes created with 50 inserts per transaction
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 2.570 97.282 0.147 0.000 0.000 0.000 0.000 0.228 pg9023_def.cx9a2_bee 0.000 0.000 0.000 7.337 92.578 0.085 0.000 0.000 0.000 0.000 0.199 pg9124_def.cx9a2_bee 0.000 0.000 0.000 4.617 95.270 0.112 0.000 0.000 0.000 0.000 0.231 pg9224_def.cx9a2_bee 0.000 0.000 0.000 3.208 96.761 0.031 0.000 0.000 0.000 0.000 0.098 pg9325_def.cx9a2_bee 0.000 0.000 0.000 4.001 95.975 0.024 0.000 0.000 0.000 0.000 0.078 pg9426_def.cx9a2_bee 0.000 0.000 0.000 84.154 15.764 0.083 0.000 0.000 0.000 0.000 0.103 pg9525_def.cx9a2_bee 0.000 0.000 0.000 95.877 4.120 0.003 0.000 0.000 0.000 0.000 0.124 pg9624_def.cx9a2_bee 0.000 0.000 0.000 94.935 5.065 0.000 0.000 0.000 0.000 0.000 0.056 pg1023_def.cx9a2_bee 0.000 0.000 0.000 93.856 6.143 0.001 0.000 0.000 0.000 0.000 0.117 pg1122_def.cx9a2_bee 0.000 0.000 0.000 90.531 9.467 0.001 0.000 0.000 0.000 0.000 0.072 pg1217_def.cx9a2_bee 0.000 0.000 0.000 86.225 13.774 0.001 0.000 0.000 0.000 0.000 0.066 pg1313_def.cx9a2_bee 0.000 0.000 0.000 87.093 12.907 0.000 0.000 0.000 0.000 0.000 0.063 pg1410_def.cx9a2_bee 0.000 0.000 0.000 89.821 10.179 0.000 0.000 0.000 0.000 0.000 0.064 pg155_def.cx9a2_bee 0.000 0.000 0.000 93.510 6.490 0.000 0.000 0.000 0.000 0.000 0.058 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.334 2.948 12.296 63.504 20.919 0.000 0.000 0.000 0.000 0.093 pg9023_def.cx9a2_bee 0.000 0.363 3.069 13.720 65.692 17.156 0.000 0.000 0.000 0.000 0.082 pg9124_def.cx9a2_bee 0.000 0.314 2.708 11.934 58.421 26.624 0.000 0.000 0.000 0.000 0.092 pg9224_def.cx9a2_bee 0.000 0.398 2.789 12.415 60.708 23.691 0.000 0.000 0.000 0.000 0.089 pg9325_def.cx9a2_bee 0.000 0.481 2.855 13.969 59.656 23.039 0.000 0.000 0.000 0.000 0.090 pg9426_def.cx9a2_bee 0.000 0.513 2.562 16.344 60.093 20.489 0.000 0.000 0.000 0.000 0.085 pg9525_def.cx9a2_bee 0.000 0.361 2.826 15.565 58.294 22.954 0.000 0.000 0.000 0.000 0.123 pg9624_def.cx9a2_bee 0.000 0.248 2.711 15.431 57.009 24.601 0.000 0.000 0.000 0.000 0.089 pg1023_def.cx9a2_bee 0.000 0.316 2.488 15.757 56.876 24.562 0.000 0.000 0.000 0.000 0.110 pg1122_def.cx9a2_bee 0.004 0.431 6.149 35.110 58.306 0.000 0.000 0.000 0.000 0.000 0.040 pg1217_def.cx9a2_bee 0.003 0.446 6.054 32.001 61.496 0.000 0.000 0.000 0.000 0.000 0.043 pg1313_def.cx9a2_bee 0.004 0.685 5.170 32.216 61.925 0.000 0.000 0.000 0.000 0.000 0.048 pg1410_def.cx9a2_bee 0.000 0.616 5.410 30.289 63.685 0.000 0.000 0.000 0.000 0.000 0.046 pg155_def.cx9a2_bee 0.000 0.670 5.299 30.378 63.654 0.000 0.000 0.000 0.000 0.000 0.046 pg161_def.cx9a2_bee
l.i2
- l.i2: continue load after secondary indexes created with 5 inserts per transaction
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 83.459 16.496 0.045 0.000 0.000 0.000 0.000 0.000 0.050 pg9023_def.cx9a2_bee 0.000 0.000 84.408 15.590 0.002 0.000 0.000 0.000 0.000 0.000 0.036 pg9124_def.cx9a2_bee 0.000 0.000 85.043 14.957 0.001 0.000 0.000 0.000 0.000 0.000 0.019 pg9224_def.cx9a2_bee 0.000 0.000 89.076 10.924 0.001 0.000 0.000 0.000 0.000 0.000 0.016 pg9325_def.cx9a2_bee 0.000 0.000 92.674 7.324 0.002 0.000 0.000 0.000 0.000 0.000 0.033 pg9426_def.cx9a2_bee 0.000 0.003 98.201 1.795 0.001 0.000 0.000 0.000 0.000 0.000 0.017 pg9525_def.cx9a2_bee 0.000 0.002 94.686 5.300 0.013 0.000 0.000 0.000 0.000 0.000 0.029 pg9624_def.cx9a2_bee 0.000 0.001 94.030 5.957 0.013 0.000 0.000 0.000 0.000 0.000 0.039 pg1023_def.cx9a2_bee 0.000 0.006 93.420 6.561 0.013 0.000 0.000 0.000 0.000 0.000 0.027 pg1122_def.cx9a2_bee 0.000 0.003 97.033 2.955 0.009 0.000 0.000 0.000 0.000 0.000 0.021 pg1217_def.cx9a2_bee 0.000 0.003 98.108 1.880 0.009 0.000 0.000 0.000 0.000 0.000 0.027 pg1313_def.cx9a2_bee 0.000 0.007 99.510 0.471 0.012 0.000 0.000 0.000 0.000 0.000 0.034 pg1410_def.cx9a2_bee 0.000 0.003 98.466 1.515 0.015 0.000 0.000 0.000 0.000 0.000 0.034 pg155_def.cx9a2_bee 0.000 0.005 98.938 1.044 0.013 0.000 0.000 0.000 0.000 0.000 0.032 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.183 pg9023_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.176 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.187 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.168 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.164 pg9426_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.135 pg9525_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.154 pg9624_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.153 pg1023_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.134 pg1122_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.107 pg1217_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.102 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.111 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.110 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.108 pg161_def.cx9a2_bee
qr100.L1
- qr100.L1: range queries with 100 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.803 0.113 0.083 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9023_def.cx9a2_bee 99.797 0.121 0.080 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9124_def.cx9a2_bee 99.881 0.117 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9224_def.cx9a2_bee 99.873 0.126 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9325_def.cx9a2_bee 99.890 0.109 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9426_def.cx9a2_bee 99.892 0.107 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 99.875 0.123 0.001 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9624_def.cx9a2_bee 99.871 0.128 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1023_def.cx9a2_bee 99.900 0.099 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1122_def.cx9a2_bee 99.881 0.118 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1217_def.cx9a2_bee 99.885 0.114 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1313_def.cx9a2_bee 93.546 6.448 0.001 0.005 nonzero nonzero nonzero 0.000 0.000 0.000 0.714 pg1410_def.cx9a2_bee 93.886 6.107 0.001 0.006 nonzero nonzero nonzero 0.000 0.000 0.000 0.732 pg155_def.cx9a2_bee 94.030 5.964 0.001 0.006 nonzero nonzero nonzero 0.000 0.000 0.000 0.732 pg161_def.cx9a2_bee
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 2.528 97.472 0.000 0.000 0.000 0.000 0.000 0.040 pg9023_def.cx9a2_bee 0.000 0.000 0.000 8.389 91.611 0.000 0.000 0.000 0.000 0.000 0.035 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.417 99.583 0.000 0.000 0.000 0.000 0.000 0.037 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.028 99.944 0.028 0.000 0.000 0.000 0.000 0.071 pg9325_def.cx9a2_bee 0.000 0.000 0.000 1.056 98.944 0.000 0.000 0.000 0.000 0.000 0.037 pg9426_def.cx9a2_bee 0.000 0.000 0.000 47.500 52.500 0.000 0.000 0.000 0.000 0.000 0.032 pg9525_def.cx9a2_bee 0.000 0.000 0.000 49.583 50.417 0.000 0.000 0.000 0.000 0.000 0.046 pg9624_def.cx9a2_bee 0.000 0.000 0.000 51.500 48.500 0.000 0.000 0.000 0.000 0.000 0.031 pg1023_def.cx9a2_bee 0.000 0.000 0.000 51.167 48.833 0.000 0.000 0.000 0.000 0.000 0.031 pg1122_def.cx9a2_bee 0.000 0.000 0.000 52.389 47.611 0.000 0.000 0.000 0.000 0.000 0.030 pg1217_def.cx9a2_bee 0.000 0.000 0.000 52.250 47.750 0.000 0.000 0.000 0.000 0.000 0.030 pg1313_def.cx9a2_bee 0.000 0.000 0.000 57.028 42.972 0.000 0.000 0.000 0.000 0.000 0.031 pg1410_def.cx9a2_bee 0.000 0.000 0.000 56.139 43.861 0.000 0.000 0.000 0.000 0.000 0.031 pg155_def.cx9a2_bee 0.000 0.000 0.000 60.778 39.222 0.000 0.000 0.000 0.000 0.000 0.030 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 10.944 65.556 23.500 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9023_def.cx9a2_bee 0.000 11.361 68.444 20.194 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9124_def.cx9a2_bee 0.000 9.389 60.611 30.000 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9224_def.cx9a2_bee 0.000 10.472 60.778 28.750 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9325_def.cx9a2_bee 0.000 9.889 62.667 27.444 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9426_def.cx9a2_bee 0.000 10.111 63.417 26.472 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 0.000 10.556 63.333 26.111 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9624_def.cx9a2_bee 0.000 9.306 62.028 28.667 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1023_def.cx9a2_bee 0.000 10.000 61.694 28.306 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg1122_def.cx9a2_bee 0.000 27.222 72.667 0.111 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg1217_def.cx9a2_bee 0.000 25.222 74.333 0.444 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.114 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.917 0.083 0.000 0.000 0.000 0.000 0.126 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.126 pg161_def.cx9a2_bee
qp100.L2
- qp100.L2: point queries with 100 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 99.502 0.498 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg9023_def.cx9a2_bee 0.000 0.000 99.387 0.613 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg9124_def.cx9a2_bee 0.000 nonzero 99.134 0.866 nonzero 0.000 0.000 0.000 0.000 0.000 0.042 pg9224_def.cx9a2_bee 0.000 nonzero 98.493 1.506 0.001 0.000 0.000 0.000 0.000 0.000 0.039 pg9325_def.cx9a2_bee 0.000 nonzero 99.494 0.506 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg9426_def.cx9a2_bee 0.000 nonzero 99.471 0.529 0.000 0.000 0.000 0.000 0.000 0.000 0.016 pg9525_def.cx9a2_bee 0.000 nonzero 99.693 0.306 nonzero 0.000 0.000 0.000 0.000 0.000 0.016 pg9624_def.cx9a2_bee 0.000 0.000 99.637 0.363 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg1023_def.cx9a2_bee 0.000 nonzero 99.686 0.313 nonzero 0.000 0.000 0.000 0.000 0.000 0.019 pg1122_def.cx9a2_bee 0.000 nonzero 99.651 0.349 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg1217_def.cx9a2_bee 0.000 nonzero 99.680 0.320 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg1313_def.cx9a2_bee 0.000 nonzero 99.712 0.287 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1410_def.cx9a2_bee 0.000 0.001 99.699 0.300 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg155_def.cx9a2_bee 0.000 nonzero 99.690 0.310 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg161_def.cx9a2_bee
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.044 pg9023_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.044 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.051 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.046 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.037 pg9426_def.cx9a2_bee 0.000 0.000 0.000 8.111 91.889 0.000 0.000 0.000 0.000 0.000 0.029 pg9525_def.cx9a2_bee 0.000 0.000 0.000 17.472 82.528 0.000 0.000 0.000 0.000 0.000 0.032 pg9624_def.cx9a2_bee 0.000 0.000 0.000 16.944 83.056 0.000 0.000 0.000 0.000 0.000 0.032 pg1023_def.cx9a2_bee 0.000 0.000 0.000 17.722 82.278 0.000 0.000 0.000 0.000 0.000 0.037 pg1122_def.cx9a2_bee 0.000 0.000 0.000 21.611 78.389 0.000 0.000 0.000 0.000 0.000 0.038 pg1217_def.cx9a2_bee 0.000 0.000 0.000 20.250 79.750 0.000 0.000 0.000 0.000 0.000 0.031 pg1313_def.cx9a2_bee 0.000 0.000 0.000 16.417 83.583 0.000 0.000 0.000 0.000 0.000 0.029 pg1410_def.cx9a2_bee 0.000 0.000 0.000 13.194 86.806 0.000 0.000 0.000 0.000 0.000 0.030 pg155_def.cx9a2_bee 0.000 0.000 0.000 16.806 83.194 0.000 0.000 0.000 0.000 0.000 0.029 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.139 99.833 0.028 0.000 0.000 0.000 0.000 0.000 0.016 pg9023_def.cx9a2_bee 0.000 0.000 0.556 99.417 0.028 0.000 0.000 0.000 0.000 0.000 0.016 pg9124_def.cx9a2_bee 0.000 0.000 0.000 99.917 0.083 0.000 0.000 0.000 0.000 0.000 0.017 pg9224_def.cx9a2_bee 0.000 0.000 0.056 99.833 0.111 0.000 0.000 0.000 0.000 0.000 0.017 pg9325_def.cx9a2_bee 0.000 0.000 0.028 99.917 0.056 0.000 0.000 0.000 0.000 0.000 0.016 pg9426_def.cx9a2_bee 0.000 0.000 0.056 99.944 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg9525_def.cx9a2_bee 0.000 0.000 0.250 99.750 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg9624_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg1023_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg1122_def.cx9a2_bee 0.000 0.000 65.917 34.083 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1217_def.cx9a2_bee 0.000 0.000 54.611 45.389 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.972 0.028 0.000 0.000 0.000 0.000 0.118 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.917 0.083 0.000 0.000 0.000 0.000 0.124 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.115 pg161_def.cx9a2_bee
qr500.L3
- qr500.L3: range queries with 500 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 98.320 1.584 0.094 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.031 pg9023_def.cx9a2_bee 98.983 0.927 0.088 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.022 pg9124_def.cx9a2_bee 99.202 0.794 0.003 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.028 pg9224_def.cx9a2_bee 99.456 0.538 0.006 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.043 pg9325_def.cx9a2_bee 99.451 0.544 0.005 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.031 pg9426_def.cx9a2_bee 99.397 0.597 0.003 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.020 pg9525_def.cx9a2_bee 99.687 0.308 0.003 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.035 pg9624_def.cx9a2_bee 99.496 0.498 0.003 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.027 pg1023_def.cx9a2_bee 99.717 0.278 0.002 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.024 pg1122_def.cx9a2_bee 99.798 0.198 0.002 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.031 pg1217_def.cx9a2_bee 99.798 0.197 0.002 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.037 pg1313_def.cx9a2_bee 93.344 6.644 0.008 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.023 pg1410_def.cx9a2_bee 93.048 6.939 0.008 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.020 pg155_def.cx9a2_bee 93.002 6.986 0.008 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.025 pg161_def.cx9a2_bee
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 9.722 90.278 0.000 0.000 0.000 0.000 0.000 0.044 pg9023_def.cx9a2_bee 0.000 0.000 0.000 20.372 79.628 0.000 0.000 0.000 0.000 0.000 0.046 pg9124_def.cx9a2_bee 0.000 0.000 0.000 1.172 98.828 0.000 0.000 0.000 0.000 0.000 0.046 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.167 99.800 0.033 0.000 0.000 0.000 0.000 0.089 pg9325_def.cx9a2_bee 0.000 0.000 0.000 2.050 97.950 0.000 0.000 0.000 0.000 0.000 0.040 pg9426_def.cx9a2_bee 0.000 0.000 0.000 66.072 33.928 0.000 0.000 0.000 0.000 0.000 0.039 pg9525_def.cx9a2_bee 0.000 0.000 0.000 79.322 20.678 0.000 0.000 0.000 0.000 0.000 0.048 pg9624_def.cx9a2_bee 0.000 0.000 0.000 83.083 16.917 0.000 0.000 0.000 0.000 0.000 0.037 pg1023_def.cx9a2_bee 0.000 0.000 0.000 79.700 20.300 0.000 0.000 0.000 0.000 0.000 0.058 pg1122_def.cx9a2_bee 0.000 0.000 0.000 81.056 18.939 0.006 0.000 0.000 0.000 0.000 0.064 pg1217_def.cx9a2_bee 0.000 0.000 0.000 80.150 19.844 0.006 0.000 0.000 0.000 0.000 0.085 pg1313_def.cx9a2_bee 0.000 0.000 0.000 81.711 18.289 0.000 0.000 0.000 0.000 0.000 0.034 pg1410_def.cx9a2_bee 0.000 0.000 0.000 82.750 17.250 0.000 0.000 0.000 0.000 0.000 0.034 pg155_def.cx9a2_bee 0.000 0.000 0.000 80.578 19.422 0.000 0.000 0.000 0.000 0.000 0.034 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 38.311 61.689 0.000 0.000 0.000 0.000 0.000 0.037 pg9023_def.cx9a2_bee 0.000 0.000 0.000 42.500 57.500 0.000 0.000 0.000 0.000 0.000 0.035 pg9124_def.cx9a2_bee 0.000 0.000 0.000 33.328 66.672 0.000 0.000 0.000 0.000 0.000 0.044 pg9224_def.cx9a2_bee 0.000 0.000 0.000 36.250 63.750 0.000 0.000 0.000 0.000 0.000 0.039 pg9325_def.cx9a2_bee 0.000 0.000 0.000 37.239 62.761 0.000 0.000 0.000 0.000 0.000 0.037 pg9426_def.cx9a2_bee 0.000 0.000 0.000 39.156 60.844 0.000 0.000 0.000 0.000 0.000 0.036 pg9525_def.cx9a2_bee 0.000 0.000 0.000 40.167 59.833 0.000 0.000 0.000 0.000 0.000 0.036 pg9624_def.cx9a2_bee 0.000 0.000 0.000 38.050 61.950 0.000 0.000 0.000 0.000 0.000 0.036 pg1023_def.cx9a2_bee 0.000 0.000 0.000 37.272 62.728 0.000 0.000 0.000 0.000 0.000 0.034 pg1122_def.cx9a2_bee 0.000 0.000 0.183 99.661 0.156 0.000 0.000 0.000 0.000 0.000 0.021 pg1217_def.cx9a2_bee 0.000 0.000 0.028 98.383 1.589 0.000 0.000 0.000 0.000 0.000 0.022 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 97.028 2.972 0.000 0.000 0.000 0.000 0.130 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 77.883 22.117 0.000 0.000 0.000 0.000 0.125 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 79.544 20.456 0.000 0.000 0.000 0.000 0.118 pg161_def.cx9a2_bee
qp500.L4
- qp500.L4: point queries with 500 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 98.395 1.604 0.001 0.000 0.000 0.000 0.000 0.000 0.038 pg9023_def.cx9a2_bee 0.000 nonzero 98.642 1.358 nonzero 0.000 0.000 0.000 0.000 0.000 0.022 pg9124_def.cx9a2_bee 0.000 0.000 95.004 4.992 0.004 0.000 0.000 0.000 0.000 0.000 0.042 pg9224_def.cx9a2_bee 0.000 0.000 94.347 5.648 0.005 0.000 0.000 0.000 0.000 0.000 0.047 pg9325_def.cx9a2_bee 0.000 0.000 97.344 2.654 0.001 0.000 0.000 0.000 0.000 0.000 0.032 pg9426_def.cx9a2_bee 0.000 nonzero 98.440 1.554 0.006 0.000 0.000 0.000 0.000 0.000 0.045 pg9525_def.cx9a2_bee 0.000 0.000 99.020 0.979 0.001 0.000 0.000 0.000 0.000 0.000 0.023 pg9624_def.cx9a2_bee 0.000 nonzero 98.867 1.132 0.001 0.000 0.000 0.000 0.000 0.000 0.036 pg1023_def.cx9a2_bee 0.000 0.000 98.957 1.042 0.001 0.000 0.000 0.000 0.000 0.000 0.035 pg1122_def.cx9a2_bee 0.000 nonzero 99.061 0.938 0.001 0.000 0.000 0.000 0.000 0.000 0.035 pg1217_def.cx9a2_bee 0.000 nonzero 98.980 1.019 0.001 0.000 0.000 0.000 0.000 0.000 0.047 pg1313_def.cx9a2_bee 0.000 0.000 98.915 1.084 0.001 0.000 0.000 0.000 0.000 0.000 0.030 pg1410_def.cx9a2_bee 0.000 0.000 98.980 1.020 0.001 0.000 0.000 0.000 0.000 0.000 0.033 pg155_def.cx9a2_bee 0.000 0.000 99.092 0.907 0.001 0.000 0.000 0.000 0.000 0.000 0.033 pg161_def.cx9a2_bee
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.694 99.306 0.000 0.000 0.000 0.000 0.000 0.050 pg9023_def.cx9a2_bee 0.000 0.000 0.000 10.517 89.483 0.000 0.000 0.000 0.000 0.000 0.040 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.006 99.989 0.006 0.000 0.000 0.000 0.000 0.067 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.978 0.022 0.000 0.000 0.000 0.000 0.078 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.106 99.894 0.000 0.000 0.000 0.000 0.000 0.055 pg9426_def.cx9a2_bee 0.000 0.000 0.000 88.361 11.589 0.050 0.000 0.000 0.000 0.000 0.081 pg9525_def.cx9a2_bee 0.000 0.000 0.000 97.056 2.944 0.000 0.000 0.000 0.000 0.000 0.059 pg9624_def.cx9a2_bee 0.000 0.000 0.000 96.450 3.550 0.000 0.000 0.000 0.000 0.000 0.048 pg1023_def.cx9a2_bee 0.000 0.000 0.000 97.156 2.844 0.000 0.000 0.000 0.000 0.000 0.041 pg1122_def.cx9a2_bee 0.000 0.000 0.000 97.917 2.083 0.000 0.000 0.000 0.000 0.000 0.034 pg1217_def.cx9a2_bee 0.000 0.000 0.000 97.378 2.617 0.006 0.000 0.000 0.000 0.000 0.093 pg1313_def.cx9a2_bee 0.000 0.000 0.000 97.400 2.600 0.000 0.000 0.000 0.000 0.000 0.041 pg1410_def.cx9a2_bee 0.000 0.000 0.000 97.761 2.239 0.000 0.000 0.000 0.000 0.000 0.037 pg155_def.cx9a2_bee 0.000 0.000 0.000 97.911 2.089 0.000 0.000 0.000 0.000 0.000 0.037 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 99.983 0.017 0.000 0.000 0.000 0.000 0.081 pg9023_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.076 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.939 0.061 0.000 0.000 0.000 0.000 0.068 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.077 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.075 pg9426_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.062 pg9525_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.066 pg9624_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.061 pg1023_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.067 pg1122_def.cx9a2_bee 0.000 0.000 0.000 37.217 62.783 0.000 0.000 0.000 0.000 0.000 0.046 pg1217_def.cx9a2_bee 0.000 0.000 0.000 25.517 74.483 0.000 0.000 0.000 0.000 0.000 0.048 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 4.233 95.767 0.000 0.000 0.000 0.000 0.146 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.011 99.989 0.000 0.000 0.000 0.000 0.159 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.006 99.994 0.000 0.000 0.000 0.000 0.139 pg161_def.cx9a2_bee
qr1000.L5
- qr1000.L5: range queries with 1000 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 82.605 17.292 0.100 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.124 pg9023_def.cx9a2_bee 85.616 14.285 0.097 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.130 pg9124_def.cx9a2_bee 84.213 15.781 0.005 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.193 pg9224_def.cx9a2_bee 88.875 11.116 0.008 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.203 pg9325_def.cx9a2_bee 89.541 10.450 0.008 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.120 pg9426_def.cx9a2_bee 87.839 12.153 0.007 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.138 pg9525_def.cx9a2_bee 90.928 9.066 0.006 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.146 pg9624_def.cx9a2_bee 85.665 14.329 0.006 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.139 pg1023_def.cx9a2_bee 91.577 8.417 0.006 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.148 pg1122_def.cx9a2_bee 98.443 1.545 0.007 0.004 nonzero nonzero 0.000 0.000 0.000 0.000 0.148 pg1217_def.cx9a2_bee 98.230 1.758 0.008 0.004 nonzero nonzero 0.000 0.000 0.000 0.000 0.133 pg1313_def.cx9a2_bee 77.966 22.029 0.004 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.115 pg1410_def.cx9a2_bee 78.067 21.929 0.004 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.109 pg155_def.cx9a2_bee 77.544 22.451 0.004 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.122 pg161_def.cx9a2_bee
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 5.772 94.219 0.008 0.000 0.000 0.000 0.000 0.072 pg9023_def.cx9a2_bee 0.000 0.000 0.000 17.233 82.764 0.003 0.000 0.000 0.000 0.000 0.067 pg9124_def.cx9a2_bee 0.000 0.000 0.000 1.406 98.578 0.017 0.000 0.000 0.000 0.000 0.073 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.253 99.708 0.039 0.000 0.000 0.000 0.000 0.093 pg9325_def.cx9a2_bee 0.000 0.000 0.000 6.803 93.164 0.033 0.000 0.000 0.000 0.000 0.082 pg9426_def.cx9a2_bee 0.000 0.000 0.000 88.619 11.303 0.078 0.000 0.000 0.000 0.000 0.101 pg9525_def.cx9a2_bee 0.000 0.000 0.000 90.511 9.489 0.000 0.000 0.000 0.000 0.000 0.046 pg9624_def.cx9a2_bee 0.000 0.000 0.000 90.156 9.842 0.003 0.000 0.000 0.000 0.000 0.097 pg1023_def.cx9a2_bee 0.000 0.000 0.000 91.519 8.475 0.006 0.000 0.000 0.000 0.000 0.079 pg1122_def.cx9a2_bee 0.000 0.000 0.000 89.422 10.575 0.003 0.000 0.000 0.000 0.000 0.075 pg1217_def.cx9a2_bee 0.000 0.000 0.000 90.861 9.133 0.006 0.000 0.000 0.000 0.000 0.088 pg1313_def.cx9a2_bee 0.000 0.000 0.000 89.950 10.050 0.000 0.000 0.000 0.000 0.000 0.053 pg1410_def.cx9a2_bee 0.000 0.000 0.000 90.450 9.550 0.000 0.000 0.000 0.000 0.000 0.054 pg155_def.cx9a2_bee 0.000 0.000 0.000 88.611 11.389 0.000 0.000 0.000 0.000 0.000 0.041 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 54.775 45.225 0.000 0.000 0.000 0.000 0.116 pg9023_def.cx9a2_bee 0.000 0.000 0.000 0.000 62.933 37.067 0.000 0.000 0.000 0.000 0.093 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.000 41.461 58.539 0.000 0.000 0.000 0.000 0.117 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 47.558 52.442 0.000 0.000 0.000 0.000 0.100 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.000 50.428 49.572 0.000 0.000 0.000 0.000 0.089 pg9426_def.cx9a2_bee 0.000 0.000 0.000 0.000 55.292 44.708 0.000 0.000 0.000 0.000 0.085 pg9525_def.cx9a2_bee 0.000 0.000 0.000 0.000 50.792 49.208 0.000 0.000 0.000 0.000 0.087 pg9624_def.cx9a2_bee 0.000 0.000 0.000 0.000 46.219 53.781 0.000 0.000 0.000 0.000 0.099 pg1023_def.cx9a2_bee 0.000 0.000 0.000 0.000 47.997 52.003 0.000 0.000 0.000 0.000 0.097 pg1122_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.069 pg1217_def.cx9a2_bee 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.057 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.157 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.159 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.160 pg161_def.cx9a2_bee
qp1000.L6
- qp1000.L6: point queries with 1000 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 96.326 3.671 0.003 0.000 0.000 0.000 0.000 0.000 0.041 pg9023_def.cx9a2_bee 0.000 nonzero 95.920 4.076 0.004 0.000 0.000 0.000 0.000 0.000 0.042 pg9124_def.cx9a2_bee 0.000 nonzero 95.452 4.544 0.004 0.000 0.000 0.000 0.000 0.000 0.038 pg9224_def.cx9a2_bee 0.000 nonzero 93.838 6.157 0.005 0.000 0.000 0.000 0.000 0.000 0.042 pg9325_def.cx9a2_bee 0.000 nonzero 93.856 6.139 0.005 0.000 0.000 0.000 0.000 0.000 0.042 pg9426_def.cx9a2_bee 0.000 nonzero 96.238 3.748 0.014 0.000 0.000 0.000 0.000 0.000 0.050 pg9525_def.cx9a2_bee 0.000 0.000 97.932 2.066 0.003 0.000 0.000 0.000 0.000 0.000 0.043 pg9624_def.cx9a2_bee 0.000 0.000 97.915 2.082 0.003 0.000 0.000 0.000 0.000 0.000 0.035 pg1023_def.cx9a2_bee 0.000 0.000 98.007 1.990 0.002 0.000 0.000 0.000 0.000 0.000 0.041 pg1122_def.cx9a2_bee 0.000 0.000 97.701 2.296 0.003 0.000 0.000 0.000 0.000 0.000 0.038 pg1217_def.cx9a2_bee 0.000 0.000 97.702 2.295 0.004 0.000 0.000 0.000 0.000 0.000 0.040 pg1313_def.cx9a2_bee 0.000 0.000 98.008 1.990 0.003 0.000 0.000 0.000 0.000 0.000 0.036 pg1410_def.cx9a2_bee 0.000 nonzero 98.035 1.962 0.002 0.000 0.000 0.000 0.000 0.000 0.036 pg155_def.cx9a2_bee 0.000 0.000 98.038 1.960 0.003 0.000 0.000 0.000 0.000 0.000 0.035 pg161_def.cx9a2_bee
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.003 99.983 0.014 0.000 0.000 0.000 0.000 0.078 pg9023_def.cx9a2_bee 0.000 0.000 0.000 0.208 99.778 0.014 0.000 0.000 0.000 0.000 0.077 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.085 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.072 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.003 99.983 0.014 0.000 0.000 0.000 0.000 0.081 pg9426_def.cx9a2_bee 0.000 0.000 0.000 72.800 26.986 0.214 0.000 0.000 0.000 0.000 0.097 pg9525_def.cx9a2_bee 0.000 0.000 0.000 89.656 10.344 0.000 0.000 0.000 0.000 0.000 0.042 pg9624_def.cx9a2_bee 0.000 0.000 0.000 66.242 33.756 0.003 0.000 0.000 0.000 0.000 0.082 pg1023_def.cx9a2_bee 0.000 0.000 0.000 77.558 22.442 0.000 0.000 0.000 0.000 0.000 0.056 pg1122_def.cx9a2_bee 0.000 0.000 0.000 97.803 2.192 0.006 0.000 0.000 0.000 0.000 0.068 pg1217_def.cx9a2_bee 0.000 0.000 0.000 98.575 1.422 0.003 0.000 0.000 0.000 0.000 0.083 pg1313_def.cx9a2_bee 0.000 0.000 0.000 87.031 12.969 0.000 0.000 0.000 0.000 0.000 0.041 pg1410_def.cx9a2_bee 0.000 0.000 0.000 86.547 13.453 0.000 0.000 0.000 0.000 0.000 0.039 pg155_def.cx9a2_bee 0.000 0.000 0.000 85.964 14.036 0.000 0.000 0.000 0.000 0.000 0.054 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.176 pg9023_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.180 pg9124_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.170 pg9224_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.159 pg9325_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.166 pg9426_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.158 pg9525_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.145 pg9624_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.137 pg1023_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.155 pg1122_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.092 pg1217_def.cx9a2_bee 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.095 pg1313_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.206 pg1410_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.199 pg155_def.cx9a2_bee 0.000 0.000 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.191 pg161_def.cx9a2_bee