Introduction
This is a report for the insert benchmark with 30M 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 30M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 50m+50m 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 | 60606 | 128756 | 6523 | 2016 | 7470 | 3151 | 6731 | 3128 | 6701 | 3427 |
| pg9124_def.cx9a2_bee | 60852 | 129870 | 7129 | 2086 | 7776 | 3112 | 6954 | 3105 | 7100 | 3456 |
| pg9224_def.cx9a2_bee | 59055 | 132744 | 7287 | 1771 | 8310 | 3575 | 7468 | 3601 | 7629 | 3649 |
| pg9325_def.cx9a2_bee | 60976 | 132159 | 7478 | 2337 | 8333 | 3537 | 7257 | 3513 | 7313 | 3503 |
| pg9426_def.cx9a2_bee | 65502 | 121458 | 7679 | 2288 | 8463 | 3554 | 7250 | 3560 | 7346 | 3553 |
| pg9525_def.cx9a2_bee | 66667 | 140187 | 10855 | 1240 | 8529 | 3599 | 7322 | 3561 | 7186 | 3592 |
| pg9624_def.cx9a2_bee | 63694 | 194806 | 10532 | 2227 | 8226 | 3519 | 7436 | 3512 | 7286 | 3554 |
| pg1023_def.cx9a2_bee | 63830 | 223881 | 9009 | 1737 | 8509 | 3500 | 7467 | 3527 | 7433 | 3518 |
| pg1122_def.cx9a2_bee | 73892 | 218979 | 11703 | 2318 | 8813 | 3484 | 7659 | 3492 | 7571 | 3514 |
| pg1217_def.cx9a2_bee | 72115 | 223881 | 21322 | 2432 | 8815 | 3483 | 7917 | 3495 | 7991 | 3523 |
| pg1313_def.cx9a2_bee | 74442 | 214286 | 16667 | 2554 | 8740 | 3448 | 8078 | 3478 | 8051 | 3485 |
| pg1410_def.cx9a2_bee | 72464 | 215828 | 18859 | 4733 | 8666 | 3492 | 7912 | 3498 | 8119 | 3505 |
| pg155_def.cx9a2_bee | 75377 | 222223 | 20758 | 3929 | 8990 | 3430 | 8309 | 3457 | 8108 | 3465 |
| pg161_def.cx9a2_bee | 74627 | 232559 | 18365 | 5426 | 8958 | 3455 | 8337 | 3419 | 8388 | 3441 |
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.00 | 1.01 | 1.09 | 1.03 | 1.04 | 0.99 | 1.03 | 0.99 | 1.06 | 1.01 |
| pg9224_def.cx9a2_bee | 0.97 | 1.03 | 1.12 | 0.88 | 1.11 | 1.13 | 1.11 | 1.15 | 1.14 | 1.06 |
| pg9325_def.cx9a2_bee | 1.01 | 1.03 | 1.15 | 1.16 | 1.12 | 1.12 | 1.08 | 1.12 | 1.09 | 1.02 |
| pg9426_def.cx9a2_bee | 1.08 | 0.94 | 1.18 | 1.13 | 1.13 | 1.13 | 1.08 | 1.14 | 1.10 | 1.04 |
| pg9525_def.cx9a2_bee | 1.10 | 1.09 | 1.66 | 0.62 | 1.14 | 1.14 | 1.09 | 1.14 | 1.07 | 1.05 |
| pg9624_def.cx9a2_bee | 1.05 | 1.51 | 1.61 | 1.10 | 1.10 | 1.12 | 1.10 | 1.12 | 1.09 | 1.04 |
| pg1023_def.cx9a2_bee | 1.05 | 1.74 | 1.38 | 0.86 | 1.14 | 1.11 | 1.11 | 1.13 | 1.11 | 1.03 |
| pg1122_def.cx9a2_bee | 1.22 | 1.70 | 1.79 | 1.15 | 1.18 | 1.11 | 1.14 | 1.12 | 1.13 | 1.03 |
| pg1217_def.cx9a2_bee | 1.19 | 1.74 | 3.27 | 1.21 | 1.18 | 1.11 | 1.18 | 1.12 | 1.19 | 1.03 |
| pg1313_def.cx9a2_bee | 1.23 | 1.66 | 2.56 | 1.27 | 1.17 | 1.09 | 1.20 | 1.11 | 1.20 | 1.02 |
| pg1410_def.cx9a2_bee | 1.20 | 1.68 | 2.89 | 2.35 | 1.16 | 1.11 | 1.18 | 1.12 | 1.21 | 1.02 |
| pg155_def.cx9a2_bee | 1.24 | 1.73 | 3.18 | 1.95 | 1.20 | 1.09 | 1.23 | 1.11 | 1.21 | 1.01 |
| pg161_def.cx9a2_bee | 1.23 | 1.81 | 2.82 | 2.69 | 1.20 | 1.10 | 1.24 | 1.09 | 1.25 | 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 | 998 | 998 |
| pg9124_def.cx9a2_bee | 100 | 100 | 499 | 499 | 997 | 998 |
| pg9224_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg9325_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg9426_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 999 |
| pg9525_def.cx9a2_bee | 100 | 100 | 499 | 499 | 997 | 998 |
| pg9624_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg1023_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg1122_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg1217_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg1313_def.cx9a2_bee | 100 | 100 | 499 | 499 | 997 | 998 |
| pg1410_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg155_def.cx9a2_bee | 100 | 100 | 499 | 499 | 998 | 998 |
| pg161_def.cx9a2_bee | 100 | 100 | 499 | 499 | 997 | 998 |
| 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.134 | 0.801 | 0.065 | 0.044 | |||||||
| pg9124_def.cx9a2_bee | 99.924 | 0.075 | 0.001 | 0.041 | |||||||
| pg9224_def.cx9a2_bee | 99.937 | 0.062 | 0.001 | 0.038 | |||||||
| pg9325_def.cx9a2_bee | 99.893 | 0.106 | 0.001 | 0.046 | |||||||
| pg9426_def.cx9a2_bee | 99.893 | 0.106 | 0.002 | 0.060 | |||||||
| pg9525_def.cx9a2_bee | 100.000 | 0.003 | |||||||||
| pg9624_def.cx9a2_bee | 100.000 | 0.004 | |||||||||
| pg1023_def.cx9a2_bee | 100.000 | 0.004 | |||||||||
| pg1122_def.cx9a2_bee | 100.000 | 0.003 | |||||||||
| pg1217_def.cx9a2_bee | 100.000 | 0.003 | |||||||||
| pg1313_def.cx9a2_bee | 100.000 | 0.003 | |||||||||
| pg1410_def.cx9a2_bee | 100.000 | 0.003 | |||||||||
| pg155_def.cx9a2_bee | 100.000 | 0.003 | |||||||||
| pg161_def.cx9a2_bee | 100.000 | 0.003 |
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 60606 0 0 0.0 272.0 22.5 0.000 0.000 0.004 0.381 6405 21.4 0.106 28 2.9 3.0 0.4 0.044 60742 58034 pg9023_def.cx9a2_bee 60852 0 0 0.0 280.9 22.7 0.000 0.000 0.005 0.382 6431 22.3 0.106 29 2.9 3.0 0.2 0.041 61027 59230 pg9124_def.cx9a2_bee 59055 0 0 0.0 1402.4 22.0 0.000 0.000 0.024 0.382 9891 22.1 0.167 30 2.9 3.0 0.2 0.038 59257 57232 pg9224_def.cx9a2_bee 60976 0 0 0.0 1118.2 25.4 0.000 0.000 0.018 0.427 9055 22.7 0.148 30 2.9 3.0 0.2 0.046 61131 58260 pg9325_def.cx9a2_bee 65502 0 0 0.0 1131.5 27.4 0.000 0.000 0.017 0.428 9363 22.5 0.143 27 2.9 3.0 1.4 0.060 65828 62615 pg9426_def.cx9a2_bee 66667 0 0 0.0 890.7 28.6 0.000 0.000 0.013 0.439 9487 22.0 0.142 26 2.9 7.8 0.2 0.003 67026 64875 pg9525_def.cx9a2_bee 63694 0 0 0.0 74.5 27.3 0.000 0.000 0.001 0.438 7887 23.1 0.124 29 2.9 7.8 0.2 0.004 63930 62525 pg9624_def.cx9a2_bee 63830 0 0 0.0 75.3 27.4 0.000 0.000 0.001 0.440 7875 23.2 0.123 29 2.9 7.8 0.2 0.004 64129 62327 pg1023_def.cx9a2_bee 73892 0 0 0.0 87.1 31.7 0.000 0.000 0.001 0.440 9133 23.7 0.124 26 2.9 7.8 2.8 0.003 74225 71916 pg1122_def.cx9a2_bee 72115 0 0 0.0 84.2 30.8 0.000 0.000 0.001 0.438 8896 23.2 0.123 26 2.9 7.8 3.0 0.003 72219 70382 pg1217_def.cx9a2_bee 74442 0 0 0.0 87.0 32.0 0.000 0.000 0.001 0.440 9145 23.7 0.123 25 2.9 7.8 0.0 0.003 74846 72615 pg1313_def.cx9a2_bee 72464 0 0 0.0 85.1 31.2 0.000 0.000 0.001 0.441 9077 23.1 0.125 26 2.9 7.8 2.8 0.003 72920 70615 pg1410_def.cx9a2_bee 75377 0 0 0.0 87.7 32.3 0.000 0.000 0.001 0.438 9252 23.1 0.123 25 2.9 7.8 2.9 0.003 75615 73465 pg155_def.cx9a2_bee 74627 0 0 0.0 86.6 31.9 0.000 0.000 0.001 0.438 9226 23.2 0.124 25 2.9 7.8 0.2 0.003 74816 72913 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 128756 0 0 0.0 242.8 42.3 0.000 0.000 0.002 0.337 446 11.7 0.003 7 5.8 5.9 2.7 0.003 NA NA pg9023_def.cx9a2_bee 129870 0 0 0.0 252.3 42.0 0.000 0.000 0.002 0.331 451 12.1 0.003 7 5.8 5.9 2.7 0.003 NA NA pg9124_def.cx9a2_bee 132744 0 0 0.0 251.8 41.3 0.000 0.000 0.002 0.318 368 11.9 0.003 7 5.8 6.0 2.7 0.003 NA NA pg9224_def.cx9a2_bee 132159 0 0 0.0 259.8 47.7 0.000 0.000 0.002 0.369 383 12.1 0.003 7 5.8 5.9 3.0 0.003 NA NA pg9325_def.cx9a2_bee 121458 0 0 0.0 226.6 37.1 0.000 0.000 0.002 0.313 414 12.2 0.003 8 5.8 5.9 3.0 0.003 NA NA pg9426_def.cx9a2_bee 140187 0 0 0.0 100.4 45.6 0.000 0.000 0.001 0.333 437 11.7 0.003 7 5.8 13.3 3.0 0.003 NA NA pg9525_def.cx9a2_bee 194806 0 0 0.0 138.7 64.0 0.000 0.000 0.001 0.337 617 11.7 0.003 5 5.8 13.3 3.0 0.003 NA NA pg9624_def.cx9a2_bee 223881 0 0 0.0 153.7 71.4 0.000 0.000 0.001 0.327 585 11.5 0.003 4 5.8 13.3 3.0 0.004 NA NA pg1023_def.cx9a2_bee 218979 0 0 0.0 152.6 70.6 0.000 0.000 0.001 0.330 629 11.5 0.003 4 5.8 13.3 3.0 0.004 NA NA pg1122_def.cx9a2_bee 223881 0 0 0.0 149.2 69.4 0.000 0.000 0.001 0.317 625 11.6 0.003 4 5.8 13.3 3.0 0.003 NA NA pg1217_def.cx9a2_bee 214286 0 0 0.0 169.9 79.0 0.000 0.000 0.001 0.377 848 11.6 0.004 4 5.8 13.3 3.0 0.003 NA NA pg1313_def.cx9a2_bee 215828 0 0 0.0 147.4 68.5 0.000 0.000 0.001 0.325 662 11.9 0.003 4 5.8 13.3 3.0 0.003 NA NA pg1410_def.cx9a2_bee 222223 0 0 0.0 176.7 82.2 0.000 0.000 0.001 0.379 686 11.5 0.003 4 5.8 13.3 3.0 0.003 NA NA pg155_def.cx9a2_bee 232559 0 0 0.0 168.9 78.6 0.000 0.000 0.001 0.346 487 11.5 0.002 4 5.8 13.3 3.1 0.003 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 | 97.778 | 2.222 | nonzero | 0.086 | |||||||
| pg9124_def.cx9a2_bee | 99.528 | 0.472 | 0.001 | 0.094 | |||||||
| pg9224_def.cx9a2_bee | 99.918 | 0.082 | 0.001 | 0.122 | |||||||
| pg9325_def.cx9a2_bee | 1.008 | 98.674 | 0.270 | 0.047 | nonzero | 0.314 | |||||
| pg9426_def.cx9a2_bee | 0.016 | 99.677 | 0.295 | 0.013 | 0.131 | ||||||
| pg9525_def.cx9a2_bee | 99.989 | 0.007 | 0.003 | 0.064 | |||||||
| pg9624_def.cx9a2_bee | 99.998 | 0.002 | nonzero | 0.043 | |||||||
| pg1023_def.cx9a2_bee | 99.991 | 0.008 | 0.001 | 0.023 | |||||||
| pg1122_def.cx9a2_bee | 99.998 | 0.002 | 0.015 | ||||||||
| pg1217_def.cx9a2_bee | 99.966 | 0.034 | nonzero | 0.019 | |||||||
| pg1313_def.cx9a2_bee | 99.999 | 0.001 | nonzero | 0.020 | |||||||
| pg1410_def.cx9a2_bee | 99.996 | 0.003 | nonzero | 0.019 | |||||||
| pg155_def.cx9a2_bee | 99.997 | 0.002 | nonzero | 0.016 | |||||||
| pg161_def.cx9a2_bee | 99.997 | 0.003 | 0.015 |
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.029 | 70.034 | 2.266 | 27.311 | 0.358 | 0.003 | 0.078 | ||||
| pg9124_def.cx9a2_bee | 0.028 | 74.268 | 0.400 | 22.695 | 2.606 | 0.004 | 0.142 | ||||
| pg9224_def.cx9a2_bee | 0.029 | 75.064 | 0.357 | 24.392 | 0.155 | 0.004 | 0.100 | ||||
| pg9325_def.cx9a2_bee | 0.025 | 79.850 | 0.399 | 18.069 | 1.645 | 0.010 | 0.002 | 0.534 | |||
| pg9426_def.cx9a2_bee | 0.026 | 79.745 | 0.443 | 19.667 | 0.114 | 0.005 | nonzero | 0.326 | |||
| pg9525_def.cx9a2_bee | 0.352 | 82.865 | 0.486 | 1.406 | 14.888 | 0.003 | nonzero | 0.273 | |||
| pg9624_def.cx9a2_bee | 0.321 | 81.721 | 0.471 | 2.932 | 14.552 | 0.003 | 0.166 | ||||
| pg1023_def.cx9a2_bee | 0.211 | 81.126 | 0.425 | 2.196 | 16.039 | 0.003 | nonzero | 0.265 | |||
| pg1122_def.cx9a2_bee | 0.412 | 82.219 | 0.449 | 7.707 | 9.214 | 0.026 | |||||
| pg1217_def.cx9a2_bee | 0.300 | 82.314 | 11.307 | 6.077 | 0.002 | 0.036 | |||||
| pg1313_def.cx9a2_bee | 0.248 | 81.864 | 0.589 | 17.299 | nonzero | 0.025 | |||||
| pg1410_def.cx9a2_bee | 0.144 | 81.635 | 2.849 | 15.372 | nonzero | 0.017 | |||||
| pg155_def.cx9a2_bee | 0.142 | 81.495 | 4.366 | 13.997 | 0.013 | ||||||
| pg161_def.cx9a2_bee | 0.128 | 81.658 | 1.726 | 16.488 | 0.014 |
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 6523 0 4 0.0 13215.1 226.7 0.001 0.004 2.026 35.593 4929 20.7 0.756 254 8.0 8.1 3.2 0.086 6842 3996 pg9023_def.cx9a2_bee 7129 0 3 0.0 14409.9 246.7 0.000 0.003 2.021 35.439 4673 23.3 0.656 261 8.0 8.2 5.2 0.094 8389 2547 pg9124_def.cx9a2_bee 7287 0 3 0.0 14693.8 249.4 0.000 0.003 2.016 35.050 5880 23.8 0.807 261 8.0 8.2 3.7 0.122 8494 3295 pg9224_def.cx9a2_bee 7478 0 12 0.1 14556.2 250.6 0.002 0.008 1.947 34.320 5695 23.2 0.762 248 8.2 8.4 5.4 0.314 8747 2648 pg9325_def.cx9a2_bee 7679 0 4 0.0 15155.8 260.0 0.001 0.004 1.974 34.677 5079 23.7 0.661 247 8.2 8.4 6.6 0.131 8790 3349 pg9426_def.cx9a2_bee 10855 0 30 0.1 448.9 18.9 0.003 0.013 0.041 1.782 5652 18.4 0.521 136 8.4 42.6 6.3 0.064 2747 1897 pg9525_def.cx9a2_bee 10532 0 29 0.1 65.1 18.5 0.003 0.013 0.006 1.799 5480 18.2 0.520 138 8.3 42.8 5.3 0.043 2847 1948 pg9624_def.cx9a2_bee 9009 0 25 0.1 54.7 14.9 0.003 0.013 0.006 1.690 4706 17.6 0.522 156 8.3 39.1 5.3 0.023 2198 1748 pg1023_def.cx9a2_bee 11703 0 32 0.1 59.7 16.0 0.003 0.013 0.005 1.402 5960 18.7 0.509 128 8.3 31.0 4.6 0.015 3346 2148 pg1122_def.cx9a2_bee 21322 0 52 0.5 98.5 29.5 0.002 0.026 0.005 1.419 10600 24.6 0.497 92 8.1 38.7 5.0 0.019 28621 3795 pg1217_def.cx9a2_bee 16667 0 49 0.2 86.0 23.5 0.003 0.012 0.005 1.443 8367 22.2 0.502 107 8.2 37.1 0.3 0.020 7442 4548 pg1313_def.cx9a2_bee 18859 0 50 0.2 87.8 26.2 0.003 0.012 0.005 1.425 9298 21.4 0.493 91 7.9 39.1 5.0 0.019 27632 4645 pg1410_def.cx9a2_bee 20758 0 54 0.2 92.7 27.7 0.003 0.012 0.004 1.365 10167 22.3 0.490 86 7.9 38.5 1.3 0.016 28268 4645 pg155_def.cx9a2_bee 18365 0 48 0.2 85.7 25.4 0.003 0.012 0.005 1.417 9025 21.1 0.491 92 7.9 39.0 5.7 0.015 27069 3996 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 | 82.718 | 15.653 | 1.603 | 0.025 | 0.044 | ||||||
| pg9124_def.cx9a2_bee | 92.204 | 7.615 | 0.134 | 0.046 | 0.032 | ||||||
| pg9224_def.cx9a2_bee | 89.450 | 10.375 | 0.175 | 0.001 | 0.043 | ||||||
| pg9325_def.cx9a2_bee | 93.940 | 5.867 | 0.192 | 0.001 | nonzero | 0.094 | |||||
| pg9426_def.cx9a2_bee | 94.353 | 5.448 | 0.197 | 0.002 | nonzero | 0.070 | |||||
| pg9525_def.cx9a2_bee | 22.001 | 77.995 | 0.003 | nonzero | nonzero | 0.036 | |||||
| pg9624_def.cx9a2_bee | 21.278 | 78.720 | 0.002 | nonzero | 0.004 | ||||||
| pg1023_def.cx9a2_bee | 10.433 | 89.564 | 0.003 | nonzero | nonzero | 0.027 | |||||
| pg1122_def.cx9a2_bee | 32.516 | 67.482 | 0.002 | 0.004 | |||||||
| pg1217_def.cx9a2_bee | 31.769 | 68.227 | 0.002 | 0.001 | nonzero | 0.041 | |||||
| pg1313_def.cx9a2_bee | 36.840 | 63.156 | 0.003 | nonzero | 0.011 | ||||||
| pg1410_def.cx9a2_bee | 23.045 | 76.951 | 0.003 | nonzero | 0.010 | ||||||
| pg155_def.cx9a2_bee | 22.301 | 77.696 | 0.003 | nonzero | 0.007 | ||||||
| pg161_def.cx9a2_bee | 20.230 | 79.766 | 0.004 | nonzero | 0.005 |
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 | 40.363 | 32.267 | 1.896 | 25.413 | 0.059 | nonzero | 0.071 | ||||
| pg9124_def.cx9a2_bee | 44.712 | 31.842 | 0.027 | 23.399 | 0.020 | nonzero | 0.075 | ||||
| pg9224_def.cx9a2_bee | 39.452 | 34.922 | 0.012 | 25.614 | nonzero | nonzero | 0.080 | ||||
| pg9325_def.cx9a2_bee | 43.132 | 38.441 | 0.023 | 18.403 | nonzero | nonzero | 0.221 | ||||
| pg9426_def.cx9a2_bee | 43.983 | 38.074 | 0.029 | 17.912 | nonzero | nonzero | 0.216 | ||||
| pg9525_def.cx9a2_bee | 60.326 | 19.482 | 0.001 | 2.710 | 17.480 | nonzero | 0.186 | ||||
| pg9624_def.cx9a2_bee | 65.346 | 15.235 | 0.003 | 19.245 | 0.171 | nonzero | 0.109 | ||||
| pg1023_def.cx9a2_bee | 63.516 | 16.188 | 0.004 | 19.679 | 0.612 | nonzero | 0.109 | ||||
| pg1122_def.cx9a2_bee | 66.602 | 15.958 | 0.004 | 17.429 | 0.007 | 0.017 | |||||
| pg1217_def.cx9a2_bee | 64.415 | 17.715 | 0.518 | 17.352 | nonzero | 0.041 | |||||
| pg1313_def.cx9a2_bee | 67.123 | 14.669 | 0.003 | 18.206 | 0.014 | ||||||
| pg1410_def.cx9a2_bee | 57.903 | 24.338 | 6.923 | 10.836 | 0.009 | ||||||
| pg155_def.cx9a2_bee | 55.696 | 24.033 | 6.053 | 14.218 | 0.015 | ||||||
| pg161_def.cx9a2_bee | 55.463 | 24.475 | 16.532 | 3.530 | 0.009 |
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 2016 0 0 0.0 4087.8 67.8 0.000 0.000 2.028 34.430 9179 17.0 4.553 675 8.1 8.2 3.2 0.044 739 460 pg9023_def.cx9a2_bee 2086 0 0 0.0 4222.0 68.9 0.000 0.000 2.024 33.810 9221 17.5 4.421 671 8.1 8.3 3.3 0.032 654 429 pg9124_def.cx9a2_bee 1771 0 0 0.0 3774.7 57.9 0.000 0.000 2.132 33.490 8724 17.0 4.927 768 8.1 8.3 2.9 0.043 559 370 pg9224_def.cx9a2_bee 2337 0 0 0.0 4937.2 75.7 0.000 0.000 2.113 33.183 11269 18.2 4.822 623 8.3 8.5 3.8 0.094 614 430 pg9325_def.cx9a2_bee 2288 0 0 0.0 4822.3 74.2 0.000 0.000 2.107 33.224 10795 18.1 4.717 633 8.3 8.5 6.9 0.070 575 375 pg9426_def.cx9a2_bee 1240 0 0 0.0 208.2 3.7 0.000 0.000 0.168 3.092 5434 13.8 4.383 891 8.4 37.8 4.5 0.036 270 210 pg9525_def.cx9a2_bee 2227 0 0 0.0 25.0 4.4 0.000 0.000 0.011 2.001 10875 15.3 4.883 550 8.4 42.1 6.6 0.004 489 310 pg9624_def.cx9a2_bee 1737 0 0 0.0 25.8 4.4 0.000 0.000 0.015 2.600 8563 14.8 4.930 682 8.4 37.5 6.6 0.027 385 300 pg1023_def.cx9a2_bee 2318 0 0 0.0 29.2 5.2 0.000 0.000 0.013 2.292 11266 15.5 4.860 535 8.4 30.6 1.7 0.004 455 325 pg1122_def.cx9a2_bee 2432 0 0 0.0 28.5 5.2 0.000 0.000 0.012 2.191 11849 15.9 4.872 523 8.1 38.2 5.8 0.041 489 415 pg1217_def.cx9a2_bee 2554 0 0 0.0 28.5 5.2 0.000 0.000 0.011 2.098 12381 15.9 4.849 498 8.3 35.3 5.3 0.011 540 420 pg1313_def.cx9a2_bee 4733 0 0 0.0 34.5 7.8 0.000 0.000 0.007 1.678 22530 18.6 4.761 314 8.0 41.0 6.5 0.010 1184 749 pg1410_def.cx9a2_bee 3929 0 0 0.0 33.2 7.1 0.000 0.000 0.008 1.843 18658 17.5 4.748 356 8.0 40.6 6.5 0.007 1069 594 pg155_def.cx9a2_bee 5426 0 0 0.0 37.1 8.8 0.000 0.000 0.007 1.665 25842 19.7 4.763 290 8.0 41.4 5.7 0.005 1713 896 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.873 | 0.126 | nonzero | 0.001 | 0.012 | ||||||
| pg9124_def.cx9a2_bee | 99.895 | 0.105 | nonzero | nonzero | 0.005 | ||||||
| pg9224_def.cx9a2_bee | 99.927 | 0.073 | nonzero | 0.004 | |||||||
| pg9325_def.cx9a2_bee | 99.914 | 0.086 | nonzero | nonzero | 0.005 | ||||||
| pg9426_def.cx9a2_bee | 99.919 | 0.081 | nonzero | nonzero | 0.005 | ||||||
| pg9525_def.cx9a2_bee | 99.953 | 0.047 | nonzero | nonzero | 0.004 | ||||||
| pg9624_def.cx9a2_bee | 99.931 | 0.069 | nonzero | 0.003 | |||||||
| pg1023_def.cx9a2_bee | 99.932 | 0.068 | nonzero | 0.004 | |||||||
| pg1122_def.cx9a2_bee | 99.952 | 0.048 | nonzero | 0.003 | |||||||
| pg1217_def.cx9a2_bee | 99.941 | 0.059 | nonzero | 0.003 | |||||||
| pg1313_def.cx9a2_bee | 99.939 | 0.061 | nonzero | 0.003 | |||||||
| pg1410_def.cx9a2_bee | 99.957 | 0.043 | nonzero | 0.002 | |||||||
| pg155_def.cx9a2_bee | 99.950 | 0.049 | nonzero | 0.003 | |||||||
| pg161_def.cx9a2_bee | 99.955 | 0.045 | nonzero | 0.003 |
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 | 92.639 | 7.361 | 0.026 | ||||||||
| pg9124_def.cx9a2_bee | 99.917 | 0.083 | 0.020 | ||||||||
| pg9224_def.cx9a2_bee | 100.000 | 0.015 | |||||||||
| pg9325_def.cx9a2_bee | 100.000 | 0.013 | |||||||||
| pg9426_def.cx9a2_bee | 100.000 | 0.012 | |||||||||
| pg9525_def.cx9a2_bee | 99.694 | 0.306 | 0.009 | ||||||||
| pg9624_def.cx9a2_bee | 99.639 | 0.361 | 0.008 | ||||||||
| pg1023_def.cx9a2_bee | 99.694 | 0.306 | 0.007 | ||||||||
| pg1122_def.cx9a2_bee | 99.722 | 0.278 | 0.007 | ||||||||
| pg1217_def.cx9a2_bee | 99.778 | 0.222 | 0.008 | ||||||||
| pg1313_def.cx9a2_bee | 99.750 | 0.250 | 0.008 | ||||||||
| pg1410_def.cx9a2_bee | 99.778 | 0.222 | 0.008 | ||||||||
| pg155_def.cx9a2_bee | 99.611 | 0.389 | 0.009 | ||||||||
| pg161_def.cx9a2_bee | 99.583 | 0.417 | 0.006 |
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 | 12.083 | 67.528 | 20.361 | 0.028 | 0.017 | ||||||
| pg9124_def.cx9a2_bee | 14.833 | 69.222 | 15.944 | 0.005 | |||||||
| pg9224_def.cx9a2_bee | 12.139 | 61.167 | 26.694 | 0.005 | |||||||
| pg9325_def.cx9a2_bee | 12.028 | 65.139 | 22.833 | 0.006 | |||||||
| pg9426_def.cx9a2_bee | 11.056 | 64.278 | 24.667 | 0.008 | |||||||
| pg9525_def.cx9a2_bee | 11.111 | 65.833 | 23.056 | 0.006 | |||||||
| pg9624_def.cx9a2_bee | 10.778 | 65.611 | 23.611 | 0.006 | |||||||
| pg1023_def.cx9a2_bee | 10.056 | 63.056 | 26.889 | 0.006 | |||||||
| pg1122_def.cx9a2_bee | 10.611 | 64.639 | 24.750 | 0.006 | |||||||
| pg1217_def.cx9a2_bee | 31.556 | 68.444 | 0.003 | ||||||||
| pg1313_def.cx9a2_bee | 27.028 | 72.944 | 0.028 | 0.005 | |||||||
| pg1410_def.cx9a2_bee | 27.500 | 72.500 | 0.003 | ||||||||
| pg155_def.cx9a2_bee | 27.806 | 72.111 | 0.083 | 0.005 | |||||||
| pg161_def.cx9a2_bee | 28.111 | 71.833 | 0.056 | 0.006 |
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 7470 0 0.0 200.6 2.9 0.000 0.000 2.010 29.909 28751 12.7 3.849 136 8.1 8.2 0.9 0.012 7142 6812 pg9023_def.cx9a2_bee 100 7776 0 0.0 200.5 2.9 0.000 0.000 2.011 29.980 29940 12.6 3.850 130 8.1 8.3 1.7 0.005 7388 7111 pg9124_def.cx9a2_bee 100 8310 0 0.0 200.1 2.9 0.000 0.000 2.007 29.910 31924 12.6 3.842 121 8.1 8.2 1.7 0.004 8035 7799 pg9224_def.cx9a2_bee 100 8333 0 0.0 218.6 3.0 0.000 0.000 2.193 30.442 32091 12.6 3.851 121 8.3 8.4 1.0 0.005 8087 7838 pg9325_def.cx9a2_bee 100 8463 0 0.0 219.1 3.0 0.000 0.000 2.197 30.486 32568 12.5 3.848 118 8.3 8.4 1.0 0.005 7993 7687 pg9426_def.cx9a2_bee 100 8529 0 0.0 13.4 0.7 0.000 0.000 0.134 7.594 32743 12.5 3.839 117 8.4 35.7 8.6 0.004 7972 7655 pg9525_def.cx9a2_bee 100 8226 0 0.0 10.4 0.8 0.000 0.000 0.104 7.907 31614 13.0 3.843 126 8.4 39.9 8.5 0.003 7991 7750 pg9624_def.cx9a2_bee 100 8509 0 0.0 9.6 0.7 0.000 0.000 0.096 7.653 32730 12.8 3.846 120 8.4 33.4 8.5 0.004 8106 7831 pg1023_def.cx9a2_bee 100 8813 0 0.0 10.8 0.8 0.000 0.000 0.108 7.983 33920 12.8 3.849 116 8.4 29.0 8.5 0.003 8266 7991 pg1122_def.cx9a2_bee 100 8815 0 0.0 10.3 0.8 0.000 0.000 0.103 7.855 33873 12.9 3.843 117 8.1 35.8 1.2 0.003 8357 8133 pg1217_def.cx9a2_bee 100 8740 0 0.0 10.1 0.8 0.000 0.000 0.101 7.760 33609 12.9 3.845 118 8.3 33.3 1.2 0.003 8327 8134 pg1313_def.cx9a2_bee 100 8666 0 0.0 8.8 0.7 0.000 0.000 0.089 7.601 33293 13.1 3.842 121 8.0 41.0 1.2 0.002 8424 8246 pg1410_def.cx9a2_bee 100 8990 0 0.0 8.9 0.7 0.000 0.000 0.089 7.615 34487 12.7 3.836 113 8.0 40.6 1.0 0.003 8533 8323 pg155_def.cx9a2_bee 100 8958 0 0.0 8.8 0.7 0.000 0.000 0.088 7.591 34338 12.8 3.833 114 8.0 41.4 1.0 0.003 8646 8438 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 | 34.094 | 65.904 | 0.001 | nonzero | 0.005 | ||||||
| pg9124_def.cx9a2_bee | 32.173 | 67.826 | 0.001 | nonzero | 0.005 | ||||||
| pg9224_def.cx9a2_bee | 87.082 | 12.917 | 0.001 | nonzero | 0.005 | ||||||
| pg9325_def.cx9a2_bee | 85.238 | 14.762 | nonzero | 0.004 | |||||||
| pg9426_def.cx9a2_bee | 85.185 | 14.814 | nonzero | nonzero | 0.005 | ||||||
| pg9525_def.cx9a2_bee | 87.472 | 12.526 | 0.001 | nonzero | 0.005 | ||||||
| pg9624_def.cx9a2_bee | 87.629 | 12.369 | 0.001 | nonzero | 0.004 | ||||||
| pg1023_def.cx9a2_bee | 87.464 | 12.534 | 0.002 | nonzero | 0.005 | ||||||
| pg1122_def.cx9a2_bee | 87.281 | 12.717 | 0.002 | 0.003 | |||||||
| pg1217_def.cx9a2_bee | 87.424 | 12.575 | 0.001 | 0.004 | |||||||
| pg1313_def.cx9a2_bee | 87.140 | 12.859 | 0.001 | 0.003 | |||||||
| pg1410_def.cx9a2_bee | 87.463 | 12.535 | 0.001 | nonzero | 0.010 | ||||||
| pg155_def.cx9a2_bee | 86.549 | 13.449 | 0.002 | 0.004 | |||||||
| pg161_def.cx9a2_bee | 85.870 | 14.129 | 0.001 | 0.003 |
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 | 93.639 | 6.361 | 0.027 | ||||||||
| pg9124_def.cx9a2_bee | 100.000 | 0.012 | |||||||||
| pg9224_def.cx9a2_bee | 100.000 | 0.010 | |||||||||
| pg9325_def.cx9a2_bee | 100.000 | 0.011 | |||||||||
| pg9426_def.cx9a2_bee | 100.000 | 0.015 | |||||||||
| pg9525_def.cx9a2_bee | 99.667 | 0.333 | 0.007 | ||||||||
| pg9624_def.cx9a2_bee | 99.722 | 0.278 | 0.006 | ||||||||
| pg1023_def.cx9a2_bee | 99.806 | 0.194 | 0.007 | ||||||||
| pg1122_def.cx9a2_bee | 99.750 | 0.250 | 0.007 | ||||||||
| pg1217_def.cx9a2_bee | 99.750 | 0.250 | 0.006 | ||||||||
| pg1313_def.cx9a2_bee | 99.722 | 0.278 | 0.007 | ||||||||
| pg1410_def.cx9a2_bee | 99.806 | 0.194 | 0.008 | ||||||||
| pg155_def.cx9a2_bee | 99.778 | 0.222 | 0.006 | ||||||||
| pg161_def.cx9a2_bee | 99.694 | 0.306 | 0.007 |
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 | 1.056 | 23.694 | 1.361 | 72.417 | 1.472 | 0.025 | |||||
| pg9124_def.cx9a2_bee | 2.333 | 57.306 | 1.694 | 38.667 | 0.007 | ||||||
| pg9224_def.cx9a2_bee | 0.333 | 39.722 | 0.139 | 59.806 | 0.011 | ||||||
| pg9325_def.cx9a2_bee | 0.583 | 38.083 | 0.167 | 61.167 | 0.009 | ||||||
| pg9426_def.cx9a2_bee | 0.250 | 19.889 | 0.111 | 79.750 | 0.011 | ||||||
| pg9525_def.cx9a2_bee | 0.306 | 21.417 | 0.278 | 78.000 | 0.010 | ||||||
| pg9624_def.cx9a2_bee | 0.806 | 47.472 | 0.361 | 51.361 | 0.008 | ||||||
| pg1023_def.cx9a2_bee | 0.111 | 99.889 | 0.014 | ||||||||
| pg1122_def.cx9a2_bee | 0.500 | 25.694 | 0.361 | 73.444 | 0.011 | ||||||
| pg1217_def.cx9a2_bee | 0.222 | 45.417 | 54.278 | 0.083 | 0.006 | ||||||
| pg1313_def.cx9a2_bee | 0.222 | 47.972 | 51.750 | 0.056 | 0.006 | ||||||
| pg1410_def.cx9a2_bee | 1.111 | 45.528 | 53.278 | 0.083 | 0.006 | ||||||
| pg155_def.cx9a2_bee | 1.500 | 41.389 | 56.889 | 0.222 | 0.005 | ||||||
| pg161_def.cx9a2_bee | 0.639 | 34.139 | 62.694 | 2.528 | 0.006 |
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 3151 0 0.0 210.1 3.3 0.000 0.000 2.105 33.373 13195 14.7 4.188 373 8.1 8.2 3.1 0.005 3148 2940 pg9023_def.cx9a2_bee 100 3112 0 0.0 214.5 3.3 0.000 0.000 2.149 33.784 13034 13.7 4.188 352 8.1 8.3 2.8 0.005 3103 2893 pg9124_def.cx9a2_bee 100 3575 0 0.0 216.5 3.3 0.000 0.000 2.170 33.768 14869 13.6 4.159 304 8.1 8.2 2.9 0.005 3579 3436 pg9224_def.cx9a2_bee 100 3537 0 0.0 353.2 4.0 0.000 0.000 3.539 40.561 15170 13.4 4.289 303 8.3 8.4 0.7 0.004 3532 3419 pg9325_def.cx9a2_bee 100 3554 0 0.0 353.4 4.0 0.000 0.000 3.545 40.618 15252 13.4 4.292 302 8.3 8.4 0.7 0.005 3549 3436 pg9426_def.cx9a2_bee 100 3599 0 0.0 106.3 1.7 0.000 0.000 1.065 17.058 14976 13.7 4.161 305 8.4 33.3 8.6 0.005 3583 3451 pg9525_def.cx9a2_bee 100 3519 0 0.0 57.4 1.7 0.000 0.000 0.575 16.955 14659 14.4 4.166 327 8.4 37.1 8.5 0.004 3500 3388 pg9624_def.cx9a2_bee 100 3500 0 0.0 57.9 1.7 0.000 0.000 0.580 17.061 14602 14.2 4.172 325 8.4 31.7 8.5 0.005 3487 3387 pg1023_def.cx9a2_bee 100 3484 0 0.0 57.9 1.7 0.000 0.000 0.581 16.940 14535 14.4 4.172 331 8.4 28.4 8.5 0.003 3471 3359 pg1122_def.cx9a2_bee 100 3483 0 0.0 57.1 1.7 0.000 0.000 0.573 16.976 14525 14.2 4.170 326 8.1 34.7 1.2 0.004 3483 3372 pg1217_def.cx9a2_bee 100 3448 0 0.0 58.2 1.7 0.000 0.000 0.584 17.014 14386 14.1 4.172 327 8.3 32.2 1.0 0.003 3437 3324 pg1313_def.cx9a2_bee 100 3492 0 0.0 56.5 1.6 0.000 0.000 0.567 16.892 14578 13.8 4.175 316 8.0 39.9 1.2 0.010 3484 3387 pg1410_def.cx9a2_bee 100 3430 0 0.0 56.5 1.6 0.000 0.000 0.566 16.838 14147 13.5 4.125 315 8.0 40.6 1.0 0.004 3420 3324 pg155_def.cx9a2_bee 100 3455 0 0.0 56.3 1.6 0.000 0.000 0.564 16.858 14284 13.2 4.134 306 8.0 40.2 0.6 0.003 3436 3323 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.562 | 1.436 | nonzero | 0.001 | nonzero | 0.021 | |||||
| pg9124_def.cx9a2_bee | 98.827 | 1.173 | nonzero | 0.003 | |||||||
| pg9224_def.cx9a2_bee | 99.043 | 0.957 | nonzero | nonzero | 0.006 | ||||||
| pg9325_def.cx9a2_bee | 98.843 | 1.157 | nonzero | 0.003 | |||||||
| pg9426_def.cx9a2_bee | 98.881 | 1.119 | nonzero | nonzero | 0.005 | ||||||
| pg9525_def.cx9a2_bee | 98.842 | 1.158 | nonzero | 0.003 | |||||||
| pg9624_def.cx9a2_bee | 99.281 | 0.719 | nonzero | 0.004 | |||||||
| pg1023_def.cx9a2_bee | 99.237 | 0.763 | nonzero | 0.003 | |||||||
| pg1122_def.cx9a2_bee | 99.402 | 0.598 | nonzero | 0.004 | |||||||
| pg1217_def.cx9a2_bee | 99.857 | 0.143 | nonzero | 0.003 | |||||||
| pg1313_def.cx9a2_bee | 99.878 | 0.122 | nonzero | nonzero | 0.004 | ||||||
| pg1410_def.cx9a2_bee | 99.908 | 0.092 | nonzero | 0.003 | |||||||
| pg155_def.cx9a2_bee | 99.933 | 0.067 | nonzero | 0.003 | |||||||
| pg161_def.cx9a2_bee | 99.931 | 0.069 | nonzero | 0.003 |
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 | 91.956 | 8.044 | 0.052 | ||||||||
| pg9124_def.cx9a2_bee | 99.744 | 0.256 | 0.035 | ||||||||
| pg9224_def.cx9a2_bee | 99.978 | 0.022 | 0.029 | ||||||||
| pg9325_def.cx9a2_bee | 99.989 | 0.011 | 0.024 | ||||||||
| pg9426_def.cx9a2_bee | 99.989 | 0.011 | 0.020 | ||||||||
| pg9525_def.cx9a2_bee | 99.944 | 0.056 | 0.009 | ||||||||
| pg9624_def.cx9a2_bee | 99.950 | 0.050 | 0.007 | ||||||||
| pg1023_def.cx9a2_bee | 99.983 | 0.017 | 0.007 | ||||||||
| pg1122_def.cx9a2_bee | 99.956 | 0.044 | 0.007 | ||||||||
| pg1217_def.cx9a2_bee | 99.956 | 0.044 | 0.007 | ||||||||
| pg1313_def.cx9a2_bee | 99.978 | 0.022 | 0.007 | ||||||||
| pg1410_def.cx9a2_bee | 99.989 | 0.011 | 0.008 | ||||||||
| pg155_def.cx9a2_bee | 99.972 | 0.028 | 0.008 | ||||||||
| pg161_def.cx9a2_bee | 99.944 | 0.056 | 0.008 |
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 | 2.639 | 85.728 | 10.989 | 0.589 | 0.056 | 0.018 | |||||
| pg9124_def.cx9a2_bee | 2.794 | 86.472 | 10.733 | 0.004 | |||||||
| pg9224_def.cx9a2_bee | 3.722 | 85.389 | 10.833 | 0.050 | 0.006 | 0.017 | |||||
| pg9325_def.cx9a2_bee | 5.122 | 94.844 | 0.033 | 0.003 | |||||||
| pg9426_def.cx9a2_bee | 7.117 | 92.850 | 0.022 | 0.011 | 0.004 | ||||||
| pg9525_def.cx9a2_bee | 10.400 | 89.578 | 0.022 | 0.003 | |||||||
| pg9624_def.cx9a2_bee | 18.983 | 80.928 | 0.089 | 0.003 | |||||||
| pg1023_def.cx9a2_bee | 18.156 | 80.789 | 0.122 | 0.933 | 0.012 | ||||||
| pg1122_def.cx9a2_bee | 18.761 | 81.106 | 0.133 | 0.003 | |||||||
| pg1217_def.cx9a2_bee | 13.367 | 86.506 | 0.128 | 0.003 | |||||||
| pg1313_def.cx9a2_bee | 17.172 | 82.683 | 0.144 | 0.003 | |||||||
| pg1410_def.cx9a2_bee | 8.906 | 90.989 | 0.106 | 0.003 | |||||||
| pg155_def.cx9a2_bee | 8.556 | 91.300 | 0.144 | 0.003 | |||||||
| pg161_def.cx9a2_bee | 7.222 | 92.617 | 0.161 | 0.003 |
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 6731 0 0.0 1031.3 17.7 0.000 0.000 2.068 36.340 26117 13.7 3.880 163 8.1 8.2 1.7 0.021 6538 5711 pg9023_def.cx9a2_bee 499 6954 0 0.0 1029.9 17.7 0.000 0.000 2.063 36.280 26923 13.7 3.872 158 8.1 8.3 3.5 0.003 6846 5901 pg9124_def.cx9a2_bee 499 7468 0 0.0 1043.1 17.7 0.000 0.000 2.092 36.305 28946 13.7 3.876 147 8.1 8.3 3.7 0.006 7275 6184 pg9224_def.cx9a2_bee 499 7257 0 0.0 1112.2 15.1 0.000 0.000 2.231 31.045 28435 13.5 3.918 149 8.3 8.5 2.6 0.003 7102 6261 pg9325_def.cx9a2_bee 499 7250 0 0.0 1112.1 15.1 0.000 0.000 2.230 31.039 28373 13.4 3.913 148 8.3 8.4 3.0 0.005 7112 6145 pg9426_def.cx9a2_bee 499 7322 0 0.0 114.1 2.3 0.000 0.000 0.229 4.806 28315 13.1 3.867 143 8.4 32.2 8.6 0.003 7192 6089 pg9525_def.cx9a2_bee 499 7436 0 0.0 61.0 2.4 0.000 0.000 0.122 4.842 28807 13.3 3.874 143 8.4 36.0 8.5 0.004 7273 6137 pg9624_def.cx9a2_bee 499 7467 0 0.0 62.0 2.3 0.000 0.000 0.124 4.783 28918 13.0 3.873 139 8.4 30.5 8.5 0.003 7349 6201 pg1023_def.cx9a2_bee 499 7659 0 0.0 61.3 2.4 0.000 0.000 0.123 4.877 29664 13.0 3.873 136 8.4 28.4 8.5 0.004 7510 6302 pg1122_def.cx9a2_bee 499 7917 0 0.0 60.4 2.4 0.000 0.000 0.121 4.825 30650 13.2 3.871 133 8.2 33.5 1.7 0.003 7688 7176 pg1217_def.cx9a2_bee 499 8078 0 0.0 61.6 2.3 0.000 0.000 0.123 4.813 31258 13.3 3.869 132 8.3 31.0 1.7 0.004 7813 7192 pg1313_def.cx9a2_bee 499 7912 0 0.0 60.2 2.3 0.000 0.000 0.121 4.639 30578 13.2 3.865 133 8.1 38.9 1.7 0.003 7734 7208 pg1410_def.cx9a2_bee 499 8309 0 0.0 60.0 2.2 0.000 0.000 0.120 4.569 32015 12.7 3.853 122 8.0 39.8 3.9 0.003 8023 7366 pg155_def.cx9a2_bee 499 8337 0 0.0 59.8 2.2 0.000 0.000 0.120 4.566 32162 12.7 3.858 122 8.0 39.1 3.9 0.003 8032 7384 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 | 32.216 | 67.780 | 0.003 | nonzero | 0.006 | ||||||
| pg9124_def.cx9a2_bee | 31.700 | 68.297 | 0.003 | nonzero | 0.005 | ||||||
| pg9224_def.cx9a2_bee | 87.469 | 12.529 | 0.002 | nonzero | 0.005 | ||||||
| pg9325_def.cx9a2_bee | 79.814 | 20.184 | 0.002 | nonzero | 0.004 | ||||||
| pg9426_def.cx9a2_bee | 80.305 | 19.693 | 0.002 | nonzero | nonzero | nonzero | 0.074 | ||||
| pg9525_def.cx9a2_bee | 87.148 | 12.849 | 0.003 | nonzero | 0.004 | ||||||
| pg9624_def.cx9a2_bee | 87.533 | 12.465 | 0.001 | nonzero | 0.004 | ||||||
| pg1023_def.cx9a2_bee | 87.779 | 12.219 | 0.002 | nonzero | 0.006 | ||||||
| pg1122_def.cx9a2_bee | 87.476 | 12.523 | 0.002 | nonzero | 0.007 | ||||||
| pg1217_def.cx9a2_bee | 87.755 | 12.243 | 0.001 | nonzero | 0.004 | ||||||
| pg1313_def.cx9a2_bee | 87.570 | 12.428 | 0.002 | 0.003 | |||||||
| pg1410_def.cx9a2_bee | 87.525 | 12.474 | 0.002 | 0.003 | |||||||
| pg155_def.cx9a2_bee | 87.224 | 12.775 | 0.002 | nonzero | 0.006 | ||||||
| pg161_def.cx9a2_bee | 85.367 | 14.632 | 0.001 | 0.003 |
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 | 92.278 | 7.722 | 0.031 | ||||||||
| pg9124_def.cx9a2_bee | 99.967 | 0.033 | 0.021 | ||||||||
| pg9224_def.cx9a2_bee | 99.994 | 0.006 | 0.021 | ||||||||
| pg9325_def.cx9a2_bee | 99.989 | 0.011 | 0.019 | ||||||||
| pg9426_def.cx9a2_bee | 99.967 | 0.033 | 0.023 | ||||||||
| pg9525_def.cx9a2_bee | 99.944 | 0.056 | 0.009 | ||||||||
| pg9624_def.cx9a2_bee | 99.961 | 0.039 | 0.008 | ||||||||
| pg1023_def.cx9a2_bee | 99.933 | 0.067 | 0.008 | ||||||||
| pg1122_def.cx9a2_bee | 99.983 | 0.011 | 0.006 | 0.023 | |||||||
| pg1217_def.cx9a2_bee | 99.944 | 0.056 | 0.008 | ||||||||
| pg1313_def.cx9a2_bee | 99.989 | 0.011 | 0.008 | ||||||||
| pg1410_def.cx9a2_bee | 99.933 | 0.056 | 0.011 | 0.028 | |||||||
| pg155_def.cx9a2_bee | 99.944 | 0.050 | 0.006 | 0.032 | |||||||
| pg161_def.cx9a2_bee | 99.961 | 0.033 | 0.006 | 0.026 |
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 | 15.772 | 66.578 | 3.578 | 13.744 | 0.328 | 0.024 | |||||
| pg9124_def.cx9a2_bee | 15.983 | 59.006 | 4.456 | 20.556 | 0.012 | ||||||
| pg9224_def.cx9a2_bee | 13.172 | 64.928 | 1.372 | 20.528 | 0.010 | ||||||
| pg9325_def.cx9a2_bee | 15.200 | 55.894 | 13.906 | 14.994 | 0.006 | 0.017 | |||||
| pg9426_def.cx9a2_bee | 15.556 | 50.606 | 13.000 | 20.839 | 0.016 | ||||||
| pg9525_def.cx9a2_bee | 20.283 | 42.794 | 13.650 | 23.272 | 0.010 | ||||||
| pg9624_def.cx9a2_bee | 20.606 | 44.250 | 13.333 | 21.811 | 0.010 | ||||||
| pg1023_def.cx9a2_bee | 20.311 | 42.228 | 12.717 | 24.744 | 0.011 | ||||||
| pg1122_def.cx9a2_bee | 20.989 | 45.839 | 14.178 | 18.989 | 0.006 | 0.021 | |||||
| pg1217_def.cx9a2_bee | 16.856 | 53.333 | 29.750 | 0.061 | 0.005 | ||||||
| pg1313_def.cx9a2_bee | 18.778 | 50.606 | 28.772 | 1.844 | 0.006 | ||||||
| pg1410_def.cx9a2_bee | 20.550 | 50.006 | 28.083 | 1.350 | 0.011 | 0.026 | |||||
| pg155_def.cx9a2_bee | 19.067 | 52.900 | 27.400 | 0.628 | 0.006 | 0.029 | |||||
| pg161_def.cx9a2_bee | 13.322 | 55.044 | 27.144 | 4.483 | 0.006 | 0.024 |
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 3128 0 0.0 1147.0 16.3 0.000 0.000 2.298 33.407 13270 15.7 4.242 402 8.1 8.2 3.1 0.006 3132 2893 pg9023_def.cx9a2_bee 499 3105 0 0.0 1147.2 16.2 0.000 0.000 2.299 33.246 13166 14.8 4.240 381 8.1 8.3 3.1 0.005 3101 2893 pg9124_def.cx9a2_bee 499 3601 0 0.0 1157.3 16.3 0.000 0.000 2.317 33.358 15183 14.8 4.217 329 8.1 8.3 1.4 0.005 3583 3468 pg9224_def.cx9a2_bee 499 3513 0 0.0 1741.9 23.1 0.000 0.000 3.494 47.452 16343 14.8 4.652 337 8.3 8.5 5.3 0.004 3517 3276 pg9325_def.cx9a2_bee 499 3560 0 0.0 1692.6 23.1 0.000 0.000 3.391 47.426 16347 14.9 4.591 335 8.3 8.5 6.7 0.074 3564 3308 pg9426_def.cx9a2_bee 499 3561 0 0.0 149.4 3.1 0.000 0.000 0.299 6.369 14984 14.3 4.208 321 8.4 31.1 6.7 0.004 3548 3420 pg9525_def.cx9a2_bee 499 3512 0 0.0 24.7 3.1 0.000 0.000 0.049 6.343 14775 14.7 4.208 335 8.4 34.8 0.7 0.004 3500 3387 pg9624_def.cx9a2_bee 499 3527 0 0.0 25.0 3.1 0.000 0.000 0.050 6.352 14845 14.8 4.209 336 8.4 29.4 6.6 0.006 3516 3388 pg1023_def.cx9a2_bee 499 3492 0 0.0 24.9 3.1 0.000 0.000 0.050 6.366 14716 14.9 4.214 341 8.4 28.4 8.5 0.007 3483 3358 pg1122_def.cx9a2_bee 499 3495 0 0.0 24.4 3.1 0.000 0.000 0.049 6.306 14702 14.5 4.207 332 8.2 31.4 6.9 0.004 3484 3372 pg1217_def.cx9a2_bee 499 3478 0 0.0 24.9 3.1 0.000 0.000 0.050 6.369 14642 14.5 4.210 334 8.3 28.9 6.4 0.003 3468 3356 pg1313_def.cx9a2_bee 499 3498 0 0.0 31.1 3.0 0.000 0.000 0.062 6.113 14747 14.0 4.216 320 8.1 36.8 3.6 0.003 3487 3374 pg1410_def.cx9a2_bee 499 3457 0 0.0 31.2 3.0 0.000 0.000 0.063 6.117 14412 13.7 4.168 317 8.0 37.7 1.7 0.006 3454 3356 pg155_def.cx9a2_bee 499 3419 0 0.0 31.0 3.0 0.000 0.000 0.062 6.086 14276 13.5 4.175 316 8.0 37.0 2.9 0.003 3404 3292 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 | 98.730 | 1.256 | 0.007 | 0.006 | nonzero | 0.020 | |||||
| pg9124_def.cx9a2_bee | 99.035 | 0.961 | 0.004 | nonzero | nonzero | 0.025 | |||||
| pg9224_def.cx9a2_bee | 99.170 | 0.826 | 0.004 | nonzero | 0.010 | ||||||
| pg9325_def.cx9a2_bee | 98.614 | 1.381 | 0.004 | nonzero | 0.007 | ||||||
| pg9426_def.cx9a2_bee | 98.703 | 1.293 | 0.004 | nonzero | nonzero | 0.017 | |||||
| pg9525_def.cx9a2_bee | 98.472 | 1.524 | 0.004 | nonzero | 0.010 | ||||||
| pg9624_def.cx9a2_bee | 98.900 | 1.096 | 0.004 | nonzero | 0.006 | ||||||
| pg1023_def.cx9a2_bee | 98.970 | 1.026 | 0.004 | nonzero | 0.006 | ||||||
| pg1122_def.cx9a2_bee | 99.097 | 0.899 | 0.004 | nonzero | 0.006 | ||||||
| pg1217_def.cx9a2_bee | 99.836 | 0.160 | 0.004 | nonzero | 0.006 | ||||||
| pg1313_def.cx9a2_bee | 99.814 | 0.182 | 0.004 | nonzero | 0.005 | ||||||
| pg1410_def.cx9a2_bee | 99.872 | 0.124 | 0.004 | nonzero | 0.007 | ||||||
| pg155_def.cx9a2_bee | 99.906 | 0.091 | 0.004 | nonzero | 0.006 | ||||||
| pg161_def.cx9a2_bee | 99.915 | 0.082 | 0.003 | nonzero | 0.011 |
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 | 94.642 | 5.358 | 0.034 | ||||||||
| pg9124_def.cx9a2_bee | 99.772 | 0.228 | 0.038 | ||||||||
| pg9224_def.cx9a2_bee | 99.994 | 0.006 | 0.018 | ||||||||
| pg9325_def.cx9a2_bee | 0.014 | 99.983 | 0.003 | 0.019 | |||||||
| pg9426_def.cx9a2_bee | 0.008 | 99.989 | 0.003 | 0.016 | |||||||
| pg9525_def.cx9a2_bee | 99.978 | 0.022 | 0.009 | ||||||||
| pg9624_def.cx9a2_bee | 99.972 | 0.028 | 0.007 | ||||||||
| pg1023_def.cx9a2_bee | 99.967 | 0.033 | 0.007 | ||||||||
| pg1122_def.cx9a2_bee | 99.972 | 0.028 | 0.008 | ||||||||
| pg1217_def.cx9a2_bee | 99.975 | 0.025 | 0.007 | ||||||||
| pg1313_def.cx9a2_bee | 99.986 | 0.014 | 0.008 | ||||||||
| pg1410_def.cx9a2_bee | 99.989 | 0.011 | 0.007 | ||||||||
| pg155_def.cx9a2_bee | 99.978 | 0.019 | 0.003 | 0.022 | |||||||
| pg161_def.cx9a2_bee | 99.981 | 0.019 | 0.007 |
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 | 1.078 | 63.778 | 12.069 | 22.514 | 0.561 | 0.027 | |||||
| pg9124_def.cx9a2_bee | 1.025 | 64.297 | 13.469 | 21.194 | 0.014 | 0.029 | |||||
| pg9224_def.cx9a2_bee | 1.483 | 66.597 | 11.889 | 20.031 | 0.012 | ||||||
| pg9325_def.cx9a2_bee | 1.800 | 82.369 | 6.161 | 9.669 | 0.013 | ||||||
| pg9426_def.cx9a2_bee | 2.431 | 80.397 | 6.397 | 10.775 | 0.014 | ||||||
| pg9525_def.cx9a2_bee | 5.486 | 77.144 | 7.094 | 10.275 | 0.010 | ||||||
| pg9624_def.cx9a2_bee | 5.978 | 75.917 | 7.178 | 10.928 | 0.010 | ||||||
| pg1023_def.cx9a2_bee | 5.664 | 75.258 | 6.308 | 12.769 | 0.011 | ||||||
| pg1122_def.cx9a2_bee | 5.975 | 78.769 | 6.711 | 8.544 | 0.009 | ||||||
| pg1217_def.cx9a2_bee | 4.606 | 80.978 | 14.414 | 0.003 | 0.005 | ||||||
| pg1313_def.cx9a2_bee | 4.672 | 79.417 | 14.594 | 1.317 | 0.005 | ||||||
| pg1410_def.cx9a2_bee | 2.983 | 80.883 | 14.911 | 1.222 | 0.005 | ||||||
| pg155_def.cx9a2_bee | 2.833 | 83.614 | 13.531 | 0.019 | 0.003 | 0.020 | |||||
| pg161_def.cx9a2_bee | 2.658 | 81.858 | 13.831 | 1.653 | 0.005 |
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 998 6701 0 0.0 2060.6 35.4 0.000 0.000 2.065 36.319 26303 15.4 3.925 184 8.1 8.3 3.2 0.020 6685 5610 pg9023_def.cx9a2_bee 997 7100 0 0.0 2066.9 35.3 0.000 0.000 2.073 36.297 27811 15.4 3.917 174 8.1 8.3 4.7 0.025 7060 5833 pg9124_def.cx9a2_bee 998 7629 0 0.0 2102.8 35.3 0.000 0.000 2.108 36.249 29955 15.4 3.927 161 8.1 8.3 3.4 0.010 7621 6202 pg9224_def.cx9a2_bee 998 7313 0 0.0 2234.9 33.2 0.000 0.000 2.240 34.091 29257 15.2 4.001 166 8.3 8.5 7.7 0.007 7085 5977 pg9325_def.cx9a2_bee 998 7346 0 0.0 2233.1 33.2 0.000 0.000 2.238 34.068 29313 15.1 3.990 164 8.3 8.5 7.2 0.017 7222 5960 pg9426_def.cx9a2_bee 997 7186 0 0.0 178.6 3.6 0.000 0.000 0.179 3.716 28100 13.8 3.911 154 8.4 28.9 5.5 0.010 6952 5895 pg9525_def.cx9a2_bee 998 7286 0 0.0 26.8 3.6 0.000 0.000 0.027 3.694 28495 14.0 3.911 154 8.4 32.7 8.5 0.006 7155 5897 pg9624_def.cx9a2_bee 998 7433 0 0.0 26.8 3.6 0.000 0.000 0.027 3.681 29042 14.2 3.907 153 8.4 28.4 0.0 0.006 7317 5980 pg1023_def.cx9a2_bee 998 7571 0 0.0 26.9 3.6 0.000 0.000 0.027 3.705 29570 14.3 3.906 151 8.4 28.4 8.6 0.006 7465 6086 pg1122_def.cx9a2_bee 998 7991 0 0.0 26.5 3.6 0.000 0.000 0.027 3.658 31170 14.3 3.901 143 8.2 29.1 4.0 0.006 7771 6936 pg1217_def.cx9a2_bee 997 8051 0 0.0 26.6 3.6 0.000 0.000 0.027 3.691 31454 14.3 3.907 142 8.3 28.3 6.4 0.005 7863 6872 pg1313_def.cx9a2_bee 998 8119 0 0.0 38.6 3.4 0.000 0.000 0.039 3.498 31606 13.8 3.893 136 8.1 34.4 2.5 0.007 7975 6902 pg1410_def.cx9a2_bee 998 8108 0 0.0 38.3 3.4 0.000 0.000 0.038 3.506 31520 13.8 3.887 136 8.1 35.4 4.0 0.006 7931 6950 pg155_def.cx9a2_bee 997 8388 0 0.0 38.3 3.4 0.000 0.000 0.038 3.499 32599 13.7 3.886 131 8.0 34.6 3.8 0.011 8091 7069 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 | 69.072 | 30.921 | 0.007 | nonzero | 0.007 | ||||||
| pg9124_def.cx9a2_bee | 71.912 | 28.082 | 0.006 | nonzero | 0.012 | ||||||
| pg9224_def.cx9a2_bee | 87.895 | 12.102 | 0.003 | nonzero | 0.005 | ||||||
| pg9325_def.cx9a2_bee | 76.358 | 23.640 | 0.003 | nonzero | 0.008 | ||||||
| pg9426_def.cx9a2_bee | 76.747 | 23.250 | 0.002 | nonzero | nonzero | 0.024 | |||||
| pg9525_def.cx9a2_bee | 87.484 | 12.512 | 0.005 | nonzero | 0.007 | ||||||
| pg9624_def.cx9a2_bee | 87.931 | 12.066 | 0.002 | 0.004 | |||||||
| pg1023_def.cx9a2_bee | 87.868 | 12.129 | 0.003 | nonzero | 0.004 | ||||||
| pg1122_def.cx9a2_bee | 87.779 | 12.219 | 0.002 | 0.003 | |||||||
| pg1217_def.cx9a2_bee | 88.044 | 11.953 | 0.003 | 0.003 | |||||||
| pg1313_def.cx9a2_bee | 87.590 | 12.407 | 0.003 | 0.003 | |||||||
| pg1410_def.cx9a2_bee | 87.582 | 12.416 | 0.002 | 0.003 | |||||||
| pg155_def.cx9a2_bee | 87.458 | 12.540 | 0.002 | 0.003 | |||||||
| pg161_def.cx9a2_bee | 85.714 | 14.285 | 0.001 | nonzero | 0.004 |
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 | 95.022 | 4.978 | 0.042 | ||||||||
| pg9124_def.cx9a2_bee | 99.875 | 0.125 | 0.037 | ||||||||
| pg9224_def.cx9a2_bee | 99.975 | 0.025 | 0.024 | ||||||||
| pg9325_def.cx9a2_bee | 0.019 | 99.964 | 0.017 | 0.042 | |||||||
| pg9426_def.cx9a2_bee | 0.022 | 99.958 | 0.019 | 0.042 | |||||||
| pg9525_def.cx9a2_bee | 99.964 | 0.036 | 0.007 | ||||||||
| pg9624_def.cx9a2_bee | 99.994 | 0.006 | 0.006 | ||||||||
| pg1023_def.cx9a2_bee | 99.975 | 0.025 | 0.008 | ||||||||
| pg1122_def.cx9a2_bee | 99.983 | 0.017 | 0.006 | ||||||||
| pg1217_def.cx9a2_bee | 99.983 | 0.017 | 0.008 | ||||||||
| pg1313_def.cx9a2_bee | 99.981 | 0.019 | 0.006 | ||||||||
| pg1410_def.cx9a2_bee | 99.981 | 0.019 | 0.008 | ||||||||
| pg155_def.cx9a2_bee | 99.986 | 0.014 | 0.008 | ||||||||
| pg161_def.cx9a2_bee | 99.986 | 0.014 | 0.008 |
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 | 6.633 | 75.144 | 7.178 | 10.778 | 0.267 | 0.027 | |||||
| pg9124_def.cx9a2_bee | 7.042 | 73.225 | 9.147 | 10.575 | 0.011 | 0.026 | |||||
| pg9224_def.cx9a2_bee | 6.333 | 78.272 | 7.150 | 8.244 | 0.016 | ||||||
| pg9325_def.cx9a2_bee | 8.250 | 74.608 | 7.047 | 10.092 | 0.003 | 0.031 | |||||
| pg9426_def.cx9a2_bee | 9.694 | 72.356 | 6.656 | 11.292 | 0.003 | 0.031 | |||||
| pg9525_def.cx9a2_bee | 14.458 | 68.764 | 7.519 | 9.258 | 0.010 | ||||||
| pg9624_def.cx9a2_bee | 13.878 | 67.511 | 7.369 | 11.242 | 0.011 | ||||||
| pg1023_def.cx9a2_bee | 14.111 | 69.419 | 6.586 | 9.883 | 0.010 | ||||||
| pg1122_def.cx9a2_bee | 13.269 | 67.644 | 6.864 | 12.222 | 0.011 | ||||||
| pg1217_def.cx9a2_bee | 11.458 | 74.361 | 14.158 | 0.022 | 0.006 | ||||||
| pg1313_def.cx9a2_bee | 11.831 | 74.086 | 13.928 | 0.156 | 0.006 | ||||||
| pg1410_def.cx9a2_bee | 11.361 | 75.286 | 13.283 | 0.069 | 0.005 | ||||||
| pg155_def.cx9a2_bee | 10.972 | 74.531 | 13.814 | 0.683 | 0.005 | ||||||
| pg161_def.cx9a2_bee | 9.161 | 74.508 | 14.572 | 1.758 | 0.005 |
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 998 3427 0 0.0 2327.5 37.5 0.000 0.000 2.333 38.495 14806 17.5 4.320 408 8.1 8.3 3.0 0.007 3516 2909 pg9023_def.cx9a2_bee 998 3456 0 0.0 2319.2 37.3 0.000 0.000 2.323 38.257 14884 16.5 4.307 382 8.1 8.3 2.1 0.012 3532 2957 pg9124_def.cx9a2_bee 998 3649 0 0.0 2363.3 37.5 0.000 0.000 2.367 38.460 15803 16.4 4.331 360 8.1 8.3 3.6 0.005 3628 3470 pg9224_def.cx9a2_bee 998 3503 0 0.0 3033.9 40.8 0.000 0.000 3.039 41.878 16792 15.9 4.794 363 8.3 8.5 6.9 0.008 3500 3276 pg9325_def.cx9a2_bee 999 3553 0 0.0 3034.9 40.9 0.000 0.000 3.039 41.933 16892 16.0 4.754 360 8.3 8.5 6.8 0.024 3548 3308 pg9426_def.cx9a2_bee 998 3592 0 0.0 171.5 3.7 0.000 0.000 0.172 3.763 15375 14.8 4.280 330 8.4 28.5 3.4 0.007 3580 3423 pg9525_def.cx9a2_bee 998 3554 0 0.0 21.1 3.7 0.000 0.000 0.021 3.762 15178 15.3 4.271 344 8.4 30.3 5.4 0.004 3534 3405 pg9624_def.cx9a2_bee 998 3518 0 0.0 21.4 3.7 0.000 0.000 0.021 3.775 15041 15.3 4.275 348 8.4 28.4 0.2 0.004 3500 3387 pg1023_def.cx9a2_bee 998 3514 0 0.0 21.6 3.7 0.000 0.000 0.022 3.769 15019 15.2 4.275 346 8.4 28.4 6.1 0.003 3500 3372 pg1122_def.cx9a2_bee 998 3523 0 0.0 20.9 3.6 0.000 0.000 0.021 3.722 15044 15.0 4.271 341 8.2 28.2 2.5 0.003 3502 3389 pg1217_def.cx9a2_bee 998 3485 0 0.0 21.2 3.7 0.000 0.000 0.021 3.758 14939 15.1 4.287 347 8.3 28.3 2.8 0.003 3469 3356 pg1313_def.cx9a2_bee 998 3505 0 0.0 26.9 3.5 0.000 0.000 0.027 3.577 14995 14.5 4.278 331 8.1 31.7 2.5 0.003 3500 3388 pg1410_def.cx9a2_bee 998 3465 0 0.0 27.1 3.5 0.000 0.000 0.027 3.590 14655 14.2 4.230 328 8.1 32.6 7.6 0.003 3455 3356 pg155_def.cx9a2_bee 998 3441 0 0.0 27.0 3.5 0.000 0.000 0.027 3.591 14600 13.9 4.243 323 8.1 31.9 3.7 0.004 3420 3308 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 60606 0 0 0.0 272.0 22.5 0.000 0.000 0.004 0.381 6405 21.4 0.106 28 2.9 3.0 0.4 0.044 60742 58034 pg9023_def.cx9a2_bee 60852 0 0 0.0 280.9 22.7 0.000 0.000 0.005 0.382 6431 22.3 0.106 29 2.9 3.0 0.2 0.041 61027 59230 pg9124_def.cx9a2_bee 59055 0 0 0.0 1402.4 22.0 0.000 0.000 0.024 0.382 9891 22.1 0.167 30 2.9 3.0 0.2 0.038 59257 57232 pg9224_def.cx9a2_bee 60976 0 0 0.0 1118.2 25.4 0.000 0.000 0.018 0.427 9055 22.7 0.148 30 2.9 3.0 0.2 0.046 61131 58260 pg9325_def.cx9a2_bee 65502 0 0 0.0 1131.5 27.4 0.000 0.000 0.017 0.428 9363 22.5 0.143 27 2.9 3.0 1.4 0.060 65828 62615 pg9426_def.cx9a2_bee 66667 0 0 0.0 890.7 28.6 0.000 0.000 0.013 0.439 9487 22.0 0.142 26 2.9 7.8 0.2 0.003 67026 64875 pg9525_def.cx9a2_bee 63694 0 0 0.0 74.5 27.3 0.000 0.000 0.001 0.438 7887 23.1 0.124 29 2.9 7.8 0.2 0.004 63930 62525 pg9624_def.cx9a2_bee 63830 0 0 0.0 75.3 27.4 0.000 0.000 0.001 0.440 7875 23.2 0.123 29 2.9 7.8 0.2 0.004 64129 62327 pg1023_def.cx9a2_bee 73892 0 0 0.0 87.1 31.7 0.000 0.000 0.001 0.440 9133 23.7 0.124 26 2.9 7.8 2.8 0.003 74225 71916 pg1122_def.cx9a2_bee 72115 0 0 0.0 84.2 30.8 0.000 0.000 0.001 0.438 8896 23.2 0.123 26 2.9 7.8 3.0 0.003 72219 70382 pg1217_def.cx9a2_bee 74442 0 0 0.0 87.0 32.0 0.000 0.000 0.001 0.440 9145 23.7 0.123 25 2.9 7.8 0.0 0.003 74846 72615 pg1313_def.cx9a2_bee 72464 0 0 0.0 85.1 31.2 0.000 0.000 0.001 0.441 9077 23.1 0.125 26 2.9 7.8 2.8 0.003 72920 70615 pg1410_def.cx9a2_bee 75377 0 0 0.0 87.7 32.3 0.000 0.000 0.001 0.438 9252 23.1 0.123 25 2.9 7.8 2.9 0.003 75615 73465 pg155_def.cx9a2_bee 74627 0 0 0.0 86.6 31.9 0.000 0.000 0.001 0.438 9226 23.2 0.124 25 2.9 7.8 0.2 0.003 74816 72913 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 128756 0 0 0.0 242.8 42.3 0.000 0.000 0.002 0.337 446 11.7 0.003 7 5.8 5.9 2.7 0.003 NA NA pg9023_def.cx9a2_bee 129870 0 0 0.0 252.3 42.0 0.000 0.000 0.002 0.331 451 12.1 0.003 7 5.8 5.9 2.7 0.003 NA NA pg9124_def.cx9a2_bee 132744 0 0 0.0 251.8 41.3 0.000 0.000 0.002 0.318 368 11.9 0.003 7 5.8 6.0 2.7 0.003 NA NA pg9224_def.cx9a2_bee 132159 0 0 0.0 259.8 47.7 0.000 0.000 0.002 0.369 383 12.1 0.003 7 5.8 5.9 3.0 0.003 NA NA pg9325_def.cx9a2_bee 121458 0 0 0.0 226.6 37.1 0.000 0.000 0.002 0.313 414 12.2 0.003 8 5.8 5.9 3.0 0.003 NA NA pg9426_def.cx9a2_bee 140187 0 0 0.0 100.4 45.6 0.000 0.000 0.001 0.333 437 11.7 0.003 7 5.8 13.3 3.0 0.003 NA NA pg9525_def.cx9a2_bee 194806 0 0 0.0 138.7 64.0 0.000 0.000 0.001 0.337 617 11.7 0.003 5 5.8 13.3 3.0 0.003 NA NA pg9624_def.cx9a2_bee 223881 0 0 0.0 153.7 71.4 0.000 0.000 0.001 0.327 585 11.5 0.003 4 5.8 13.3 3.0 0.004 NA NA pg1023_def.cx9a2_bee 218979 0 0 0.0 152.6 70.6 0.000 0.000 0.001 0.330 629 11.5 0.003 4 5.8 13.3 3.0 0.004 NA NA pg1122_def.cx9a2_bee 223881 0 0 0.0 149.2 69.4 0.000 0.000 0.001 0.317 625 11.6 0.003 4 5.8 13.3 3.0 0.003 NA NA pg1217_def.cx9a2_bee 214286 0 0 0.0 169.9 79.0 0.000 0.000 0.001 0.377 848 11.6 0.004 4 5.8 13.3 3.0 0.003 NA NA pg1313_def.cx9a2_bee 215828 0 0 0.0 147.4 68.5 0.000 0.000 0.001 0.325 662 11.9 0.003 4 5.8 13.3 3.0 0.003 NA NA pg1410_def.cx9a2_bee 222223 0 0 0.0 176.7 82.2 0.000 0.000 0.001 0.379 686 11.5 0.003 4 5.8 13.3 3.0 0.003 NA NA pg155_def.cx9a2_bee 232559 0 0 0.0 168.9 78.6 0.000 0.000 0.001 0.346 487 11.5 0.002 4 5.8 13.3 3.1 0.003 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 6523 0 4 0.0 13215.1 226.7 0.001 0.004 2.026 35.593 4929 20.7 0.756 254 8.0 8.1 3.2 0.086 6842 3996 pg9023_def.cx9a2_bee 7129 0 3 0.0 14409.9 246.7 0.000 0.003 2.021 35.439 4673 23.3 0.656 261 8.0 8.2 5.2 0.094 8389 2547 pg9124_def.cx9a2_bee 7287 0 3 0.0 14693.8 249.4 0.000 0.003 2.016 35.050 5880 23.8 0.807 261 8.0 8.2 3.7 0.122 8494 3295 pg9224_def.cx9a2_bee 7478 0 12 0.1 14556.2 250.6 0.002 0.008 1.947 34.320 5695 23.2 0.762 248 8.2 8.4 5.4 0.314 8747 2648 pg9325_def.cx9a2_bee 7679 0 4 0.0 15155.8 260.0 0.001 0.004 1.974 34.677 5079 23.7 0.661 247 8.2 8.4 6.6 0.131 8790 3349 pg9426_def.cx9a2_bee 10855 0 30 0.1 448.9 18.9 0.003 0.013 0.041 1.782 5652 18.4 0.521 136 8.4 42.6 6.3 0.064 2747 1897 pg9525_def.cx9a2_bee 10532 0 29 0.1 65.1 18.5 0.003 0.013 0.006 1.799 5480 18.2 0.520 138 8.3 42.8 5.3 0.043 2847 1948 pg9624_def.cx9a2_bee 9009 0 25 0.1 54.7 14.9 0.003 0.013 0.006 1.690 4706 17.6 0.522 156 8.3 39.1 5.3 0.023 2198 1748 pg1023_def.cx9a2_bee 11703 0 32 0.1 59.7 16.0 0.003 0.013 0.005 1.402 5960 18.7 0.509 128 8.3 31.0 4.6 0.015 3346 2148 pg1122_def.cx9a2_bee 21322 0 52 0.5 98.5 29.5 0.002 0.026 0.005 1.419 10600 24.6 0.497 92 8.1 38.7 5.0 0.019 28621 3795 pg1217_def.cx9a2_bee 16667 0 49 0.2 86.0 23.5 0.003 0.012 0.005 1.443 8367 22.2 0.502 107 8.2 37.1 0.3 0.020 7442 4548 pg1313_def.cx9a2_bee 18859 0 50 0.2 87.8 26.2 0.003 0.012 0.005 1.425 9298 21.4 0.493 91 7.9 39.1 5.0 0.019 27632 4645 pg1410_def.cx9a2_bee 20758 0 54 0.2 92.7 27.7 0.003 0.012 0.004 1.365 10167 22.3 0.490 86 7.9 38.5 1.3 0.016 28268 4645 pg155_def.cx9a2_bee 18365 0 48 0.2 85.7 25.4 0.003 0.012 0.005 1.417 9025 21.1 0.491 92 7.9 39.0 5.7 0.015 27069 3996 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 2016 0 0 0.0 4087.8 67.8 0.000 0.000 2.028 34.430 9179 17.0 4.553 675 8.1 8.2 3.2 0.044 739 460 pg9023_def.cx9a2_bee 2086 0 0 0.0 4222.0 68.9 0.000 0.000 2.024 33.810 9221 17.5 4.421 671 8.1 8.3 3.3 0.032 654 429 pg9124_def.cx9a2_bee 1771 0 0 0.0 3774.7 57.9 0.000 0.000 2.132 33.490 8724 17.0 4.927 768 8.1 8.3 2.9 0.043 559 370 pg9224_def.cx9a2_bee 2337 0 0 0.0 4937.2 75.7 0.000 0.000 2.113 33.183 11269 18.2 4.822 623 8.3 8.5 3.8 0.094 614 430 pg9325_def.cx9a2_bee 2288 0 0 0.0 4822.3 74.2 0.000 0.000 2.107 33.224 10795 18.1 4.717 633 8.3 8.5 6.9 0.070 575 375 pg9426_def.cx9a2_bee 1240 0 0 0.0 208.2 3.7 0.000 0.000 0.168 3.092 5434 13.8 4.383 891 8.4 37.8 4.5 0.036 270 210 pg9525_def.cx9a2_bee 2227 0 0 0.0 25.0 4.4 0.000 0.000 0.011 2.001 10875 15.3 4.883 550 8.4 42.1 6.6 0.004 489 310 pg9624_def.cx9a2_bee 1737 0 0 0.0 25.8 4.4 0.000 0.000 0.015 2.600 8563 14.8 4.930 682 8.4 37.5 6.6 0.027 385 300 pg1023_def.cx9a2_bee 2318 0 0 0.0 29.2 5.2 0.000 0.000 0.013 2.292 11266 15.5 4.860 535 8.4 30.6 1.7 0.004 455 325 pg1122_def.cx9a2_bee 2432 0 0 0.0 28.5 5.2 0.000 0.000 0.012 2.191 11849 15.9 4.872 523 8.1 38.2 5.8 0.041 489 415 pg1217_def.cx9a2_bee 2554 0 0 0.0 28.5 5.2 0.000 0.000 0.011 2.098 12381 15.9 4.849 498 8.3 35.3 5.3 0.011 540 420 pg1313_def.cx9a2_bee 4733 0 0 0.0 34.5 7.8 0.000 0.000 0.007 1.678 22530 18.6 4.761 314 8.0 41.0 6.5 0.010 1184 749 pg1410_def.cx9a2_bee 3929 0 0 0.0 33.2 7.1 0.000 0.000 0.008 1.843 18658 17.5 4.748 356 8.0 40.6 6.5 0.007 1069 594 pg155_def.cx9a2_bee 5426 0 0 0.0 37.1 8.8 0.000 0.000 0.007 1.665 25842 19.7 4.763 290 8.0 41.4 5.7 0.005 1713 896 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 7470 0 0.0 200.6 2.9 0.000 0.000 2.010 29.909 28751 12.7 3.849 136 8.1 8.2 0.9 0.012 7142 6812 pg9023_def.cx9a2_bee 100 7776 0 0.0 200.5 2.9 0.000 0.000 2.011 29.980 29940 12.6 3.850 130 8.1 8.3 1.7 0.005 7388 7111 pg9124_def.cx9a2_bee 100 8310 0 0.0 200.1 2.9 0.000 0.000 2.007 29.910 31924 12.6 3.842 121 8.1 8.2 1.7 0.004 8035 7799 pg9224_def.cx9a2_bee 100 8333 0 0.0 218.6 3.0 0.000 0.000 2.193 30.442 32091 12.6 3.851 121 8.3 8.4 1.0 0.005 8087 7838 pg9325_def.cx9a2_bee 100 8463 0 0.0 219.1 3.0 0.000 0.000 2.197 30.486 32568 12.5 3.848 118 8.3 8.4 1.0 0.005 7993 7687 pg9426_def.cx9a2_bee 100 8529 0 0.0 13.4 0.7 0.000 0.000 0.134 7.594 32743 12.5 3.839 117 8.4 35.7 8.6 0.004 7972 7655 pg9525_def.cx9a2_bee 100 8226 0 0.0 10.4 0.8 0.000 0.000 0.104 7.907 31614 13.0 3.843 126 8.4 39.9 8.5 0.003 7991 7750 pg9624_def.cx9a2_bee 100 8509 0 0.0 9.6 0.7 0.000 0.000 0.096 7.653 32730 12.8 3.846 120 8.4 33.4 8.5 0.004 8106 7831 pg1023_def.cx9a2_bee 100 8813 0 0.0 10.8 0.8 0.000 0.000 0.108 7.983 33920 12.8 3.849 116 8.4 29.0 8.5 0.003 8266 7991 pg1122_def.cx9a2_bee 100 8815 0 0.0 10.3 0.8 0.000 0.000 0.103 7.855 33873 12.9 3.843 117 8.1 35.8 1.2 0.003 8357 8133 pg1217_def.cx9a2_bee 100 8740 0 0.0 10.1 0.8 0.000 0.000 0.101 7.760 33609 12.9 3.845 118 8.3 33.3 1.2 0.003 8327 8134 pg1313_def.cx9a2_bee 100 8666 0 0.0 8.8 0.7 0.000 0.000 0.089 7.601 33293 13.1 3.842 121 8.0 41.0 1.2 0.002 8424 8246 pg1410_def.cx9a2_bee 100 8990 0 0.0 8.9 0.7 0.000 0.000 0.089 7.615 34487 12.7 3.836 113 8.0 40.6 1.0 0.003 8533 8323 pg155_def.cx9a2_bee 100 8958 0 0.0 8.8 0.7 0.000 0.000 0.088 7.591 34338 12.8 3.833 114 8.0 41.4 1.0 0.003 8646 8438 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 3151 0 0.0 210.1 3.3 0.000 0.000 2.105 33.373 13195 14.7 4.188 373 8.1 8.2 3.1 0.005 3148 2940 pg9023_def.cx9a2_bee 100 3112 0 0.0 214.5 3.3 0.000 0.000 2.149 33.784 13034 13.7 4.188 352 8.1 8.3 2.8 0.005 3103 2893 pg9124_def.cx9a2_bee 100 3575 0 0.0 216.5 3.3 0.000 0.000 2.170 33.768 14869 13.6 4.159 304 8.1 8.2 2.9 0.005 3579 3436 pg9224_def.cx9a2_bee 100 3537 0 0.0 353.2 4.0 0.000 0.000 3.539 40.561 15170 13.4 4.289 303 8.3 8.4 0.7 0.004 3532 3419 pg9325_def.cx9a2_bee 100 3554 0 0.0 353.4 4.0 0.000 0.000 3.545 40.618 15252 13.4 4.292 302 8.3 8.4 0.7 0.005 3549 3436 pg9426_def.cx9a2_bee 100 3599 0 0.0 106.3 1.7 0.000 0.000 1.065 17.058 14976 13.7 4.161 305 8.4 33.3 8.6 0.005 3583 3451 pg9525_def.cx9a2_bee 100 3519 0 0.0 57.4 1.7 0.000 0.000 0.575 16.955 14659 14.4 4.166 327 8.4 37.1 8.5 0.004 3500 3388 pg9624_def.cx9a2_bee 100 3500 0 0.0 57.9 1.7 0.000 0.000 0.580 17.061 14602 14.2 4.172 325 8.4 31.7 8.5 0.005 3487 3387 pg1023_def.cx9a2_bee 100 3484 0 0.0 57.9 1.7 0.000 0.000 0.581 16.940 14535 14.4 4.172 331 8.4 28.4 8.5 0.003 3471 3359 pg1122_def.cx9a2_bee 100 3483 0 0.0 57.1 1.7 0.000 0.000 0.573 16.976 14525 14.2 4.170 326 8.1 34.7 1.2 0.004 3483 3372 pg1217_def.cx9a2_bee 100 3448 0 0.0 58.2 1.7 0.000 0.000 0.584 17.014 14386 14.1 4.172 327 8.3 32.2 1.0 0.003 3437 3324 pg1313_def.cx9a2_bee 100 3492 0 0.0 56.5 1.6 0.000 0.000 0.567 16.892 14578 13.8 4.175 316 8.0 39.9 1.2 0.010 3484 3387 pg1410_def.cx9a2_bee 100 3430 0 0.0 56.5 1.6 0.000 0.000 0.566 16.838 14147 13.5 4.125 315 8.0 40.6 1.0 0.004 3420 3324 pg155_def.cx9a2_bee 100 3455 0 0.0 56.3 1.6 0.000 0.000 0.564 16.858 14284 13.2 4.134 306 8.0 40.2 0.6 0.003 3436 3323 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 6731 0 0.0 1031.3 17.7 0.000 0.000 2.068 36.340 26117 13.7 3.880 163 8.1 8.2 1.7 0.021 6538 5711 pg9023_def.cx9a2_bee 499 6954 0 0.0 1029.9 17.7 0.000 0.000 2.063 36.280 26923 13.7 3.872 158 8.1 8.3 3.5 0.003 6846 5901 pg9124_def.cx9a2_bee 499 7468 0 0.0 1043.1 17.7 0.000 0.000 2.092 36.305 28946 13.7 3.876 147 8.1 8.3 3.7 0.006 7275 6184 pg9224_def.cx9a2_bee 499 7257 0 0.0 1112.2 15.1 0.000 0.000 2.231 31.045 28435 13.5 3.918 149 8.3 8.5 2.6 0.003 7102 6261 pg9325_def.cx9a2_bee 499 7250 0 0.0 1112.1 15.1 0.000 0.000 2.230 31.039 28373 13.4 3.913 148 8.3 8.4 3.0 0.005 7112 6145 pg9426_def.cx9a2_bee 499 7322 0 0.0 114.1 2.3 0.000 0.000 0.229 4.806 28315 13.1 3.867 143 8.4 32.2 8.6 0.003 7192 6089 pg9525_def.cx9a2_bee 499 7436 0 0.0 61.0 2.4 0.000 0.000 0.122 4.842 28807 13.3 3.874 143 8.4 36.0 8.5 0.004 7273 6137 pg9624_def.cx9a2_bee 499 7467 0 0.0 62.0 2.3 0.000 0.000 0.124 4.783 28918 13.0 3.873 139 8.4 30.5 8.5 0.003 7349 6201 pg1023_def.cx9a2_bee 499 7659 0 0.0 61.3 2.4 0.000 0.000 0.123 4.877 29664 13.0 3.873 136 8.4 28.4 8.5 0.004 7510 6302 pg1122_def.cx9a2_bee 499 7917 0 0.0 60.4 2.4 0.000 0.000 0.121 4.825 30650 13.2 3.871 133 8.2 33.5 1.7 0.003 7688 7176 pg1217_def.cx9a2_bee 499 8078 0 0.0 61.6 2.3 0.000 0.000 0.123 4.813 31258 13.3 3.869 132 8.3 31.0 1.7 0.004 7813 7192 pg1313_def.cx9a2_bee 499 7912 0 0.0 60.2 2.3 0.000 0.000 0.121 4.639 30578 13.2 3.865 133 8.1 38.9 1.7 0.003 7734 7208 pg1410_def.cx9a2_bee 499 8309 0 0.0 60.0 2.2 0.000 0.000 0.120 4.569 32015 12.7 3.853 122 8.0 39.8 3.9 0.003 8023 7366 pg155_def.cx9a2_bee 499 8337 0 0.0 59.8 2.2 0.000 0.000 0.120 4.566 32162 12.7 3.858 122 8.0 39.1 3.9 0.003 8032 7384 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 3128 0 0.0 1147.0 16.3 0.000 0.000 2.298 33.407 13270 15.7 4.242 402 8.1 8.2 3.1 0.006 3132 2893 pg9023_def.cx9a2_bee 499 3105 0 0.0 1147.2 16.2 0.000 0.000 2.299 33.246 13166 14.8 4.240 381 8.1 8.3 3.1 0.005 3101 2893 pg9124_def.cx9a2_bee 499 3601 0 0.0 1157.3 16.3 0.000 0.000 2.317 33.358 15183 14.8 4.217 329 8.1 8.3 1.4 0.005 3583 3468 pg9224_def.cx9a2_bee 499 3513 0 0.0 1741.9 23.1 0.000 0.000 3.494 47.452 16343 14.8 4.652 337 8.3 8.5 5.3 0.004 3517 3276 pg9325_def.cx9a2_bee 499 3560 0 0.0 1692.6 23.1 0.000 0.000 3.391 47.426 16347 14.9 4.591 335 8.3 8.5 6.7 0.074 3564 3308 pg9426_def.cx9a2_bee 499 3561 0 0.0 149.4 3.1 0.000 0.000 0.299 6.369 14984 14.3 4.208 321 8.4 31.1 6.7 0.004 3548 3420 pg9525_def.cx9a2_bee 499 3512 0 0.0 24.7 3.1 0.000 0.000 0.049 6.343 14775 14.7 4.208 335 8.4 34.8 0.7 0.004 3500 3387 pg9624_def.cx9a2_bee 499 3527 0 0.0 25.0 3.1 0.000 0.000 0.050 6.352 14845 14.8 4.209 336 8.4 29.4 6.6 0.006 3516 3388 pg1023_def.cx9a2_bee 499 3492 0 0.0 24.9 3.1 0.000 0.000 0.050 6.366 14716 14.9 4.214 341 8.4 28.4 8.5 0.007 3483 3358 pg1122_def.cx9a2_bee 499 3495 0 0.0 24.4 3.1 0.000 0.000 0.049 6.306 14702 14.5 4.207 332 8.2 31.4 6.9 0.004 3484 3372 pg1217_def.cx9a2_bee 499 3478 0 0.0 24.9 3.1 0.000 0.000 0.050 6.369 14642 14.5 4.210 334 8.3 28.9 6.4 0.003 3468 3356 pg1313_def.cx9a2_bee 499 3498 0 0.0 31.1 3.0 0.000 0.000 0.062 6.113 14747 14.0 4.216 320 8.1 36.8 3.6 0.003 3487 3374 pg1410_def.cx9a2_bee 499 3457 0 0.0 31.2 3.0 0.000 0.000 0.063 6.117 14412 13.7 4.168 317 8.0 37.7 1.7 0.006 3454 3356 pg155_def.cx9a2_bee 499 3419 0 0.0 31.0 3.0 0.000 0.000 0.062 6.086 14276 13.5 4.175 316 8.0 37.0 2.9 0.003 3404 3292 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 998 6701 0 0.0 2060.6 35.4 0.000 0.000 2.065 36.319 26303 15.4 3.925 184 8.1 8.3 3.2 0.020 6685 5610 pg9023_def.cx9a2_bee 997 7100 0 0.0 2066.9 35.3 0.000 0.000 2.073 36.297 27811 15.4 3.917 174 8.1 8.3 4.7 0.025 7060 5833 pg9124_def.cx9a2_bee 998 7629 0 0.0 2102.8 35.3 0.000 0.000 2.108 36.249 29955 15.4 3.927 161 8.1 8.3 3.4 0.010 7621 6202 pg9224_def.cx9a2_bee 998 7313 0 0.0 2234.9 33.2 0.000 0.000 2.240 34.091 29257 15.2 4.001 166 8.3 8.5 7.7 0.007 7085 5977 pg9325_def.cx9a2_bee 998 7346 0 0.0 2233.1 33.2 0.000 0.000 2.238 34.068 29313 15.1 3.990 164 8.3 8.5 7.2 0.017 7222 5960 pg9426_def.cx9a2_bee 997 7186 0 0.0 178.6 3.6 0.000 0.000 0.179 3.716 28100 13.8 3.911 154 8.4 28.9 5.5 0.010 6952 5895 pg9525_def.cx9a2_bee 998 7286 0 0.0 26.8 3.6 0.000 0.000 0.027 3.694 28495 14.0 3.911 154 8.4 32.7 8.5 0.006 7155 5897 pg9624_def.cx9a2_bee 998 7433 0 0.0 26.8 3.6 0.000 0.000 0.027 3.681 29042 14.2 3.907 153 8.4 28.4 0.0 0.006 7317 5980 pg1023_def.cx9a2_bee 998 7571 0 0.0 26.9 3.6 0.000 0.000 0.027 3.705 29570 14.3 3.906 151 8.4 28.4 8.6 0.006 7465 6086 pg1122_def.cx9a2_bee 998 7991 0 0.0 26.5 3.6 0.000 0.000 0.027 3.658 31170 14.3 3.901 143 8.2 29.1 4.0 0.006 7771 6936 pg1217_def.cx9a2_bee 997 8051 0 0.0 26.6 3.6 0.000 0.000 0.027 3.691 31454 14.3 3.907 142 8.3 28.3 6.4 0.005 7863 6872 pg1313_def.cx9a2_bee 998 8119 0 0.0 38.6 3.4 0.000 0.000 0.039 3.498 31606 13.8 3.893 136 8.1 34.4 2.5 0.007 7975 6902 pg1410_def.cx9a2_bee 998 8108 0 0.0 38.3 3.4 0.000 0.000 0.038 3.506 31520 13.8 3.887 136 8.1 35.4 4.0 0.006 7931 6950 pg155_def.cx9a2_bee 997 8388 0 0.0 38.3 3.4 0.000 0.000 0.038 3.499 32599 13.7 3.886 131 8.0 34.6 3.8 0.011 8091 7069 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 998 3427 0 0.0 2327.5 37.5 0.000 0.000 2.333 38.495 14806 17.5 4.320 408 8.1 8.3 3.0 0.007 3516 2909 pg9023_def.cx9a2_bee 998 3456 0 0.0 2319.2 37.3 0.000 0.000 2.323 38.257 14884 16.5 4.307 382 8.1 8.3 2.1 0.012 3532 2957 pg9124_def.cx9a2_bee 998 3649 0 0.0 2363.3 37.5 0.000 0.000 2.367 38.460 15803 16.4 4.331 360 8.1 8.3 3.6 0.005 3628 3470 pg9224_def.cx9a2_bee 998 3503 0 0.0 3033.9 40.8 0.000 0.000 3.039 41.878 16792 15.9 4.794 363 8.3 8.5 6.9 0.008 3500 3276 pg9325_def.cx9a2_bee 999 3553 0 0.0 3034.9 40.9 0.000 0.000 3.039 41.933 16892 16.0 4.754 360 8.3 8.5 6.8 0.024 3548 3308 pg9426_def.cx9a2_bee 998 3592 0 0.0 171.5 3.7 0.000 0.000 0.172 3.763 15375 14.8 4.280 330 8.4 28.5 3.4 0.007 3580 3423 pg9525_def.cx9a2_bee 998 3554 0 0.0 21.1 3.7 0.000 0.000 0.021 3.762 15178 15.3 4.271 344 8.4 30.3 5.4 0.004 3534 3405 pg9624_def.cx9a2_bee 998 3518 0 0.0 21.4 3.7 0.000 0.000 0.021 3.775 15041 15.3 4.275 348 8.4 28.4 0.2 0.004 3500 3387 pg1023_def.cx9a2_bee 998 3514 0 0.0 21.6 3.7 0.000 0.000 0.022 3.769 15019 15.2 4.275 346 8.4 28.4 6.1 0.003 3500 3372 pg1122_def.cx9a2_bee 998 3523 0 0.0 20.9 3.6 0.000 0.000 0.021 3.722 15044 15.0 4.271 341 8.2 28.2 2.5 0.003 3502 3389 pg1217_def.cx9a2_bee 998 3485 0 0.0 21.2 3.7 0.000 0.000 0.021 3.758 14939 15.1 4.287 347 8.3 28.3 2.8 0.003 3469 3356 pg1313_def.cx9a2_bee 998 3505 0 0.0 26.9 3.5 0.000 0.000 0.027 3.577 14995 14.5 4.278 331 8.1 31.7 2.5 0.003 3500 3388 pg1410_def.cx9a2_bee 998 3465 0 0.0 27.1 3.5 0.000 0.000 0.027 3.590 14655 14.2 4.230 328 8.1 32.6 7.6 0.003 3455 3356 pg155_def.cx9a2_bee 998 3441 0 0.0 27.0 3.5 0.000 0.000 0.027 3.591 14600 13.9 4.243 323 8.1 31.9 3.7 0.004 3420 3308 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.134 0.801 0.065 0.000 0.000 0.000 0.000 0.000 0.044 pg9023_def.cx9a2_bee 0.000 0.000 99.924 0.075 0.001 0.000 0.000 0.000 0.000 0.000 0.041 pg9124_def.cx9a2_bee 0.000 0.000 99.937 0.062 0.001 0.000 0.000 0.000 0.000 0.000 0.038 pg9224_def.cx9a2_bee 0.000 0.000 99.893 0.106 0.001 0.000 0.000 0.000 0.000 0.000 0.046 pg9325_def.cx9a2_bee 0.000 0.000 99.893 0.106 0.002 0.000 0.000 0.000 0.000 0.000 0.060 pg9426_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9525_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9624_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1023_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1122_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1217_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1313_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1410_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg155_def.cx9a2_bee 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 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 97.778 2.222 nonzero 0.000 0.000 0.000 0.000 0.086 pg9023_def.cx9a2_bee 0.000 0.000 0.000 99.528 0.472 0.001 0.000 0.000 0.000 0.000 0.094 pg9124_def.cx9a2_bee 0.000 0.000 0.000 99.918 0.082 0.001 0.000 0.000 0.000 0.000 0.122 pg9224_def.cx9a2_bee 0.000 0.000 1.008 98.674 0.270 0.047 nonzero 0.000 0.000 0.000 0.314 pg9325_def.cx9a2_bee 0.000 0.000 0.016 99.677 0.295 0.013 0.000 0.000 0.000 0.000 0.131 pg9426_def.cx9a2_bee 0.000 0.000 99.989 0.007 0.003 0.000 0.000 0.000 0.000 0.000 0.064 pg9525_def.cx9a2_bee 0.000 0.000 99.998 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.043 pg9624_def.cx9a2_bee 0.000 0.000 99.991 0.008 0.001 0.000 0.000 0.000 0.000 0.000 0.023 pg1023_def.cx9a2_bee 0.000 0.000 99.998 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg1122_def.cx9a2_bee 0.000 0.000 99.966 0.034 nonzero 0.000 0.000 0.000 0.000 0.000 0.019 pg1217_def.cx9a2_bee 0.000 0.000 99.999 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.020 pg1313_def.cx9a2_bee 0.000 0.000 99.996 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.019 pg1410_def.cx9a2_bee 0.000 0.000 99.997 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.016 pg155_def.cx9a2_bee 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.029 70.034 2.266 27.311 0.358 0.003 0.000 0.000 0.000 0.000 0.078 pg9023_def.cx9a2_bee 0.028 74.268 0.400 22.695 2.606 0.004 0.000 0.000 0.000 0.000 0.142 pg9124_def.cx9a2_bee 0.029 75.064 0.357 24.392 0.155 0.004 0.000 0.000 0.000 0.000 0.100 pg9224_def.cx9a2_bee 0.025 79.850 0.399 18.069 1.645 0.010 0.002 0.000 0.000 0.000 0.534 pg9325_def.cx9a2_bee 0.026 79.745 0.443 19.667 0.114 0.005 nonzero 0.000 0.000 0.000 0.326 pg9426_def.cx9a2_bee 0.352 82.865 0.486 1.406 14.888 0.003 nonzero 0.000 0.000 0.000 0.273 pg9525_def.cx9a2_bee 0.321 81.721 0.471 2.932 14.552 0.003 0.000 0.000 0.000 0.000 0.166 pg9624_def.cx9a2_bee 0.211 81.126 0.425 2.196 16.039 0.003 nonzero 0.000 0.000 0.000 0.265 pg1023_def.cx9a2_bee 0.412 82.219 0.449 7.707 9.214 0.000 0.000 0.000 0.000 0.000 0.026 pg1122_def.cx9a2_bee 0.300 82.314 11.307 6.077 0.002 0.000 0.000 0.000 0.000 0.000 0.036 pg1217_def.cx9a2_bee 0.248 81.864 0.589 17.299 nonzero 0.000 0.000 0.000 0.000 0.000 0.025 pg1313_def.cx9a2_bee 0.144 81.635 2.849 15.372 nonzero 0.000 0.000 0.000 0.000 0.000 0.017 pg1410_def.cx9a2_bee 0.142 81.495 4.366 13.997 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg155_def.cx9a2_bee 0.128 81.658 1.726 16.488 0.000 0.000 0.000 0.000 0.000 0.000 0.014 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 82.718 15.653 1.603 0.025 0.000 0.000 0.000 0.000 0.000 0.044 pg9023_def.cx9a2_bee 0.000 92.204 7.615 0.134 0.046 0.000 0.000 0.000 0.000 0.000 0.032 pg9124_def.cx9a2_bee 0.000 89.450 10.375 0.175 0.001 0.000 0.000 0.000 0.000 0.000 0.043 pg9224_def.cx9a2_bee 0.000 93.940 5.867 0.192 0.001 nonzero 0.000 0.000 0.000 0.000 0.094 pg9325_def.cx9a2_bee 0.000 94.353 5.448 0.197 0.002 nonzero 0.000 0.000 0.000 0.000 0.070 pg9426_def.cx9a2_bee 22.001 77.995 0.003 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.036 pg9525_def.cx9a2_bee 21.278 78.720 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9624_def.cx9a2_bee 10.433 89.564 0.003 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.027 pg1023_def.cx9a2_bee 32.516 67.482 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1122_def.cx9a2_bee 31.769 68.227 0.002 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.041 pg1217_def.cx9a2_bee 36.840 63.156 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1313_def.cx9a2_bee 23.045 76.951 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1410_def.cx9a2_bee 22.301 77.696 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg155_def.cx9a2_bee 20.230 79.766 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 40.363 32.267 1.896 25.413 0.059 nonzero 0.000 0.000 0.000 0.000 0.071 pg9023_def.cx9a2_bee 44.712 31.842 0.027 23.399 0.020 nonzero 0.000 0.000 0.000 0.000 0.075 pg9124_def.cx9a2_bee 39.452 34.922 0.012 25.614 nonzero nonzero 0.000 0.000 0.000 0.000 0.080 pg9224_def.cx9a2_bee 43.132 38.441 0.023 18.403 nonzero nonzero 0.000 0.000 0.000 0.000 0.221 pg9325_def.cx9a2_bee 43.983 38.074 0.029 17.912 nonzero nonzero 0.000 0.000 0.000 0.000 0.216 pg9426_def.cx9a2_bee 60.326 19.482 0.001 2.710 17.480 nonzero 0.000 0.000 0.000 0.000 0.186 pg9525_def.cx9a2_bee 65.346 15.235 0.003 19.245 0.171 nonzero 0.000 0.000 0.000 0.000 0.109 pg9624_def.cx9a2_bee 63.516 16.188 0.004 19.679 0.612 nonzero 0.000 0.000 0.000 0.000 0.109 pg1023_def.cx9a2_bee 66.602 15.958 0.004 17.429 0.007 0.000 0.000 0.000 0.000 0.000 0.017 pg1122_def.cx9a2_bee 64.415 17.715 0.518 17.352 nonzero 0.000 0.000 0.000 0.000 0.000 0.041 pg1217_def.cx9a2_bee 67.123 14.669 0.003 18.206 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg1313_def.cx9a2_bee 57.903 24.338 6.923 10.836 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg1410_def.cx9a2_bee 55.696 24.033 6.053 14.218 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg155_def.cx9a2_bee 55.463 24.475 16.532 3.530 0.000 0.000 0.000 0.000 0.000 0.000 0.009 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.873 0.126 nonzero 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg9023_def.cx9a2_bee 99.895 0.105 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9124_def.cx9a2_bee 99.927 0.073 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9224_def.cx9a2_bee 99.914 0.086 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9325_def.cx9a2_bee 99.919 0.081 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9426_def.cx9a2_bee 99.953 0.047 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9525_def.cx9a2_bee 99.931 0.069 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9624_def.cx9a2_bee 99.932 0.068 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1023_def.cx9a2_bee 99.952 0.048 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1122_def.cx9a2_bee 99.941 0.059 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1217_def.cx9a2_bee 99.939 0.061 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1313_def.cx9a2_bee 99.957 0.043 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 pg1410_def.cx9a2_bee 99.950 0.049 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg155_def.cx9a2_bee 99.955 0.045 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 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 92.639 7.361 0.000 0.000 0.000 0.000 0.000 0.026 pg9023_def.cx9a2_bee 0.000 0.000 0.000 99.917 0.083 0.000 0.000 0.000 0.000 0.000 0.020 pg9124_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg9224_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 pg9325_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg9426_def.cx9a2_bee 0.000 0.000 99.694 0.306 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9525_def.cx9a2_bee 0.000 0.000 99.639 0.361 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg9624_def.cx9a2_bee 0.000 0.000 99.694 0.306 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1023_def.cx9a2_bee 0.000 0.000 99.722 0.278 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1122_def.cx9a2_bee 0.000 0.000 99.778 0.222 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1217_def.cx9a2_bee 0.000 0.000 99.750 0.250 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1313_def.cx9a2_bee 0.000 0.000 99.778 0.222 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1410_def.cx9a2_bee 0.000 0.000 99.611 0.389 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg155_def.cx9a2_bee 0.000 0.000 99.583 0.417 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 12.083 67.528 20.361 0.028 0.000 0.000 0.000 0.000 0.000 0.017 pg9023_def.cx9a2_bee 0.000 14.833 69.222 15.944 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9124_def.cx9a2_bee 0.000 12.139 61.167 26.694 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9224_def.cx9a2_bee 0.000 12.028 65.139 22.833 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9325_def.cx9a2_bee 0.000 11.056 64.278 24.667 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg9426_def.cx9a2_bee 0.000 11.111 65.833 23.056 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9525_def.cx9a2_bee 0.000 10.778 65.611 23.611 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9624_def.cx9a2_bee 0.000 10.056 63.056 26.889 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1023_def.cx9a2_bee 0.000 10.611 64.639 24.750 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1122_def.cx9a2_bee 0.000 31.556 68.444 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1217_def.cx9a2_bee 0.000 27.028 72.944 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1313_def.cx9a2_bee 0.000 27.500 72.500 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1410_def.cx9a2_bee 0.000 27.806 72.111 0.083 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg155_def.cx9a2_bee 0.000 28.111 71.833 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.006 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 34.094 65.904 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9023_def.cx9a2_bee 32.173 67.826 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9124_def.cx9a2_bee 87.082 12.917 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9224_def.cx9a2_bee 85.238 14.762 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9325_def.cx9a2_bee 85.185 14.814 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9426_def.cx9a2_bee 87.472 12.526 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9525_def.cx9a2_bee 87.629 12.369 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9624_def.cx9a2_bee 87.464 12.534 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1023_def.cx9a2_bee 87.281 12.717 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1122_def.cx9a2_bee 87.424 12.575 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1217_def.cx9a2_bee 87.140 12.859 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1313_def.cx9a2_bee 87.463 12.535 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1410_def.cx9a2_bee 86.549 13.449 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg155_def.cx9a2_bee 85.870 14.129 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 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 93.639 6.361 0.000 0.000 0.000 0.000 0.000 0.027 pg9023_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg9124_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9224_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9325_def.cx9a2_bee 0.000 0.000 0.000 100.000 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg9426_def.cx9a2_bee 0.000 0.000 99.667 0.333 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9525_def.cx9a2_bee 0.000 0.000 99.722 0.278 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9624_def.cx9a2_bee 0.000 0.000 99.806 0.194 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1023_def.cx9a2_bee 0.000 0.000 99.750 0.250 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1122_def.cx9a2_bee 0.000 0.000 99.750 0.250 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1217_def.cx9a2_bee 0.000 0.000 99.722 0.278 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1313_def.cx9a2_bee 0.000 0.000 99.806 0.194 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1410_def.cx9a2_bee 0.000 0.000 99.778 0.222 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg155_def.cx9a2_bee 0.000 0.000 99.694 0.306 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 1.056 23.694 1.361 72.417 1.472 0.000 0.000 0.000 0.000 0.000 0.025 pg9023_def.cx9a2_bee 2.333 57.306 1.694 38.667 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9124_def.cx9a2_bee 0.333 39.722 0.139 59.806 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9224_def.cx9a2_bee 0.583 38.083 0.167 61.167 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9325_def.cx9a2_bee 0.250 19.889 0.111 79.750 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9426_def.cx9a2_bee 0.306 21.417 0.278 78.000 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 0.806 47.472 0.361 51.361 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg9624_def.cx9a2_bee 0.000 0.000 0.111 99.889 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg1023_def.cx9a2_bee 0.500 25.694 0.361 73.444 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1122_def.cx9a2_bee 0.222 45.417 54.278 0.083 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1217_def.cx9a2_bee 0.222 47.972 51.750 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1313_def.cx9a2_bee 1.111 45.528 53.278 0.083 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1410_def.cx9a2_bee 1.500 41.389 56.889 0.222 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg155_def.cx9a2_bee 0.639 34.139 62.694 2.528 0.000 0.000 0.000 0.000 0.000 0.000 0.006 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.562 1.436 nonzero 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.021 pg9023_def.cx9a2_bee 98.827 1.173 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9124_def.cx9a2_bee 99.043 0.957 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9224_def.cx9a2_bee 98.843 1.157 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9325_def.cx9a2_bee 98.881 1.119 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9426_def.cx9a2_bee 98.842 1.158 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9525_def.cx9a2_bee 99.281 0.719 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9624_def.cx9a2_bee 99.237 0.763 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1023_def.cx9a2_bee 99.402 0.598 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1122_def.cx9a2_bee 99.857 0.143 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1217_def.cx9a2_bee 99.878 0.122 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1313_def.cx9a2_bee 99.908 0.092 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1410_def.cx9a2_bee 99.933 0.067 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg155_def.cx9a2_bee 99.931 0.069 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 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 91.956 8.044 0.000 0.000 0.000 0.000 0.000 0.052 pg9023_def.cx9a2_bee 0.000 0.000 0.000 99.744 0.256 0.000 0.000 0.000 0.000 0.000 0.035 pg9124_def.cx9a2_bee 0.000 0.000 0.000 99.978 0.022 0.000 0.000 0.000 0.000 0.000 0.029 pg9224_def.cx9a2_bee 0.000 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.000 0.024 pg9325_def.cx9a2_bee 0.000 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.000 0.020 pg9426_def.cx9a2_bee 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9525_def.cx9a2_bee 0.000 0.000 99.950 0.050 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9624_def.cx9a2_bee 0.000 0.000 99.983 0.017 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1023_def.cx9a2_bee 0.000 0.000 99.956 0.044 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1122_def.cx9a2_bee 0.000 0.000 99.956 0.044 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1217_def.cx9a2_bee 0.000 0.000 99.978 0.022 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1313_def.cx9a2_bee 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1410_def.cx9a2_bee 0.000 0.000 99.972 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg155_def.cx9a2_bee 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 2.639 85.728 10.989 0.589 0.056 0.000 0.000 0.000 0.000 0.000 0.018 pg9023_def.cx9a2_bee 2.794 86.472 10.733 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9124_def.cx9a2_bee 3.722 85.389 10.833 0.050 0.006 0.000 0.000 0.000 0.000 0.000 0.017 pg9224_def.cx9a2_bee 5.122 94.844 0.033 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9325_def.cx9a2_bee 7.117 92.850 0.022 0.011 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9426_def.cx9a2_bee 10.400 89.578 0.022 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9525_def.cx9a2_bee 18.983 80.928 0.089 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg9624_def.cx9a2_bee 18.156 80.789 0.122 0.933 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg1023_def.cx9a2_bee 18.761 81.106 0.133 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1122_def.cx9a2_bee 13.367 86.506 0.128 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1217_def.cx9a2_bee 17.172 82.683 0.144 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1313_def.cx9a2_bee 8.906 90.989 0.106 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1410_def.cx9a2_bee 8.556 91.300 0.144 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg155_def.cx9a2_bee 7.222 92.617 0.161 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 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 32.216 67.780 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9023_def.cx9a2_bee 31.700 68.297 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9124_def.cx9a2_bee 87.469 12.529 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9224_def.cx9a2_bee 79.814 20.184 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9325_def.cx9a2_bee 80.305 19.693 0.002 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.074 pg9426_def.cx9a2_bee 87.148 12.849 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9525_def.cx9a2_bee 87.533 12.465 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9624_def.cx9a2_bee 87.779 12.219 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1023_def.cx9a2_bee 87.476 12.523 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1122_def.cx9a2_bee 87.755 12.243 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1217_def.cx9a2_bee 87.570 12.428 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1313_def.cx9a2_bee 87.525 12.474 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1410_def.cx9a2_bee 87.224 12.775 0.002 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg155_def.cx9a2_bee 85.367 14.632 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 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 92.278 7.722 0.000 0.000 0.000 0.000 0.000 0.031 pg9023_def.cx9a2_bee 0.000 0.000 0.000 99.967 0.033 0.000 0.000 0.000 0.000 0.000 0.021 pg9124_def.cx9a2_bee 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.000 0.021 pg9224_def.cx9a2_bee 0.000 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.000 0.019 pg9325_def.cx9a2_bee 0.000 0.000 0.000 99.967 0.033 0.000 0.000 0.000 0.000 0.000 0.023 pg9426_def.cx9a2_bee 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9525_def.cx9a2_bee 0.000 0.000 99.961 0.039 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg9624_def.cx9a2_bee 0.000 0.000 99.933 0.067 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1023_def.cx9a2_bee 0.000 0.000 99.983 0.011 0.006 0.000 0.000 0.000 0.000 0.000 0.023 pg1122_def.cx9a2_bee 0.000 0.000 99.944 0.056 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1217_def.cx9a2_bee 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1313_def.cx9a2_bee 0.000 0.000 99.933 0.056 0.011 0.000 0.000 0.000 0.000 0.000 0.028 pg1410_def.cx9a2_bee 0.000 0.000 99.944 0.050 0.006 0.000 0.000 0.000 0.000 0.000 0.032 pg155_def.cx9a2_bee 0.000 0.000 99.961 0.033 0.006 0.000 0.000 0.000 0.000 0.000 0.026 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 15.772 66.578 3.578 13.744 0.328 0.000 0.000 0.000 0.000 0.000 0.024 pg9023_def.cx9a2_bee 15.983 59.006 4.456 20.556 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg9124_def.cx9a2_bee 13.172 64.928 1.372 20.528 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9224_def.cx9a2_bee 15.200 55.894 13.906 14.994 0.006 0.000 0.000 0.000 0.000 0.000 0.017 pg9325_def.cx9a2_bee 15.556 50.606 13.000 20.839 0.000 0.000 0.000 0.000 0.000 0.000 0.016 pg9426_def.cx9a2_bee 20.283 42.794 13.650 23.272 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 20.606 44.250 13.333 21.811 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9624_def.cx9a2_bee 20.311 42.228 12.717 24.744 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1023_def.cx9a2_bee 20.989 45.839 14.178 18.989 0.006 0.000 0.000 0.000 0.000 0.000 0.021 pg1122_def.cx9a2_bee 16.856 53.333 29.750 0.061 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1217_def.cx9a2_bee 18.778 50.606 28.772 1.844 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1313_def.cx9a2_bee 20.550 50.006 28.083 1.350 0.011 0.000 0.000 0.000 0.000 0.000 0.026 pg1410_def.cx9a2_bee 19.067 52.900 27.400 0.628 0.006 0.000 0.000 0.000 0.000 0.000 0.029 pg155_def.cx9a2_bee 13.322 55.044 27.144 4.483 0.006 0.000 0.000 0.000 0.000 0.000 0.024 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 98.730 1.256 0.007 0.006 nonzero 0.000 0.000 0.000 0.000 0.000 0.020 pg9023_def.cx9a2_bee 99.035 0.961 0.004 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.025 pg9124_def.cx9a2_bee 99.170 0.826 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9224_def.cx9a2_bee 98.614 1.381 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9325_def.cx9a2_bee 98.703 1.293 0.004 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.017 pg9426_def.cx9a2_bee 98.472 1.524 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 98.900 1.096 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9624_def.cx9a2_bee 98.970 1.026 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1023_def.cx9a2_bee 99.097 0.899 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1122_def.cx9a2_bee 99.836 0.160 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1217_def.cx9a2_bee 99.814 0.182 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1313_def.cx9a2_bee 99.872 0.124 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1410_def.cx9a2_bee 99.906 0.091 0.004 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg155_def.cx9a2_bee 99.915 0.082 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.011 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 94.642 5.358 0.000 0.000 0.000 0.000 0.000 0.034 pg9023_def.cx9a2_bee 0.000 0.000 0.000 99.772 0.228 0.000 0.000 0.000 0.000 0.000 0.038 pg9124_def.cx9a2_bee 0.000 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.000 0.018 pg9224_def.cx9a2_bee 0.000 0.000 0.014 99.983 0.003 0.000 0.000 0.000 0.000 0.000 0.019 pg9325_def.cx9a2_bee 0.000 0.000 0.008 99.989 0.003 0.000 0.000 0.000 0.000 0.000 0.016 pg9426_def.cx9a2_bee 0.000 0.000 99.978 0.022 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg9525_def.cx9a2_bee 0.000 0.000 99.972 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9624_def.cx9a2_bee 0.000 0.000 99.967 0.033 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1023_def.cx9a2_bee 0.000 0.000 99.972 0.028 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1122_def.cx9a2_bee 0.000 0.000 99.975 0.025 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1217_def.cx9a2_bee 0.000 0.000 99.986 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1313_def.cx9a2_bee 0.000 0.000 99.989 0.011 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1410_def.cx9a2_bee 0.000 0.000 99.978 0.019 0.003 0.000 0.000 0.000 0.000 0.000 0.022 pg155_def.cx9a2_bee 0.000 0.000 99.981 0.019 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 1.078 63.778 12.069 22.514 0.561 0.000 0.000 0.000 0.000 0.000 0.027 pg9023_def.cx9a2_bee 1.025 64.297 13.469 21.194 0.014 0.000 0.000 0.000 0.000 0.000 0.029 pg9124_def.cx9a2_bee 1.483 66.597 11.889 20.031 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg9224_def.cx9a2_bee 1.800 82.369 6.161 9.669 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg9325_def.cx9a2_bee 2.431 80.397 6.397 10.775 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg9426_def.cx9a2_bee 5.486 77.144 7.094 10.275 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 5.978 75.917 7.178 10.928 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9624_def.cx9a2_bee 5.664 75.258 6.308 12.769 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1023_def.cx9a2_bee 5.975 78.769 6.711 8.544 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg1122_def.cx9a2_bee 4.606 80.978 14.414 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1217_def.cx9a2_bee 4.672 79.417 14.594 1.317 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1313_def.cx9a2_bee 2.983 80.883 14.911 1.222 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1410_def.cx9a2_bee 2.833 83.614 13.531 0.019 0.003 0.000 0.000 0.000 0.000 0.000 0.020 pg155_def.cx9a2_bee 2.658 81.858 13.831 1.653 0.000 0.000 0.000 0.000 0.000 0.000 0.005 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 69.072 30.921 0.007 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9023_def.cx9a2_bee 71.912 28.082 0.006 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg9124_def.cx9a2_bee 87.895 12.102 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg9224_def.cx9a2_bee 76.358 23.640 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg9325_def.cx9a2_bee 76.747 23.250 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.024 pg9426_def.cx9a2_bee 87.484 12.512 0.005 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9525_def.cx9a2_bee 87.931 12.066 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg9624_def.cx9a2_bee 87.868 12.129 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1023_def.cx9a2_bee 87.779 12.219 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1122_def.cx9a2_bee 88.044 11.953 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1217_def.cx9a2_bee 87.590 12.407 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1313_def.cx9a2_bee 87.582 12.416 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1410_def.cx9a2_bee 87.458 12.540 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg155_def.cx9a2_bee 85.714 14.285 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 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 95.022 4.978 0.000 0.000 0.000 0.000 0.000 0.042 pg9023_def.cx9a2_bee 0.000 0.000 0.000 99.875 0.125 0.000 0.000 0.000 0.000 0.000 0.037 pg9124_def.cx9a2_bee 0.000 0.000 0.000 99.975 0.025 0.000 0.000 0.000 0.000 0.000 0.024 pg9224_def.cx9a2_bee 0.000 0.000 0.019 99.964 0.017 0.000 0.000 0.000 0.000 0.000 0.042 pg9325_def.cx9a2_bee 0.000 0.000 0.022 99.958 0.019 0.000 0.000 0.000 0.000 0.000 0.042 pg9426_def.cx9a2_bee 0.000 0.000 99.964 0.036 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg9525_def.cx9a2_bee 0.000 0.000 99.994 0.006 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg9624_def.cx9a2_bee 0.000 0.000 99.975 0.025 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1023_def.cx9a2_bee 0.000 0.000 99.983 0.017 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1122_def.cx9a2_bee 0.000 0.000 99.983 0.017 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1217_def.cx9a2_bee 0.000 0.000 99.981 0.019 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1313_def.cx9a2_bee 0.000 0.000 99.981 0.019 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1410_def.cx9a2_bee 0.000 0.000 99.986 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg155_def.cx9a2_bee 0.000 0.000 99.986 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg161_def.cx9a2_bee
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 6.633 75.144 7.178 10.778 0.267 0.000 0.000 0.000 0.000 0.000 0.027 pg9023_def.cx9a2_bee 7.042 73.225 9.147 10.575 0.011 0.000 0.000 0.000 0.000 0.000 0.026 pg9124_def.cx9a2_bee 6.333 78.272 7.150 8.244 0.000 0.000 0.000 0.000 0.000 0.000 0.016 pg9224_def.cx9a2_bee 8.250 74.608 7.047 10.092 0.003 0.000 0.000 0.000 0.000 0.000 0.031 pg9325_def.cx9a2_bee 9.694 72.356 6.656 11.292 0.003 0.000 0.000 0.000 0.000 0.000 0.031 pg9426_def.cx9a2_bee 14.458 68.764 7.519 9.258 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg9525_def.cx9a2_bee 13.878 67.511 7.369 11.242 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg9624_def.cx9a2_bee 14.111 69.419 6.586 9.883 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1023_def.cx9a2_bee 13.269 67.644 6.864 12.222 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1122_def.cx9a2_bee 11.458 74.361 14.158 0.022 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1217_def.cx9a2_bee 11.831 74.086 13.928 0.156 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1313_def.cx9a2_bee 11.361 75.286 13.283 0.069 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1410_def.cx9a2_bee 10.972 74.531 13.814 0.683 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg155_def.cx9a2_bee 9.161 74.508 14.572 1.758 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg161_def.cx9a2_bee