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 on GCP with 15 cores, hyperthreads disabled, 120G of RAM and XFS with SW RAID 0 on 4 NVMe devices (1.5T total). 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 3600s 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 the OS page cache but not by the storage engine. Clients and the DBMS share one server. The per-database configs are in the per-database subdirectories here.

The tested DBMS are:


Contents


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.

dbmsl.i0l.xl.i1q100.1q500.1q1000.1
160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30 1012658228714311029911082910300297615
160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30 1012658238955212296310993410302395932
160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30 101265822549307198811129410341596796
160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30 1012658225493013783611184710484498416
160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30 1019108222361110810811074010522399320
160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30 1006289222361110843010989710179395541
160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30 104575222549307219611253710362397889
160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30 101910825412705105911048010326895972
160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30 10062892163514113652112080105436100042
160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30 1019108228714311083411035810448699165
160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30 1012658225493010929011058610210595529
160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30 1019108222361111128111059510266096835
160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30 1032258228714310952910987910239896427
160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30 103896121931516559010992810188091058
160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30 96969717593413545011079910309096807
160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30 94674620012503275510954310219894806
160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30 1012658228714311034511011010171497278
160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30 1006289222361110872511057810247994598
160m.pg153_o3_native_lto.cx7a18_4g_gcp_c2s30 1012658238955212710511027710393398473

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.

dbmsl.i0l.xl.i1q100.1q500.1q1000.1
160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30 1.001.001.001.001.001.00
160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30 1.001.041.110.991.000.98
160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30 1.000.990.651.001.000.99
160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30 1.000.991.251.011.021.01
160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30 1.010.970.981.001.021.02
160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30 0.990.970.980.990.990.98
160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30 1.030.990.651.021.011.00
160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30 1.011.110.461.001.000.98
160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30 0.990.951.031.011.021.02
160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30 1.011.001.001.001.011.02
160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30 1.000.990.991.000.990.98
160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30 1.010.971.011.001.000.99
160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30 1.021.000.990.990.990.99
160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30 1.030.960.590.990.990.93
160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30 0.960.770.321.001.000.99
160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30 0.930.870.300.990.990.97
160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30 1.001.001.000.990.991.00
160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30 0.990.970.991.000.990.97
160m.pg153_o3_native_lto.cx7a18_4g_gcp_c2s30 1.001.041.151.001.011.01

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.

dbmsq100.1q500.1q1000.1
pg153_o3_native_lto.cx7a_4g_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3079739877973
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3079839877976
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3079839877976
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3079739887976
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3079739887976
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3079739887976
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3079739877971
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3079839887976
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3079739877973
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3079739877973
target80040008000

l.i0

l.i0: load without secondary indexes. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3097.7092.2190.0490.0060.0150.0020.748
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3097.9561.9730.0490.0090.0090.0040.565
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3097.8742.0540.0460.0090.0130.0030.387
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3098.1621.7660.0490.0040.0160.0030.434
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3097.9511.9750.0480.0090.0150.0020.389
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3098.0121.9130.0470.0100.0150.0020.644
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3098.1451.8270.0180.0070.0030.0010.339
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3098.0101.9200.0490.0090.0110.0010.307
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3097.7212.2090.0430.0120.0120.0030.379
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3098.1301.7890.0520.0080.0190.0010.357
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3098.0211.9050.0500.0070.0150.0020.557
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3098.0161.9120.0480.0080.0150.0010.624
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3098.1921.7400.0530.0060.0080.0010.351
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3098.4141.5520.0220.0070.0030.0020.772
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3098.1441.7830.0430.0060.0100.0140.874
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3097.6882.1380.0800.0700.0130.0110.0011.386
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3097.9741.9540.0490.0070.0150.0020.499
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3098.0081.8960.0550.0180.0220.243
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3097.8552.0740.0500.0050.0130.0030.474

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
1012658	0	0	0.0	4987.3	410.3	0.000	0.000	0.005	0.415	84219	75.3	0.083	11	15.3	41.4	0.0	0.748	146738	42669	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
1012658	0	0	0.0	4927.1	406.0	0.000	0.000	0.005	0.411	84498	75.5	0.083	11	15.3	41.4	0.0	0.565	146440	33663	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
1012658	0	0	0.0	5073.9	406.6	0.000	0.000	0.005	0.411	83933	75.5	0.083	11	15.3	41.4	0.0	0.387	147538	31077	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
1012658	0	0	0.0	5052.4	406.0	0.000	0.000	0.005	0.411	83777	75.8	0.083	11	15.3	41.4	0.0	0.434	147740	22887	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
1019108	0	0	0.0	5099.3	406.2	0.000	0.000	0.005	0.408	83934	75.6	0.082	11	15.3	41.4	0.0	0.389	147039	34162	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
1006289	0	0	0.0	5094.8	403.3	0.000	0.000	0.005	0.410	83353	76.0	0.083	11	15.3	41.4	0.0	0.644	146297	28968	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
1045752	0	0	0.0	5033.5	418.2	0.000	0.000	0.005	0.410	89790	77.7	0.086	11	15.3	41.6	0.0	0.339	147040	72321	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
1019108	0	0	0.0	3516.7	336.9	0.000	0.000	0.003	0.338	86409	76.4	0.085	11	15.3	31.4	0.0	0.307	145042	36360	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
1006289	0	0	0.0	3680.3	376.9	0.000	0.000	0.004	0.384	84315	75.6	0.084	11	15.3	41.4	0.0	0.379	146242	13286	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
1019108	0	0	0.0	5084.8	407.8	0.000	0.000	0.005	0.410	84696	75.9	0.083	11	15.3	41.4	0.0	0.357	146939	11687	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
1012658	0	0	0.0	5009.0	406.1	0.000	0.000	0.005	0.411	83655	76.2	0.083	11	15.3	41.4	0.0	0.557	146841	15283	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
1019108	0	0	0.0	4627.1	404.7	0.000	0.000	0.005	0.407	84386	75.8	0.083	11	15.3	41.4	NA	0.624	147193	23574	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
1032258	0	0	0.0	5083.0	421.6	0.000	0.000	0.005	0.418	85309	77.4	0.083	11	15.3	41.4	NA	0.351	148739	26771	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
1038961	0	0	0.0	5028.4	415.2	0.000	0.000	0.005	0.409	88826	77.7	0.085	11	15.3	41.6	0.0	0.772	147538	30778	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
969697	0	0	0.0	4527.3	388.0	0.000	0.000	0.005	0.410	77119	70.9	0.080	11	15.3	41.4	0.0	0.874	149036	10588	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
946746	0	0	0.0	4136.7	395.9	0.000	0.000	0.004	0.428	76310	70.4	0.081	11	15.3	42.9	0.0	1.386	148538	4295	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
1012658	0	0	0.0	5148.3	407.4	0.000	0.000	0.005	0.412	84233	75.5	0.083	11	15.3	41.4	0.0	0.499	147039	35461	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
1006289	0	0	0.0	4513.9	397.2	0.000	0.000	0.004	0.404	85387	75.2	0.085	11	15.3	41.4	0.0	0.243	146941	32764	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
1012658	0	0	0.0	5116.9	410.0	0.000	0.000	0.005	0.415	83565	76.0	0.083	11	15.3	41.4	0.0	0.474	146395	40571	160m.pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

l.x

l.x: create secondary indexes.

Average throughput:

Image

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
2287143	0	0	0.0	1548.0	577.2	0.000	0.000	0.001	0.258	15066	37.3	0.007	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
2389552	0	0	0.0	1274.7	444.0	0.000	0.000	0.001	0.190	8504	41.2	0.004	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
2254930	0	0	0.0	1571.6	562.1	0.000	0.000	0.001	0.255	14541	37.9	0.006	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
2254930	0	0	0.0	1509.2	564.2	0.000	0.000	0.001	0.256	15285	38.1	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
2223611	0	0	0.0	1565.7	559.9	0.000	0.000	0.001	0.258	15825	38.3	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
2223611	0	0	0.0	1562.3	561.2	0.000	0.000	0.001	0.258	14893	38.3	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
2254930	0	0	0.0	1462.6	545.9	0.000	0.000	0.001	0.248	9033	37.6	0.004	3	29.4	68.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
2541270	0	0	0.0	1322.1	435.6	0.000	0.000	0.001	0.176	15640	43.5	0.006	3	29.4	45.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
2163514	0	0	0.0	3068.7	587.7	0.000	0.000	0.001	0.278	14423	39.4	0.007	3	29.4	67.8	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
2287143	0	0	0.0	1590.1	581.7	0.000	0.000	0.001	0.260	15596	38.1	0.007	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
2254930	0	0	0.0	1572.4	578.5	0.000	0.000	0.001	0.263	15629	37.9	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
2223611	0	0	0.0	1507.1	558.2	0.000	0.000	0.001	0.257	15721	38.1	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
2287143	0	0	0.0	1533.1	574.1	0.000	0.000	0.001	0.257	14268	38.1	0.006	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
2193151	0	0	0.0	1438.9	540.7	0.000	0.000	0.001	0.252	13020	37.8	0.006	3	29.4	68.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
1759341	0	0	0.0	1214.4	454.6	0.000	0.000	0.001	0.265	12549	29.9	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
2001250	0	0	0.0	1237.0	414.5	0.000	0.000	0.001	0.212	14863	33.2	0.007	2	29.4	61.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
2287143	0	0	0.0	1607.2	579.2	0.000	0.000	0.001	0.259	15297	37.9	0.007	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
2223611	0	0	0.0	1608.9	562.7	0.000	0.000	0.001	0.259	15835	37.7	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
2389552	0	0	0.0	1277.0	431.3	0.000	0.000	0.001	0.185	7584	40.6	0.003	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

l.i1

l.i1: continue load after secondary indexes created. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3092.7115.2671.9210.101nonzero0.294
pg153_o3_native_lto.cx7a1_4g_gcp_c2s300.04395.3833.7320.7950.047nonzero0.297
pg153_o3_native_lto.cx7a2_4g_gcp_c2s300.07088.1277.1804.623nonzero0.097
pg153_o3_native_lto.cx7a3_4g_gcp_c2s30nonzero98.4881.3160.1830.013nonzero0.424
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3092.1385.7032.0510.108nonzero0.297
pg153_o3_native_lto.cx7a5_4g_gcp_c2s300.03093.1825.0361.6640.088nonzero0.347
pg153_o3_native_lto.cx7a6_4g_gcp_c2s300.04787.4788.2504.1860.0370.001nonzero5.172
pg153_o3_native_lto.cx7a7_4g_gcp_c2s30nonzero79.81011.2447.0361.910nonzero0.298
pg153_o3_native_lto.cx7a8_4g_gcp_c2s300.00593.0874.7862.0110.110nonzero0.320
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3093.6324.5111.7620.095nonzero0.305
pg153_o3_native_lto.cx7a10_4g_gcp_c2s300.00193.9384.5241.4560.081nonzero0.288
pg153_o3_native_lto.cx7a11_4g_gcp_c2s300.00194.1934.0991.6190.088nonzero0.462
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3094.5294.1660.9440.3550.0050.649
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3091.7663.3023.9550.8760.0800.0203.943
pg153_o3_native_lto.cx7a14_4g_gcp_c2s300.00468.6975.60725.4660.226nonzero2.445
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3081.1394.0589.2215.5410.040nonzero14.734
pg153_o3_native_lto.cx7a16_4g_gcp_c2s30nonzero93.2174.7821.8980.102nonzero0.317
pg153_o3_native_lto.cx7a17_4g_gcp_c2s300.00292.4465.5501.8980.104nonzero0.314
pg153_o3_native_lto.cx7a18_4g_gcp_c2s300.33996.9072.1420.5760.036nonzerononzero1.984

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3087.73110.3990.6390.4600.7180.052nonzero0.305
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3083.29915.2750.6540.2780.4360.058nonzero0.364
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3078.2027.9440.5197.6465.6870.002nonzero0.501
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3090.0538.6380.5440.2490.4020.113nonzero0.422
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3084.60013.3030.6620.6520.7080.075nonzero0.381
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3086.61511.4640.7020.3930.7240.102nonzero0.370
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3078.5987.9560.4137.8505.1630.020nonzero0.450
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3072.52418.0031.2782.9674.3640.863nonzero0.364
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3083.86513.8980.7240.7680.6710.073nonzero0.328
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3085.80112.0650.6640.6070.7800.083nonzero0.432
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3088.1149.7650.5870.5810.7660.186nonzero0.357
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3088.6819.2170.6210.6220.7480.112nonzero0.410
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3085.82712.6380.5490.4420.4500.0930.0020.599
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3086.92311.9060.3590.3240.2530.2120.0200.0033.939
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3077.62116.3560.4272.5902.9240.083nonzerononzero1.042
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3069.11624.9440.6301.1162.6401.5370.017nonzero14.743
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3086.36111.9750.5970.4330.5760.057nonzero0.313
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3085.77712.5860.5380.5180.4800.100nonzero0.304
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3087.65910.3990.7060.1271.0690.041nonzerononzero1.998

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
110299	0	1552	27.3	58532.9	1326.7	0.014	0.254	0.531	12.317	72270	51.3	0.655	70	137.1	207.2	NA	0.294	15635	1099	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
122963	0	1808	25.0	56404.5	1326.6	0.015	0.208	0.459	11.048	77575	57.8	0.631	71	131.0	201.1	NA	0.297	17331	1049	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
71988	0	35	0.2	171201.9	1445.2	0.000	0.003	2.378	20.558	49204	53.9	0.684	112	49.7	107.9	NA	0.097	9693	2098	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
137836	0	1050	13.8	53204.9	1315.5	0.008	0.103	0.386	9.773	85883	63.5	0.623	69	110.1	157.1	NA	0.424	19778	649	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
108108	0	1634	29.2	59244.8	1320.2	0.015	0.276	0.548	12.505	70013	50.9	0.648	71	141.4	211.5	NA	0.297	14784	600	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
108430	0	1837	31.4	58561.1	1316.7	0.017	0.297	0.540	12.434	70760	52.5	0.653	73	133.0	203.1	NA	0.347	15640	200	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
72196	0	46	0.2	172007.3	1446.9	0.001	0.003	2.383	20.522	50094	53.9	0.694	112	50.0	108.5	NA	5.172	9693	2049	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
51059	0	0	0.0	64239.1	1224.9	0.000	0.000	1.258	24.565	44639	31.2	0.874	92	57.1	73.1	NA	0.298	5244	699	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
113652	0	1740	32.5	58914.1	1311.7	0.015	0.293	0.518	11.818	68791	50.7	0.605	67	145.1	215.2	NA	0.320	16688	1199	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
110834	0	1616	28.1	57033.1	1310.4	0.015	0.260	0.515	12.107	72014	52.5	0.650	71	137.0	207.1	NA	0.305	15383	600	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
109290	0	1833	35.0	56061.3	1300.1	0.017	0.328	0.513	12.181	70754	54.2	0.647	74	122.6	192.6	NA	0.288	15791	499	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
111281	0	1858	32.6	55870.2	1304.6	0.017	0.300	0.502	12.005	72303	53.9	0.650	73	122.1	192.7	NA	0.462	15838	400	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
109529	0	1479	28.2	56657.3	1311.5	0.014	0.264	0.517	12.262	72357	51.6	0.661	71	155.3	225.4	NA	0.649	14734	999	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
65590	0	926	17.8	29156.7	730.9	0.014	0.278	0.445	11.410	42389	30.2	0.646	69	167.8	237.9	NA	3.943	7683	0	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
35450	0	0	0.0	85556.9	742.6	0.000	0.000	2.413	21.451	24728	22.1	0.698	94	54.2	98.9	0.0	2.445	4745	1398	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
32755	0	414	7.2	36868.0	671.8	0.013	0.224	1.126	21.002	25040	17.4	0.764	80	125.0	157.1	NA	14.734	3197	300	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
110345	0	1644	30.5	57482.3	1319.8	0.015	0.283	0.521	12.247	71749	51.6	0.650	70	137.8	207.9	NA	0.317	15688	1449	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
108725	0	1623	31.4	54530.5	1317.9	0.015	0.296	0.502	12.412	71235	51.5	0.655	71	131.5	201.6	NA	0.314	15383	1199	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
127105	0	1444	15.1	54350.1	1307.7	0.011	0.121	0.428	10.535	81410	62.1	0.640	73	75.8	144.8	NA	1.984	18630	749	160m.pg153_o3_native_lto.cx7a18_4g_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:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3099.9520.0460.001nonzerononzerononzero0.134
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3099.9480.0510.001nonzerononzerononzero0.094
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3099.9950.0040.001nonzero0.005
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3099.9890.0100.001nonzerononzerononzero0.127
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3099.9490.0500.001nonzerononzerononzero0.145
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3099.9510.0480.001nonzerononzerononzerononzero0.273
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3099.9940.0050.001nonzero0.007
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3099.9950.0050.001nonzero0.004
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3099.9390.0590.001nonzerononzerononzero0.182
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3099.9500.0480.001nonzerononzerononzero0.128
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3099.9770.0210.001nonzerononzerononzero0.123
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3099.9810.0180.001nonzerononzerononzero0.112
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3099.9350.0630.001nonzerononzerononzero0.132
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3099.9490.0500.001nonzerononzerononzerononzero0.308
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3099.9950.0050.0010.004
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3099.9490.0500.001nonzerononzerononzero0.225
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3099.9620.0370.001nonzerononzerononzero0.120
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3099.9660.0330.001nonzerononzerononzero0.130
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3099.9950.0040.001nonzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3077.40622.2970.2800.0170.224
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3079.35420.1940.4310.0210.150
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3099.9970.0030.015
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3097.5592.4150.0230.0030.134
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3077.48822.1390.3660.0070.122
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3072.28827.2380.4690.0030.0020.274
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3099.9950.0050.014
pg153_o3_native_lto.cx7a7_4g_gcp_c2s30100.0000.004
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3079.68919.7710.5100.0260.0030.331
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3083.56816.1130.3000.0190.223
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3087.74812.1490.0870.0160.168
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3088.56611.3770.0430.0090.0050.354
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3068.78530.5970.6040.0100.0030.391
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3075.00324.6040.3730.0170.0020.482
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3099.9970.0030.005
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3078.22421.3140.4270.0280.0070.592
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3081.31218.3840.2990.0050.154
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3085.47414.3820.1200.0210.0030.302
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3099.5420.4570.0020.017

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3038.86348.99512.1280.0140.014
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3033.68153.70012.6150.0030.0020.022
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3066.32326.9703.6983.0090.010
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3039.67949.73410.5800.0070.014
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3038.16349.71212.1180.0070.015
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3038.75248.84512.4030.004
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3066.60229.6303.7670.004
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3039.87349.81610.3110.003
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3036.85649.27113.8650.0090.014
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3040.95049.9709.0690.0090.0020.056
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3045.59046.9187.4830.0090.011
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3044.24045.9579.8000.0030.005
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3039.66550.27410.0590.0020.018
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3038.88051.06810.0520.004
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3053.42033.86612.7140.003
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3040.04348.91711.0380.0020.045
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3042.19849.7558.0420.0050.014
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3038.71950.96210.3120.0050.0020.068
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3040.16150.1569.6670.0160.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
797	110829	512	4.2	3382.8	36.9	0.005	0.039	4.243	47.347	423400	53.0	3.820	72	137.2	179.4	0.0	0.134	13953	13489	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
797	109934	474	4.1	3353.2	36.2	0.004	0.038	4.206	46.452	419974	53.0	3.820	72	131.0	180.2	0.0	0.094	13894	12195	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
797	111294	0	0.0	3419.8	33.0	0.000	0.000	4.289	42.355	424784	52.8	3.817	71	49.6	73.9	0.0	0.005	13889	13655	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
798	111847	84	0.6	3357.9	35.6	0.001	0.006	4.210	45.728	426110	53.0	3.810	71	109.7	149.2	0.0	0.127	13969	13713	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
798	110740	568	4.5	3353.9	38.1	0.005	0.041	4.206	48.945	422340	53.1	3.814	72	141.5	211.5	0.0	0.145	13985	13761	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
797	109897	515	4.4	3395.3	65.2	0.005	0.041	4.258	83.690	419927	52.9	3.821	72	133.0	177.0	0.0	0.273	13809	13457	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
797	112537	0	0.0	3368.3	32.2	0.000	0.000	4.225	41.312	429441	52.9	3.816	71	50.0	74.5	0.0	0.007	14049	13841	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
797	110480	0	0.0	3411.9	34.7	0.000	0.000	4.279	44.530	421773	52.7	3.818	72	57.0	68.7	0.0	0.004	13873	13649	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
797	112080	472	4.3	3381.8	39.8	0.004	0.039	4.242	51.086	428263	52.8	3.821	71	145.1	187.3	0.0	0.182	14112	5626	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
797	110358	465	4.0	3364.0	50.7	0.004	0.037	4.219	65.143	421275	53.0	3.817	72	137.0	200.1	0.0	0.128	13750	13505	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
797	110586	280	2.1	3434.9	92.0	0.003	0.020	4.308	118.106	422246	53.0	3.818	72	119.9	163.5	0.0	0.123	13953	13191	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
797	110595	226	1.4	3366.1	57.9	0.002	0.013	4.222	74.331	422273	53.1	3.818	72	118.5	162.1	0.0	0.112	13921	13655	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
797	109879	653	5.9	3412.5	55.2	0.006	0.055	4.280	70.876	419988	53.0	3.822	72	155.3	200.3	0.0	0.132	13713	13457	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
797	109928	744	5.9	3382.5	52.3	0.007	0.055	4.242	67.155	420129	53.0	3.822	72	167.8	211.8	0.0	0.308	13953	13217	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
798	110799	0	0.0	3398.6	32.9	0.000	0.000	4.262	42.216	422859	52.9	3.816	72	54.2	74.1	0.0	0.004	13905	13665	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
797	109543	448	4.7	3375.5	45.6	0.004	0.043	4.234	58.578	418638	52.9	3.822	72	116.8	133.2	0.0	0.225	13713	10085	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
797	110110	355	3.5	3397.1	52.0	0.003	0.033	4.261	66.729	420635	53.0	3.820	72	137.8	181.7	0.0	0.120	13761	13521	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
797	110578	550	2.8	3384.4	48.6	0.005	0.026	4.245	62.453	422304	53.1	3.819	72	131.6	175.3	0.0	0.130	13841	13617	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
797	110277	4	0.0	3366.5	38.5	0.000	0.000	4.222	49.403	420876	53.0	3.817	72	75.1	120.4	0.0	0.009	13847	13617	160m.pg153_o3_native_lto.cx7a18_4g_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:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3099.9260.0630.0100.001nonzero0.025
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3099.9490.0430.0080.001nonzero0.024
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3099.9680.0240.007nonzerononzero0.021
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3099.9770.0140.0080.001nonzero0.023
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3099.9600.0320.0070.001nonzero0.026
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3099.9290.0600.0100.001nonzero0.024
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3099.9660.0250.008nonzerononzero0.023
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3099.9570.0320.0100.002nonzero0.031
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3099.9480.0420.0090.001nonzero0.036
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3099.9400.0510.0090.001nonzero0.027
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3099.9390.0500.0110.001nonzero0.035
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3099.9430.0460.0100.001nonzero0.020
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3099.9190.0690.0110.001nonzero0.029
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3099.9020.0870.0110.001nonzero0.043
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3099.9650.0260.0080.001nonzerononzero0.069
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3099.9380.0510.0100.001nonzero0.037
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3099.9240.0660.0100.001nonzerononzero0.094
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3099.9240.0650.0100.001nonzero0.026
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3099.9620.0300.007nonzerononzerononzero0.078

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3088.34111.6030.0560.036
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3090.9539.0010.0450.030
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3099.5860.4070.0070.022
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3098.5921.3830.0250.028
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3091.6448.3070.0490.036
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3091.9577.9600.0840.034
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3099.3240.6670.0090.027
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3097.5042.3010.1950.046
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3089.63610.3140.0500.036
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3090.4289.5050.0680.039
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3097.9471.9230.1300.043
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3097.8862.0850.0290.026
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3087.90712.0310.0620.037
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3084.73014.7900.4800.0010.067
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3099.0270.7810.192nonzero0.069
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3091.4618.2770.2620.050
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3094.2055.7170.0650.0130.103
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3091.8508.0580.0920.039
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3098.3261.6440.0270.0020.092

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3077.4172.6910.33318.6540.9050.044
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3077.2373.9770.32318.2390.2240.037
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3075.8643.0233.09417.9970.0210.029
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3078.5682.1030.48718.3060.5350.044
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3078.5632.2220.30418.0050.9060.050
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3077.5272.6360.24918.7850.8030.047
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3074.6102.6173.98418.7320.0570.029
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3076.6832.4820.43919.4060.9900.051
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3077.5022.4720.29818.7530.9760.055
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3078.5862.7170.34417.5120.8410.061
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3077.7393.1251.62517.4020.1090.031
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3077.9852.6441.94017.2090.2220.035
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3077.4343.3710.42517.8580.9110.050
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3077.5472.7830.36518.4660.8390.044
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3076.7732.5352.65517.8440.193nonzero0.074
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3077.2322.8840.31418.5161.0550.053
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3080.0598.0300.41711.4150.0750.0050.095
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3078.1532.8700.31217.6631.0010.044
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3077.68916.2731.0844.9330.0190.0020.085

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	103002	659	4.3	15870.0	189.1	0.006	0.043	3.981	48.568	393856	55.2	3.824	80	137.2	157.7	0.0	0.025	12866	11939	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
3987	103023	430	3.2	15846.1	188.4	0.004	0.032	3.975	48.402	393117	55.3	3.816	81	131.0	146.0	0.0	0.024	12903	12295	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
3987	103415	0	0.0	15738.0	144.1	0.000	0.000	3.948	37.018	396551	55.1	3.835	80	49.6	71.8	0.0	0.021	12962	12355	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
3987	104844	36	0.3	15786.3	177.5	0.000	0.003	3.960	45.603	398880	55.0	3.805	79	109.7	143.4	0.0	0.023	13026	12530	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
3987	105223	635	4.4	15838.2	197.8	0.006	0.043	3.973	50.814	398333	55.2	3.786	79	141.5	205.2	0.0	0.026	13217	12231	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
3987	101793	593	3.4	15991.7	307.9	0.006	0.034	4.011	79.080	389881	55.2	3.830	81	133.0	153.7	0.0	0.024	12695	11715	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
3988	103623	0	0.0	15707.8	142.3	0.000	0.000	3.939	36.547	396412	55.3	3.826	80	50.0	72.5	0.0	0.023	12930	12339	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
3987	103268	0	0.0	15744.2	150.8	0.000	0.000	3.949	38.740	394947	55.1	3.824	80	57.0	73.1	0.0	0.031	12962	12003	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
3987	105436	574	4.1	15414.9	177.0	0.005	0.040	3.867	45.469	402582	55.2	3.818	79	145.2	165.6	0.0	0.036	13346	12482	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
3987	104486	758	5.1	15908.1	245.7	0.007	0.050	3.990	63.117	397392	55.2	3.803	79	137.0	187.0	0.0	0.027	13026	11843	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
3987	102105	219	1.6	16058.7	377.0	0.002	0.017	4.028	96.831	391276	55.1	3.832	81	119.9	140.8	0.0	0.035	12738	11987	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
3988	102660	188	1.5	15880.5	239.5	0.002	0.015	3.982	61.506	392876	55.1	3.827	81	118.5	139.4	0.0	0.020	12882	12195	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
3988	102398	804	6.2	15920.6	263.4	0.008	0.062	3.992	67.629	391817	55.3	3.826	81	155.3	175.7	0.0	0.029	12754	11667	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
3987	101880	999	7.6	15908.7	257.8	0.010	0.077	3.990	66.224	389918	55.4	3.827	82	167.8	188.1	0.0	0.043	12866	11891	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
3988	103090	0	0.0	15713.8	145.2	0.000	0.000	3.940	37.297	394520	55.1	3.827	80	54.2	76.1	0.0	0.069	12914	12147	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
3987	102198	456	2.9	15833.3	170.2	0.004	0.029	3.972	43.715	390610	55.2	3.822	81	116.8	134.9	0.0	0.037	12775	11911	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
3987	101714	762	7.0	16190.0	248.3	0.007	0.071	4.061	63.789	391090	55.0	3.845	81	137.8	159.7	0.0	0.094	12834	10644	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
3987	102479	389	2.6	15169.2	212.7	0.004	0.026	3.805	54.640	392258	54.8	3.828	80	131.6	152.6	0.0	0.026	12642	11204	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
3987	103933	32	0.3	16217.5	183.5	0.000	0.003	4.068	47.139	398476	55.0	3.834	79	75.1	91.7	0.0	0.078	13042	11219	160m.pg153_o3_native_lto.cx7a18_4g_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:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3099.8410.1380.0190.002nonzerononzerononzero0.320
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3099.8400.1400.0190.001nonzerononzero0.102
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3099.8890.0900.0190.002nonzero0.041
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3099.9090.0730.0160.001nonzero0.026
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3099.8790.1020.0170.001nonzerononzero0.216
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3099.8330.1460.0190.002nonzerononzero0.216
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3099.8950.0880.0160.001nonzerononzero0.101
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3099.8100.1360.0400.013nonzerononzerononzero0.338
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3099.8680.1150.0150.001nonzerononzero0.246
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3099.8630.1150.0190.002nonzerononzero0.141
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3099.8270.1470.0230.002nonzerononzerononzero0.276
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3099.8630.1160.0190.002nonzerononzero0.165
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3099.8080.1680.0220.002nonzerononzero0.142
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3099.8260.1590.0120.0020.001nonzerononzero0.301
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3099.8500.1150.0240.0070.004nonzero0.096
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3099.8930.0940.0120.001nonzerononzerononzero0.545
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3099.8390.1400.0190.001nonzerononzero0.154
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3099.7340.2380.0250.003nonzerononzero0.181
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3099.9040.0840.0120.001nonzerononzero0.093

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3095.7684.0730.1150.0410.0030.326
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3095.7894.1500.0560.0050.135
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3096.8623.0030.1350.049
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3097.8632.0990.038nonzero0.113
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3096.7743.1140.0890.0230.221
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3095.5994.1900.1980.0140.220
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3097.9422.0250.0330.032
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3084.76714.5050.6790.0460.0030.377
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3096.1493.7000.1040.048nonzero0.261
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3096.8623.0560.0750.0070.152
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3096.9132.8370.2240.0240.0010.295
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3097.2692.5900.1190.0220.201
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3092.3567.4910.1360.0160.230
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3093.6495.4110.8090.1240.0070.673
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3092.1655.3242.4900.0200.106
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3099.0800.6660.1250.1020.0260.554
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3096.6183.2920.0800.0100.173
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3092.6957.0320.2540.0180.185
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3098.0121.9530.0330.0020.097

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg153_o3_native_lto.cx7a_4g_gcp_c2s3079.2393.9270.62910.7755.4250.0050.0010.322
pg153_o3_native_lto.cx7a1_4g_gcp_c2s3075.2076.0121.99911.5105.272nonzero0.070
pg153_o3_native_lto.cx7a2_4g_gcp_c2s3076.5194.3083.82312.2053.1450.050
pg153_o3_native_lto.cx7a3_4g_gcp_c2s3078.3253.7961.25511.1795.4460.061
pg153_o3_native_lto.cx7a4_4g_gcp_c2s3078.1283.8330.58911.5975.8490.0040.148
pg153_o3_native_lto.cx7a5_4g_gcp_c2s3078.0224.5950.55611.4335.3920.0020.190
pg153_o3_native_lto.cx7a6_4g_gcp_c2s3077.0243.9013.28312.9932.7980.051
pg153_o3_native_lto.cx7a7_4g_gcp_c2s3072.4097.5852.09412.1245.7800.007nonzero0.337
pg153_o3_native_lto.cx7a8_4g_gcp_c2s3079.6093.3650.48510.9455.5880.0080.246
pg153_o3_native_lto.cx7a9_4g_gcp_c2s3078.0294.2600.63211.0156.0640.0010.141
pg153_o3_native_lto.cx7a10_4g_gcp_c2s3076.1905.2881.86011.7794.8790.004nonzero0.263
pg153_o3_native_lto.cx7a11_4g_gcp_c2s3076.5824.2702.11711.6745.3550.0030.161
pg153_o3_native_lto.cx7a12_4g_gcp_c2s3079.1234.1560.50910.5355.6770.0010.139
pg153_o3_native_lto.cx7a13_4g_gcp_c2s3079.3044.4050.35112.2123.7270.0010.187
pg153_o3_native_lto.cx7a14_4g_gcp_c2s3074.8005.6022.62812.9284.0390.0030.088
pg153_o3_native_lto.cx7a15_4g_gcp_c2s3079.4053.5190.72713.4552.8630.0270.0030.547
pg153_o3_native_lto.cx7a16_4g_gcp_c2s3076.5199.5512.29811.5500.0780.0030.152
pg153_o3_native_lto.cx7a17_4g_gcp_c2s3077.3904.9070.55110.9696.1790.0030.183
pg153_o3_native_lto.cx7a18_4g_gcp_c2s3079.62314.9731.5613.8230.0200.0010.092

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	97615	656	6.9	30722.7	308.7	0.007	0.073	3.851	39.621	369246	57.9	3.783	89	137.2	164.4	0.0	0.320	12386	9925	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
7976	95932	647	4.9	30642.8	290.1	0.007	0.052	3.842	37.246	361328	58.4	3.766	91	131.0	148.7	0.0	0.102	12055	10053	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
7973	96796	0	0.0	30500.5	272.4	0.000	0.000	3.825	34.987	367970	57.6	3.802	89	49.4	78.7	0.0	0.041	12226	10553	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
7976	98416	63	0.6	30652.6	384.1	0.001	0.006	3.843	49.316	369604	58.0	3.756	88	109.7	131.3	0.0	0.026	12410	11000	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
7976	99320	362	8.7	30654.4	338.7	0.004	0.089	3.844	43.489	370108	58.1	3.726	88	141.5	201.0	0.0	0.216	12466	10021	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
7976	95541	833	5.9	30809.6	420.5	0.009	0.063	3.863	53.990	361617	58.0	3.785	91	133.0	159.8	0.0	0.216	12104	10165	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
7976	97889	0	0.0	30529.5	269.9	0.000	0.000	3.828	34.648	370078	57.9	3.781	89	49.9	79.4	0.0	0.101	12241	10708	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
7978	95972	0	0.0	30451.2	309.7	0.000	0.000	3.817	39.747	366681	57.2	3.821	89	57.0	73.1	0.0	0.338	12083	10133	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
7976	100042	878	9.5	29527.1	306.2	0.009	0.097	3.702	39.317	377970	58.0	3.778	87	145.2	171.8	0.0	0.246	12642	10309	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
7976	99165	335	8.5	30667.0	392.6	0.003	0.088	3.845	50.403	370455	58.1	3.736	88	137.0	181.9	0.0	0.141	12466	10388	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
7976	95529	684	4.8	30682.8	451.3	0.007	0.052	3.847	57.941	362465	57.9	3.794	91	119.9	147.2	0.0	0.276	11848	10006	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
7976	96835	553	5.2	30702.5	388.3	0.006	0.055	3.850	49.851	366023	58.2	3.780	90	118.5	145.7	0.0	0.165	12120	10293	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
7976	96427	937	12.6	30720.0	449.2	0.010	0.134	3.852	57.679	365423	58.1	3.790	90	155.3	181.8	0.0	0.142	11939	9651	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
7971	91058	1262	14.6	29901.4	438.7	0.014	0.164	3.751	56.357	349899	57.9	3.843	95	167.8	195.1	0.0	0.301	11603	8503	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
7976	96807	0	0.0	30436.1	275.4	0.000	0.000	3.816	35.356	366384	56.8	3.785	88	53.7	82.9	0.0	0.096	12231	9893	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
7973	94806	586	3.9	30648.0	314.0	0.006	0.042	3.844	40.322	362852	57.7	3.827	91	116.8	143.2	0.0	0.545	12119	8183	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
7976	97278	774	9.9	30650.1	346.9	0.008	0.104	3.843	44.535	372401	57.1	3.828	88	137.8	165.1	0.0	0.154	12370	10261	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
7976	94598	951	6.3	25569.4	296.5	0.010	0.069	3.206	38.063	360318	57.1	3.809	91	131.6	158.3	0.0	0.181	12039	9497	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
7973	98473	38	0.3	30911.5	365.4	0.000	0.003	3.877	46.929	376395	57.0	3.822	87	75.1	93.9	0.0	0.093	12401	10682	160m.pg153_o3_native_lto.cx7a18_4g_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
1012658	0	0	0.0	4987.3	410.3	0.000	0.000	0.005	0.415	84219	75.3	0.083	11	15.3	41.4	0.0	0.748	146738	42669	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
1012658	0	0	0.0	4927.1	406.0	0.000	0.000	0.005	0.411	84498	75.5	0.083	11	15.3	41.4	0.0	0.565	146440	33663	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
1012658	0	0	0.0	5073.9	406.6	0.000	0.000	0.005	0.411	83933	75.5	0.083	11	15.3	41.4	0.0	0.387	147538	31077	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
1012658	0	0	0.0	5052.4	406.0	0.000	0.000	0.005	0.411	83777	75.8	0.083	11	15.3	41.4	0.0	0.434	147740	22887	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
1019108	0	0	0.0	5099.3	406.2	0.000	0.000	0.005	0.408	83934	75.6	0.082	11	15.3	41.4	0.0	0.389	147039	34162	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
1006289	0	0	0.0	5094.8	403.3	0.000	0.000	0.005	0.410	83353	76.0	0.083	11	15.3	41.4	0.0	0.644	146297	28968	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
1045752	0	0	0.0	5033.5	418.2	0.000	0.000	0.005	0.410	89790	77.7	0.086	11	15.3	41.6	0.0	0.339	147040	72321	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
1019108	0	0	0.0	3516.7	336.9	0.000	0.000	0.003	0.338	86409	76.4	0.085	11	15.3	31.4	0.0	0.307	145042	36360	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
1006289	0	0	0.0	3680.3	376.9	0.000	0.000	0.004	0.384	84315	75.6	0.084	11	15.3	41.4	0.0	0.379	146242	13286	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
1019108	0	0	0.0	5084.8	407.8	0.000	0.000	0.005	0.410	84696	75.9	0.083	11	15.3	41.4	0.0	0.357	146939	11687	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
1012658	0	0	0.0	5009.0	406.1	0.000	0.000	0.005	0.411	83655	76.2	0.083	11	15.3	41.4	0.0	0.557	146841	15283	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
1019108	0	0	0.0	4627.1	404.7	0.000	0.000	0.005	0.407	84386	75.8	0.083	11	15.3	41.4	NA	0.624	147193	23574	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
1032258	0	0	0.0	5083.0	421.6	0.000	0.000	0.005	0.418	85309	77.4	0.083	11	15.3	41.4	NA	0.351	148739	26771	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
1038961	0	0	0.0	5028.4	415.2	0.000	0.000	0.005	0.409	88826	77.7	0.085	11	15.3	41.6	0.0	0.772	147538	30778	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
969697	0	0	0.0	4527.3	388.0	0.000	0.000	0.005	0.410	77119	70.9	0.080	11	15.3	41.4	0.0	0.874	149036	10588	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
946746	0	0	0.0	4136.7	395.9	0.000	0.000	0.004	0.428	76310	70.4	0.081	11	15.3	42.9	0.0	1.386	148538	4295	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
1012658	0	0	0.0	5148.3	407.4	0.000	0.000	0.005	0.412	84233	75.5	0.083	11	15.3	41.4	0.0	0.499	147039	35461	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
1006289	0	0	0.0	4513.9	397.2	0.000	0.000	0.004	0.404	85387	75.2	0.085	11	15.3	41.4	0.0	0.243	146941	32764	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
1012658	0	0	0.0	5116.9	410.0	0.000	0.000	0.005	0.415	83565	76.0	0.083	11	15.3	41.4	0.0	0.474	146395	40571	160m.pg153_o3_native_lto.cx7a18_4g_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
2287143	0	0	0.0	1548.0	577.2	0.000	0.000	0.001	0.258	15066	37.3	0.007	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
2389552	0	0	0.0	1274.7	444.0	0.000	0.000	0.001	0.190	8504	41.2	0.004	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
2254930	0	0	0.0	1571.6	562.1	0.000	0.000	0.001	0.255	14541	37.9	0.006	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
2254930	0	0	0.0	1509.2	564.2	0.000	0.000	0.001	0.256	15285	38.1	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
2223611	0	0	0.0	1565.7	559.9	0.000	0.000	0.001	0.258	15825	38.3	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
2223611	0	0	0.0	1562.3	561.2	0.000	0.000	0.001	0.258	14893	38.3	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
2254930	0	0	0.0	1462.6	545.9	0.000	0.000	0.001	0.248	9033	37.6	0.004	3	29.4	68.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
2541270	0	0	0.0	1322.1	435.6	0.000	0.000	0.001	0.176	15640	43.5	0.006	3	29.4	45.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
2163514	0	0	0.0	3068.7	587.7	0.000	0.000	0.001	0.278	14423	39.4	0.007	3	29.4	67.8	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
2287143	0	0	0.0	1590.1	581.7	0.000	0.000	0.001	0.260	15596	38.1	0.007	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
2254930	0	0	0.0	1572.4	578.5	0.000	0.000	0.001	0.263	15629	37.9	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
2223611	0	0	0.0	1507.1	558.2	0.000	0.000	0.001	0.257	15721	38.1	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
2287143	0	0	0.0	1533.1	574.1	0.000	0.000	0.001	0.257	14268	38.1	0.006	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
2193151	0	0	0.0	1438.9	540.7	0.000	0.000	0.001	0.252	13020	37.8	0.006	3	29.4	68.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
1759341	0	0	0.0	1214.4	454.6	0.000	0.000	0.001	0.265	12549	29.9	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
2001250	0	0	0.0	1237.0	414.5	0.000	0.000	0.001	0.212	14863	33.2	0.007	2	29.4	61.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
2287143	0	0	0.0	1607.2	579.2	0.000	0.000	0.001	0.259	15297	37.9	0.007	2	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
2223611	0	0	0.0	1608.9	562.7	0.000	0.000	0.001	0.259	15835	37.7	0.007	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
2389552	0	0	0.0	1277.0	431.3	0.000	0.000	0.001	0.185	7584	40.6	0.003	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a18_4g_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
110299	0	1552	27.3	58532.9	1326.7	0.014	0.254	0.531	12.317	72270	51.3	0.655	70	137.1	207.2	NA	0.294	15635	1099	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
122963	0	1808	25.0	56404.5	1326.6	0.015	0.208	0.459	11.048	77575	57.8	0.631	71	131.0	201.1	NA	0.297	17331	1049	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
71988	0	35	0.2	171201.9	1445.2	0.000	0.003	2.378	20.558	49204	53.9	0.684	112	49.7	107.9	NA	0.097	9693	2098	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
137836	0	1050	13.8	53204.9	1315.5	0.008	0.103	0.386	9.773	85883	63.5	0.623	69	110.1	157.1	NA	0.424	19778	649	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
108108	0	1634	29.2	59244.8	1320.2	0.015	0.276	0.548	12.505	70013	50.9	0.648	71	141.4	211.5	NA	0.297	14784	600	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
108430	0	1837	31.4	58561.1	1316.7	0.017	0.297	0.540	12.434	70760	52.5	0.653	73	133.0	203.1	NA	0.347	15640	200	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
72196	0	46	0.2	172007.3	1446.9	0.001	0.003	2.383	20.522	50094	53.9	0.694	112	50.0	108.5	NA	5.172	9693	2049	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
51059	0	0	0.0	64239.1	1224.9	0.000	0.000	1.258	24.565	44639	31.2	0.874	92	57.1	73.1	NA	0.298	5244	699	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
113652	0	1740	32.5	58914.1	1311.7	0.015	0.293	0.518	11.818	68791	50.7	0.605	67	145.1	215.2	NA	0.320	16688	1199	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
110834	0	1616	28.1	57033.1	1310.4	0.015	0.260	0.515	12.107	72014	52.5	0.650	71	137.0	207.1	NA	0.305	15383	600	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
109290	0	1833	35.0	56061.3	1300.1	0.017	0.328	0.513	12.181	70754	54.2	0.647	74	122.6	192.6	NA	0.288	15791	499	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
111281	0	1858	32.6	55870.2	1304.6	0.017	0.300	0.502	12.005	72303	53.9	0.650	73	122.1	192.7	NA	0.462	15838	400	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
109529	0	1479	28.2	56657.3	1311.5	0.014	0.264	0.517	12.262	72357	51.6	0.661	71	155.3	225.4	NA	0.649	14734	999	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
65590	0	926	17.8	29156.7	730.9	0.014	0.278	0.445	11.410	42389	30.2	0.646	69	167.8	237.9	NA	3.943	7683	0	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
35450	0	0	0.0	85556.9	742.6	0.000	0.000	2.413	21.451	24728	22.1	0.698	94	54.2	98.9	0.0	2.445	4745	1398	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
32755	0	414	7.2	36868.0	671.8	0.013	0.224	1.126	21.002	25040	17.4	0.764	80	125.0	157.1	NA	14.734	3197	300	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
110345	0	1644	30.5	57482.3	1319.8	0.015	0.283	0.521	12.247	71749	51.6	0.650	70	137.8	207.9	NA	0.317	15688	1449	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
108725	0	1623	31.4	54530.5	1317.9	0.015	0.296	0.502	12.412	71235	51.5	0.655	71	131.5	201.6	NA	0.314	15383	1199	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
127105	0	1444	15.1	54350.1	1307.7	0.011	0.121	0.428	10.535	81410	62.1	0.640	73	75.8	144.8	NA	1.984	18630	749	160m.pg153_o3_native_lto.cx7a18_4g_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	110829	512	4.2	3382.8	36.9	0.005	0.039	4.243	47.347	423400	53.0	3.820	72	137.2	179.4	0.0	0.134	13953	13489	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
797	109934	474	4.1	3353.2	36.2	0.004	0.038	4.206	46.452	419974	53.0	3.820	72	131.0	180.2	0.0	0.094	13894	12195	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
797	111294	0	0.0	3419.8	33.0	0.000	0.000	4.289	42.355	424784	52.8	3.817	71	49.6	73.9	0.0	0.005	13889	13655	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
798	111847	84	0.6	3357.9	35.6	0.001	0.006	4.210	45.728	426110	53.0	3.810	71	109.7	149.2	0.0	0.127	13969	13713	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
798	110740	568	4.5	3353.9	38.1	0.005	0.041	4.206	48.945	422340	53.1	3.814	72	141.5	211.5	0.0	0.145	13985	13761	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
797	109897	515	4.4	3395.3	65.2	0.005	0.041	4.258	83.690	419927	52.9	3.821	72	133.0	177.0	0.0	0.273	13809	13457	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
797	112537	0	0.0	3368.3	32.2	0.000	0.000	4.225	41.312	429441	52.9	3.816	71	50.0	74.5	0.0	0.007	14049	13841	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
797	110480	0	0.0	3411.9	34.7	0.000	0.000	4.279	44.530	421773	52.7	3.818	72	57.0	68.7	0.0	0.004	13873	13649	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
797	112080	472	4.3	3381.8	39.8	0.004	0.039	4.242	51.086	428263	52.8	3.821	71	145.1	187.3	0.0	0.182	14112	5626	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
797	110358	465	4.0	3364.0	50.7	0.004	0.037	4.219	65.143	421275	53.0	3.817	72	137.0	200.1	0.0	0.128	13750	13505	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
797	110586	280	2.1	3434.9	92.0	0.003	0.020	4.308	118.106	422246	53.0	3.818	72	119.9	163.5	0.0	0.123	13953	13191	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
797	110595	226	1.4	3366.1	57.9	0.002	0.013	4.222	74.331	422273	53.1	3.818	72	118.5	162.1	0.0	0.112	13921	13655	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
797	109879	653	5.9	3412.5	55.2	0.006	0.055	4.280	70.876	419988	53.0	3.822	72	155.3	200.3	0.0	0.132	13713	13457	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
797	109928	744	5.9	3382.5	52.3	0.007	0.055	4.242	67.155	420129	53.0	3.822	72	167.8	211.8	0.0	0.308	13953	13217	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
798	110799	0	0.0	3398.6	32.9	0.000	0.000	4.262	42.216	422859	52.9	3.816	72	54.2	74.1	0.0	0.004	13905	13665	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
797	109543	448	4.7	3375.5	45.6	0.004	0.043	4.234	58.578	418638	52.9	3.822	72	116.8	133.2	0.0	0.225	13713	10085	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
797	110110	355	3.5	3397.1	52.0	0.003	0.033	4.261	66.729	420635	53.0	3.820	72	137.8	181.7	0.0	0.120	13761	13521	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
797	110578	550	2.8	3384.4	48.6	0.005	0.026	4.245	62.453	422304	53.1	3.819	72	131.6	175.3	0.0	0.130	13841	13617	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
797	110277	4	0.0	3366.5	38.5	0.000	0.000	4.222	49.403	420876	53.0	3.817	72	75.1	120.4	0.0	0.009	13847	13617	160m.pg153_o3_native_lto.cx7a18_4g_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	103002	659	4.3	15870.0	189.1	0.006	0.043	3.981	48.568	393856	55.2	3.824	80	137.2	157.7	0.0	0.025	12866	11939	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
3987	103023	430	3.2	15846.1	188.4	0.004	0.032	3.975	48.402	393117	55.3	3.816	81	131.0	146.0	0.0	0.024	12903	12295	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
3987	103415	0	0.0	15738.0	144.1	0.000	0.000	3.948	37.018	396551	55.1	3.835	80	49.6	71.8	0.0	0.021	12962	12355	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
3987	104844	36	0.3	15786.3	177.5	0.000	0.003	3.960	45.603	398880	55.0	3.805	79	109.7	143.4	0.0	0.023	13026	12530	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
3987	105223	635	4.4	15838.2	197.8	0.006	0.043	3.973	50.814	398333	55.2	3.786	79	141.5	205.2	0.0	0.026	13217	12231	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
3987	101793	593	3.4	15991.7	307.9	0.006	0.034	4.011	79.080	389881	55.2	3.830	81	133.0	153.7	0.0	0.024	12695	11715	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
3988	103623	0	0.0	15707.8	142.3	0.000	0.000	3.939	36.547	396412	55.3	3.826	80	50.0	72.5	0.0	0.023	12930	12339	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
3987	103268	0	0.0	15744.2	150.8	0.000	0.000	3.949	38.740	394947	55.1	3.824	80	57.0	73.1	0.0	0.031	12962	12003	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
3987	105436	574	4.1	15414.9	177.0	0.005	0.040	3.867	45.469	402582	55.2	3.818	79	145.2	165.6	0.0	0.036	13346	12482	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
3987	104486	758	5.1	15908.1	245.7	0.007	0.050	3.990	63.117	397392	55.2	3.803	79	137.0	187.0	0.0	0.027	13026	11843	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
3987	102105	219	1.6	16058.7	377.0	0.002	0.017	4.028	96.831	391276	55.1	3.832	81	119.9	140.8	0.0	0.035	12738	11987	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
3988	102660	188	1.5	15880.5	239.5	0.002	0.015	3.982	61.506	392876	55.1	3.827	81	118.5	139.4	0.0	0.020	12882	12195	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
3988	102398	804	6.2	15920.6	263.4	0.008	0.062	3.992	67.629	391817	55.3	3.826	81	155.3	175.7	0.0	0.029	12754	11667	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
3987	101880	999	7.6	15908.7	257.8	0.010	0.077	3.990	66.224	389918	55.4	3.827	82	167.8	188.1	0.0	0.043	12866	11891	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
3988	103090	0	0.0	15713.8	145.2	0.000	0.000	3.940	37.297	394520	55.1	3.827	80	54.2	76.1	0.0	0.069	12914	12147	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
3987	102198	456	2.9	15833.3	170.2	0.004	0.029	3.972	43.715	390610	55.2	3.822	81	116.8	134.9	0.0	0.037	12775	11911	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
3987	101714	762	7.0	16190.0	248.3	0.007	0.071	4.061	63.789	391090	55.0	3.845	81	137.8	159.7	0.0	0.094	12834	10644	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
3987	102479	389	2.6	15169.2	212.7	0.004	0.026	3.805	54.640	392258	54.8	3.828	80	131.6	152.6	0.0	0.026	12642	11204	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
3987	103933	32	0.3	16217.5	183.5	0.000	0.003	4.068	47.139	398476	55.0	3.834	79	75.1	91.7	0.0	0.078	13042	11219	160m.pg153_o3_native_lto.cx7a18_4g_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	97615	656	6.9	30722.7	308.7	0.007	0.073	3.851	39.621	369246	57.9	3.783	89	137.2	164.4	0.0	0.320	12386	9925	160m.pg153_o3_native_lto.cx7a_4g_gcp_c2s30
7976	95932	647	4.9	30642.8	290.1	0.007	0.052	3.842	37.246	361328	58.4	3.766	91	131.0	148.7	0.0	0.102	12055	10053	160m.pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
7973	96796	0	0.0	30500.5	272.4	0.000	0.000	3.825	34.987	367970	57.6	3.802	89	49.4	78.7	0.0	0.041	12226	10553	160m.pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
7976	98416	63	0.6	30652.6	384.1	0.001	0.006	3.843	49.316	369604	58.0	3.756	88	109.7	131.3	0.0	0.026	12410	11000	160m.pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
7976	99320	362	8.7	30654.4	338.7	0.004	0.089	3.844	43.489	370108	58.1	3.726	88	141.5	201.0	0.0	0.216	12466	10021	160m.pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
7976	95541	833	5.9	30809.6	420.5	0.009	0.063	3.863	53.990	361617	58.0	3.785	91	133.0	159.8	0.0	0.216	12104	10165	160m.pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
7976	97889	0	0.0	30529.5	269.9	0.000	0.000	3.828	34.648	370078	57.9	3.781	89	49.9	79.4	0.0	0.101	12241	10708	160m.pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
7978	95972	0	0.0	30451.2	309.7	0.000	0.000	3.817	39.747	366681	57.2	3.821	89	57.0	73.1	0.0	0.338	12083	10133	160m.pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
7976	100042	878	9.5	29527.1	306.2	0.009	0.097	3.702	39.317	377970	58.0	3.778	87	145.2	171.8	0.0	0.246	12642	10309	160m.pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
7976	99165	335	8.5	30667.0	392.6	0.003	0.088	3.845	50.403	370455	58.1	3.736	88	137.0	181.9	0.0	0.141	12466	10388	160m.pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
7976	95529	684	4.8	30682.8	451.3	0.007	0.052	3.847	57.941	362465	57.9	3.794	91	119.9	147.2	0.0	0.276	11848	10006	160m.pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
7976	96835	553	5.2	30702.5	388.3	0.006	0.055	3.850	49.851	366023	58.2	3.780	90	118.5	145.7	0.0	0.165	12120	10293	160m.pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
7976	96427	937	12.6	30720.0	449.2	0.010	0.134	3.852	57.679	365423	58.1	3.790	90	155.3	181.8	0.0	0.142	11939	9651	160m.pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
7971	91058	1262	14.6	29901.4	438.7	0.014	0.164	3.751	56.357	349899	57.9	3.843	95	167.8	195.1	0.0	0.301	11603	8503	160m.pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
7976	96807	0	0.0	30436.1	275.4	0.000	0.000	3.816	35.356	366384	56.8	3.785	88	53.7	82.9	0.0	0.096	12231	9893	160m.pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
7973	94806	586	3.9	30648.0	314.0	0.006	0.042	3.844	40.322	362852	57.7	3.827	91	116.8	143.2	0.0	0.545	12119	8183	160m.pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
7976	97278	774	9.9	30650.1	346.9	0.008	0.104	3.843	44.535	372401	57.1	3.828	88	137.8	165.1	0.0	0.154	12370	10261	160m.pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
7976	94598	951	6.3	25569.4	296.5	0.010	0.069	3.206	38.063	360318	57.1	3.809	91	131.6	158.3	0.0	0.181	12039	9497	160m.pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
7973	98473	38	0.3	30911.5	365.4	0.000	0.003	3.877	46.929	376395	57.0	3.822	87	75.1	93.9	0.0	0.093	12401	10682	160m.pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	97.709	2.219	0.049	0.006	0.015	0.002	0.000	0.000	0.000	0.748	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
0.000	97.956	1.973	0.049	0.009	0.009	0.004	0.000	0.000	0.000	0.565	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
0.000	97.874	2.054	0.046	0.009	0.013	0.003	0.000	0.000	0.000	0.387	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
0.000	98.162	1.766	0.049	0.004	0.016	0.003	0.000	0.000	0.000	0.434	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
0.000	97.951	1.975	0.048	0.009	0.015	0.002	0.000	0.000	0.000	0.389	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
0.000	98.012	1.913	0.047	0.010	0.015	0.002	0.000	0.000	0.000	0.644	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
0.000	98.145	1.827	0.018	0.007	0.003	0.001	0.000	0.000	0.000	0.339	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
0.000	98.010	1.920	0.049	0.009	0.011	0.001	0.000	0.000	0.000	0.307	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
0.000	97.721	2.209	0.043	0.012	0.012	0.003	0.000	0.000	0.000	0.379	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
0.000	98.130	1.789	0.052	0.008	0.019	0.001	0.000	0.000	0.000	0.357	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
0.000	98.021	1.905	0.050	0.007	0.015	0.002	0.000	0.000	0.000	0.557	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
0.000	98.016	1.912	0.048	0.008	0.015	0.001	0.000	0.000	0.000	0.624	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
0.000	98.192	1.740	0.053	0.006	0.008	0.001	0.000	0.000	0.000	0.351	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
0.000	98.414	1.552	0.022	0.007	0.003	0.002	0.000	0.000	0.000	0.772	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
0.000	98.144	1.783	0.043	0.006	0.010	0.014	0.000	0.000	0.000	0.874	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
0.000	97.688	2.138	0.080	0.070	0.013	0.011	0.001	0.000	0.000	1.386	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
0.000	97.974	1.954	0.049	0.007	0.015	0.002	0.000	0.000	0.000	0.499	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
0.000	98.008	1.896	0.055	0.018	0.022	0.000	0.000	0.000	0.000	0.243	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
0.000	97.855	2.074	0.050	0.005	0.013	0.003	0.000	0.000	0.000	0.474	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

l.x

TODO - determine whether there is data for create index response time


l.i1

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	92.711	5.267	1.921	0.101	nonzero	0.000	0.000	0.000	0.294	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
0.000	0.043	95.383	3.732	0.795	0.047	nonzero	0.000	0.000	0.000	0.297	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
0.000	0.070	88.127	7.180	4.623	nonzero	0.000	0.000	0.000	0.000	0.097	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
0.000	nonzero	98.488	1.316	0.183	0.013	nonzero	0.000	0.000	0.000	0.424	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
0.000	0.000	92.138	5.703	2.051	0.108	nonzero	0.000	0.000	0.000	0.297	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
0.000	0.030	93.182	5.036	1.664	0.088	nonzero	0.000	0.000	0.000	0.347	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
0.000	0.047	87.478	8.250	4.186	0.037	0.001	0.000	nonzero	0.000	5.172	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
0.000	nonzero	79.810	11.244	7.036	1.910	nonzero	0.000	0.000	0.000	0.298	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
0.000	0.005	93.087	4.786	2.011	0.110	nonzero	0.000	0.000	0.000	0.320	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
0.000	0.000	93.632	4.511	1.762	0.095	nonzero	0.000	0.000	0.000	0.305	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
0.000	0.001	93.938	4.524	1.456	0.081	nonzero	0.000	0.000	0.000	0.288	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
0.000	0.001	94.193	4.099	1.619	0.088	nonzero	0.000	0.000	0.000	0.462	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
0.000	0.000	94.529	4.166	0.944	0.355	0.005	0.000	0.000	0.000	0.649	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
0.000	0.000	91.766	3.302	3.955	0.876	0.080	0.020	0.000	0.000	3.943	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
0.000	0.004	68.697	5.607	25.466	0.226	0.000	nonzero	0.000	0.000	2.445	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
0.000	0.000	81.139	4.058	9.221	5.541	0.040	0.000	nonzero	0.000	14.734	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
0.000	nonzero	93.217	4.782	1.898	0.102	nonzero	0.000	0.000	0.000	0.317	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
0.000	0.002	92.446	5.550	1.898	0.104	nonzero	0.000	0.000	0.000	0.314	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
0.000	0.339	96.907	2.142	0.576	0.036	nonzero	nonzero	0.000	0.000	1.984	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
87.731	10.399	0.639	0.460	0.718	0.052	nonzero	0.000	0.000	0.000	0.305	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
83.299	15.275	0.654	0.278	0.436	0.058	nonzero	0.000	0.000	0.000	0.364	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
78.202	7.944	0.519	7.646	5.687	0.002	nonzero	0.000	0.000	0.000	0.501	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
90.053	8.638	0.544	0.249	0.402	0.113	nonzero	0.000	0.000	0.000	0.422	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
84.600	13.303	0.662	0.652	0.708	0.075	nonzero	0.000	0.000	0.000	0.381	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
86.615	11.464	0.702	0.393	0.724	0.102	nonzero	0.000	0.000	0.000	0.370	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
78.598	7.956	0.413	7.850	5.163	0.020	nonzero	0.000	0.000	0.000	0.450	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
72.524	18.003	1.278	2.967	4.364	0.863	nonzero	0.000	0.000	0.000	0.364	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
83.865	13.898	0.724	0.768	0.671	0.073	nonzero	0.000	0.000	0.000	0.328	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
85.801	12.065	0.664	0.607	0.780	0.083	nonzero	0.000	0.000	0.000	0.432	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
88.114	9.765	0.587	0.581	0.766	0.186	nonzero	0.000	0.000	0.000	0.357	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
88.681	9.217	0.621	0.622	0.748	0.112	nonzero	0.000	0.000	0.000	0.410	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
85.827	12.638	0.549	0.442	0.450	0.093	0.002	0.000	0.000	0.000	0.599	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
86.923	11.906	0.359	0.324	0.253	0.212	0.020	0.003	0.000	0.000	3.939	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
77.621	16.356	0.427	2.590	2.924	0.083	nonzero	nonzero	0.000	0.000	1.042	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
69.116	24.944	0.630	1.116	2.640	1.537	0.017	0.000	nonzero	0.000	14.743	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
86.361	11.975	0.597	0.433	0.576	0.057	nonzero	0.000	0.000	0.000	0.313	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
85.777	12.586	0.538	0.518	0.480	0.100	nonzero	0.000	0.000	0.000	0.304	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
87.659	10.399	0.706	0.127	1.069	0.041	nonzero	nonzero	0.000	0.000	1.998	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

q100.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.952	0.046	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.134	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
99.948	0.051	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.094	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
99.989	0.010	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.127	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
99.949	0.050	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.145	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
99.951	0.048	0.001	nonzero	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.273	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
99.994	0.005	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
99.995	0.005	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
99.939	0.059	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.182	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
99.950	0.048	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.128	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
99.977	0.021	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.123	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
99.981	0.018	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.112	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
99.935	0.063	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.132	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
99.949	0.050	0.001	nonzero	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.308	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
99.995	0.005	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
99.949	0.050	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.225	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
99.962	0.037	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.120	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
99.966	0.033	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.130	pg153_o3_native_lto.cx7a17_4g_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.cx7a18_4g_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	77.406	22.297	0.280	0.017	0.000	0.000	0.000	0.000	0.224	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
0.000	0.000	79.354	20.194	0.431	0.021	0.000	0.000	0.000	0.000	0.150	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
0.000	0.000	97.559	2.415	0.023	0.003	0.000	0.000	0.000	0.000	0.134	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
0.000	0.000	77.488	22.139	0.366	0.007	0.000	0.000	0.000	0.000	0.122	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
0.000	0.000	72.288	27.238	0.469	0.003	0.002	0.000	0.000	0.000	0.274	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
0.000	0.000	99.995	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
0.000	0.000	100.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
0.000	0.000	79.689	19.771	0.510	0.026	0.003	0.000	0.000	0.000	0.331	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
0.000	0.000	83.568	16.113	0.300	0.019	0.000	0.000	0.000	0.000	0.223	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
0.000	0.000	87.748	12.149	0.087	0.016	0.000	0.000	0.000	0.000	0.168	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
0.000	0.000	88.566	11.377	0.043	0.009	0.005	0.000	0.000	0.000	0.354	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
0.000	0.000	68.785	30.597	0.604	0.010	0.003	0.000	0.000	0.000	0.391	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
0.000	0.000	75.003	24.604	0.373	0.017	0.002	0.000	0.000	0.000	0.482	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
0.000	0.000	78.224	21.314	0.427	0.028	0.007	0.000	0.000	0.000	0.592	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
0.000	0.000	81.312	18.384	0.299	0.005	0.000	0.000	0.000	0.000	0.154	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
0.000	0.000	85.474	14.382	0.120	0.021	0.003	0.000	0.000	0.000	0.302	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
0.000	0.000	99.542	0.457	0.002	0.000	0.000	0.000	0.000	0.000	0.017	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
38.863	48.995	12.128	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
33.681	53.700	12.615	0.003	0.002	0.000	0.000	0.000	0.000	0.000	0.022	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
66.323	26.970	3.698	3.009	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
39.679	49.734	10.580	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
38.163	49.712	12.118	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
38.752	48.845	12.403	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
66.602	29.630	3.767	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
39.873	49.816	10.311	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
36.856	49.271	13.865	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
40.950	49.970	9.069	0.009	0.002	0.000	0.000	0.000	0.000	0.000	0.056	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
45.590	46.918	7.483	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
44.240	45.957	9.800	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
39.665	50.274	10.059	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.018	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
38.880	51.068	10.052	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
53.420	33.866	12.714	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
40.043	48.917	11.038	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.045	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
42.198	49.755	8.042	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
38.719	50.962	10.312	0.005	0.000	0.002	0.000	0.000	0.000	0.000	0.068	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
40.161	50.156	9.667	0.016	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

q500.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.926	0.063	0.010	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
99.949	0.043	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
99.968	0.024	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.021	pg153_o3_native_lto.cx7a2_4g_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.cx7a3_4g_gcp_c2s30
99.960	0.032	0.007	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
99.929	0.060	0.010	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
99.966	0.025	0.008	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.023	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
99.957	0.032	0.010	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.031	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
99.948	0.042	0.009	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
99.940	0.051	0.009	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.027	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
99.939	0.050	0.011	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
99.943	0.046	0.010	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
99.919	0.069	0.011	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.029	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
99.902	0.087	0.011	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.043	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
99.965	0.026	0.008	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.069	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
99.938	0.051	0.010	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
99.924	0.066	0.010	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.094	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
99.924	0.065	0.010	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
99.962	0.030	0.007	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.078	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	88.341	11.603	0.056	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
0.000	0.000	90.953	9.001	0.045	0.000	0.000	0.000	0.000	0.000	0.030	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
0.000	0.000	99.586	0.407	0.007	0.000	0.000	0.000	0.000	0.000	0.022	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
0.000	0.000	98.592	1.383	0.025	0.000	0.000	0.000	0.000	0.000	0.028	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
0.000	0.000	91.644	8.307	0.049	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
0.000	0.000	91.957	7.960	0.084	0.000	0.000	0.000	0.000	0.000	0.034	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
0.000	0.000	99.324	0.667	0.009	0.000	0.000	0.000	0.000	0.000	0.027	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
0.000	0.000	97.504	2.301	0.195	0.000	0.000	0.000	0.000	0.000	0.046	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
0.000	0.000	89.636	10.314	0.050	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
0.000	0.000	90.428	9.505	0.068	0.000	0.000	0.000	0.000	0.000	0.039	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
0.000	0.000	97.947	1.923	0.130	0.000	0.000	0.000	0.000	0.000	0.043	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
0.000	0.000	97.886	2.085	0.029	0.000	0.000	0.000	0.000	0.000	0.026	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
0.000	0.000	87.907	12.031	0.062	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
0.000	0.000	84.730	14.790	0.480	0.001	0.000	0.000	0.000	0.000	0.067	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
0.000	0.000	99.027	0.781	0.192	nonzero	0.000	0.000	0.000	0.000	0.069	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
0.000	0.000	91.461	8.277	0.262	0.000	0.000	0.000	0.000	0.000	0.050	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
0.000	0.000	94.205	5.717	0.065	0.013	0.000	0.000	0.000	0.000	0.103	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
0.000	0.000	91.850	8.058	0.092	0.000	0.000	0.000	0.000	0.000	0.039	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
0.000	0.000	98.326	1.644	0.027	0.002	0.000	0.000	0.000	0.000	0.092	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
77.417	2.691	0.333	18.654	0.905	0.000	0.000	0.000	0.000	0.000	0.044	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
77.237	3.977	0.323	18.239	0.224	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
75.864	3.023	3.094	17.997	0.021	0.000	0.000	0.000	0.000	0.000	0.029	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
78.568	2.103	0.487	18.306	0.535	0.000	0.000	0.000	0.000	0.000	0.044	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
78.563	2.222	0.304	18.005	0.906	0.000	0.000	0.000	0.000	0.000	0.050	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
77.527	2.636	0.249	18.785	0.803	0.000	0.000	0.000	0.000	0.000	0.047	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
74.610	2.617	3.984	18.732	0.057	0.000	0.000	0.000	0.000	0.000	0.029	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
76.683	2.482	0.439	19.406	0.990	0.000	0.000	0.000	0.000	0.000	0.051	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
77.502	2.472	0.298	18.753	0.976	0.000	0.000	0.000	0.000	0.000	0.055	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
78.586	2.717	0.344	17.512	0.841	0.000	0.000	0.000	0.000	0.000	0.061	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
77.739	3.125	1.625	17.402	0.109	0.000	0.000	0.000	0.000	0.000	0.031	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
77.985	2.644	1.940	17.209	0.222	0.000	0.000	0.000	0.000	0.000	0.035	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
77.434	3.371	0.425	17.858	0.911	0.000	0.000	0.000	0.000	0.000	0.050	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
77.547	2.783	0.365	18.466	0.839	0.000	0.000	0.000	0.000	0.000	0.044	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
76.773	2.535	2.655	17.844	0.193	nonzero	0.000	0.000	0.000	0.000	0.074	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
77.232	2.884	0.314	18.516	1.055	0.000	0.000	0.000	0.000	0.000	0.053	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
80.059	8.030	0.417	11.415	0.075	0.005	0.000	0.000	0.000	0.000	0.095	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
78.153	2.870	0.312	17.663	1.001	0.000	0.000	0.000	0.000	0.000	0.044	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
77.689	16.273	1.084	4.933	0.019	0.002	0.000	0.000	0.000	0.000	0.085	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

q1000.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.841	0.138	0.019	0.002	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.320	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
99.840	0.140	0.019	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.102	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
99.889	0.090	0.019	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.041	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
99.909	0.073	0.016	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
99.879	0.102	0.017	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.216	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
99.833	0.146	0.019	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.216	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
99.895	0.088	0.016	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.101	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
99.810	0.136	0.040	0.013	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.338	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
99.868	0.115	0.015	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.246	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
99.863	0.115	0.019	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.141	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
99.827	0.147	0.023	0.002	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.276	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
99.863	0.116	0.019	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.165	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
99.808	0.168	0.022	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.142	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
99.826	0.159	0.012	0.002	0.001	nonzero	nonzero	0.000	0.000	0.000	0.301	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
99.850	0.115	0.024	0.007	0.004	nonzero	0.000	0.000	0.000	0.000	0.096	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
99.893	0.094	0.012	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.545	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
99.839	0.140	0.019	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.154	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
99.734	0.238	0.025	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.181	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
99.904	0.084	0.012	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.093	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	95.768	4.073	0.115	0.041	0.003	0.000	0.000	0.000	0.326	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
0.000	0.000	95.789	4.150	0.056	0.005	0.000	0.000	0.000	0.000	0.135	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
0.000	0.000	96.862	3.003	0.135	0.000	0.000	0.000	0.000	0.000	0.049	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
0.000	0.000	97.863	2.099	0.038	nonzero	0.000	0.000	0.000	0.000	0.113	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
0.000	0.000	96.774	3.114	0.089	0.023	0.000	0.000	0.000	0.000	0.221	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
0.000	0.000	95.599	4.190	0.198	0.014	0.000	0.000	0.000	0.000	0.220	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
0.000	0.000	97.942	2.025	0.033	0.000	0.000	0.000	0.000	0.000	0.032	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
0.000	0.000	84.767	14.505	0.679	0.046	0.003	0.000	0.000	0.000	0.377	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
0.000	0.000	96.149	3.700	0.104	0.048	nonzero	0.000	0.000	0.000	0.261	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
0.000	0.000	96.862	3.056	0.075	0.007	0.000	0.000	0.000	0.000	0.152	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
0.000	0.000	96.913	2.837	0.224	0.024	0.001	0.000	0.000	0.000	0.295	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
0.000	0.000	97.269	2.590	0.119	0.022	0.000	0.000	0.000	0.000	0.201	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
0.000	0.000	92.356	7.491	0.136	0.016	0.000	0.000	0.000	0.000	0.230	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
0.000	0.000	93.649	5.411	0.809	0.124	0.007	0.000	0.000	0.000	0.673	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
0.000	0.000	92.165	5.324	2.490	0.020	0.000	0.000	0.000	0.000	0.106	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
0.000	0.000	99.080	0.666	0.125	0.102	0.026	0.000	0.000	0.000	0.554	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
0.000	0.000	96.618	3.292	0.080	0.010	0.000	0.000	0.000	0.000	0.173	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
0.000	0.000	92.695	7.032	0.254	0.018	0.000	0.000	0.000	0.000	0.185	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
0.000	0.000	98.012	1.953	0.033	0.002	0.000	0.000	0.000	0.000	0.097	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
79.239	3.927	0.629	10.775	5.425	0.005	0.001	0.000	0.000	0.000	0.322	pg153_o3_native_lto.cx7a_4g_gcp_c2s30
75.207	6.012	1.999	11.510	5.272	nonzero	0.000	0.000	0.000	0.000	0.070	pg153_o3_native_lto.cx7a1_4g_gcp_c2s30
76.519	4.308	3.823	12.205	3.145	0.000	0.000	0.000	0.000	0.000	0.050	pg153_o3_native_lto.cx7a2_4g_gcp_c2s30
78.325	3.796	1.255	11.179	5.446	0.000	0.000	0.000	0.000	0.000	0.061	pg153_o3_native_lto.cx7a3_4g_gcp_c2s30
78.128	3.833	0.589	11.597	5.849	0.004	0.000	0.000	0.000	0.000	0.148	pg153_o3_native_lto.cx7a4_4g_gcp_c2s30
78.022	4.595	0.556	11.433	5.392	0.002	0.000	0.000	0.000	0.000	0.190	pg153_o3_native_lto.cx7a5_4g_gcp_c2s30
77.024	3.901	3.283	12.993	2.798	0.000	0.000	0.000	0.000	0.000	0.051	pg153_o3_native_lto.cx7a6_4g_gcp_c2s30
72.409	7.585	2.094	12.124	5.780	0.007	nonzero	0.000	0.000	0.000	0.337	pg153_o3_native_lto.cx7a7_4g_gcp_c2s30
79.609	3.365	0.485	10.945	5.588	0.008	0.000	0.000	0.000	0.000	0.246	pg153_o3_native_lto.cx7a8_4g_gcp_c2s30
78.029	4.260	0.632	11.015	6.064	0.001	0.000	0.000	0.000	0.000	0.141	pg153_o3_native_lto.cx7a9_4g_gcp_c2s30
76.190	5.288	1.860	11.779	4.879	0.004	nonzero	0.000	0.000	0.000	0.263	pg153_o3_native_lto.cx7a10_4g_gcp_c2s30
76.582	4.270	2.117	11.674	5.355	0.003	0.000	0.000	0.000	0.000	0.161	pg153_o3_native_lto.cx7a11_4g_gcp_c2s30
79.123	4.156	0.509	10.535	5.677	0.001	0.000	0.000	0.000	0.000	0.139	pg153_o3_native_lto.cx7a12_4g_gcp_c2s30
79.304	4.405	0.351	12.212	3.727	0.001	0.000	0.000	0.000	0.000	0.187	pg153_o3_native_lto.cx7a13_4g_gcp_c2s30
74.800	5.602	2.628	12.928	4.039	0.003	0.000	0.000	0.000	0.000	0.088	pg153_o3_native_lto.cx7a14_4g_gcp_c2s30
79.405	3.519	0.727	13.455	2.863	0.027	0.003	0.000	0.000	0.000	0.547	pg153_o3_native_lto.cx7a15_4g_gcp_c2s30
76.519	9.551	2.298	11.550	0.078	0.003	0.000	0.000	0.000	0.000	0.152	pg153_o3_native_lto.cx7a16_4g_gcp_c2s30
77.390	4.907	0.551	10.969	6.179	0.003	0.000	0.000	0.000	0.000	0.183	pg153_o3_native_lto.cx7a17_4g_gcp_c2s30
79.623	14.973	1.561	3.823	0.020	0.001	0.000	0.000	0.000	0.000	0.092	pg153_o3_native_lto.cx7a18_4g_gcp_c2s30