Introduction

This is a report for the insert benchmark with 160M docs and 8 client(s). It is generated by scripts (bash, awk, sed) and Tufte might not be impressed. An overview of the insert benchmark is here and a short update is here. Below, by DBMS, I mean DBMS+version.config. An example is my8020.c10b40 where my means MySQL, 8020 is version 8.0.20 and c10b40 is the name for the configuration file.

The test server is a c2-standard-30 with 15 cores, hyperthreads disabled, 120G RAM and XFS with SW RAID 0 across 4 NVMe SSD. The benchmark was run with 8 clients and there were 1 or 3 connections per client (1 for queries or inserts without rate limits, 1+1 for rate limited inserts+deletes). It uses 8 tables, 1 per client. It loads 20M rows per table without secondary indexes, creates secondary indexes, then inserts 100M rows per table with a delete per insert to avoid growing the table. It then does 3 read+write tests for 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 Postgres. 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_gcp_c2s30 10322582106579154202119591114612111298
160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 10322582254930157264120662115075111142
160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 10256412134667154769119949115140110954
160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 10322582106579161681122089117536114570
160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 10389612052564153905119895116741113259
160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 10389612052564151429119883115072111120
160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 10457522026582158667119857114774111461
160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 10457522354412117405119692113870106740
160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 101265820525648978711344710496897625
160m.pg153_o3_native_lto.cx7a9_gcp_c2s30 10191082026582157666120672116680113846
160m.pg153_o3_native_lto.cx7a10_gcp_c2s30 9638551524762134998116432111335106827
160m.pg153_o3_native_lto.cx7a11_gcp_c2s30 10126582026582139227116907112072105734
160m.pg153_o3_native_lto.cx7a12_gcp_c2s30 10322582052564139640117258111715105898
160m.pg153_o3_native_lto.cx7a13_gcp_c2s30 10256412052564134567117248111658108036
160m.pg153_o3_native_lto.cx7a14_gcp_c2s30 10126582052564138865116547111040105715
160m.pg153_o3_native_lto.cx7a15_gcp_c2s30 9937892163514129345116229111335108612
160m.pg153_o3_native_lto.cx7a16_gcp_c2s30 10000002106579249299115262111254110511
160m.pg153_o3_native_lto.cx7a17_gcp_c2s30 9937892052564137646115269109849106692
160m.pg153_o3_native_lto.cx7a18_gcp_c2s30 10126582193151278940115836111132111408

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_gcp_c2s30 1.001.001.001.001.001.00
160m.pg153_o3_native_lto.cx7a1_gcp_c2s30 1.001.071.021.011.001.00
160m.pg153_o3_native_lto.cx7a2_gcp_c2s30 0.991.011.001.001.001.00
160m.pg153_o3_native_lto.cx7a3_gcp_c2s30 1.001.001.051.021.031.03
160m.pg153_o3_native_lto.cx7a4_gcp_c2s30 1.010.971.001.001.021.02
160m.pg153_o3_native_lto.cx7a5_gcp_c2s30 1.010.970.981.001.001.00
160m.pg153_o3_native_lto.cx7a6_gcp_c2s30 1.010.961.031.001.001.00
160m.pg153_o3_native_lto.cx7a7_gcp_c2s30 1.011.120.761.000.990.96
160m.pg153_o3_native_lto.cx7a8_gcp_c2s30 0.980.970.580.950.920.88
160m.pg153_o3_native_lto.cx7a9_gcp_c2s30 0.990.961.021.011.021.02
160m.pg153_o3_native_lto.cx7a10_gcp_c2s30 0.930.720.880.970.970.96
160m.pg153_o3_native_lto.cx7a11_gcp_c2s30 0.980.960.900.980.980.95
160m.pg153_o3_native_lto.cx7a12_gcp_c2s30 1.000.970.910.980.970.95
160m.pg153_o3_native_lto.cx7a13_gcp_c2s30 0.990.970.870.980.970.97
160m.pg153_o3_native_lto.cx7a14_gcp_c2s30 0.980.970.900.970.970.95
160m.pg153_o3_native_lto.cx7a15_gcp_c2s30 0.961.030.840.970.970.98
160m.pg153_o3_native_lto.cx7a16_gcp_c2s30 0.971.001.620.960.970.99
160m.pg153_o3_native_lto.cx7a17_gcp_c2s30 0.960.970.890.960.960.96
160m.pg153_o3_native_lto.cx7a18_gcp_c2s30 0.981.041.810.970.971.00

This lists the average rate of inserts/s for the tests that do inserts concurrent with queries. For such tests the query rate is listed in the table above. The read+write tests are setup so that the insert rate should match the target rate every second. Cells that are not at least 95% of the target have a red background to indicate a failure to satisfy the target.

dbmsq100.1q500.1q1000.1
pg153_o3_native_lto.cx7a_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a1_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a2_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a3_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a4_gcp_c2s3079839877976
pg153_o3_native_lto.cx7a5_gcp_c2s3079739887976
pg153_o3_native_lto.cx7a6_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a7_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a8_gcp_c2s3079839887976
pg153_o3_native_lto.cx7a9_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a10_gcp_c2s3079839877976
pg153_o3_native_lto.cx7a11_gcp_c2s3079839877943
pg153_o3_native_lto.cx7a12_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a13_gcp_c2s3079839877976
pg153_o3_native_lto.cx7a14_gcp_c2s3079739887976
pg153_o3_native_lto.cx7a15_gcp_c2s3079739877976
pg153_o3_native_lto.cx7a16_gcp_c2s3079739877978
pg153_o3_native_lto.cx7a17_gcp_c2s3079739887976
pg153_o3_native_lto.cx7a18_gcp_c2s3079739877976
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_gcp_c2s3097.7012.2360.0400.0080.0130.0020.704
pg153_o3_native_lto.cx7a1_gcp_c2s3098.2251.7160.0380.0050.0120.0040.397
pg153_o3_native_lto.cx7a2_gcp_c2s3097.8662.0720.0380.0060.0150.0030.523
pg153_o3_native_lto.cx7a3_gcp_c2s3097.9501.9840.0450.0060.0130.0030.407
pg153_o3_native_lto.cx7a4_gcp_c2s3098.0891.8490.0410.0050.0110.0040.697
pg153_o3_native_lto.cx7a5_gcp_c2s3098.1991.7340.0430.0060.0160.0030.408
pg153_o3_native_lto.cx7a6_gcp_c2s3098.1701.7680.0460.0030.0100.0040.448
pg153_o3_native_lto.cx7a7_gcp_c2s3097.9681.9550.0520.0100.0120.0020.442
pg153_o3_native_lto.cx7a8_gcp_c2s3097.7542.1220.0770.0310.0110.0040.401
pg153_o3_native_lto.cx7a9_gcp_c2s3097.6582.2830.0370.0070.0110.0040.413
pg153_o3_native_lto.cx7a10_gcp_c2s3097.5342.4050.0350.0050.0090.0120.876
pg153_o3_native_lto.cx7a11_gcp_c2s3097.5362.4020.0400.0040.0150.0030.550
pg153_o3_native_lto.cx7a12_gcp_c2s3097.7862.1670.0370.0020.0050.0030.756
pg153_o3_native_lto.cx7a13_gcp_c2s3097.9832.0040.0050.0020.0030.0020.605
pg153_o3_native_lto.cx7a14_gcp_c2s3097.5992.3370.0420.0050.0150.0020.420
pg153_o3_native_lto.cx7a15_gcp_c2s3097.2642.5890.1050.0260.0120.0030.483
pg153_o3_native_lto.cx7a16_gcp_c2s3097.4362.5050.0360.0060.0140.0030.322
pg153_o3_native_lto.cx7a17_gcp_c2s3097.5332.4100.0380.0020.0130.0030.443
pg153_o3_native_lto.cx7a18_gcp_c2s3097.4682.4690.0420.0050.0160.0010.458

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.

dbms0.000sum:DBMS
pg153_o3_native_lto.cx7a_gcp_c2s30
pg153_o3_native_lto.cx7a1_gcp_c2s30
pg153_o3_native_lto.cx7a2_gcp_c2s30
pg153_o3_native_lto.cx7a3_gcp_c2s30
pg153_o3_native_lto.cx7a4_gcp_c2s30
pg153_o3_native_lto.cx7a5_gcp_c2s30
pg153_o3_native_lto.cx7a6_gcp_c2s30
pg153_o3_native_lto.cx7a7_gcp_c2s30
pg153_o3_native_lto.cx7a8_gcp_c2s30
pg153_o3_native_lto.cx7a9_gcp_c2s30

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
1032258	0	0	0.0	1014.2	332.5	0.000	0.000	0.001	0.330	86436	74.1	0.084	11	15.3	41.4	0.0	0.704	149937	22176	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
1032258	0	0	0.0	1015.5	333.5	0.000	0.000	0.001	0.331	86789	74.2	0.084	11	15.3	41.4	NA	0.397	151735	27071	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
1025641	0	0	0.0	1016.3	334.3	0.000	0.000	0.001	0.334	86805	74.5	0.085	11	15.3	41.4	0.0	0.523	149539	25073	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
1032258	0	0	0.0	1018.1	335.3	0.000	0.000	0.001	0.333	86496	74.2	0.084	11	15.3	41.4	NA	0.407	150937	27170	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
1038961	0	0	0.0	1040.8	342.7	0.000	0.000	0.001	0.338	87672	75.4	0.084	11	15.3	41.4	0.0	0.697	150738	29078	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
1038961	0	0	0.0	1041.9	343.2	0.000	0.000	0.001	0.338	87359	75.6	0.084	11	15.3	41.4	0.0	0.408	151635	23874	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
1045752	0	0	0.0	1043.7	342.6	0.000	0.000	0.001	0.335	88081	75.8	0.084	11	15.3	41.4	0.0	0.448	151936	13185	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
1045752	0	0	0.0	1286.6	338.0	0.000	0.000	0.001	0.331	89006	76.1	0.085	11	15.3	31.4	0.0	0.442	151236	31466	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
1012658	0	35	0.2	3779.2	374.5	0.000	0.000	0.004	0.379	84719	74.4	0.084	11	15.3	41.4	0.0	0.401	149088	27270	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
1019108	0	0	0.0	1025.2	338.9	0.000	0.000	0.001	0.341	85668	74.8	0.084	11	15.3	41.4	0.0	0.413	148340	14484	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
963855	0	0	0.0	937.1	316.6	0.000	0.000	0.001	0.336	80096	71.1	0.083	11	15.3	41.4	0.0	0.876	146491	11088	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
1012658	0	0	0.0	1008.9	332.1	0.000	0.000	0.001	0.336	85983	75.3	0.085	11	15.3	41.4	0.0	0.550	146094	400	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
1032258	0	0	0.0	1041.1	345.2	0.000	0.000	0.001	0.342	87606	76.8	0.085	11	15.3	41.4	0.0	0.756	148139	33364	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
1025641	0	0	0.0	974.7	332.2	0.000	0.000	0.001	0.332	89251	75.4	0.087	11	15.3	41.6	0.0	0.605	147889	51392	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
1012658	0	0	0.0	1007.1	332.9	0.000	0.000	0.001	0.337	85915	75.7	0.085	11	15.3	41.4	0.0	0.420	145742	36161	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
993789	0	0	0.0	1200.6	372.8	0.000	0.000	0.001	0.384	84132	74.2	0.085	11	15.3	42.9	0.0	0.483	144742	6393	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
1000000	0	0	0.0	1006.5	333.9	0.000	0.000	0.001	0.342	86289	75.3	0.086	11	15.3	41.4	0.0	0.322	145044	26581	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
993789	0	0	0.0	982.2	322.6	0.000	0.000	0.001	0.332	83762	75.0	0.084	11	15.3	41.4	0.0	0.443	143141	35261	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
1012658	0	0	0.0	1006.0	333.4	0.000	0.000	0.001	0.337	85339	75.7	0.084	11	15.3	41.4	0.0	0.458	144898	11891	160m.pg153_o3_native_lto.cx7a18_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
2106579	0	0	0.0	1517.4	646.9	0.000	0.000	0.001	0.314	23135	35.6	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
2254930	0	0	0.0	1273.1	550.8	0.000	0.000	0.001	0.250	10043	38.6	0.004	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
2134667	0	0	0.0	1515.9	631.4	0.000	0.000	0.001	0.303	18955	35.6	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
2106579	0	0	0.0	1555.7	635.2	0.000	0.000	0.001	0.309	23897	35.3	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
2052564	0	0	0.0	1432.8	611.6	0.000	0.000	0.001	0.305	18705	35.6	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
2052564	0	0	0.0	1435.2	613.4	0.000	0.000	0.001	0.306	18059	35.4	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
2026582	0	0	0.0	1427.9	610.2	0.000	0.000	0.001	0.308	17688	35.6	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
2354412	0	0	0.0	1409.2	543.5	0.000	0.000	0.001	0.236	30190	40.1	0.013	3	29.4	45.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
2052564	0	5072	29.6	3395.1	631.2	0.002	0.015	0.002	0.315	15277	37.4	0.007	3	29.4	68.1	0.0	0.002	NA	NA	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
2026582	0	0	0.0	1379.0	595.4	0.000	0.000	0.001	0.301	26588	35.6	0.013	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
1524762	0	0	0.0	1115.8	471.5	0.000	0.000	0.001	0.317	10317	24.9	0.007	2	29.4	68.3	0.0	0.003	NA	NA	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
2026582	0	0	0.0	1420.7	598.5	0.000	0.000	0.001	0.302	19163	36.0	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
2052564	0	0	0.0	1408.4	601.6	0.000	0.000	0.001	0.300	21221	35.8	0.010	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
2052564	0	0	0.0	1388.8	585.6	0.000	0.000	0.001	0.292	15155	36.3	0.007	3	29.4	68.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
2052564	0	0	0.0	1490.4	630.0	0.000	0.000	0.001	0.314	23182	36.2	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
2163514	0	0	0.0	1584.3	532.2	0.000	0.000	0.001	0.252	24572	38.4	0.011	3	29.4	61.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
2106579	0	0	0.0	1479.2	627.7	0.000	0.000	0.001	0.305	16783	36.1	0.008	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
2052564	0	0	0.0	1475.4	620.2	0.000	0.000	0.001	0.309	23404	36.2	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
2193151	0	0	0.0	1195.0	514.6	0.000	0.000	0.001	0.240	8605	38.8	0.004	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a18_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_gcp_c2s3056.27843.3830.2610.0750.002nonzero0.503
pg153_o3_native_lto.cx7a1_gcp_c2s3055.94243.9820.0620.0130.001nonzero0.432
pg153_o3_native_lto.cx7a2_gcp_c2s3051.91647.7680.2440.0710.001nonzero0.266
pg153_o3_native_lto.cx7a3_gcp_c2s3060.18339.7990.0170.0010.001nonzero0.406
pg153_o3_native_lto.cx7a4_gcp_c2s3054.92444.7360.2610.0780.002nonzero0.389
pg153_o3_native_lto.cx7a5_gcp_c2s3054.25445.4130.2550.0760.0020.244
pg153_o3_native_lto.cx7a6_gcp_c2s3056.33943.3590.2400.0600.002nonzero0.474
pg153_o3_native_lto.cx7a7_gcp_c2s3034.49262.3911.8761.2200.020nonzero0.657
pg153_o3_native_lto.cx7a8_gcp_c2s301.22582.00915.1591.5640.043nonzero0.318
pg153_o3_native_lto.cx7a9_gcp_c2s3055.88443.8090.2430.0630.001nonzero0.325
pg153_o3_native_lto.cx7a10_gcp_c2s309.39290.0770.2100.3120.0070.0010.934
pg153_o3_native_lto.cx7a11_gcp_c2s3011.10388.4910.3140.0900.001nonzero0.303
pg153_o3_native_lto.cx7a12_gcp_c2s3015.49284.3040.1000.0990.004nonzero0.676
pg153_o3_native_lto.cx7a13_gcp_c2s3011.24988.6550.0370.0490.0100.0010.733
pg153_o3_native_lto.cx7a14_gcp_c2s307.71091.9450.2750.0690.001nonzero0.262
pg153_o3_native_lto.cx7a15_gcp_c2s304.77394.0201.0060.1970.0050.209
pg153_o3_native_lto.cx7a16_gcp_c2s304.22994.9230.6640.1830.0010.215
pg153_o3_native_lto.cx7a17_gcp_c2s307.44392.1900.2840.0820.001nonzero0.306
pg153_o3_native_lto.cx7a18_gcp_c2s3036.66662.9350.3530.0460.001nonzero0.297

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_gcp_c2s3083.8172.7562.3187.1993.9070.004nonzero0.306
pg153_o3_native_lto.cx7a1_gcp_c2s3083.5073.0872.5627.1343.7080.001nonzero0.439
pg153_o3_native_lto.cx7a2_gcp_c2s3083.6452.8541.9927.5313.9750.002nonzero0.270
pg153_o3_native_lto.cx7a3_gcp_c2s3084.1162.5562.9426.6783.7070.001nonzero0.416
pg153_o3_native_lto.cx7a4_gcp_c2s3083.8022.5492.4267.1184.1020.002nonzero0.365
pg153_o3_native_lto.cx7a5_gcp_c2s3083.6432.7442.4947.0934.0240.0020.250
pg153_o3_native_lto.cx7a6_gcp_c2s3083.8692.6372.6496.9473.8960.002nonzero0.488
pg153_o3_native_lto.cx7a7_gcp_c2s3081.0703.3781.9387.8895.6760.048nonzero0.779
pg153_o3_native_lto.cx7a8_gcp_c2s3084.7595.4710.5754.5244.6630.008nonzero0.358
pg153_o3_native_lto.cx7a9_gcp_c2s3083.7162.7052.5187.1693.8900.002nonzero0.340
pg153_o3_native_lto.cx7a10_gcp_c2s3083.6082.4342.3876.6534.8990.0170.0010.947
pg153_o3_native_lto.cx7a11_gcp_c2s3083.4962.6042.1057.0704.7240.002nonzero0.309
pg153_o3_native_lto.cx7a12_gcp_c2s3083.5642.6662.1717.0364.5560.006nonzero0.680
pg153_o3_native_lto.cx7a13_gcp_c2s3083.9642.5221.9416.8894.6690.0160.0010.743
pg153_o3_native_lto.cx7a14_gcp_c2s3083.8282.3032.1326.7454.9910.001nonzero0.266
pg153_o3_native_lto.cx7a15_gcp_c2s3081.7753.5531.8297.4645.3710.008nonzero0.356
pg153_o3_native_lto.cx7a16_gcp_c2s3077.9818.24511.2832.3930.098nonzero0.216
pg153_o3_native_lto.cx7a17_gcp_c2s3083.7622.3652.1316.9524.7890.001nonzero0.307
pg153_o3_native_lto.cx7a18_gcp_c2s3077.1149.94910.9451.9720.0200.001nonzero0.302

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
154202	0	18	0.1	1717.5	201.1	0.000	0.001	0.011	1.335	69002	64.2	0.447	62	48.9	118.9	0.0	0.503	4795	1948	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
157264	0	2	0.0	1412.4	155.5	0.000	0.000	0.009	1.012	70563	65.3	0.449	62	48.6	118.6	0.0	0.432	4545	2148	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
154769	0	19	0.1	1619.8	199.5	0.000	0.001	0.010	1.320	69104	65.4	0.446	63	49.0	119.1	0.0	0.266	4598	2048	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
161681	0	3	0.0	1264.0	128.5	0.000	0.000	0.008	0.814	71451	64.9	0.442	60	48.9	104.4	0.0	0.406	4545	2198	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
153905	0	19	0.1	1632.1	195.8	0.000	0.001	0.011	1.303	69289	65.0	0.450	63	48.8	118.9	0.0	0.389	4747	2148	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
151429	0	16	0.1	1723.7	196.4	0.000	0.001	0.011	1.328	67685	63.7	0.447	63	48.9	119.0	0.0	0.244	4645	2198	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
158667	0	18	0.1	1693.2	201.8	0.000	0.001	0.011	1.302	70909	65.7	0.447	62	48.8	118.8	0.0	0.474	4895	2098	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
117405	0	4	0.0	16242.0	850.8	0.000	0.000	0.138	7.421	51689	57.2	0.440	73	48.8	64.8	0.0	0.657	4495	1249	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
89787	0	7266	83.6	89043.1	1260.1	0.081	0.954	0.992	14.371	59928	53.1	0.667	89	50.6	115.6	0.0	0.318	11138	1798	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
157666	0	18	0.1	1644.1	200.9	0.000	0.001	0.010	1.305	70446	65.8	0.447	63	48.9	119.0	0.0	0.325	4895	2148	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
134998	0	15	0.1	1438.1	176.8	0.000	0.001	0.011	1.341	60836	61.9	0.451	69	48.8	118.9	0.0	0.934	4345	1449	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
139227	0	15	0.1	1606.9	182.9	0.000	0.001	0.012	1.345	62928	64.1	0.452	69	49.0	119.1	0.0	0.303	4145	1848	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
139640	0	18	0.1	1592.7	183.2	0.000	0.001	0.011	1.343	63178	63.3	0.452	68	49.0	119.0	0.0	0.676	3947	1748	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
134567	0	15	0.1	1466.0	181.5	0.000	0.001	0.011	1.381	61086	61.1	0.454	68	49.1	119.2	NA	0.733	4295	1848	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
138865	0	16	0.1	1414.6	178.4	0.000	0.001	0.010	1.315	63370	64.6	0.456	70	48.6	118.7	0.0	0.262	3996	1898	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
129345	0	4	0.0	9664.8	552.7	0.000	0.000	0.075	4.376	57275	65.6	0.443	76	49.1	81.1	0.0	0.209	4194	1648	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
249299	0	33	0.2	1612.8	260.9	0.000	0.001	0.006	1.072	96086	71.4	0.385	43	41.2	111.3	0.0	0.215	39607	4845	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
137646	0	15	0.1	1506.6	179.5	0.000	0.001	0.011	1.335	62500	63.9	0.454	70	48.8	118.8	0.0	0.306	3896	1799	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
278940	0	10	0.0	1472.8	226.5	0.000	0.000	0.005	0.831	104820	76.4	0.376	41	41.4	111.5	0.0	0.297	42553	7991	160m.pg153_o3_native_lto.cx7a18_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_gcp_c2s3099.9960.0040.001nonzero0.009
pg153_o3_native_lto.cx7a1_gcp_c2s3099.9960.0030.001nonzero0.010
pg153_o3_native_lto.cx7a2_gcp_c2s3099.9950.0040.001nonzerononzero0.338
pg153_o3_native_lto.cx7a3_gcp_c2s3099.9960.0030.001nonzero0.007
pg153_o3_native_lto.cx7a4_gcp_c2s3099.9970.0030.001nonzero0.006
pg153_o3_native_lto.cx7a5_gcp_c2s3099.9950.0040.001nonzero0.008
pg153_o3_native_lto.cx7a6_gcp_c2s3099.9950.0040.001nonzerononzero0.338
pg153_o3_native_lto.cx7a7_gcp_c2s3099.9950.0040.001nonzero0.006
pg153_o3_native_lto.cx7a8_gcp_c2s3099.9610.0380.001nonzerononzerononzero0.229
pg153_o3_native_lto.cx7a9_gcp_c2s3099.9950.0040.001nonzero0.009
pg153_o3_native_lto.cx7a10_gcp_c2s3099.9950.0040.001nonzero0.008
pg153_o3_native_lto.cx7a11_gcp_c2s3099.9950.0040.001nonzero0.008
pg153_o3_native_lto.cx7a12_gcp_c2s3099.9950.0040.001nonzero0.008
pg153_o3_native_lto.cx7a13_gcp_c2s3099.9950.0040.001nonzero0.010
pg153_o3_native_lto.cx7a14_gcp_c2s3099.9950.0040.001nonzero0.012
pg153_o3_native_lto.cx7a15_gcp_c2s3099.9950.0040.001nonzero0.008
pg153_o3_native_lto.cx7a16_gcp_c2s3099.9950.0040.001nonzero0.009
pg153_o3_native_lto.cx7a17_gcp_c2s3099.9950.0040.001nonzero0.007
pg153_o3_native_lto.cx7a18_gcp_c2s3099.9950.0040.001nonzero0.012

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_gcp_c2s3099.9970.0030.012
pg153_o3_native_lto.cx7a1_gcp_c2s300.01999.7620.2190.011
pg153_o3_native_lto.cx7a2_gcp_c2s300.67999.3160.0050.013
pg153_o3_native_lto.cx7a3_gcp_c2s3048.03051.9700.004
pg153_o3_native_lto.cx7a4_gcp_c2s3015.92784.0710.0020.011
pg153_o3_native_lto.cx7a5_gcp_c2s301.00098.9860.0140.014
pg153_o3_native_lto.cx7a6_gcp_c2s301.20198.7930.0050.010
pg153_o3_native_lto.cx7a7_gcp_c2s3099.9980.0020.012
pg153_o3_native_lto.cx7a8_gcp_c2s3081.93617.7970.2600.0070.185
pg153_o3_native_lto.cx7a9_gcp_c2s306.82593.1720.0030.011
pg153_o3_native_lto.cx7a10_gcp_c2s300.00799.9910.0020.009
pg153_o3_native_lto.cx7a11_gcp_c2s300.00799.9860.0070.007
pg153_o3_native_lto.cx7a12_gcp_c2s300.06199.9380.0020.010
pg153_o3_native_lto.cx7a13_gcp_c2s300.04399.9510.0050.005
pg153_o3_native_lto.cx7a14_gcp_c2s300.02899.9650.0070.010
pg153_o3_native_lto.cx7a15_gcp_c2s3099.9950.0050.012
pg153_o3_native_lto.cx7a16_gcp_c2s300.03199.9640.0050.013
pg153_o3_native_lto.cx7a17_gcp_c2s300.01699.9790.0050.008
pg153_o3_native_lto.cx7a18_gcp_c2s300.47799.3850.1370.014

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_gcp_c2s3056.12729.42914.4380.0070.010
pg153_o3_native_lto.cx7a1_gcp_c2s3063.51721.74714.7290.0070.004
pg153_o3_native_lto.cx7a2_gcp_c2s3057.61331.41110.9690.0070.010
pg153_o3_native_lto.cx7a3_gcp_c2s3043.83333.32522.8420.004
pg153_o3_native_lto.cx7a4_gcp_c2s3059.01931.6019.3780.0020.010
pg153_o3_native_lto.cx7a5_gcp_c2s3058.45526.81414.7240.0070.009
pg153_o3_native_lto.cx7a6_gcp_c2s3053.34432.89113.7600.0050.011
pg153_o3_native_lto.cx7a7_gcp_c2s3047.99328.34223.6600.0050.005
pg153_o3_native_lto.cx7a8_gcp_c2s3065.48324.30610.1980.0140.005
pg153_o3_native_lto.cx7a9_gcp_c2s3058.25924.69417.0430.0030.012
pg153_o3_native_lto.cx7a10_gcp_c2s3074.33710.89614.7640.0030.007
pg153_o3_native_lto.cx7a11_gcp_c2s3064.03011.11124.2500.6090.012
pg153_o3_native_lto.cx7a12_gcp_c2s3064.44418.74116.8040.0100.010
pg153_o3_native_lto.cx7a13_gcp_c2s3048.68930.80620.2290.2760.009
pg153_o3_native_lto.cx7a14_gcp_c2s3062.05416.75921.1840.0030.010
pg153_o3_native_lto.cx7a15_gcp_c2s3048.80727.22423.3910.5780.010
pg153_o3_native_lto.cx7a16_gcp_c2s3058.78315.55725.6560.0030.008
pg153_o3_native_lto.cx7a17_gcp_c2s3056.30926.10217.5830.0050.012
pg153_o3_native_lto.cx7a18_gcp_c2s3063.37822.83713.7590.0260.005

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
797	119591	0	0.0	1902.8	29.9	0.000	0.000	2.387	38.373	455997	53.1	3.813	67	48.9	82.9	0.0	0.009	15040	14677	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
797	120662	0	0.0	1903.4	28.3	0.000	0.000	2.387	36.287	459865	53.2	3.811	66	48.6	95.8	0.0	0.010	14960	14645	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
797	119949	0	0.0	1898.4	30.6	0.000	0.000	2.381	39.313	457300	53.1	3.812	66	48.9	85.9	0.0	0.338	14912	14624	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
797	122089	0	0.0	1904.0	23.6	0.000	0.000	2.388	30.354	464667	53.0	3.806	65	48.9	97.8	0.0	0.007	15487	15247	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
798	119895	0	0.0	270.2	11.6	0.000	0.000	0.339	14.925	456129	52.9	3.804	66	48.8	118.9	0.0	0.006	15039	14816	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
797	119883	0	0.0	1875.3	28.4	0.000	0.000	2.352	36.525	457032	53.2	3.812	67	48.9	83.2	0.0	0.008	15040	14720	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
797	119857	0	0.0	1922.2	30.1	0.000	0.000	2.411	38.656	456908	53.2	3.812	67	48.8	85.8	0.0	0.338	15013	14725	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
797	119692	0	0.0	1909.2	28.0	0.000	0.000	2.395	35.953	456405	53.2	3.813	67	48.7	61.5	0.0	0.006	15024	14725	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
798	113447	409	3.1	3510.0	100.2	0.004	0.028	4.401	128.595	433182	53.1	3.818	70	50.6	75.0	0.0	0.229	14102	13287	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
797	120672	0	0.0	833.2	19.4	0.000	0.000	1.045	24.901	459541	53.1	3.808	66	48.9	110.9	0.0	0.009	14965	14752	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
798	116432	0	0.0	1922.6	30.4	0.000	0.000	2.411	39.014	443861	53.1	3.812	68	48.8	86.0	0.0	0.008	14544	14246	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
798	116907	0	0.0	1955.4	29.6	0.000	0.000	2.452	37.976	445682	53.2	3.812	68	49.0	85.5	0.0	0.008	14560	14134	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
797	117258	0	0.0	1846.3	28.8	0.000	0.000	2.316	36.940	447077	53.2	3.813	68	49.0	83.0	0.0	0.008	14678	14384	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
798	117248	0	0.0	1911.7	29.0	0.000	0.000	2.397	37.212	446923	53.2	3.812	68	49.1	83.2	0.0	0.010	14880	14454	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
797	116547	0	0.0	1916.0	30.5	0.000	0.000	2.403	39.138	444466	53.1	3.814	68	48.5	85.5	0.0	0.012	14800	14368	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
797	116229	0	0.0	1910.6	29.5	0.000	0.000	2.396	37.902	443184	53.1	3.813	69	49.1	65.5	0.0	0.008	14672	14400	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
797	115262	0	0.0	1768.2	28.2	0.000	0.000	2.218	36.227	439547	53.1	3.813	69	41.2	73.9	0.0	0.009	14464	14096	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
797	115269	0	0.0	1917.4	29.5	0.000	0.000	2.405	37.919	439518	53.2	3.813	69	48.8	84.9	0.0	0.007	14624	14352	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
797	115836	0	0.0	1762.5	26.1	0.000	0.000	2.211	33.566	441609	53.1	3.812	69	41.4	88.3	0.0	0.012	14496	14208	160m.pg153_o3_native_lto.cx7a18_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_gcp_c2s3099.9790.0130.0080.001nonzerononzero0.338
pg153_o3_native_lto.cx7a1_gcp_c2s3099.9790.0140.007nonzerononzero0.018
pg153_o3_native_lto.cx7a2_gcp_c2s3099.9760.0140.0090.001nonzero0.020
pg153_o3_native_lto.cx7a3_gcp_c2s3099.9870.0070.005nonzerononzero0.027
pg153_o3_native_lto.cx7a4_gcp_c2s3099.9840.0090.007nonzerononzero0.028
pg153_o3_native_lto.cx7a5_gcp_c2s3099.9770.0140.0080.001nonzerononzerononzero0.338
pg153_o3_native_lto.cx7a6_gcp_c2s3099.9770.0140.0080.001nonzero0.023
pg153_o3_native_lto.cx7a7_gcp_c2s3099.9740.0160.0080.001nonzerononzerononzero0.338
pg153_o3_native_lto.cx7a8_gcp_c2s3099.9210.0750.004nonzerononzerononzero0.072
pg153_o3_native_lto.cx7a9_gcp_c2s3099.9830.0100.007nonzerononzerononzero0.086
pg153_o3_native_lto.cx7a10_gcp_c2s3099.9770.0150.0070.001nonzero0.037
pg153_o3_native_lto.cx7a11_gcp_c2s3099.9760.0160.008nonzero0.013
pg153_o3_native_lto.cx7a12_gcp_c2s3099.9760.0160.008nonzero0.015
pg153_o3_native_lto.cx7a13_gcp_c2s3099.9770.0150.0070.001nonzero0.025
pg153_o3_native_lto.cx7a14_gcp_c2s3099.9750.0160.008nonzerononzero0.018
pg153_o3_native_lto.cx7a15_gcp_c2s3099.9750.0160.0080.001nonzero0.034
pg153_o3_native_lto.cx7a16_gcp_c2s3099.9790.0150.007nonzerononzero0.019
pg153_o3_native_lto.cx7a17_gcp_c2s3099.9760.0160.008nonzerononzero0.018
pg153_o3_native_lto.cx7a18_gcp_c2s3099.9780.0160.006nonzerononzero0.020

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_gcp_c2s307.68791.8300.4780.0060.026
pg153_o3_native_lto.cx7a1_gcp_c2s3099.5180.4750.0070.020
pg153_o3_native_lto.cx7a2_gcp_c2s305.20694.1350.6490.0100.030
pg153_o3_native_lto.cx7a3_gcp_c2s3076.63223.1800.1860.0010.020
pg153_o3_native_lto.cx7a4_gcp_c2s3052.31047.0440.6100.0370.043
pg153_o3_native_lto.cx7a5_gcp_c2s307.33091.7830.8140.0730.049
pg153_o3_native_lto.cx7a6_gcp_c2s306.08092.8781.0100.0320.033
pg153_o3_native_lto.cx7a7_gcp_c2s301.43997.8360.4960.2020.0270.148
pg153_o3_native_lto.cx7a8_gcp_c2s3089.3269.9010.7520.0210.218
pg153_o3_native_lto.cx7a9_gcp_c2s3043.04956.6080.2900.0500.0030.078
pg153_o3_native_lto.cx7a10_gcp_c2s300.00899.5970.3430.0520.040
pg153_o3_native_lto.cx7a11_gcp_c2s300.01499.6680.3170.0010.019
pg153_o3_native_lto.cx7a12_gcp_c2s300.04199.8220.1360.015
pg153_o3_native_lto.cx7a13_gcp_c2s300.01999.5850.3870.0100.037
pg153_o3_native_lto.cx7a14_gcp_c2s300.00199.6860.3100.0020.019
pg153_o3_native_lto.cx7a15_gcp_c2s300.02299.3080.6430.0270.036
pg153_o3_native_lto.cx7a16_gcp_c2s300.62499.1660.2070.0020.017
pg153_o3_native_lto.cx7a17_gcp_c2s300.00399.7150.2790.0030.020
pg153_o3_native_lto.cx7a18_gcp_c2s301.99397.6100.3950.0010.018

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_gcp_c2s3078.1601.0893.86216.7870.1020.038
pg153_o3_native_lto.cx7a1_gcp_c2s3078.5581.8034.13015.4970.0130.030
pg153_o3_native_lto.cx7a2_gcp_c2s3077.7191.1973.08117.9400.0620.046
pg153_o3_native_lto.cx7a3_gcp_c2s3081.3200.9080.70017.0060.0660.040
pg153_o3_native_lto.cx7a4_gcp_c2s3077.6761.3323.57717.2260.1900.043
pg153_o3_native_lto.cx7a5_gcp_c2s3076.4401.2383.71918.4650.1380.045
pg153_o3_native_lto.cx7a6_gcp_c2s3077.8621.1882.48018.3380.1330.038
pg153_o3_native_lto.cx7a7_gcp_c2s3078.3081.3132.15917.9050.2970.0180.148
pg153_o3_native_lto.cx7a8_gcp_c2s3076.4152.9834.50316.0670.0310.0010.080
pg153_o3_native_lto.cx7a9_gcp_c2s3079.2001.2992.76816.6480.0810.0030.081
pg153_o3_native_lto.cx7a10_gcp_c2s3079.5181.2773.07116.0710.0620.036
pg153_o3_native_lto.cx7a11_gcp_c2s3077.9171.2842.44318.3390.0170.022
pg153_o3_native_lto.cx7a12_gcp_c2s3079.5211.2654.42414.7780.0130.022
pg153_o3_native_lto.cx7a13_gcp_c2s3076.6391.4721.85819.6620.3690.044
pg153_o3_native_lto.cx7a14_gcp_c2s3077.9121.4264.89315.7570.0110.031
pg153_o3_native_lto.cx7a15_gcp_c2s3077.5711.6912.43718.1660.1350.041
pg153_o3_native_lto.cx7a16_gcp_c2s3079.7686.8658.2665.1010.0010.018
pg153_o3_native_lto.cx7a17_gcp_c2s3079.5051.2993.71315.3950.0870.027
pg153_o3_native_lto.cx7a18_gcp_c2s3078.0289.4038.4894.0800.013

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
3987	114612	0	0.0	3050.5	70.8	0.000	0.000	0.765	18.190	436492	54.5	3.808	71	48.9	72.1	0.0	0.338	14352	13798	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
3987	115075	0	0.0	3012.4	62.5	0.000	0.000	0.756	16.057	438743	54.6	3.813	71	48.6	65.4	0.0	0.018	14432	13958	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
3987	115140	0	0.0	3103.6	71.6	0.000	0.000	0.778	18.394	438748	54.4	3.811	71	48.9	72.4	0.0	0.020	14352	13761	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
3987	117536	0	0.0	2988.9	51.3	0.000	0.000	0.750	13.186	445976	54.1	3.794	69	48.9	92.2	0.0	0.027	14784	14279	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
3987	116741	0	0.0	386.5	18.6	0.000	0.000	0.097	4.785	442080	54.1	3.787	70	48.8	113.9	0.0	0.028	14710	14213	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
3988	115072	0	0.0	3062.9	71.5	0.000	0.000	0.768	18.352	438021	54.5	3.806	71	48.9	72.1	0.0	0.338	14432	13857	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
3987	114774	0	0.0	3092.2	71.7	0.000	0.000	0.776	18.409	436578	54.5	3.804	71	48.8	72.2	0.0	0.023	14384	13841	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
3987	113870	0	0.0	4675.3	91.7	0.000	0.000	1.173	23.556	434106	54.4	3.812	72	48.7	64.8	0.0	0.338	14225	13266	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
3988	104968	1681	10.1	15408.2	451.4	0.016	0.098	3.864	115.913	403370	55.4	3.843	79	50.6	73.1	0.0	0.072	13122	12370	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
3987	116680	0	0.0	802.8	32.5	0.000	0.000	0.201	8.341	443336	54.2	3.800	70	48.9	99.0	0.0	0.086	14645	14129	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
3987	111335	0	0.0	3084.2	71.0	0.000	0.000	0.774	18.231	424504	54.5	3.813	73	48.8	72.1	0.0	0.037	13793	13186	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
3987	112072	0	0.0	3053.4	71.4	0.000	0.000	0.766	18.345	427830	54.5	3.817	73	49.0	72.3	0.0	0.013	14081	13510	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
3987	111715	0	0.0	3076.6	71.3	0.000	0.000	0.772	18.310	426936	54.5	3.822	73	49.0	72.1	0.0	0.015	14006	13441	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
3987	111658	0	0.0	3079.4	70.1	0.000	0.000	0.772	17.993	423576	54.7	3.793	73	49.1	72.2	0.0	0.025	13985	13414	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
3988	111040	0	0.0	3069.7	71.6	0.000	0.000	0.770	18.384	424167	54.4	3.820	73	48.5	71.9	0.0	0.018	13878	13441	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
3987	111335	0	0.0	3060.5	72.4	0.000	0.000	0.768	18.598	423370	54.6	3.803	74	49.1	70.1	0.0	0.034	13937	13425	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
3987	111254	0	0.0	2490.2	70.0	0.000	0.000	0.625	17.977	425564	54.1	3.825	73	41.3	65.6	0.0	0.019	13750	12115	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
3988	109849	0	0.0	3070.6	71.2	0.000	0.000	0.770	18.281	418692	54.5	3.812	74	48.8	72.0	0.0	0.018	13681	13090	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
3987	111132	0	0.0	2445.5	61.5	0.000	0.000	0.613	15.791	424536	54.1	3.820	73	41.4	59.5	0.0	0.020	13969	12130	160m.pg153_o3_native_lto.cx7a18_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_gcp_c2s3099.9450.0370.0150.003nonzero0.035
pg153_o3_native_lto.cx7a1_gcp_c2s3099.9460.0420.0110.001nonzero0.022
pg153_o3_native_lto.cx7a2_gcp_c2s3099.9420.0390.0160.003nonzerononzero0.081
pg153_o3_native_lto.cx7a3_gcp_c2s3099.9650.0240.0110.001nonzero0.032
pg153_o3_native_lto.cx7a4_gcp_c2s3099.9600.0280.0120.001nonzero0.049
pg153_o3_native_lto.cx7a5_gcp_c2s3099.9440.0370.0150.003nonzero0.043
pg153_o3_native_lto.cx7a6_gcp_c2s3099.9420.0380.0170.003nonzero0.035
pg153_o3_native_lto.cx7a7_gcp_c2s3099.9000.0550.0280.0150.001nonzerononzero0.292
pg153_o3_native_lto.cx7a8_gcp_c2s3099.6890.2830.0210.0060.002nonzero0.161
pg153_o3_native_lto.cx7a9_gcp_c2s3099.9540.0310.0130.001nonzero0.048
pg153_o3_native_lto.cx7a10_gcp_c2s3099.9370.0450.0160.002nonzero0.027
pg153_o3_native_lto.cx7a11_gcp_c2s3099.9390.0430.0150.002nonzerononzero15.654
pg153_o3_native_lto.cx7a12_gcp_c2s3099.9370.0470.0150.001nonzerononzero0.096
pg153_o3_native_lto.cx7a13_gcp_c2s3099.9510.0360.0130.001nonzerononzerononzero0.269
pg153_o3_native_lto.cx7a14_gcp_c2s3099.9330.0460.0170.003nonzero0.039
pg153_o3_native_lto.cx7a15_gcp_c2s3099.9410.0410.0150.003nonzero0.056
pg153_o3_native_lto.cx7a16_gcp_c2s3099.9380.0430.0160.003nonzero0.025
pg153_o3_native_lto.cx7a17_gcp_c2s3099.9370.0430.0170.003nonzero0.057
pg153_o3_native_lto.cx7a18_gcp_c2s3099.9440.0440.0120.001nonzero0.054

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_gcp_c2s3023.08574.2932.4700.1520.042
pg153_o3_native_lto.cx7a1_gcp_c2s302.84096.2460.8900.0230.030
pg153_o3_native_lto.cx7a2_gcp_c2s3019.25778.4082.2300.1050.036
pg153_o3_native_lto.cx7a3_gcp_c2s3063.23236.3390.4170.0120.035
pg153_o3_native_lto.cx7a4_gcp_c2s3052.27346.7670.8600.1000.044
pg153_o3_native_lto.cx7a5_gcp_c2s3025.22672.6172.0660.0910.051
pg153_o3_native_lto.cx7a6_gcp_c2s3020.19276.8392.8080.1610.041
pg153_o3_native_lto.cx7a7_gcp_c2s300.14986.88811.5101.4200.033nonzero0.299
pg153_o3_native_lto.cx7a8_gcp_c2s3084.84813.1261.9240.101nonzero0.323
pg153_o3_native_lto.cx7a9_gcp_c2s3048.64249.8081.4080.1410.045
pg153_o3_native_lto.cx7a10_gcp_c2s300.68297.0152.1440.1580.040
pg153_o3_native_lto.cx7a11_gcp_c2s302.00496.2911.5650.138nonzero0.00115.661
pg153_o3_native_lto.cx7a12_gcp_c2s301.35098.1400.4940.0140.0020.101
pg153_o3_native_lto.cx7a13_gcp_c2s301.06598.2370.6470.0480.0030.152
pg153_o3_native_lto.cx7a14_gcp_c2s300.48996.2103.1060.1950.037
pg153_o3_native_lto.cx7a15_gcp_c2s301.29795.9482.3940.3600.0010.114
pg153_o3_native_lto.cx7a16_gcp_c2s304.59892.3672.8560.1790.045
pg153_o3_native_lto.cx7a17_gcp_c2s300.66296.4702.6880.1800.058
pg153_o3_native_lto.cx7a18_gcp_c2s309.23089.5211.2130.0370.040

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_gcp_c2s3078.4162.3352.53513.4493.2650.052
pg153_o3_native_lto.cx7a1_gcp_c2s3076.9344.0123.23212.6983.1240.028
pg153_o3_native_lto.cx7a2_gcp_c2s3078.4032.8232.74313.6072.4230.049
pg153_o3_native_lto.cx7a3_gcp_c2s3079.1193.1311.35012.5953.8060.051
pg153_o3_native_lto.cx7a4_gcp_c2s3077.7313.3552.47913.1903.2450.056
pg153_o3_native_lto.cx7a5_gcp_c2s3078.3672.8112.52813.4972.7980.048
pg153_o3_native_lto.cx7a6_gcp_c2s3078.1013.1762.47412.8673.3820.050
pg153_o3_native_lto.cx7a7_gcp_c2s3072.3215.9142.83014.5834.3410.0120.194
pg153_o3_native_lto.cx7a8_gcp_c2s3076.9844.1083.35112.1813.3640.0120.157
pg153_o3_native_lto.cx7a9_gcp_c2s3077.8443.7012.44012.8773.1380.049
pg153_o3_native_lto.cx7a10_gcp_c2s3075.1543.3133.97011.2026.3620.052
pg153_o3_native_lto.cx7a11_gcp_c2s3078.7703.0242.49711.3744.333nonzero0.00115.721
pg153_o3_native_lto.cx7a12_gcp_c2s3076.2373.6523.13411.1305.8480.058
pg153_o3_native_lto.cx7a13_gcp_c2s3079.6462.2691.43511.3435.3070.0010.081
pg153_o3_native_lto.cx7a14_gcp_c2s3076.1813.9322.86611.6205.4020.050
pg153_o3_native_lto.cx7a15_gcp_c2s3077.2963.5221.94911.5535.6800.0010.144
pg153_o3_native_lto.cx7a16_gcp_c2s3077.7737.0716.7408.3510.0650.037
pg153_o3_native_lto.cx7a17_gcp_c2s3076.4793.8442.52211.1955.9600.047
pg153_o3_native_lto.cx7a18_gcp_c2s3077.5687.3099.7675.3430.0140.032

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
7978	111298	0	0.0	2672.4	93.4	0.000	0.000	0.335	11.982	418763	56.1	3.763	76	48.9	77.5	0.0	0.035	13905	12599	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
7978	111142	0	0.0	2628.2	80.5	0.000	0.000	0.329	10.335	419789	56.4	3.777	76	48.6	67.2	0.0	0.022	13953	12962	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
7978	110954	0	0.0	2600.1	93.8	0.000	0.000	0.326	12.036	419603	56.0	3.782	76	48.8	77.3	0.0	0.081	13878	12882	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
7976	114570	0	0.0	2472.7	65.5	0.000	0.000	0.310	8.405	428815	55.9	3.743	73	49.1	80.5	0.0	0.032	14400	13058	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
7976	113259	0	0.0	273.8	21.0	0.000	0.000	0.034	2.693	424762	55.8	3.750	74	48.8	109.3	0.0	0.049	14293	13222	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
7976	111120	0	0.0	2679.3	93.7	0.000	0.000	0.336	12.024	419102	56.1	3.772	76	48.9	77.5	0.0	0.043	14113	12754	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
7978	111461	0	0.0	2601.5	94.0	0.000	0.000	0.326	12.071	419712	56.1	3.766	75	48.8	77.3	0.0	0.035	14161	13011	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
7978	106740	0	0.0	9844.1	197.8	0.000	0.000	1.234	25.383	403822	55.7	3.783	78	48.7	64.8	0.0	0.292	13409	10724	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
7976	97625	2494	15.6	28621.5	785.9	0.026	0.163	3.589	100.900	373489	57.3	3.826	88	50.4	79.7	0.0	0.161	12514	7256	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
7976	113846	0	0.0	627.1	37.4	0.000	0.000	0.079	4.799	428380	55.8	3.763	74	48.8	94.1	0.0	0.048	14353	13238	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
7976	106827	0	0.0	2561.8	93.3	0.000	0.000	0.321	11.978	400131	56.7	3.746	80	48.8	77.7	0.0	0.027	13441	11908	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
7943	105734	0	0.0	2634.5	93.0	0.000	0.000	0.332	11.996	401903	56.1	3.801	80	49.0	77.5	0.0	15.654	13361	11859	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
7978	105898	0	0.0	2680.1	94.2	0.000	0.000	0.336	12.095	401042	56.7	3.787	80	48.8	77.5	0.0	0.096	13297	11923	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
7976	108036	0	0.0	2577.4	92.0	0.000	0.000	0.323	11.812	405081	56.5	3.749	78	49.1	77.9	0.0	0.269	13526	12354	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
7976	105715	0	0.0	2579.7	94.1	0.000	0.000	0.323	12.088	400771	56.3	3.791	80	48.5	77.3	0.0	0.039	13090	12023	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
7976	108612	0	0.0	2499.8	95.7	0.000	0.000	0.313	12.293	407103	56.4	3.748	78	49.0	77.7	0.0	0.056	13585	12216	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
7978	110511	0	0.0	2065.0	87.9	0.000	0.000	0.259	11.278	420941	55.0	3.809	75	41.3	69.8	0.0	0.025	13985	11992	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
7976	106692	0	0.0	2651.2	94.0	0.000	0.000	0.332	12.064	401707	56.4	3.765	79	48.7	77.4	0.0	0.057	13521	11908	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
7976	111408	0	0.0	2051.4	76.2	0.000	0.000	0.257	9.790	422986	55.2	3.797	74	41.4	60.1	0.0	0.054	13873	11927	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

l.i0

l.i0: load without secondary indexes

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
1032258	0	0	0.0	1014.2	332.5	0.000	0.000	0.001	0.330	86436	74.1	0.084	11	15.3	41.4	0.0	0.704	149937	22176	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
1032258	0	0	0.0	1015.5	333.5	0.000	0.000	0.001	0.331	86789	74.2	0.084	11	15.3	41.4	NA	0.397	151735	27071	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
1025641	0	0	0.0	1016.3	334.3	0.000	0.000	0.001	0.334	86805	74.5	0.085	11	15.3	41.4	0.0	0.523	149539	25073	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
1032258	0	0	0.0	1018.1	335.3	0.000	0.000	0.001	0.333	86496	74.2	0.084	11	15.3	41.4	NA	0.407	150937	27170	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
1038961	0	0	0.0	1040.8	342.7	0.000	0.000	0.001	0.338	87672	75.4	0.084	11	15.3	41.4	0.0	0.697	150738	29078	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
1038961	0	0	0.0	1041.9	343.2	0.000	0.000	0.001	0.338	87359	75.6	0.084	11	15.3	41.4	0.0	0.408	151635	23874	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
1045752	0	0	0.0	1043.7	342.6	0.000	0.000	0.001	0.335	88081	75.8	0.084	11	15.3	41.4	0.0	0.448	151936	13185	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
1045752	0	0	0.0	1286.6	338.0	0.000	0.000	0.001	0.331	89006	76.1	0.085	11	15.3	31.4	0.0	0.442	151236	31466	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
1012658	0	35	0.2	3779.2	374.5	0.000	0.000	0.004	0.379	84719	74.4	0.084	11	15.3	41.4	0.0	0.401	149088	27270	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
1019108	0	0	0.0	1025.2	338.9	0.000	0.000	0.001	0.341	85668	74.8	0.084	11	15.3	41.4	0.0	0.413	148340	14484	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
963855	0	0	0.0	937.1	316.6	0.000	0.000	0.001	0.336	80096	71.1	0.083	11	15.3	41.4	0.0	0.876	146491	11088	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
1012658	0	0	0.0	1008.9	332.1	0.000	0.000	0.001	0.336	85983	75.3	0.085	11	15.3	41.4	0.0	0.550	146094	400	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
1032258	0	0	0.0	1041.1	345.2	0.000	0.000	0.001	0.342	87606	76.8	0.085	11	15.3	41.4	0.0	0.756	148139	33364	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
1025641	0	0	0.0	974.7	332.2	0.000	0.000	0.001	0.332	89251	75.4	0.087	11	15.3	41.6	0.0	0.605	147889	51392	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
1012658	0	0	0.0	1007.1	332.9	0.000	0.000	0.001	0.337	85915	75.7	0.085	11	15.3	41.4	0.0	0.420	145742	36161	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
993789	0	0	0.0	1200.6	372.8	0.000	0.000	0.001	0.384	84132	74.2	0.085	11	15.3	42.9	0.0	0.483	144742	6393	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
1000000	0	0	0.0	1006.5	333.9	0.000	0.000	0.001	0.342	86289	75.3	0.086	11	15.3	41.4	0.0	0.322	145044	26581	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
993789	0	0	0.0	982.2	322.6	0.000	0.000	0.001	0.332	83762	75.0	0.084	11	15.3	41.4	0.0	0.443	143141	35261	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
1012658	0	0	0.0	1006.0	333.4	0.000	0.000	0.001	0.337	85339	75.7	0.084	11	15.3	41.4	0.0	0.458	144898	11891	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

l.x

l.x: create secondary indexes

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
2106579	0	0	0.0	1517.4	646.9	0.000	0.000	0.001	0.314	23135	35.6	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
2254930	0	0	0.0	1273.1	550.8	0.000	0.000	0.001	0.250	10043	38.6	0.004	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
2134667	0	0	0.0	1515.9	631.4	0.000	0.000	0.001	0.303	18955	35.6	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
2106579	0	0	0.0	1555.7	635.2	0.000	0.000	0.001	0.309	23897	35.3	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
2052564	0	0	0.0	1432.8	611.6	0.000	0.000	0.001	0.305	18705	35.6	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
2052564	0	0	0.0	1435.2	613.4	0.000	0.000	0.001	0.306	18059	35.4	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
2026582	0	0	0.0	1427.9	610.2	0.000	0.000	0.001	0.308	17688	35.6	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
2354412	0	0	0.0	1409.2	543.5	0.000	0.000	0.001	0.236	30190	40.1	0.013	3	29.4	45.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
2052564	0	5072	29.6	3395.1	631.2	0.002	0.015	0.002	0.315	15277	37.4	0.007	3	29.4	68.1	0.0	0.002	NA	NA	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
2026582	0	0	0.0	1379.0	595.4	0.000	0.000	0.001	0.301	26588	35.6	0.013	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
1524762	0	0	0.0	1115.8	471.5	0.000	0.000	0.001	0.317	10317	24.9	0.007	2	29.4	68.3	0.0	0.003	NA	NA	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
2026582	0	0	0.0	1420.7	598.5	0.000	0.000	0.001	0.302	19163	36.0	0.009	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
2052564	0	0	0.0	1408.4	601.6	0.000	0.000	0.001	0.300	21221	35.8	0.010	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
2052564	0	0	0.0	1388.8	585.6	0.000	0.000	0.001	0.292	15155	36.3	0.007	3	29.4	68.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
2052564	0	0	0.0	1490.4	630.0	0.000	0.000	0.001	0.314	23182	36.2	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
2163514	0	0	0.0	1584.3	532.2	0.000	0.000	0.001	0.252	24572	38.4	0.011	3	29.4	61.5	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
2106579	0	0	0.0	1479.2	627.7	0.000	0.000	0.001	0.305	16783	36.1	0.008	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
2052564	0	0	0.0	1475.4	620.2	0.000	0.000	0.001	0.309	23404	36.2	0.011	3	29.4	68.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
2193151	0	0	0.0	1195.0	514.6	0.000	0.000	0.001	0.240	8605	38.8	0.004	3	29.4	63.3	0.0	0.001	NA	NA	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

l.i1

l.i1: continue load after secondary indexes created

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
154202	0	18	0.1	1717.5	201.1	0.000	0.001	0.011	1.335	69002	64.2	0.447	62	48.9	118.9	0.0	0.503	4795	1948	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
157264	0	2	0.0	1412.4	155.5	0.000	0.000	0.009	1.012	70563	65.3	0.449	62	48.6	118.6	0.0	0.432	4545	2148	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
154769	0	19	0.1	1619.8	199.5	0.000	0.001	0.010	1.320	69104	65.4	0.446	63	49.0	119.1	0.0	0.266	4598	2048	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
161681	0	3	0.0	1264.0	128.5	0.000	0.000	0.008	0.814	71451	64.9	0.442	60	48.9	104.4	0.0	0.406	4545	2198	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
153905	0	19	0.1	1632.1	195.8	0.000	0.001	0.011	1.303	69289	65.0	0.450	63	48.8	118.9	0.0	0.389	4747	2148	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
151429	0	16	0.1	1723.7	196.4	0.000	0.001	0.011	1.328	67685	63.7	0.447	63	48.9	119.0	0.0	0.244	4645	2198	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
158667	0	18	0.1	1693.2	201.8	0.000	0.001	0.011	1.302	70909	65.7	0.447	62	48.8	118.8	0.0	0.474	4895	2098	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
117405	0	4	0.0	16242.0	850.8	0.000	0.000	0.138	7.421	51689	57.2	0.440	73	48.8	64.8	0.0	0.657	4495	1249	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
89787	0	7266	83.6	89043.1	1260.1	0.081	0.954	0.992	14.371	59928	53.1	0.667	89	50.6	115.6	0.0	0.318	11138	1798	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
157666	0	18	0.1	1644.1	200.9	0.000	0.001	0.010	1.305	70446	65.8	0.447	63	48.9	119.0	0.0	0.325	4895	2148	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
134998	0	15	0.1	1438.1	176.8	0.000	0.001	0.011	1.341	60836	61.9	0.451	69	48.8	118.9	0.0	0.934	4345	1449	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
139227	0	15	0.1	1606.9	182.9	0.000	0.001	0.012	1.345	62928	64.1	0.452	69	49.0	119.1	0.0	0.303	4145	1848	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
139640	0	18	0.1	1592.7	183.2	0.000	0.001	0.011	1.343	63178	63.3	0.452	68	49.0	119.0	0.0	0.676	3947	1748	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
134567	0	15	0.1	1466.0	181.5	0.000	0.001	0.011	1.381	61086	61.1	0.454	68	49.1	119.2	NA	0.733	4295	1848	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
138865	0	16	0.1	1414.6	178.4	0.000	0.001	0.010	1.315	63370	64.6	0.456	70	48.6	118.7	0.0	0.262	3996	1898	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
129345	0	4	0.0	9664.8	552.7	0.000	0.000	0.075	4.376	57275	65.6	0.443	76	49.1	81.1	0.0	0.209	4194	1648	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
249299	0	33	0.2	1612.8	260.9	0.000	0.001	0.006	1.072	96086	71.4	0.385	43	41.2	111.3	0.0	0.215	39607	4845	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
137646	0	15	0.1	1506.6	179.5	0.000	0.001	0.011	1.335	62500	63.9	0.454	70	48.8	118.8	0.0	0.306	3896	1799	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
278940	0	10	0.0	1472.8	226.5	0.000	0.000	0.005	0.831	104820	76.4	0.376	41	41.4	111.5	0.0	0.297	42553	7991	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

q100.1

q100.1: range queries with 100 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
797	119591	0	0.0	1902.8	29.9	0.000	0.000	2.387	38.373	455997	53.1	3.813	67	48.9	82.9	0.0	0.009	15040	14677	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
797	120662	0	0.0	1903.4	28.3	0.000	0.000	2.387	36.287	459865	53.2	3.811	66	48.6	95.8	0.0	0.010	14960	14645	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
797	119949	0	0.0	1898.4	30.6	0.000	0.000	2.381	39.313	457300	53.1	3.812	66	48.9	85.9	0.0	0.338	14912	14624	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
797	122089	0	0.0	1904.0	23.6	0.000	0.000	2.388	30.354	464667	53.0	3.806	65	48.9	97.8	0.0	0.007	15487	15247	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
798	119895	0	0.0	270.2	11.6	0.000	0.000	0.339	14.925	456129	52.9	3.804	66	48.8	118.9	0.0	0.006	15039	14816	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
797	119883	0	0.0	1875.3	28.4	0.000	0.000	2.352	36.525	457032	53.2	3.812	67	48.9	83.2	0.0	0.008	15040	14720	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
797	119857	0	0.0	1922.2	30.1	0.000	0.000	2.411	38.656	456908	53.2	3.812	67	48.8	85.8	0.0	0.338	15013	14725	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
797	119692	0	0.0	1909.2	28.0	0.000	0.000	2.395	35.953	456405	53.2	3.813	67	48.7	61.5	0.0	0.006	15024	14725	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
798	113447	409	3.1	3510.0	100.2	0.004	0.028	4.401	128.595	433182	53.1	3.818	70	50.6	75.0	0.0	0.229	14102	13287	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
797	120672	0	0.0	833.2	19.4	0.000	0.000	1.045	24.901	459541	53.1	3.808	66	48.9	110.9	0.0	0.009	14965	14752	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
798	116432	0	0.0	1922.6	30.4	0.000	0.000	2.411	39.014	443861	53.1	3.812	68	48.8	86.0	0.0	0.008	14544	14246	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
798	116907	0	0.0	1955.4	29.6	0.000	0.000	2.452	37.976	445682	53.2	3.812	68	49.0	85.5	0.0	0.008	14560	14134	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
797	117258	0	0.0	1846.3	28.8	0.000	0.000	2.316	36.940	447077	53.2	3.813	68	49.0	83.0	0.0	0.008	14678	14384	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
798	117248	0	0.0	1911.7	29.0	0.000	0.000	2.397	37.212	446923	53.2	3.812	68	49.1	83.2	0.0	0.010	14880	14454	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
797	116547	0	0.0	1916.0	30.5	0.000	0.000	2.403	39.138	444466	53.1	3.814	68	48.5	85.5	0.0	0.012	14800	14368	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
797	116229	0	0.0	1910.6	29.5	0.000	0.000	2.396	37.902	443184	53.1	3.813	69	49.1	65.5	0.0	0.008	14672	14400	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
797	115262	0	0.0	1768.2	28.2	0.000	0.000	2.218	36.227	439547	53.1	3.813	69	41.2	73.9	0.0	0.009	14464	14096	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
797	115269	0	0.0	1917.4	29.5	0.000	0.000	2.405	37.919	439518	53.2	3.813	69	48.8	84.9	0.0	0.007	14624	14352	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
797	115836	0	0.0	1762.5	26.1	0.000	0.000	2.211	33.566	441609	53.1	3.812	69	41.4	88.3	0.0	0.012	14496	14208	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

q500.1

q500.1: range queries with 500 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
3987	114612	0	0.0	3050.5	70.8	0.000	0.000	0.765	18.190	436492	54.5	3.808	71	48.9	72.1	0.0	0.338	14352	13798	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
3987	115075	0	0.0	3012.4	62.5	0.000	0.000	0.756	16.057	438743	54.6	3.813	71	48.6	65.4	0.0	0.018	14432	13958	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
3987	115140	0	0.0	3103.6	71.6	0.000	0.000	0.778	18.394	438748	54.4	3.811	71	48.9	72.4	0.0	0.020	14352	13761	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
3987	117536	0	0.0	2988.9	51.3	0.000	0.000	0.750	13.186	445976	54.1	3.794	69	48.9	92.2	0.0	0.027	14784	14279	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
3987	116741	0	0.0	386.5	18.6	0.000	0.000	0.097	4.785	442080	54.1	3.787	70	48.8	113.9	0.0	0.028	14710	14213	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
3988	115072	0	0.0	3062.9	71.5	0.000	0.000	0.768	18.352	438021	54.5	3.806	71	48.9	72.1	0.0	0.338	14432	13857	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
3987	114774	0	0.0	3092.2	71.7	0.000	0.000	0.776	18.409	436578	54.5	3.804	71	48.8	72.2	0.0	0.023	14384	13841	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
3987	113870	0	0.0	4675.3	91.7	0.000	0.000	1.173	23.556	434106	54.4	3.812	72	48.7	64.8	0.0	0.338	14225	13266	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
3988	104968	1681	10.1	15408.2	451.4	0.016	0.098	3.864	115.913	403370	55.4	3.843	79	50.6	73.1	0.0	0.072	13122	12370	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
3987	116680	0	0.0	802.8	32.5	0.000	0.000	0.201	8.341	443336	54.2	3.800	70	48.9	99.0	0.0	0.086	14645	14129	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
3987	111335	0	0.0	3084.2	71.0	0.000	0.000	0.774	18.231	424504	54.5	3.813	73	48.8	72.1	0.0	0.037	13793	13186	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
3987	112072	0	0.0	3053.4	71.4	0.000	0.000	0.766	18.345	427830	54.5	3.817	73	49.0	72.3	0.0	0.013	14081	13510	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
3987	111715	0	0.0	3076.6	71.3	0.000	0.000	0.772	18.310	426936	54.5	3.822	73	49.0	72.1	0.0	0.015	14006	13441	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
3987	111658	0	0.0	3079.4	70.1	0.000	0.000	0.772	17.993	423576	54.7	3.793	73	49.1	72.2	0.0	0.025	13985	13414	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
3988	111040	0	0.0	3069.7	71.6	0.000	0.000	0.770	18.384	424167	54.4	3.820	73	48.5	71.9	0.0	0.018	13878	13441	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
3987	111335	0	0.0	3060.5	72.4	0.000	0.000	0.768	18.598	423370	54.6	3.803	74	49.1	70.1	0.0	0.034	13937	13425	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
3987	111254	0	0.0	2490.2	70.0	0.000	0.000	0.625	17.977	425564	54.1	3.825	73	41.3	65.6	0.0	0.019	13750	12115	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
3988	109849	0	0.0	3070.6	71.2	0.000	0.000	0.770	18.281	418692	54.5	3.812	74	48.8	72.0	0.0	0.018	13681	13090	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
3987	111132	0	0.0	2445.5	61.5	0.000	0.000	0.613	15.791	424536	54.1	3.820	73	41.4	59.5	0.0	0.020	13969	12130	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

q1000.1

q1000.1: range queries with 1000 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
7978	111298	0	0.0	2672.4	93.4	0.000	0.000	0.335	11.982	418763	56.1	3.763	76	48.9	77.5	0.0	0.035	13905	12599	160m.pg153_o3_native_lto.cx7a_gcp_c2s30
7978	111142	0	0.0	2628.2	80.5	0.000	0.000	0.329	10.335	419789	56.4	3.777	76	48.6	67.2	0.0	0.022	13953	12962	160m.pg153_o3_native_lto.cx7a1_gcp_c2s30
7978	110954	0	0.0	2600.1	93.8	0.000	0.000	0.326	12.036	419603	56.0	3.782	76	48.8	77.3	0.0	0.081	13878	12882	160m.pg153_o3_native_lto.cx7a2_gcp_c2s30
7976	114570	0	0.0	2472.7	65.5	0.000	0.000	0.310	8.405	428815	55.9	3.743	73	49.1	80.5	0.0	0.032	14400	13058	160m.pg153_o3_native_lto.cx7a3_gcp_c2s30
7976	113259	0	0.0	273.8	21.0	0.000	0.000	0.034	2.693	424762	55.8	3.750	74	48.8	109.3	0.0	0.049	14293	13222	160m.pg153_o3_native_lto.cx7a4_gcp_c2s30
7976	111120	0	0.0	2679.3	93.7	0.000	0.000	0.336	12.024	419102	56.1	3.772	76	48.9	77.5	0.0	0.043	14113	12754	160m.pg153_o3_native_lto.cx7a5_gcp_c2s30
7978	111461	0	0.0	2601.5	94.0	0.000	0.000	0.326	12.071	419712	56.1	3.766	75	48.8	77.3	0.0	0.035	14161	13011	160m.pg153_o3_native_lto.cx7a6_gcp_c2s30
7978	106740	0	0.0	9844.1	197.8	0.000	0.000	1.234	25.383	403822	55.7	3.783	78	48.7	64.8	0.0	0.292	13409	10724	160m.pg153_o3_native_lto.cx7a7_gcp_c2s30
7976	97625	2494	15.6	28621.5	785.9	0.026	0.163	3.589	100.900	373489	57.3	3.826	88	50.4	79.7	0.0	0.161	12514	7256	160m.pg153_o3_native_lto.cx7a8_gcp_c2s30
7976	113846	0	0.0	627.1	37.4	0.000	0.000	0.079	4.799	428380	55.8	3.763	74	48.8	94.1	0.0	0.048	14353	13238	160m.pg153_o3_native_lto.cx7a9_gcp_c2s30
7976	106827	0	0.0	2561.8	93.3	0.000	0.000	0.321	11.978	400131	56.7	3.746	80	48.8	77.7	0.0	0.027	13441	11908	160m.pg153_o3_native_lto.cx7a10_gcp_c2s30
7943	105734	0	0.0	2634.5	93.0	0.000	0.000	0.332	11.996	401903	56.1	3.801	80	49.0	77.5	0.0	15.654	13361	11859	160m.pg153_o3_native_lto.cx7a11_gcp_c2s30
7978	105898	0	0.0	2680.1	94.2	0.000	0.000	0.336	12.095	401042	56.7	3.787	80	48.8	77.5	0.0	0.096	13297	11923	160m.pg153_o3_native_lto.cx7a12_gcp_c2s30
7976	108036	0	0.0	2577.4	92.0	0.000	0.000	0.323	11.812	405081	56.5	3.749	78	49.1	77.9	0.0	0.269	13526	12354	160m.pg153_o3_native_lto.cx7a13_gcp_c2s30
7976	105715	0	0.0	2579.7	94.1	0.000	0.000	0.323	12.088	400771	56.3	3.791	80	48.5	77.3	0.0	0.039	13090	12023	160m.pg153_o3_native_lto.cx7a14_gcp_c2s30
7976	108612	0	0.0	2499.8	95.7	0.000	0.000	0.313	12.293	407103	56.4	3.748	78	49.0	77.7	0.0	0.056	13585	12216	160m.pg153_o3_native_lto.cx7a15_gcp_c2s30
7978	110511	0	0.0	2065.0	87.9	0.000	0.000	0.259	11.278	420941	55.0	3.809	75	41.3	69.8	0.0	0.025	13985	11992	160m.pg153_o3_native_lto.cx7a16_gcp_c2s30
7976	106692	0	0.0	2651.2	94.0	0.000	0.000	0.332	12.064	401707	56.4	3.765	79	48.7	77.4	0.0	0.057	13521	11908	160m.pg153_o3_native_lto.cx7a17_gcp_c2s30
7976	111408	0	0.0	2051.4	76.2	0.000	0.000	0.257	9.790	422986	55.2	3.797	74	41.4	60.1	0.0	0.054	13873	11927	160m.pg153_o3_native_lto.cx7a18_gcp_c2s30

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	97.701	2.236	0.040	0.008	0.013	0.002	0.000	0.000	0.000	0.704	pg153_o3_native_lto.cx7a_gcp_c2s30
0.000	98.225	1.716	0.038	0.005	0.012	0.004	0.000	0.000	0.000	0.397	pg153_o3_native_lto.cx7a1_gcp_c2s30
0.000	97.866	2.072	0.038	0.006	0.015	0.003	0.000	0.000	0.000	0.523	pg153_o3_native_lto.cx7a2_gcp_c2s30
0.000	97.950	1.984	0.045	0.006	0.013	0.003	0.000	0.000	0.000	0.407	pg153_o3_native_lto.cx7a3_gcp_c2s30
0.000	98.089	1.849	0.041	0.005	0.011	0.004	0.000	0.000	0.000	0.697	pg153_o3_native_lto.cx7a4_gcp_c2s30
0.000	98.199	1.734	0.043	0.006	0.016	0.003	0.000	0.000	0.000	0.408	pg153_o3_native_lto.cx7a5_gcp_c2s30
0.000	98.170	1.768	0.046	0.003	0.010	0.004	0.000	0.000	0.000	0.448	pg153_o3_native_lto.cx7a6_gcp_c2s30
0.000	97.968	1.955	0.052	0.010	0.012	0.002	0.000	0.000	0.000	0.442	pg153_o3_native_lto.cx7a7_gcp_c2s30
0.000	97.754	2.122	0.077	0.031	0.011	0.004	0.000	0.000	0.000	0.401	pg153_o3_native_lto.cx7a8_gcp_c2s30
0.000	97.658	2.283	0.037	0.007	0.011	0.004	0.000	0.000	0.000	0.413	pg153_o3_native_lto.cx7a9_gcp_c2s30
0.000	97.534	2.405	0.035	0.005	0.009	0.012	0.000	0.000	0.000	0.876	pg153_o3_native_lto.cx7a10_gcp_c2s30
0.000	97.536	2.402	0.040	0.004	0.015	0.003	0.000	0.000	0.000	0.550	pg153_o3_native_lto.cx7a11_gcp_c2s30
0.000	97.786	2.167	0.037	0.002	0.005	0.003	0.000	0.000	0.000	0.756	pg153_o3_native_lto.cx7a12_gcp_c2s30
0.000	97.983	2.004	0.005	0.002	0.003	0.002	0.000	0.000	0.000	0.605	pg153_o3_native_lto.cx7a13_gcp_c2s30
0.000	97.599	2.337	0.042	0.005	0.015	0.002	0.000	0.000	0.000	0.420	pg153_o3_native_lto.cx7a14_gcp_c2s30
0.000	97.264	2.589	0.105	0.026	0.012	0.003	0.000	0.000	0.000	0.483	pg153_o3_native_lto.cx7a15_gcp_c2s30
0.000	97.436	2.505	0.036	0.006	0.014	0.003	0.000	0.000	0.000	0.322	pg153_o3_native_lto.cx7a16_gcp_c2s30
0.000	97.533	2.410	0.038	0.002	0.013	0.003	0.000	0.000	0.000	0.443	pg153_o3_native_lto.cx7a17_gcp_c2s30
0.000	97.468	2.469	0.042	0.005	0.016	0.001	0.000	0.000	0.000	0.458	pg153_o3_native_lto.cx7a18_gcp_c2s30

Delete response time histogram

0.000	sum:DBMS
0.000	pg153_o3_native_lto.cx7a_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a1_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a2_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a3_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a4_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a5_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a6_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a7_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a8_gcp_c2s30
0.000	pg153_o3_native_lto.cx7a9_gcp_c2s30

l.x

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	56.278	43.383	0.261	0.075	0.002	nonzero	0.000	0.000	0.000	0.503	pg153_o3_native_lto.cx7a_gcp_c2s30
0.000	55.942	43.982	0.062	0.013	0.001	nonzero	0.000	0.000	0.000	0.432	pg153_o3_native_lto.cx7a1_gcp_c2s30
0.000	51.916	47.768	0.244	0.071	0.001	nonzero	0.000	0.000	0.000	0.266	pg153_o3_native_lto.cx7a2_gcp_c2s30
0.000	60.183	39.799	0.017	0.001	0.001	nonzero	0.000	0.000	0.000	0.406	pg153_o3_native_lto.cx7a3_gcp_c2s30
0.000	54.924	44.736	0.261	0.078	0.002	nonzero	0.000	0.000	0.000	0.389	pg153_o3_native_lto.cx7a4_gcp_c2s30
0.000	54.254	45.413	0.255	0.076	0.002	0.000	0.000	0.000	0.000	0.244	pg153_o3_native_lto.cx7a5_gcp_c2s30
0.000	56.339	43.359	0.240	0.060	0.002	nonzero	0.000	0.000	0.000	0.474	pg153_o3_native_lto.cx7a6_gcp_c2s30
0.000	34.492	62.391	1.876	1.220	0.020	nonzero	0.000	0.000	0.000	0.657	pg153_o3_native_lto.cx7a7_gcp_c2s30
0.000	1.225	82.009	15.159	1.564	0.043	nonzero	0.000	0.000	0.000	0.318	pg153_o3_native_lto.cx7a8_gcp_c2s30
0.000	55.884	43.809	0.243	0.063	0.001	nonzero	0.000	0.000	0.000	0.325	pg153_o3_native_lto.cx7a9_gcp_c2s30
0.000	9.392	90.077	0.210	0.312	0.007	0.001	0.000	0.000	0.000	0.934	pg153_o3_native_lto.cx7a10_gcp_c2s30
0.000	11.103	88.491	0.314	0.090	0.001	nonzero	0.000	0.000	0.000	0.303	pg153_o3_native_lto.cx7a11_gcp_c2s30
0.000	15.492	84.304	0.100	0.099	0.004	nonzero	0.000	0.000	0.000	0.676	pg153_o3_native_lto.cx7a12_gcp_c2s30
0.000	11.249	88.655	0.037	0.049	0.010	0.001	0.000	0.000	0.000	0.733	pg153_o3_native_lto.cx7a13_gcp_c2s30
0.000	7.710	91.945	0.275	0.069	0.001	nonzero	0.000	0.000	0.000	0.262	pg153_o3_native_lto.cx7a14_gcp_c2s30
0.000	4.773	94.020	1.006	0.197	0.005	0.000	0.000	0.000	0.000	0.209	pg153_o3_native_lto.cx7a15_gcp_c2s30
0.000	4.229	94.923	0.664	0.183	0.001	0.000	0.000	0.000	0.000	0.215	pg153_o3_native_lto.cx7a16_gcp_c2s30
0.000	7.443	92.190	0.284	0.082	0.001	nonzero	0.000	0.000	0.000	0.306	pg153_o3_native_lto.cx7a17_gcp_c2s30
0.000	36.666	62.935	0.353	0.046	0.001	nonzero	0.000	0.000	0.000	0.297	pg153_o3_native_lto.cx7a18_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
83.817	2.756	2.318	7.199	3.907	0.004	nonzero	0.000	0.000	0.000	0.306	pg153_o3_native_lto.cx7a_gcp_c2s30
83.507	3.087	2.562	7.134	3.708	0.001	nonzero	0.000	0.000	0.000	0.439	pg153_o3_native_lto.cx7a1_gcp_c2s30
83.645	2.854	1.992	7.531	3.975	0.002	nonzero	0.000	0.000	0.000	0.270	pg153_o3_native_lto.cx7a2_gcp_c2s30
84.116	2.556	2.942	6.678	3.707	0.001	nonzero	0.000	0.000	0.000	0.416	pg153_o3_native_lto.cx7a3_gcp_c2s30
83.802	2.549	2.426	7.118	4.102	0.002	nonzero	0.000	0.000	0.000	0.365	pg153_o3_native_lto.cx7a4_gcp_c2s30
83.643	2.744	2.494	7.093	4.024	0.002	0.000	0.000	0.000	0.000	0.250	pg153_o3_native_lto.cx7a5_gcp_c2s30
83.869	2.637	2.649	6.947	3.896	0.002	nonzero	0.000	0.000	0.000	0.488	pg153_o3_native_lto.cx7a6_gcp_c2s30
81.070	3.378	1.938	7.889	5.676	0.048	nonzero	0.000	0.000	0.000	0.779	pg153_o3_native_lto.cx7a7_gcp_c2s30
84.759	5.471	0.575	4.524	4.663	0.008	nonzero	0.000	0.000	0.000	0.358	pg153_o3_native_lto.cx7a8_gcp_c2s30
83.716	2.705	2.518	7.169	3.890	0.002	nonzero	0.000	0.000	0.000	0.340	pg153_o3_native_lto.cx7a9_gcp_c2s30
83.608	2.434	2.387	6.653	4.899	0.017	0.001	0.000	0.000	0.000	0.947	pg153_o3_native_lto.cx7a10_gcp_c2s30
83.496	2.604	2.105	7.070	4.724	0.002	nonzero	0.000	0.000	0.000	0.309	pg153_o3_native_lto.cx7a11_gcp_c2s30
83.564	2.666	2.171	7.036	4.556	0.006	nonzero	0.000	0.000	0.000	0.680	pg153_o3_native_lto.cx7a12_gcp_c2s30
83.964	2.522	1.941	6.889	4.669	0.016	0.001	0.000	0.000	0.000	0.743	pg153_o3_native_lto.cx7a13_gcp_c2s30
83.828	2.303	2.132	6.745	4.991	0.001	nonzero	0.000	0.000	0.000	0.266	pg153_o3_native_lto.cx7a14_gcp_c2s30
81.775	3.553	1.829	7.464	5.371	0.008	nonzero	0.000	0.000	0.000	0.356	pg153_o3_native_lto.cx7a15_gcp_c2s30
77.981	8.245	11.283	2.393	0.098	nonzero	0.000	0.000	0.000	0.000	0.216	pg153_o3_native_lto.cx7a16_gcp_c2s30
83.762	2.365	2.131	6.952	4.789	0.001	nonzero	0.000	0.000	0.000	0.307	pg153_o3_native_lto.cx7a17_gcp_c2s30
77.114	9.949	10.945	1.972	0.020	0.001	nonzero	0.000	0.000	0.000	0.302	pg153_o3_native_lto.cx7a18_gcp_c2s30

q100.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.996	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg153_o3_native_lto.cx7a_gcp_c2s30
99.996	0.003	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a1_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	nonzero	0.000	0.000	0.000	0.338	pg153_o3_native_lto.cx7a2_gcp_c2s30
99.996	0.003	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg153_o3_native_lto.cx7a3_gcp_c2s30
99.997	0.003	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg153_o3_native_lto.cx7a4_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a5_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	nonzero	0.000	0.000	0.000	0.338	pg153_o3_native_lto.cx7a6_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg153_o3_native_lto.cx7a7_gcp_c2s30
99.961	0.038	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.229	pg153_o3_native_lto.cx7a8_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg153_o3_native_lto.cx7a9_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a10_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a11_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a12_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a13_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a14_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a15_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.cx7a16_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg153_o3_native_lto.cx7a17_gcp_c2s30
99.995	0.004	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a18_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a_gcp_c2s30
0.000	0.019	99.762	0.219	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg153_o3_native_lto.cx7a1_gcp_c2s30
0.000	0.679	99.316	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg153_o3_native_lto.cx7a2_gcp_c2s30
0.000	48.030	51.970	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a3_gcp_c2s30
0.000	15.927	84.071	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg153_o3_native_lto.cx7a4_gcp_c2s30
0.000	1.000	98.986	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a5_gcp_c2s30
0.000	1.201	98.793	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a6_gcp_c2s30
0.000	0.000	99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a7_gcp_c2s30
0.000	0.000	81.936	17.797	0.260	0.007	0.000	0.000	0.000	0.000	0.185	pg153_o3_native_lto.cx7a8_gcp_c2s30
0.000	6.825	93.172	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg153_o3_native_lto.cx7a9_gcp_c2s30
0.000	0.007	99.991	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg153_o3_native_lto.cx7a10_gcp_c2s30
0.000	0.007	99.986	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg153_o3_native_lto.cx7a11_gcp_c2s30
0.000	0.061	99.938	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a12_gcp_c2s30
0.000	0.043	99.951	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a13_gcp_c2s30
0.000	0.028	99.965	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a14_gcp_c2s30
0.000	0.000	99.995	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a15_gcp_c2s30
0.000	0.031	99.964	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg153_o3_native_lto.cx7a16_gcp_c2s30
0.000	0.016	99.979	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a17_gcp_c2s30
0.000	0.477	99.385	0.137	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg153_o3_native_lto.cx7a18_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
56.127	29.429	14.438	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a_gcp_c2s30
63.517	21.747	14.729	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a1_gcp_c2s30
57.613	31.411	10.969	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a2_gcp_c2s30
43.833	33.325	22.842	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg153_o3_native_lto.cx7a3_gcp_c2s30
59.019	31.601	9.378	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a4_gcp_c2s30
58.455	26.814	14.724	0.007	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg153_o3_native_lto.cx7a5_gcp_c2s30
53.344	32.891	13.760	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg153_o3_native_lto.cx7a6_gcp_c2s30
47.993	28.342	23.660	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a7_gcp_c2s30
65.483	24.306	10.198	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a8_gcp_c2s30
58.259	24.694	17.043	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a9_gcp_c2s30
74.337	10.896	14.764	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg153_o3_native_lto.cx7a10_gcp_c2s30
64.030	11.111	24.250	0.609	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a11_gcp_c2s30
64.444	18.741	16.804	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a12_gcp_c2s30
48.689	30.806	20.229	0.276	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg153_o3_native_lto.cx7a13_gcp_c2s30
62.054	16.759	21.184	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a14_gcp_c2s30
48.807	27.224	23.391	0.578	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg153_o3_native_lto.cx7a15_gcp_c2s30
58.783	15.557	25.656	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg153_o3_native_lto.cx7a16_gcp_c2s30
56.309	26.102	17.583	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg153_o3_native_lto.cx7a17_gcp_c2s30
63.378	22.837	13.759	0.026	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg153_o3_native_lto.cx7a18_gcp_c2s30

q500.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.979	0.013	0.008	0.001	nonzero	0.000	nonzero	0.000	0.000	0.000	0.338	pg153_o3_native_lto.cx7a_gcp_c2s30
99.979	0.014	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.018	pg153_o3_native_lto.cx7a1_gcp_c2s30
99.976	0.014	0.009	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	pg153_o3_native_lto.cx7a2_gcp_c2s30
99.987	0.007	0.005	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.027	pg153_o3_native_lto.cx7a3_gcp_c2s30
99.984	0.009	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	pg153_o3_native_lto.cx7a4_gcp_c2s30
99.977	0.014	0.008	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.338	pg153_o3_native_lto.cx7a5_gcp_c2s30
99.977	0.014	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.023	pg153_o3_native_lto.cx7a6_gcp_c2s30
99.974	0.016	0.008	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.338	pg153_o3_native_lto.cx7a7_gcp_c2s30
99.921	0.075	0.004	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.072	pg153_o3_native_lto.cx7a8_gcp_c2s30
99.983	0.010	0.007	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.086	pg153_o3_native_lto.cx7a9_gcp_c2s30
99.977	0.015	0.007	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a10_gcp_c2s30
99.976	0.016	0.008	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg153_o3_native_lto.cx7a11_gcp_c2s30
99.976	0.016	0.008	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg153_o3_native_lto.cx7a12_gcp_c2s30
99.977	0.015	0.007	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg153_o3_native_lto.cx7a13_gcp_c2s30
99.975	0.016	0.008	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.018	pg153_o3_native_lto.cx7a14_gcp_c2s30
99.975	0.016	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	pg153_o3_native_lto.cx7a15_gcp_c2s30
99.979	0.015	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.019	pg153_o3_native_lto.cx7a16_gcp_c2s30
99.976	0.016	0.008	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.018	pg153_o3_native_lto.cx7a17_gcp_c2s30
99.978	0.016	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	pg153_o3_native_lto.cx7a18_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	7.687	91.830	0.478	0.006	0.000	0.000	0.000	0.000	0.000	0.026	pg153_o3_native_lto.cx7a_gcp_c2s30
0.000	0.000	99.518	0.475	0.007	0.000	0.000	0.000	0.000	0.000	0.020	pg153_o3_native_lto.cx7a1_gcp_c2s30
0.000	5.206	94.135	0.649	0.010	0.000	0.000	0.000	0.000	0.000	0.030	pg153_o3_native_lto.cx7a2_gcp_c2s30
0.000	76.632	23.180	0.186	0.001	0.000	0.000	0.000	0.000	0.000	0.020	pg153_o3_native_lto.cx7a3_gcp_c2s30
0.000	52.310	47.044	0.610	0.037	0.000	0.000	0.000	0.000	0.000	0.043	pg153_o3_native_lto.cx7a4_gcp_c2s30
0.000	7.330	91.783	0.814	0.073	0.000	0.000	0.000	0.000	0.000	0.049	pg153_o3_native_lto.cx7a5_gcp_c2s30
0.000	6.080	92.878	1.010	0.032	0.000	0.000	0.000	0.000	0.000	0.033	pg153_o3_native_lto.cx7a6_gcp_c2s30
0.000	1.439	97.836	0.496	0.202	0.027	0.000	0.000	0.000	0.000	0.148	pg153_o3_native_lto.cx7a7_gcp_c2s30
0.000	0.000	89.326	9.901	0.752	0.021	0.000	0.000	0.000	0.000	0.218	pg153_o3_native_lto.cx7a8_gcp_c2s30
0.000	43.049	56.608	0.290	0.050	0.003	0.000	0.000	0.000	0.000	0.078	pg153_o3_native_lto.cx7a9_gcp_c2s30
0.000	0.008	99.597	0.343	0.052	0.000	0.000	0.000	0.000	0.000	0.040	pg153_o3_native_lto.cx7a10_gcp_c2s30
0.000	0.014	99.668	0.317	0.001	0.000	0.000	0.000	0.000	0.000	0.019	pg153_o3_native_lto.cx7a11_gcp_c2s30
0.000	0.041	99.822	0.136	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg153_o3_native_lto.cx7a12_gcp_c2s30
0.000	0.019	99.585	0.387	0.010	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a13_gcp_c2s30
0.000	0.001	99.686	0.310	0.002	0.000	0.000	0.000	0.000	0.000	0.019	pg153_o3_native_lto.cx7a14_gcp_c2s30
0.000	0.022	99.308	0.643	0.027	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a15_gcp_c2s30
0.000	0.624	99.166	0.207	0.002	0.000	0.000	0.000	0.000	0.000	0.017	pg153_o3_native_lto.cx7a16_gcp_c2s30
0.000	0.003	99.715	0.279	0.003	0.000	0.000	0.000	0.000	0.000	0.020	pg153_o3_native_lto.cx7a17_gcp_c2s30
0.000	1.993	97.610	0.395	0.001	0.000	0.000	0.000	0.000	0.000	0.018	pg153_o3_native_lto.cx7a18_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
78.160	1.089	3.862	16.787	0.102	0.000	0.000	0.000	0.000	0.000	0.038	pg153_o3_native_lto.cx7a_gcp_c2s30
78.558	1.803	4.130	15.497	0.013	0.000	0.000	0.000	0.000	0.000	0.030	pg153_o3_native_lto.cx7a1_gcp_c2s30
77.719	1.197	3.081	17.940	0.062	0.000	0.000	0.000	0.000	0.000	0.046	pg153_o3_native_lto.cx7a2_gcp_c2s30
81.320	0.908	0.700	17.006	0.066	0.000	0.000	0.000	0.000	0.000	0.040	pg153_o3_native_lto.cx7a3_gcp_c2s30
77.676	1.332	3.577	17.226	0.190	0.000	0.000	0.000	0.000	0.000	0.043	pg153_o3_native_lto.cx7a4_gcp_c2s30
76.440	1.238	3.719	18.465	0.138	0.000	0.000	0.000	0.000	0.000	0.045	pg153_o3_native_lto.cx7a5_gcp_c2s30
77.862	1.188	2.480	18.338	0.133	0.000	0.000	0.000	0.000	0.000	0.038	pg153_o3_native_lto.cx7a6_gcp_c2s30
78.308	1.313	2.159	17.905	0.297	0.018	0.000	0.000	0.000	0.000	0.148	pg153_o3_native_lto.cx7a7_gcp_c2s30
76.415	2.983	4.503	16.067	0.031	0.001	0.000	0.000	0.000	0.000	0.080	pg153_o3_native_lto.cx7a8_gcp_c2s30
79.200	1.299	2.768	16.648	0.081	0.003	0.000	0.000	0.000	0.000	0.081	pg153_o3_native_lto.cx7a9_gcp_c2s30
79.518	1.277	3.071	16.071	0.062	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a10_gcp_c2s30
77.917	1.284	2.443	18.339	0.017	0.000	0.000	0.000	0.000	0.000	0.022	pg153_o3_native_lto.cx7a11_gcp_c2s30
79.521	1.265	4.424	14.778	0.013	0.000	0.000	0.000	0.000	0.000	0.022	pg153_o3_native_lto.cx7a12_gcp_c2s30
76.639	1.472	1.858	19.662	0.369	0.000	0.000	0.000	0.000	0.000	0.044	pg153_o3_native_lto.cx7a13_gcp_c2s30
77.912	1.426	4.893	15.757	0.011	0.000	0.000	0.000	0.000	0.000	0.031	pg153_o3_native_lto.cx7a14_gcp_c2s30
77.571	1.691	2.437	18.166	0.135	0.000	0.000	0.000	0.000	0.000	0.041	pg153_o3_native_lto.cx7a15_gcp_c2s30
79.768	6.865	8.266	5.101	0.001	0.000	0.000	0.000	0.000	0.000	0.018	pg153_o3_native_lto.cx7a16_gcp_c2s30
79.505	1.299	3.713	15.395	0.087	0.000	0.000	0.000	0.000	0.000	0.027	pg153_o3_native_lto.cx7a17_gcp_c2s30
78.028	9.403	8.489	4.080	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg153_o3_native_lto.cx7a18_gcp_c2s30

q1000.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.945	0.037	0.015	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	pg153_o3_native_lto.cx7a_gcp_c2s30
99.946	0.042	0.011	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.022	pg153_o3_native_lto.cx7a1_gcp_c2s30
99.942	0.039	0.016	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.081	pg153_o3_native_lto.cx7a2_gcp_c2s30
99.965	0.024	0.011	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	pg153_o3_native_lto.cx7a3_gcp_c2s30
99.960	0.028	0.012	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.049	pg153_o3_native_lto.cx7a4_gcp_c2s30
99.944	0.037	0.015	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.043	pg153_o3_native_lto.cx7a5_gcp_c2s30
99.942	0.038	0.017	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	pg153_o3_native_lto.cx7a6_gcp_c2s30
99.900	0.055	0.028	0.015	0.001	nonzero	nonzero	0.000	0.000	0.000	0.292	pg153_o3_native_lto.cx7a7_gcp_c2s30
99.689	0.283	0.021	0.006	0.002	nonzero	0.000	0.000	0.000	0.000	0.161	pg153_o3_native_lto.cx7a8_gcp_c2s30
99.954	0.031	0.013	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.048	pg153_o3_native_lto.cx7a9_gcp_c2s30
99.937	0.045	0.016	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.027	pg153_o3_native_lto.cx7a10_gcp_c2s30
99.939	0.043	0.015	0.002	nonzero	0.000	0.000	0.000	nonzero	0.000	15.654	pg153_o3_native_lto.cx7a11_gcp_c2s30
99.937	0.047	0.015	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.096	pg153_o3_native_lto.cx7a12_gcp_c2s30
99.951	0.036	0.013	0.001	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.269	pg153_o3_native_lto.cx7a13_gcp_c2s30
99.933	0.046	0.017	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.039	pg153_o3_native_lto.cx7a14_gcp_c2s30
99.941	0.041	0.015	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.056	pg153_o3_native_lto.cx7a15_gcp_c2s30
99.938	0.043	0.016	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg153_o3_native_lto.cx7a16_gcp_c2s30
99.937	0.043	0.017	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.057	pg153_o3_native_lto.cx7a17_gcp_c2s30
99.944	0.044	0.012	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.054	pg153_o3_native_lto.cx7a18_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	23.085	74.293	2.470	0.152	0.000	0.000	0.000	0.000	0.000	0.042	pg153_o3_native_lto.cx7a_gcp_c2s30
0.000	2.840	96.246	0.890	0.023	0.000	0.000	0.000	0.000	0.000	0.030	pg153_o3_native_lto.cx7a1_gcp_c2s30
0.000	19.257	78.408	2.230	0.105	0.000	0.000	0.000	0.000	0.000	0.036	pg153_o3_native_lto.cx7a2_gcp_c2s30
0.000	63.232	36.339	0.417	0.012	0.000	0.000	0.000	0.000	0.000	0.035	pg153_o3_native_lto.cx7a3_gcp_c2s30
0.000	52.273	46.767	0.860	0.100	0.000	0.000	0.000	0.000	0.000	0.044	pg153_o3_native_lto.cx7a4_gcp_c2s30
0.000	25.226	72.617	2.066	0.091	0.000	0.000	0.000	0.000	0.000	0.051	pg153_o3_native_lto.cx7a5_gcp_c2s30
0.000	20.192	76.839	2.808	0.161	0.000	0.000	0.000	0.000	0.000	0.041	pg153_o3_native_lto.cx7a6_gcp_c2s30
0.000	0.149	86.888	11.510	1.420	0.033	nonzero	0.000	0.000	0.000	0.299	pg153_o3_native_lto.cx7a7_gcp_c2s30
0.000	0.000	84.848	13.126	1.924	0.101	nonzero	0.000	0.000	0.000	0.323	pg153_o3_native_lto.cx7a8_gcp_c2s30
0.000	48.642	49.808	1.408	0.141	0.000	0.000	0.000	0.000	0.000	0.045	pg153_o3_native_lto.cx7a9_gcp_c2s30
0.000	0.682	97.015	2.144	0.158	0.000	0.000	0.000	0.000	0.000	0.040	pg153_o3_native_lto.cx7a10_gcp_c2s30
0.000	2.004	96.291	1.565	0.138	nonzero	0.000	0.000	0.001	0.000	15.661	pg153_o3_native_lto.cx7a11_gcp_c2s30
0.000	1.350	98.140	0.494	0.014	0.002	0.000	0.000	0.000	0.000	0.101	pg153_o3_native_lto.cx7a12_gcp_c2s30
0.000	1.065	98.237	0.647	0.048	0.003	0.000	0.000	0.000	0.000	0.152	pg153_o3_native_lto.cx7a13_gcp_c2s30
0.000	0.489	96.210	3.106	0.195	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a14_gcp_c2s30
0.000	1.297	95.948	2.394	0.360	0.001	0.000	0.000	0.000	0.000	0.114	pg153_o3_native_lto.cx7a15_gcp_c2s30
0.000	4.598	92.367	2.856	0.179	0.000	0.000	0.000	0.000	0.000	0.045	pg153_o3_native_lto.cx7a16_gcp_c2s30
0.000	0.662	96.470	2.688	0.180	0.000	0.000	0.000	0.000	0.000	0.058	pg153_o3_native_lto.cx7a17_gcp_c2s30
0.000	9.230	89.521	1.213	0.037	0.000	0.000	0.000	0.000	0.000	0.040	pg153_o3_native_lto.cx7a18_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
78.416	2.335	2.535	13.449	3.265	0.000	0.000	0.000	0.000	0.000	0.052	pg153_o3_native_lto.cx7a_gcp_c2s30
76.934	4.012	3.232	12.698	3.124	0.000	0.000	0.000	0.000	0.000	0.028	pg153_o3_native_lto.cx7a1_gcp_c2s30
78.403	2.823	2.743	13.607	2.423	0.000	0.000	0.000	0.000	0.000	0.049	pg153_o3_native_lto.cx7a2_gcp_c2s30
79.119	3.131	1.350	12.595	3.806	0.000	0.000	0.000	0.000	0.000	0.051	pg153_o3_native_lto.cx7a3_gcp_c2s30
77.731	3.355	2.479	13.190	3.245	0.000	0.000	0.000	0.000	0.000	0.056	pg153_o3_native_lto.cx7a4_gcp_c2s30
78.367	2.811	2.528	13.497	2.798	0.000	0.000	0.000	0.000	0.000	0.048	pg153_o3_native_lto.cx7a5_gcp_c2s30
78.101	3.176	2.474	12.867	3.382	0.000	0.000	0.000	0.000	0.000	0.050	pg153_o3_native_lto.cx7a6_gcp_c2s30
72.321	5.914	2.830	14.583	4.341	0.012	0.000	0.000	0.000	0.000	0.194	pg153_o3_native_lto.cx7a7_gcp_c2s30
76.984	4.108	3.351	12.181	3.364	0.012	0.000	0.000	0.000	0.000	0.157	pg153_o3_native_lto.cx7a8_gcp_c2s30
77.844	3.701	2.440	12.877	3.138	0.000	0.000	0.000	0.000	0.000	0.049	pg153_o3_native_lto.cx7a9_gcp_c2s30
75.154	3.313	3.970	11.202	6.362	0.000	0.000	0.000	0.000	0.000	0.052	pg153_o3_native_lto.cx7a10_gcp_c2s30
78.770	3.024	2.497	11.374	4.333	nonzero	0.000	0.000	0.001	0.000	15.721	pg153_o3_native_lto.cx7a11_gcp_c2s30
76.237	3.652	3.134	11.130	5.848	0.000	0.000	0.000	0.000	0.000	0.058	pg153_o3_native_lto.cx7a12_gcp_c2s30
79.646	2.269	1.435	11.343	5.307	0.001	0.000	0.000	0.000	0.000	0.081	pg153_o3_native_lto.cx7a13_gcp_c2s30
76.181	3.932	2.866	11.620	5.402	0.000	0.000	0.000	0.000	0.000	0.050	pg153_o3_native_lto.cx7a14_gcp_c2s30
77.296	3.522	1.949	11.553	5.680	0.001	0.000	0.000	0.000	0.000	0.144	pg153_o3_native_lto.cx7a15_gcp_c2s30
77.773	7.071	6.740	8.351	0.065	0.000	0.000	0.000	0.000	0.000	0.037	pg153_o3_native_lto.cx7a16_gcp_c2s30
76.479	3.844	2.522	11.195	5.960	0.000	0.000	0.000	0.000	0.000	0.047	pg153_o3_native_lto.cx7a17_gcp_c2s30
77.568	7.309	9.767	5.343	0.014	0.000	0.000	0.000	0.000	0.000	0.032	pg153_o3_native_lto.cx7a18_gcp_c2s30