Introduction
This is a report for the insert benchmark with 160M docs and 8 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 is a c2-standard-30 with 15 cores, hyperthreads disabled, 120G RAM and XFS with SW RAID 0 across 4 NVMe SSD. The benchmark was run with 8 clients 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 8 tables, 1 per client. It loads 20M rows per table without secondary indexes, creates secondary indexes, then inserts 100M rows per table with a delete per insert to avoid growing the table. It then does 3 read+write tests for 1800s each that do queries as fast as possible with 100, 500 and then 1000 inserts/second/client concurrent with the queries and 1000 deletes/second to avoid growing the table. The database is cached by Postgres. Clients and the DBMS share one server. The per-database configs are in the per-database subdirectories here.
The tested DBMS are:
- pg153_o3_native_lto.cx7a_gcp_c2s30 - Postgres 15.3, the cx7a_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto
- pg153_o3_native_lto.cx7a1_gcp_c2s30 - Postgres 15.3, the cx7a1_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds wal_compression=lz4
- pg153_o3_native_lto.cx7a2_gcp_c2s30 - Postgres 15.3, the cx7a2_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds backend_flush_after=256kb
- pg153_o3_native_lto.cx7a3_gcp_c2s30 - Postgres 15.3, the cx7a3_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds full_page_writes=off
- pg153_o3_native_lto.cx7a4_gcp_c2s30 - Postgres 15.3, the cx7a4_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds checkpoint_timeout=1800s
- pg153_o3_native_lto.cx7a5_gcp_c2s30 - Postgres 15.3, the cx7a5_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds min_wal_size=16384
- pg153_o3_native_lto.cx7a6_gcp_c2s30 - Postgres 15.3, the cx7a6_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds backend_flush_after=256kb, used initdb —wal-segsize 256, inherits larger value for wal_buffers
- pg153_o3_native_lto.cx7a7_gcp_c2s30 - Postgres 15.3, the cx7a7_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds max_wal_size=16GB
- pg153_o3_native_lto.cx7a8_gcp_c2s30 - Postgres 15.3, the cx7a8_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, uses shared_buffers=8GB
- pg153_o3_native_lto.cx7a9_gcp_c2s30 - Postgres 15.3, the cx7a8_gcp_c2s30 config and the build used: -O3 -march=native -mtune=native -flto, adds checkpoint_timeout=900s
Contents
- Summary
- l.i0: load without secondary indexes
- l.x: create secondary indexes
- l.i1: continue load after secondary indexes created
- q100.1: range queries with 100 insert/s per client
- q500.1: range queries with 500 insert/s per client
- q1000.1: range queries with 1000 insert/s per client
Summary
The numbers are inserts/s for l.i0 and l.i1, indexed docs (or rows) /s for l.x and queries/s for q*.2. 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 | q100.1 | q500.1 | q1000.1 |
|---|---|---|---|---|---|---|
| 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 | 1032258 | 2106579 | 154202 | 119591 | 114612 | 111298 |
| 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 | 1032258 | 2254930 | 157264 | 120662 | 115075 | 111142 |
| 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 | 1025641 | 2134667 | 154769 | 119949 | 115140 | 110954 |
| 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 | 1032258 | 2106579 | 161681 | 122089 | 117536 | 114570 |
| 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 | 1038961 | 2052564 | 153905 | 119895 | 116741 | 113259 |
| 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 | 1038961 | 2052564 | 151429 | 119883 | 115072 | 111120 |
| 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 | 1045752 | 2026582 | 158667 | 119857 | 114774 | 111461 |
| 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 | 1045752 | 2354412 | 117405 | 119692 | 113870 | 106740 |
| 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 | 1012658 | 2052564 | 89787 | 113447 | 104968 | 97625 |
| 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30 | 1019108 | 2026582 | 157666 | 120672 | 116680 | 113846 |
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.
| dbms | l.i0 | l.x | l.i1 | q100.1 | q500.1 | q1000.1 |
|---|---|---|---|---|---|---|
| 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 | 1.00 | 1.07 | 1.02 | 1.01 | 1.00 | 1.00 |
| 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 | 0.99 | 1.01 | 1.00 | 1.00 | 1.00 | 1.00 |
| 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 | 1.00 | 1.00 | 1.05 | 1.02 | 1.03 | 1.03 |
| 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 | 1.01 | 0.97 | 1.00 | 1.00 | 1.02 | 1.02 |
| 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 | 1.01 | 0.97 | 0.98 | 1.00 | 1.00 | 1.00 |
| 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 | 1.01 | 0.96 | 1.03 | 1.00 | 1.00 | 1.00 |
| 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 | 1.01 | 1.12 | 0.76 | 1.00 | 0.99 | 0.96 |
| 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 | 0.98 | 0.97 | 0.58 | 0.95 | 0.92 | 0.88 |
| 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30 | 0.99 | 0.96 | 1.02 | 1.01 | 1.02 | 1.02 |
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 | q100.1 | q500.1 | q1000.1 |
|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 797 | 3987 | 7978 |
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 797 | 3987 | 7978 |
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 797 | 3987 | 7978 |
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 797 | 3987 | 7976 |
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 798 | 3987 | 7976 |
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 797 | 3988 | 7976 |
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 797 | 3987 | 7978 |
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 797 | 3987 | 7978 |
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 798 | 3988 | 7976 |
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 797 | 3987 | 7976 |
| target | 800 | 4000 | 8000 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 97.701 | 2.236 | 0.040 | 0.008 | 0.013 | 0.002 | 0.704 | ||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 98.225 | 1.716 | 0.038 | 0.005 | 0.012 | 0.004 | 0.397 | ||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 97.866 | 2.072 | 0.038 | 0.006 | 0.015 | 0.003 | 0.523 | ||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 97.950 | 1.984 | 0.045 | 0.006 | 0.013 | 0.003 | 0.407 | ||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 98.089 | 1.849 | 0.041 | 0.005 | 0.011 | 0.004 | 0.697 | ||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 98.199 | 1.734 | 0.043 | 0.006 | 0.016 | 0.003 | 0.408 | ||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 98.170 | 1.768 | 0.046 | 0.003 | 0.010 | 0.004 | 0.448 | ||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 97.968 | 1.955 | 0.052 | 0.010 | 0.012 | 0.002 | 0.442 | ||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 97.754 | 2.122 | 0.077 | 0.031 | 0.011 | 0.004 | 0.401 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 97.658 | 2.283 | 0.037 | 0.007 | 0.011 | 0.004 | 0.413 |
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 | 0.000 | sum:DBMS | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | |||||||||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 |
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 1032258 0 0 0.0 1014.2 332.5 0.000 0.000 0.001 0.330 86436 74.1 0.084 11 15.3 41.4 0.0 0.704 149937 22176 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 1032258 0 0 0.0 1015.5 333.5 0.000 0.000 0.001 0.331 86789 74.2 0.084 11 15.3 41.4 NA 0.397 151735 27071 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 1025641 0 0 0.0 1016.3 334.3 0.000 0.000 0.001 0.334 86805 74.5 0.085 11 15.3 41.4 0.0 0.523 149539 25073 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 1032258 0 0 0.0 1018.1 335.3 0.000 0.000 0.001 0.333 86496 74.2 0.084 11 15.3 41.4 NA 0.407 150937 27170 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 1038961 0 0 0.0 1040.8 342.7 0.000 0.000 0.001 0.338 87672 75.4 0.084 11 15.3 41.4 0.0 0.697 150738 29078 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 1038961 0 0 0.0 1041.9 343.2 0.000 0.000 0.001 0.338 87359 75.6 0.084 11 15.3 41.4 0.0 0.408 151635 23874 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 1045752 0 0 0.0 1043.7 342.6 0.000 0.000 0.001 0.335 88081 75.8 0.084 11 15.3 41.4 0.0 0.448 151936 13185 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 1045752 0 0 0.0 1286.6 338.0 0.000 0.000 0.001 0.331 89006 76.1 0.085 11 15.3 31.4 0.0 0.442 151236 31466 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 1012658 0 35 0.2 3779.2 374.5 0.000 0.000 0.004 0.379 84719 74.4 0.084 11 15.3 41.4 0.0 0.401 149088 27270 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 1019108 0 0 0.0 1025.2 338.9 0.000 0.000 0.001 0.341 85668 74.8 0.084 11 15.3 41.4 0.0 0.413 148340 14484 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
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 2106579 0 0 0.0 1517.4 646.9 0.000 0.000 0.001 0.314 23135 35.6 0.011 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 2254930 0 0 0.0 1273.1 550.8 0.000 0.000 0.001 0.250 10043 38.6 0.004 3 29.4 63.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 2134667 0 0 0.0 1515.9 631.4 0.000 0.000 0.001 0.303 18955 35.6 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 2106579 0 0 0.0 1555.7 635.2 0.000 0.000 0.001 0.309 23897 35.3 0.011 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 2052564 0 0 0.0 1432.8 611.6 0.000 0.000 0.001 0.305 18705 35.6 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 2052564 0 0 0.0 1435.2 613.4 0.000 0.000 0.001 0.306 18059 35.4 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 2026582 0 0 0.0 1427.9 610.2 0.000 0.000 0.001 0.308 17688 35.6 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 2354412 0 0 0.0 1409.2 543.5 0.000 0.000 0.001 0.236 30190 40.1 0.013 3 29.4 45.5 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 2052564 0 5072 29.6 3395.1 631.2 0.002 0.015 0.002 0.315 15277 37.4 0.007 3 29.4 68.1 0.0 0.002 NA NA 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 2026582 0 0 0.0 1379.0 595.4 0.000 0.000 0.001 0.301 26588 35.6 0.013 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
l.i1
l.i1: continue load after secondary indexes created. 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 56.278 | 43.383 | 0.261 | 0.075 | 0.002 | nonzero | 0.503 | ||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 55.942 | 43.982 | 0.062 | 0.013 | 0.001 | nonzero | 0.432 | ||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 51.916 | 47.768 | 0.244 | 0.071 | 0.001 | nonzero | 0.266 | ||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 60.183 | 39.799 | 0.017 | 0.001 | 0.001 | nonzero | 0.406 | ||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 54.924 | 44.736 | 0.261 | 0.078 | 0.002 | nonzero | 0.389 | ||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 54.254 | 45.413 | 0.255 | 0.076 | 0.002 | 0.244 | |||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 56.339 | 43.359 | 0.240 | 0.060 | 0.002 | nonzero | 0.474 | ||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 34.492 | 62.391 | 1.876 | 1.220 | 0.020 | nonzero | 0.657 | ||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 1.225 | 82.009 | 15.159 | 1.564 | 0.043 | nonzero | 0.318 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 55.884 | 43.809 | 0.243 | 0.063 | 0.001 | nonzero | 0.325 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 83.817 | 2.756 | 2.318 | 7.199 | 3.907 | 0.004 | nonzero | 0.306 | |||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 83.507 | 3.087 | 2.562 | 7.134 | 3.708 | 0.001 | nonzero | 0.439 | |||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 83.645 | 2.854 | 1.992 | 7.531 | 3.975 | 0.002 | nonzero | 0.270 | |||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 84.116 | 2.556 | 2.942 | 6.678 | 3.707 | 0.001 | nonzero | 0.416 | |||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 83.802 | 2.549 | 2.426 | 7.118 | 4.102 | 0.002 | nonzero | 0.365 | |||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 83.643 | 2.744 | 2.494 | 7.093 | 4.024 | 0.002 | 0.250 | ||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 83.869 | 2.637 | 2.649 | 6.947 | 3.896 | 0.002 | nonzero | 0.488 | |||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 81.070 | 3.378 | 1.938 | 7.889 | 5.676 | 0.048 | nonzero | 0.779 | |||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 84.759 | 5.471 | 0.575 | 4.524 | 4.663 | 0.008 | nonzero | 0.358 | |||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 83.716 | 2.705 | 2.518 | 7.169 | 3.890 | 0.002 | nonzero | 0.340 |
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 154202 0 18 0.1 1717.5 201.1 0.000 0.001 0.011 1.335 69002 64.2 0.447 62 48.9 118.9 0.0 0.503 4795 1948 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 157264 0 2 0.0 1412.4 155.5 0.000 0.000 0.009 1.012 70563 65.3 0.449 62 48.6 118.6 0.0 0.432 4545 2148 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 154769 0 19 0.1 1619.8 199.5 0.000 0.001 0.010 1.320 69104 65.4 0.446 63 49.0 119.1 0.0 0.266 4598 2048 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 161681 0 3 0.0 1264.0 128.5 0.000 0.000 0.008 0.814 71451 64.9 0.442 60 48.9 104.4 0.0 0.406 4545 2198 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 153905 0 19 0.1 1632.1 195.8 0.000 0.001 0.011 1.303 69289 65.0 0.450 63 48.8 118.9 0.0 0.389 4747 2148 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 151429 0 16 0.1 1723.7 196.4 0.000 0.001 0.011 1.328 67685 63.7 0.447 63 48.9 119.0 0.0 0.244 4645 2198 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 158667 0 18 0.1 1693.2 201.8 0.000 0.001 0.011 1.302 70909 65.7 0.447 62 48.8 118.8 0.0 0.474 4895 2098 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 117405 0 4 0.0 16242.0 850.8 0.000 0.000 0.138 7.421 51689 57.2 0.440 73 48.8 64.8 0.0 0.657 4495 1249 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 89787 0 7266 83.6 89043.1 1260.1 0.081 0.954 0.992 14.371 59928 53.1 0.667 89 50.6 115.6 0.0 0.318 11138 1798 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 157666 0 18 0.1 1644.1 200.9 0.000 0.001 0.010 1.305 70446 65.8 0.447 63 48.9 119.0 0.0 0.325 4895 2148 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
q100.1
q100.1: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 99.996 | 0.004 | 0.001 | nonzero | 0.009 | ||||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 99.996 | 0.003 | 0.001 | nonzero | 0.010 | ||||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 99.995 | 0.004 | 0.001 | nonzero | nonzero | 0.338 | |||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 99.996 | 0.003 | 0.001 | nonzero | 0.007 | ||||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 99.997 | 0.003 | 0.001 | nonzero | 0.006 | ||||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 99.995 | 0.004 | 0.001 | nonzero | 0.008 | ||||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 99.995 | 0.004 | 0.001 | nonzero | nonzero | 0.338 | |||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 99.995 | 0.004 | 0.001 | nonzero | 0.006 | ||||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 99.961 | 0.038 | 0.001 | nonzero | nonzero | nonzero | 0.229 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 99.995 | 0.004 | 0.001 | nonzero | 0.009 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 99.997 | 0.003 | 0.012 | ||||||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 0.019 | 99.762 | 0.219 | 0.011 | |||||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 0.679 | 99.316 | 0.005 | 0.013 | |||||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 48.030 | 51.970 | 0.004 | ||||||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 15.927 | 84.071 | 0.002 | 0.011 | |||||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 1.000 | 98.986 | 0.014 | 0.014 | |||||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 1.201 | 98.793 | 0.005 | 0.010 | |||||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 99.998 | 0.002 | 0.012 | ||||||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 81.936 | 17.797 | 0.260 | 0.007 | 0.185 | ||||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 6.825 | 93.172 | 0.003 | 0.011 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 56.127 | 29.429 | 14.438 | 0.007 | 0.010 | ||||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 63.517 | 21.747 | 14.729 | 0.007 | 0.004 | ||||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 57.613 | 31.411 | 10.969 | 0.007 | 0.010 | ||||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 43.833 | 33.325 | 22.842 | 0.004 | |||||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 59.019 | 31.601 | 9.378 | 0.002 | 0.010 | ||||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 58.455 | 26.814 | 14.724 | 0.007 | 0.009 | ||||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 53.344 | 32.891 | 13.760 | 0.005 | 0.011 | ||||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 47.993 | 28.342 | 23.660 | 0.005 | 0.005 | ||||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 65.483 | 24.306 | 10.198 | 0.014 | 0.005 | ||||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 58.259 | 24.694 | 17.043 | 0.003 | 0.012 |
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 797 119591 0 0.0 1902.8 29.9 0.000 0.000 2.387 38.373 455997 53.1 3.813 67 48.9 82.9 0.0 0.009 15040 14677 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 797 120662 0 0.0 1903.4 28.3 0.000 0.000 2.387 36.287 459865 53.2 3.811 66 48.6 95.8 0.0 0.010 14960 14645 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 797 119949 0 0.0 1898.4 30.6 0.000 0.000 2.381 39.313 457300 53.1 3.812 66 48.9 85.9 0.0 0.338 14912 14624 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 797 122089 0 0.0 1904.0 23.6 0.000 0.000 2.388 30.354 464667 53.0 3.806 65 48.9 97.8 0.0 0.007 15487 15247 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 798 119895 0 0.0 270.2 11.6 0.000 0.000 0.339 14.925 456129 52.9 3.804 66 48.8 118.9 0.0 0.006 15039 14816 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 797 119883 0 0.0 1875.3 28.4 0.000 0.000 2.352 36.525 457032 53.2 3.812 67 48.9 83.2 0.0 0.008 15040 14720 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 797 119857 0 0.0 1922.2 30.1 0.000 0.000 2.411 38.656 456908 53.2 3.812 67 48.8 85.8 0.0 0.338 15013 14725 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 797 119692 0 0.0 1909.2 28.0 0.000 0.000 2.395 35.953 456405 53.2 3.813 67 48.7 61.5 0.0 0.006 15024 14725 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 798 113447 409 3.1 3510.0 100.2 0.004 0.028 4.401 128.595 433182 53.1 3.818 70 50.6 75.0 0.0 0.229 14102 13287 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 797 120672 0 0.0 833.2 19.4 0.000 0.000 1.045 24.901 459541 53.1 3.808 66 48.9 110.9 0.0 0.009 14965 14752 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
q500.1
q500.1: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 99.979 | 0.013 | 0.008 | 0.001 | nonzero | nonzero | 0.338 | ||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 99.979 | 0.014 | 0.007 | nonzero | nonzero | 0.018 | |||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 99.976 | 0.014 | 0.009 | 0.001 | nonzero | 0.020 | |||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 99.987 | 0.007 | 0.005 | nonzero | nonzero | 0.027 | |||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 99.984 | 0.009 | 0.007 | nonzero | nonzero | 0.028 | |||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 99.977 | 0.014 | 0.008 | 0.001 | nonzero | nonzero | nonzero | 0.338 | |||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 99.977 | 0.014 | 0.008 | 0.001 | nonzero | 0.023 | |||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 99.974 | 0.016 | 0.008 | 0.001 | nonzero | nonzero | nonzero | 0.338 | |||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 99.921 | 0.075 | 0.004 | nonzero | nonzero | nonzero | 0.072 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 99.983 | 0.010 | 0.007 | nonzero | nonzero | nonzero | 0.086 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 7.687 | 91.830 | 0.478 | 0.006 | 0.026 | ||||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 99.518 | 0.475 | 0.007 | 0.020 | |||||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 5.206 | 94.135 | 0.649 | 0.010 | 0.030 | ||||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 76.632 | 23.180 | 0.186 | 0.001 | 0.020 | ||||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 52.310 | 47.044 | 0.610 | 0.037 | 0.043 | ||||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 7.330 | 91.783 | 0.814 | 0.073 | 0.049 | ||||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 6.080 | 92.878 | 1.010 | 0.032 | 0.033 | ||||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 1.439 | 97.836 | 0.496 | 0.202 | 0.027 | 0.148 | |||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 89.326 | 9.901 | 0.752 | 0.021 | 0.218 | ||||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 43.049 | 56.608 | 0.290 | 0.050 | 0.003 | 0.078 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 78.160 | 1.089 | 3.862 | 16.787 | 0.102 | 0.038 | |||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 78.558 | 1.803 | 4.130 | 15.497 | 0.013 | 0.030 | |||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 77.719 | 1.197 | 3.081 | 17.940 | 0.062 | 0.046 | |||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 81.320 | 0.908 | 0.700 | 17.006 | 0.066 | 0.040 | |||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 77.676 | 1.332 | 3.577 | 17.226 | 0.190 | 0.043 | |||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 76.440 | 1.238 | 3.719 | 18.465 | 0.138 | 0.045 | |||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 77.862 | 1.188 | 2.480 | 18.338 | 0.133 | 0.038 | |||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 78.308 | 1.313 | 2.159 | 17.905 | 0.297 | 0.018 | 0.148 | ||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 76.415 | 2.983 | 4.503 | 16.067 | 0.031 | 0.001 | 0.080 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 79.200 | 1.299 | 2.768 | 16.648 | 0.081 | 0.003 | 0.081 |
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 3987 114612 0 0.0 3050.5 70.8 0.000 0.000 0.765 18.190 436492 54.5 3.808 71 48.9 72.1 0.0 0.338 14352 13798 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 3987 115075 0 0.0 3012.4 62.5 0.000 0.000 0.756 16.057 438743 54.6 3.813 71 48.6 65.4 0.0 0.018 14432 13958 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 3987 115140 0 0.0 3103.6 71.6 0.000 0.000 0.778 18.394 438748 54.4 3.811 71 48.9 72.4 0.0 0.020 14352 13761 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 3987 117536 0 0.0 2988.9 51.3 0.000 0.000 0.750 13.186 445976 54.1 3.794 69 48.9 92.2 0.0 0.027 14784 14279 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 3987 116741 0 0.0 386.5 18.6 0.000 0.000 0.097 4.785 442080 54.1 3.787 70 48.8 113.9 0.0 0.028 14710 14213 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 3988 115072 0 0.0 3062.9 71.5 0.000 0.000 0.768 18.352 438021 54.5 3.806 71 48.9 72.1 0.0 0.338 14432 13857 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 3987 114774 0 0.0 3092.2 71.7 0.000 0.000 0.776 18.409 436578 54.5 3.804 71 48.8 72.2 0.0 0.023 14384 13841 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 3987 113870 0 0.0 4675.3 91.7 0.000 0.000 1.173 23.556 434106 54.4 3.812 72 48.7 64.8 0.0 0.338 14225 13266 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 3988 104968 1681 10.1 15408.2 451.4 0.016 0.098 3.864 115.913 403370 55.4 3.843 79 50.6 73.1 0.0 0.072 13122 12370 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 3987 116680 0 0.0 802.8 32.5 0.000 0.000 0.201 8.341 443336 54.2 3.800 70 48.9 99.0 0.0 0.086 14645 14129 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
q1000.1
q1000.1: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 99.945 | 0.037 | 0.015 | 0.003 | nonzero | 0.035 | |||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 99.946 | 0.042 | 0.011 | 0.001 | nonzero | 0.022 | |||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 99.942 | 0.039 | 0.016 | 0.003 | nonzero | nonzero | 0.081 | ||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 99.965 | 0.024 | 0.011 | 0.001 | nonzero | 0.032 | |||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 99.960 | 0.028 | 0.012 | 0.001 | nonzero | 0.049 | |||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 99.944 | 0.037 | 0.015 | 0.003 | nonzero | 0.043 | |||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 99.942 | 0.038 | 0.017 | 0.003 | nonzero | 0.035 | |||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 99.900 | 0.055 | 0.028 | 0.015 | 0.001 | nonzero | nonzero | 0.292 | |||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 99.689 | 0.283 | 0.021 | 0.006 | 0.002 | nonzero | 0.161 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 99.954 | 0.031 | 0.013 | 0.001 | nonzero | 0.048 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 23.085 | 74.293 | 2.470 | 0.152 | 0.042 | ||||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 2.840 | 96.246 | 0.890 | 0.023 | 0.030 | ||||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 19.257 | 78.408 | 2.230 | 0.105 | 0.036 | ||||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 63.232 | 36.339 | 0.417 | 0.012 | 0.035 | ||||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 52.273 | 46.767 | 0.860 | 0.100 | 0.044 | ||||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 25.226 | 72.617 | 2.066 | 0.091 | 0.051 | ||||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 20.192 | 76.839 | 2.808 | 0.161 | 0.041 | ||||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 0.149 | 86.888 | 11.510 | 1.420 | 0.033 | nonzero | 0.299 | ||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 84.848 | 13.126 | 1.924 | 0.101 | nonzero | 0.323 | |||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 48.642 | 49.808 | 1.408 | 0.141 | 0.045 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg153_o3_native_lto.cx7a_gcp_c2s30 | 78.416 | 2.335 | 2.535 | 13.449 | 3.265 | 0.052 | |||||
| pg153_o3_native_lto.cx7a1_gcp_c2s30 | 76.934 | 4.012 | 3.232 | 12.698 | 3.124 | 0.028 | |||||
| pg153_o3_native_lto.cx7a2_gcp_c2s30 | 78.403 | 2.823 | 2.743 | 13.607 | 2.423 | 0.049 | |||||
| pg153_o3_native_lto.cx7a3_gcp_c2s30 | 79.119 | 3.131 | 1.350 | 12.595 | 3.806 | 0.051 | |||||
| pg153_o3_native_lto.cx7a4_gcp_c2s30 | 77.731 | 3.355 | 2.479 | 13.190 | 3.245 | 0.056 | |||||
| pg153_o3_native_lto.cx7a5_gcp_c2s30 | 78.367 | 2.811 | 2.528 | 13.497 | 2.798 | 0.048 | |||||
| pg153_o3_native_lto.cx7a6_gcp_c2s30 | 78.101 | 3.176 | 2.474 | 12.867 | 3.382 | 0.050 | |||||
| pg153_o3_native_lto.cx7a7_gcp_c2s30 | 72.321 | 5.914 | 2.830 | 14.583 | 4.341 | 0.012 | 0.194 | ||||
| pg153_o3_native_lto.cx7a8_gcp_c2s30 | 76.984 | 4.108 | 3.351 | 12.181 | 3.364 | 0.012 | 0.157 | ||||
| pg153_o3_native_lto.cx7a9_gcp_c2s30 | 77.844 | 3.701 | 2.440 | 12.877 | 3.138 | 0.049 |
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 7978 111298 0 0.0 2672.4 93.4 0.000 0.000 0.335 11.982 418763 56.1 3.763 76 48.9 77.5 0.0 0.035 13905 12599 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 7978 111142 0 0.0 2628.2 80.5 0.000 0.000 0.329 10.335 419789 56.4 3.777 76 48.6 67.2 0.0 0.022 13953 12962 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 7978 110954 0 0.0 2600.1 93.8 0.000 0.000 0.326 12.036 419603 56.0 3.782 76 48.8 77.3 0.0 0.081 13878 12882 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 7976 114570 0 0.0 2472.7 65.5 0.000 0.000 0.310 8.405 428815 55.9 3.743 73 49.1 80.5 0.0 0.032 14400 13058 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 7976 113259 0 0.0 273.8 21.0 0.000 0.000 0.034 2.693 424762 55.8 3.750 74 48.8 109.3 0.0 0.049 14293 13222 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 7976 111120 0 0.0 2679.3 93.7 0.000 0.000 0.336 12.024 419102 56.1 3.772 76 48.9 77.5 0.0 0.043 14113 12754 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 7978 111461 0 0.0 2601.5 94.0 0.000 0.000 0.326 12.071 419712 56.1 3.766 75 48.8 77.3 0.0 0.035 14161 13011 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 7978 106740 0 0.0 9844.1 197.8 0.000 0.000 1.234 25.383 403822 55.7 3.783 78 48.7 64.8 0.0 0.292 13409 10724 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 7976 97625 2494 15.6 28621.5 785.9 0.026 0.163 3.589 100.900 373489 57.3 3.826 88 50.4 79.7 0.0 0.161 12514 7256 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 7976 113846 0 0.0 627.1 37.4 0.000 0.000 0.079 4.799 428380 55.8 3.763 74 48.8 94.1 0.0 0.048 14353 13238 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
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 1032258 0 0 0.0 1014.2 332.5 0.000 0.000 0.001 0.330 86436 74.1 0.084 11 15.3 41.4 0.0 0.704 149937 22176 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 1032258 0 0 0.0 1015.5 333.5 0.000 0.000 0.001 0.331 86789 74.2 0.084 11 15.3 41.4 NA 0.397 151735 27071 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 1025641 0 0 0.0 1016.3 334.3 0.000 0.000 0.001 0.334 86805 74.5 0.085 11 15.3 41.4 0.0 0.523 149539 25073 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 1032258 0 0 0.0 1018.1 335.3 0.000 0.000 0.001 0.333 86496 74.2 0.084 11 15.3 41.4 NA 0.407 150937 27170 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 1038961 0 0 0.0 1040.8 342.7 0.000 0.000 0.001 0.338 87672 75.4 0.084 11 15.3 41.4 0.0 0.697 150738 29078 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 1038961 0 0 0.0 1041.9 343.2 0.000 0.000 0.001 0.338 87359 75.6 0.084 11 15.3 41.4 0.0 0.408 151635 23874 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 1045752 0 0 0.0 1043.7 342.6 0.000 0.000 0.001 0.335 88081 75.8 0.084 11 15.3 41.4 0.0 0.448 151936 13185 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 1045752 0 0 0.0 1286.6 338.0 0.000 0.000 0.001 0.331 89006 76.1 0.085 11 15.3 31.4 0.0 0.442 151236 31466 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 1012658 0 35 0.2 3779.2 374.5 0.000 0.000 0.004 0.379 84719 74.4 0.084 11 15.3 41.4 0.0 0.401 149088 27270 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 1019108 0 0 0.0 1025.2 338.9 0.000 0.000 0.001 0.341 85668 74.8 0.084 11 15.3 41.4 0.0 0.413 148340 14484 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
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 2106579 0 0 0.0 1517.4 646.9 0.000 0.000 0.001 0.314 23135 35.6 0.011 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 2254930 0 0 0.0 1273.1 550.8 0.000 0.000 0.001 0.250 10043 38.6 0.004 3 29.4 63.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 2134667 0 0 0.0 1515.9 631.4 0.000 0.000 0.001 0.303 18955 35.6 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 2106579 0 0 0.0 1555.7 635.2 0.000 0.000 0.001 0.309 23897 35.3 0.011 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 2052564 0 0 0.0 1432.8 611.6 0.000 0.000 0.001 0.305 18705 35.6 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 2052564 0 0 0.0 1435.2 613.4 0.000 0.000 0.001 0.306 18059 35.4 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 2026582 0 0 0.0 1427.9 610.2 0.000 0.000 0.001 0.308 17688 35.6 0.009 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 2354412 0 0 0.0 1409.2 543.5 0.000 0.000 0.001 0.236 30190 40.1 0.013 3 29.4 45.5 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 2052564 0 5072 29.6 3395.1 631.2 0.002 0.015 0.002 0.315 15277 37.4 0.007 3 29.4 68.1 0.0 0.002 NA NA 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 2026582 0 0 0.0 1379.0 595.4 0.000 0.000 0.001 0.301 26588 35.6 0.013 3 29.4 68.3 0.0 0.001 NA NA 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
l.i1
l.i1: continue load after secondary indexes created
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 154202 0 18 0.1 1717.5 201.1 0.000 0.001 0.011 1.335 69002 64.2 0.447 62 48.9 118.9 0.0 0.503 4795 1948 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 157264 0 2 0.0 1412.4 155.5 0.000 0.000 0.009 1.012 70563 65.3 0.449 62 48.6 118.6 0.0 0.432 4545 2148 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 154769 0 19 0.1 1619.8 199.5 0.000 0.001 0.010 1.320 69104 65.4 0.446 63 49.0 119.1 0.0 0.266 4598 2048 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 161681 0 3 0.0 1264.0 128.5 0.000 0.000 0.008 0.814 71451 64.9 0.442 60 48.9 104.4 0.0 0.406 4545 2198 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 153905 0 19 0.1 1632.1 195.8 0.000 0.001 0.011 1.303 69289 65.0 0.450 63 48.8 118.9 0.0 0.389 4747 2148 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 151429 0 16 0.1 1723.7 196.4 0.000 0.001 0.011 1.328 67685 63.7 0.447 63 48.9 119.0 0.0 0.244 4645 2198 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 158667 0 18 0.1 1693.2 201.8 0.000 0.001 0.011 1.302 70909 65.7 0.447 62 48.8 118.8 0.0 0.474 4895 2098 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 117405 0 4 0.0 16242.0 850.8 0.000 0.000 0.138 7.421 51689 57.2 0.440 73 48.8 64.8 0.0 0.657 4495 1249 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 89787 0 7266 83.6 89043.1 1260.1 0.081 0.954 0.992 14.371 59928 53.1 0.667 89 50.6 115.6 0.0 0.318 11138 1798 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 157666 0 18 0.1 1644.1 200.9 0.000 0.001 0.010 1.305 70446 65.8 0.447 63 48.9 119.0 0.0 0.325 4895 2148 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
q100.1
q100.1: 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 797 119591 0 0.0 1902.8 29.9 0.000 0.000 2.387 38.373 455997 53.1 3.813 67 48.9 82.9 0.0 0.009 15040 14677 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 797 120662 0 0.0 1903.4 28.3 0.000 0.000 2.387 36.287 459865 53.2 3.811 66 48.6 95.8 0.0 0.010 14960 14645 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 797 119949 0 0.0 1898.4 30.6 0.000 0.000 2.381 39.313 457300 53.1 3.812 66 48.9 85.9 0.0 0.338 14912 14624 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 797 122089 0 0.0 1904.0 23.6 0.000 0.000 2.388 30.354 464667 53.0 3.806 65 48.9 97.8 0.0 0.007 15487 15247 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 798 119895 0 0.0 270.2 11.6 0.000 0.000 0.339 14.925 456129 52.9 3.804 66 48.8 118.9 0.0 0.006 15039 14816 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 797 119883 0 0.0 1875.3 28.4 0.000 0.000 2.352 36.525 457032 53.2 3.812 67 48.9 83.2 0.0 0.008 15040 14720 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 797 119857 0 0.0 1922.2 30.1 0.000 0.000 2.411 38.656 456908 53.2 3.812 67 48.8 85.8 0.0 0.338 15013 14725 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 797 119692 0 0.0 1909.2 28.0 0.000 0.000 2.395 35.953 456405 53.2 3.813 67 48.7 61.5 0.0 0.006 15024 14725 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 798 113447 409 3.1 3510.0 100.2 0.004 0.028 4.401 128.595 433182 53.1 3.818 70 50.6 75.0 0.0 0.229 14102 13287 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 797 120672 0 0.0 833.2 19.4 0.000 0.000 1.045 24.901 459541 53.1 3.808 66 48.9 110.9 0.0 0.009 14965 14752 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
q500.1
q500.1: 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 3987 114612 0 0.0 3050.5 70.8 0.000 0.000 0.765 18.190 436492 54.5 3.808 71 48.9 72.1 0.0 0.338 14352 13798 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 3987 115075 0 0.0 3012.4 62.5 0.000 0.000 0.756 16.057 438743 54.6 3.813 71 48.6 65.4 0.0 0.018 14432 13958 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 3987 115140 0 0.0 3103.6 71.6 0.000 0.000 0.778 18.394 438748 54.4 3.811 71 48.9 72.4 0.0 0.020 14352 13761 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 3987 117536 0 0.0 2988.9 51.3 0.000 0.000 0.750 13.186 445976 54.1 3.794 69 48.9 92.2 0.0 0.027 14784 14279 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 3987 116741 0 0.0 386.5 18.6 0.000 0.000 0.097 4.785 442080 54.1 3.787 70 48.8 113.9 0.0 0.028 14710 14213 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 3988 115072 0 0.0 3062.9 71.5 0.000 0.000 0.768 18.352 438021 54.5 3.806 71 48.9 72.1 0.0 0.338 14432 13857 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 3987 114774 0 0.0 3092.2 71.7 0.000 0.000 0.776 18.409 436578 54.5 3.804 71 48.8 72.2 0.0 0.023 14384 13841 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 3987 113870 0 0.0 4675.3 91.7 0.000 0.000 1.173 23.556 434106 54.4 3.812 72 48.7 64.8 0.0 0.338 14225 13266 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 3988 104968 1681 10.1 15408.2 451.4 0.016 0.098 3.864 115.913 403370 55.4 3.843 79 50.6 73.1 0.0 0.072 13122 12370 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 3987 116680 0 0.0 802.8 32.5 0.000 0.000 0.201 8.341 443336 54.2 3.800 70 48.9 99.0 0.0 0.086 14645 14129 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
q1000.1
q1000.1: 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 7978 111298 0 0.0 2672.4 93.4 0.000 0.000 0.335 11.982 418763 56.1 3.763 76 48.9 77.5 0.0 0.035 13905 12599 160m.pg153_o3_native_lto.cx7a_gcp_c2s30 7978 111142 0 0.0 2628.2 80.5 0.000 0.000 0.329 10.335 419789 56.4 3.777 76 48.6 67.2 0.0 0.022 13953 12962 160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 7978 110954 0 0.0 2600.1 93.8 0.000 0.000 0.326 12.036 419603 56.0 3.782 76 48.8 77.3 0.0 0.081 13878 12882 160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 7976 114570 0 0.0 2472.7 65.5 0.000 0.000 0.310 8.405 428815 55.9 3.743 73 49.1 80.5 0.0 0.032 14400 13058 160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 7976 113259 0 0.0 273.8 21.0 0.000 0.000 0.034 2.693 424762 55.8 3.750 74 48.8 109.3 0.0 0.049 14293 13222 160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 7976 111120 0 0.0 2679.3 93.7 0.000 0.000 0.336 12.024 419102 56.1 3.772 76 48.9 77.5 0.0 0.043 14113 12754 160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 7978 111461 0 0.0 2601.5 94.0 0.000 0.000 0.326 12.071 419712 56.1 3.766 75 48.8 77.3 0.0 0.035 14161 13011 160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 7978 106740 0 0.0 9844.1 197.8 0.000 0.000 1.234 25.383 403822 55.7 3.783 78 48.7 64.8 0.0 0.292 13409 10724 160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 7976 97625 2494 15.6 28621.5 785.9 0.026 0.163 3.589 100.900 373489 57.3 3.826 88 50.4 79.7 0.0 0.161 12514 7256 160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 7976 113846 0 0.0 627.1 37.4 0.000 0.000 0.079 4.799 428380 55.8 3.763 74 48.8 94.1 0.0 0.048 14353 13238 160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
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 97.701 2.236 0.040 0.008 0.013 0.002 0.000 0.000 0.000 0.704 pg153_o3_native_lto.cx7a_gcp_c2s30 0.000 98.225 1.716 0.038 0.005 0.012 0.004 0.000 0.000 0.000 0.397 pg153_o3_native_lto.cx7a1_gcp_c2s30 0.000 97.866 2.072 0.038 0.006 0.015 0.003 0.000 0.000 0.000 0.523 pg153_o3_native_lto.cx7a2_gcp_c2s30 0.000 97.950 1.984 0.045 0.006 0.013 0.003 0.000 0.000 0.000 0.407 pg153_o3_native_lto.cx7a3_gcp_c2s30 0.000 98.089 1.849 0.041 0.005 0.011 0.004 0.000 0.000 0.000 0.697 pg153_o3_native_lto.cx7a4_gcp_c2s30 0.000 98.199 1.734 0.043 0.006 0.016 0.003 0.000 0.000 0.000 0.408 pg153_o3_native_lto.cx7a5_gcp_c2s30 0.000 98.170 1.768 0.046 0.003 0.010 0.004 0.000 0.000 0.000 0.448 pg153_o3_native_lto.cx7a6_gcp_c2s30 0.000 97.968 1.955 0.052 0.010 0.012 0.002 0.000 0.000 0.000 0.442 pg153_o3_native_lto.cx7a7_gcp_c2s30 0.000 97.754 2.122 0.077 0.031 0.011 0.004 0.000 0.000 0.000 0.401 pg153_o3_native_lto.cx7a8_gcp_c2s30 0.000 97.658 2.283 0.037 0.007 0.011 0.004 0.000 0.000 0.000 0.413 pg153_o3_native_lto.cx7a9_gcp_c2s30
Delete response time histogram
0.000 sum:DBMS 0.000 pg153_o3_native_lto.cx7a_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a1_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a2_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a3_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a4_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a5_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a6_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a7_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a8_gcp_c2s30 0.000 pg153_o3_native_lto.cx7a9_gcp_c2s30
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
- 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 56.278 43.383 0.261 0.075 0.002 nonzero 0.000 0.000 0.000 0.503 pg153_o3_native_lto.cx7a_gcp_c2s30 0.000 55.942 43.982 0.062 0.013 0.001 nonzero 0.000 0.000 0.000 0.432 pg153_o3_native_lto.cx7a1_gcp_c2s30 0.000 51.916 47.768 0.244 0.071 0.001 nonzero 0.000 0.000 0.000 0.266 pg153_o3_native_lto.cx7a2_gcp_c2s30 0.000 60.183 39.799 0.017 0.001 0.001 nonzero 0.000 0.000 0.000 0.406 pg153_o3_native_lto.cx7a3_gcp_c2s30 0.000 54.924 44.736 0.261 0.078 0.002 nonzero 0.000 0.000 0.000 0.389 pg153_o3_native_lto.cx7a4_gcp_c2s30 0.000 54.254 45.413 0.255 0.076 0.002 0.000 0.000 0.000 0.000 0.244 pg153_o3_native_lto.cx7a5_gcp_c2s30 0.000 56.339 43.359 0.240 0.060 0.002 nonzero 0.000 0.000 0.000 0.474 pg153_o3_native_lto.cx7a6_gcp_c2s30 0.000 34.492 62.391 1.876 1.220 0.020 nonzero 0.000 0.000 0.000 0.657 pg153_o3_native_lto.cx7a7_gcp_c2s30 0.000 1.225 82.009 15.159 1.564 0.043 nonzero 0.000 0.000 0.000 0.318 pg153_o3_native_lto.cx7a8_gcp_c2s30 0.000 55.884 43.809 0.243 0.063 0.001 nonzero 0.000 0.000 0.000 0.325 pg153_o3_native_lto.cx7a9_gcp_c2s30
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 83.817 2.756 2.318 7.199 3.907 0.004 nonzero 0.000 0.000 0.000 0.306 pg153_o3_native_lto.cx7a_gcp_c2s30 83.507 3.087 2.562 7.134 3.708 0.001 nonzero 0.000 0.000 0.000 0.439 pg153_o3_native_lto.cx7a1_gcp_c2s30 83.645 2.854 1.992 7.531 3.975 0.002 nonzero 0.000 0.000 0.000 0.270 pg153_o3_native_lto.cx7a2_gcp_c2s30 84.116 2.556 2.942 6.678 3.707 0.001 nonzero 0.000 0.000 0.000 0.416 pg153_o3_native_lto.cx7a3_gcp_c2s30 83.802 2.549 2.426 7.118 4.102 0.002 nonzero 0.000 0.000 0.000 0.365 pg153_o3_native_lto.cx7a4_gcp_c2s30 83.643 2.744 2.494 7.093 4.024 0.002 0.000 0.000 0.000 0.000 0.250 pg153_o3_native_lto.cx7a5_gcp_c2s30 83.869 2.637 2.649 6.947 3.896 0.002 nonzero 0.000 0.000 0.000 0.488 pg153_o3_native_lto.cx7a6_gcp_c2s30 81.070 3.378 1.938 7.889 5.676 0.048 nonzero 0.000 0.000 0.000 0.779 pg153_o3_native_lto.cx7a7_gcp_c2s30 84.759 5.471 0.575 4.524 4.663 0.008 nonzero 0.000 0.000 0.000 0.358 pg153_o3_native_lto.cx7a8_gcp_c2s30 83.716 2.705 2.518 7.169 3.890 0.002 nonzero 0.000 0.000 0.000 0.340 pg153_o3_native_lto.cx7a9_gcp_c2s30
q100.1
- q100.1: 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.996 0.004 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg153_o3_native_lto.cx7a_gcp_c2s30 99.996 0.003 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg153_o3_native_lto.cx7a1_gcp_c2s30 99.995 0.004 0.001 nonzero 0.000 0.000 nonzero 0.000 0.000 0.000 0.338 pg153_o3_native_lto.cx7a2_gcp_c2s30 99.996 0.003 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg153_o3_native_lto.cx7a3_gcp_c2s30 99.997 0.003 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg153_o3_native_lto.cx7a4_gcp_c2s30 99.995 0.004 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg153_o3_native_lto.cx7a5_gcp_c2s30 99.995 0.004 0.001 nonzero 0.000 0.000 nonzero 0.000 0.000 0.000 0.338 pg153_o3_native_lto.cx7a6_gcp_c2s30 99.995 0.004 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg153_o3_native_lto.cx7a7_gcp_c2s30 99.961 0.038 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.229 pg153_o3_native_lto.cx7a8_gcp_c2s30 99.995 0.004 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg153_o3_native_lto.cx7a9_gcp_c2s30
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg153_o3_native_lto.cx7a_gcp_c2s30 0.000 0.019 99.762 0.219 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg153_o3_native_lto.cx7a1_gcp_c2s30 0.000 0.679 99.316 0.005 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg153_o3_native_lto.cx7a2_gcp_c2s30 0.000 48.030 51.970 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg153_o3_native_lto.cx7a3_gcp_c2s30 0.000 15.927 84.071 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg153_o3_native_lto.cx7a4_gcp_c2s30 0.000 1.000 98.986 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg153_o3_native_lto.cx7a5_gcp_c2s30 0.000 1.201 98.793 0.005 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg153_o3_native_lto.cx7a6_gcp_c2s30 0.000 0.000 99.998 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg153_o3_native_lto.cx7a7_gcp_c2s30 0.000 0.000 81.936 17.797 0.260 0.007 0.000 0.000 0.000 0.000 0.185 pg153_o3_native_lto.cx7a8_gcp_c2s30 0.000 6.825 93.172 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg153_o3_native_lto.cx7a9_gcp_c2s30
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 56.127 29.429 14.438 0.007 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg153_o3_native_lto.cx7a_gcp_c2s30 63.517 21.747 14.729 0.007 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg153_o3_native_lto.cx7a1_gcp_c2s30 57.613 31.411 10.969 0.007 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg153_o3_native_lto.cx7a2_gcp_c2s30 43.833 33.325 22.842 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg153_o3_native_lto.cx7a3_gcp_c2s30 59.019 31.601 9.378 0.002 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg153_o3_native_lto.cx7a4_gcp_c2s30 58.455 26.814 14.724 0.007 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg153_o3_native_lto.cx7a5_gcp_c2s30 53.344 32.891 13.760 0.005 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg153_o3_native_lto.cx7a6_gcp_c2s30 47.993 28.342 23.660 0.005 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg153_o3_native_lto.cx7a7_gcp_c2s30 65.483 24.306 10.198 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg153_o3_native_lto.cx7a8_gcp_c2s30 58.259 24.694 17.043 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg153_o3_native_lto.cx7a9_gcp_c2s30
q500.1
- q500.1: 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 99.979 0.013 0.008 0.001 nonzero 0.000 nonzero 0.000 0.000 0.000 0.338 pg153_o3_native_lto.cx7a_gcp_c2s30 99.979 0.014 0.007 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.018 pg153_o3_native_lto.cx7a1_gcp_c2s30 99.976 0.014 0.009 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.020 pg153_o3_native_lto.cx7a2_gcp_c2s30 99.987 0.007 0.005 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.027 pg153_o3_native_lto.cx7a3_gcp_c2s30 99.984 0.009 0.007 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.028 pg153_o3_native_lto.cx7a4_gcp_c2s30 99.977 0.014 0.008 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.338 pg153_o3_native_lto.cx7a5_gcp_c2s30 99.977 0.014 0.008 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.023 pg153_o3_native_lto.cx7a6_gcp_c2s30 99.974 0.016 0.008 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.338 pg153_o3_native_lto.cx7a7_gcp_c2s30 99.921 0.075 0.004 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.072 pg153_o3_native_lto.cx7a8_gcp_c2s30 99.983 0.010 0.007 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.086 pg153_o3_native_lto.cx7a9_gcp_c2s30
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 7.687 91.830 0.478 0.006 0.000 0.000 0.000 0.000 0.000 0.026 pg153_o3_native_lto.cx7a_gcp_c2s30 0.000 0.000 99.518 0.475 0.007 0.000 0.000 0.000 0.000 0.000 0.020 pg153_o3_native_lto.cx7a1_gcp_c2s30 0.000 5.206 94.135 0.649 0.010 0.000 0.000 0.000 0.000 0.000 0.030 pg153_o3_native_lto.cx7a2_gcp_c2s30 0.000 76.632 23.180 0.186 0.001 0.000 0.000 0.000 0.000 0.000 0.020 pg153_o3_native_lto.cx7a3_gcp_c2s30 0.000 52.310 47.044 0.610 0.037 0.000 0.000 0.000 0.000 0.000 0.043 pg153_o3_native_lto.cx7a4_gcp_c2s30 0.000 7.330 91.783 0.814 0.073 0.000 0.000 0.000 0.000 0.000 0.049 pg153_o3_native_lto.cx7a5_gcp_c2s30 0.000 6.080 92.878 1.010 0.032 0.000 0.000 0.000 0.000 0.000 0.033 pg153_o3_native_lto.cx7a6_gcp_c2s30 0.000 1.439 97.836 0.496 0.202 0.027 0.000 0.000 0.000 0.000 0.148 pg153_o3_native_lto.cx7a7_gcp_c2s30 0.000 0.000 89.326 9.901 0.752 0.021 0.000 0.000 0.000 0.000 0.218 pg153_o3_native_lto.cx7a8_gcp_c2s30 0.000 43.049 56.608 0.290 0.050 0.003 0.000 0.000 0.000 0.000 0.078 pg153_o3_native_lto.cx7a9_gcp_c2s30
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 78.160 1.089 3.862 16.787 0.102 0.000 0.000 0.000 0.000 0.000 0.038 pg153_o3_native_lto.cx7a_gcp_c2s30 78.558 1.803 4.130 15.497 0.013 0.000 0.000 0.000 0.000 0.000 0.030 pg153_o3_native_lto.cx7a1_gcp_c2s30 77.719 1.197 3.081 17.940 0.062 0.000 0.000 0.000 0.000 0.000 0.046 pg153_o3_native_lto.cx7a2_gcp_c2s30 81.320 0.908 0.700 17.006 0.066 0.000 0.000 0.000 0.000 0.000 0.040 pg153_o3_native_lto.cx7a3_gcp_c2s30 77.676 1.332 3.577 17.226 0.190 0.000 0.000 0.000 0.000 0.000 0.043 pg153_o3_native_lto.cx7a4_gcp_c2s30 76.440 1.238 3.719 18.465 0.138 0.000 0.000 0.000 0.000 0.000 0.045 pg153_o3_native_lto.cx7a5_gcp_c2s30 77.862 1.188 2.480 18.338 0.133 0.000 0.000 0.000 0.000 0.000 0.038 pg153_o3_native_lto.cx7a6_gcp_c2s30 78.308 1.313 2.159 17.905 0.297 0.018 0.000 0.000 0.000 0.000 0.148 pg153_o3_native_lto.cx7a7_gcp_c2s30 76.415 2.983 4.503 16.067 0.031 0.001 0.000 0.000 0.000 0.000 0.080 pg153_o3_native_lto.cx7a8_gcp_c2s30 79.200 1.299 2.768 16.648 0.081 0.003 0.000 0.000 0.000 0.000 0.081 pg153_o3_native_lto.cx7a9_gcp_c2s30
q1000.1
- q1000.1: 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 99.945 0.037 0.015 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.035 pg153_o3_native_lto.cx7a_gcp_c2s30 99.946 0.042 0.011 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.022 pg153_o3_native_lto.cx7a1_gcp_c2s30 99.942 0.039 0.016 0.003 nonzero nonzero 0.000 0.000 0.000 0.000 0.081 pg153_o3_native_lto.cx7a2_gcp_c2s30 99.965 0.024 0.011 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.032 pg153_o3_native_lto.cx7a3_gcp_c2s30 99.960 0.028 0.012 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.049 pg153_o3_native_lto.cx7a4_gcp_c2s30 99.944 0.037 0.015 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.043 pg153_o3_native_lto.cx7a5_gcp_c2s30 99.942 0.038 0.017 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.035 pg153_o3_native_lto.cx7a6_gcp_c2s30 99.900 0.055 0.028 0.015 0.001 nonzero nonzero 0.000 0.000 0.000 0.292 pg153_o3_native_lto.cx7a7_gcp_c2s30 99.689 0.283 0.021 0.006 0.002 nonzero 0.000 0.000 0.000 0.000 0.161 pg153_o3_native_lto.cx7a8_gcp_c2s30 99.954 0.031 0.013 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.048 pg153_o3_native_lto.cx7a9_gcp_c2s30
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 23.085 74.293 2.470 0.152 0.000 0.000 0.000 0.000 0.000 0.042 pg153_o3_native_lto.cx7a_gcp_c2s30 0.000 2.840 96.246 0.890 0.023 0.000 0.000 0.000 0.000 0.000 0.030 pg153_o3_native_lto.cx7a1_gcp_c2s30 0.000 19.257 78.408 2.230 0.105 0.000 0.000 0.000 0.000 0.000 0.036 pg153_o3_native_lto.cx7a2_gcp_c2s30 0.000 63.232 36.339 0.417 0.012 0.000 0.000 0.000 0.000 0.000 0.035 pg153_o3_native_lto.cx7a3_gcp_c2s30 0.000 52.273 46.767 0.860 0.100 0.000 0.000 0.000 0.000 0.000 0.044 pg153_o3_native_lto.cx7a4_gcp_c2s30 0.000 25.226 72.617 2.066 0.091 0.000 0.000 0.000 0.000 0.000 0.051 pg153_o3_native_lto.cx7a5_gcp_c2s30 0.000 20.192 76.839 2.808 0.161 0.000 0.000 0.000 0.000 0.000 0.041 pg153_o3_native_lto.cx7a6_gcp_c2s30 0.000 0.149 86.888 11.510 1.420 0.033 nonzero 0.000 0.000 0.000 0.299 pg153_o3_native_lto.cx7a7_gcp_c2s30 0.000 0.000 84.848 13.126 1.924 0.101 nonzero 0.000 0.000 0.000 0.323 pg153_o3_native_lto.cx7a8_gcp_c2s30 0.000 48.642 49.808 1.408 0.141 0.000 0.000 0.000 0.000 0.000 0.045 pg153_o3_native_lto.cx7a9_gcp_c2s30
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 78.416 2.335 2.535 13.449 3.265 0.000 0.000 0.000 0.000 0.000 0.052 pg153_o3_native_lto.cx7a_gcp_c2s30 76.934 4.012 3.232 12.698 3.124 0.000 0.000 0.000 0.000 0.000 0.028 pg153_o3_native_lto.cx7a1_gcp_c2s30 78.403 2.823 2.743 13.607 2.423 0.000 0.000 0.000 0.000 0.000 0.049 pg153_o3_native_lto.cx7a2_gcp_c2s30 79.119 3.131 1.350 12.595 3.806 0.000 0.000 0.000 0.000 0.000 0.051 pg153_o3_native_lto.cx7a3_gcp_c2s30 77.731 3.355 2.479 13.190 3.245 0.000 0.000 0.000 0.000 0.000 0.056 pg153_o3_native_lto.cx7a4_gcp_c2s30 78.367 2.811 2.528 13.497 2.798 0.000 0.000 0.000 0.000 0.000 0.048 pg153_o3_native_lto.cx7a5_gcp_c2s30 78.101 3.176 2.474 12.867 3.382 0.000 0.000 0.000 0.000 0.000 0.050 pg153_o3_native_lto.cx7a6_gcp_c2s30 72.321 5.914 2.830 14.583 4.341 0.012 0.000 0.000 0.000 0.000 0.194 pg153_o3_native_lto.cx7a7_gcp_c2s30 76.984 4.108 3.351 12.181 3.364 0.012 0.000 0.000 0.000 0.000 0.157 pg153_o3_native_lto.cx7a8_gcp_c2s30 77.844 3.701 2.440 12.877 3.138 0.000 0.000 0.000 0.000 0.000 0.049 pg153_o3_native_lto.cx7a9_gcp_c2s30