Introduction

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

The test server has 8 AMD cores, 32G RAM and an NVMe SSD. It is described here as the PN53. The benchmark was run with 1 client and there were 1 or 3 connections per client (1 for queries or inserts without rate limits, 1+1 for rate limited inserts+deletes). It uses 1 table. It loads 20M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 40m+10m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 1800s each that do queries as fast as possible with 100,100,500,500,1000,1000 inserts/s and the same for deletes/s per client concurrent with the queries. The database is cached 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, l.i1 and l.i2, indexed docs (or rows) /s for l.x and queries/s for qr100, qp100 thru qr1000, qp1000" The values are the average rate over the entire test for inserts (IPS) and queries (QPS). The range of values for IPS and QPS is split into 3 parts: bottom 25%, middle 50%, top 25%. Values in the bottom 25% have a red background, values in the top 25% have a green background and values in the middle have no color. A gray background is used for values that can be ignored because the DBMS did not sustain the target insert rate. Red backgrounds are not used when the minimum value is within 80% of the max value.

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
pg140_o2nofp.cx10a_c8r32 139860322582268283516150366166146336278144906266
pg1418_o2nofp.cx10a_c8r32 136986333335253323322150806168143946150143096130
pg150_o2nofp.cx10a_c8r32 142857350879264723515153356193146776226147466200
pg1513_o2nofp.cx10a_c8r32 143885363638269003598151336192144536188144086156
pg160_o2nofp.cx10a_c8r32 142857370372246003287152366148146996152145846150
pg169_o2nofp.cx10a_c8r32 141844357145261273511152896219147186143146426164
pg170_o2nofp.cx10a_c8r32 140845370372249693168152586170145636106145566072
pg175_o2nofp.cx10a_c8r32 138889384617254133229152766135144296089144996082
pg18beta1_o2nofp.cx10b_c8r32 140845384617226883089149836020142766013141916003
pg18beta1_o2nofp.cx10c_c8r32 141844377360241843109149665994142366011142775985
pg18beta1_o2nofp.cx10d_c8r32 139860377360227923233148655734143165710143695731

This table has relative throughput, throughput for the DBMS relative to the DBMS in the first line, using the absolute throughput from the previous table. Values less than 0.95 have a yellow background. Values greater than 1.05 have a blue background.

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
pg140_o2nofp.cx10a_c8r32 1.001.001.001.001.001.001.001.001.001.00
pg1418_o2nofp.cx10a_c8r32 0.981.030.940.941.001.000.980.980.990.98
pg150_o2nofp.cx10a_c8r32 1.021.090.991.001.021.001.000.991.020.99
pg1513_o2nofp.cx10a_c8r32 1.031.131.001.021.011.000.990.990.990.98
pg160_o2nofp.cx10a_c8r32 1.021.150.920.931.011.001.000.981.010.98
pg169_o2nofp.cx10a_c8r32 1.011.110.971.001.021.011.010.981.010.98
pg170_o2nofp.cx10a_c8r32 1.011.150.930.901.011.001.000.971.000.97
pg175_o2nofp.cx10a_c8r32 0.991.190.950.921.020.990.990.971.000.97
pg18beta1_o2nofp.cx10b_c8r32 1.011.190.850.881.000.980.980.960.980.96
pg18beta1_o2nofp.cx10c_c8r32 1.011.170.900.881.000.970.970.960.990.96
pg18beta1_o2nofp.cx10d_c8r32 1.001.170.850.920.990.930.980.910.990.91

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.

dbmsqr100.L1qp100.L2qr500.L3qp500.L4qr1000.L5qp1000.L6
pg140_o2nofp.cx10a_c8r3210010050050010001000
pg1418_o2nofp.cx10a_c8r32100100500500999999
pg150_o2nofp.cx10a_c8r32100100500500999999
pg1513_o2nofp.cx10a_c8r321001005005001000999
pg160_o2nofp.cx10a_c8r32100100500500999999
pg169_o2nofp.cx10a_c8r32100100500500999999
pg170_o2nofp.cx10a_c8r32100100500500999999
pg175_o2nofp.cx10a_c8r321001005005001000999
pg18beta1_o2nofp.cx10b_c8r3210010050050010001000
pg18beta1_o2nofp.cx10c_c8r32100100500500999999
pg18beta1_o2nofp.cx10d_c8r32100100500500999999
target10010050050010001000

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
pg140_o2nofp.cx10a_c8r3299.9800.0200.003
pg1418_o2nofp.cx10a_c8r3299.9790.0200.0010.005
pg150_o2nofp.cx10a_c8r3299.9840.0150.003
pg1513_o2nofp.cx10a_c8r3299.9890.0110.002
pg160_o2nofp.cx10a_c8r3299.9870.0130.002
pg169_o2nofp.cx10a_c8r3299.9860.0140.002
pg170_o2nofp.cx10a_c8r3299.9880.0120.002
pg175_o2nofp.cx10a_c8r3299.9820.0180.003
pg18beta1_o2nofp.cx10b_c8r3299.9890.0110.002
pg18beta1_o2nofp.cx10c_c8r3299.9840.0170.002
pg18beta1_o2nofp.cx10d_c8r3299.9800.0200.002

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
139860	0	0	0.0	523.5	59.2	0.000	0.000	0.004	0.433	16764	19.7	0.120	11	1.9	5.2	0.8	0.003	140183	135583	pg140_o2nofp.cx10a_c8r32
136986	0	0	0.0	513.2	57.9	0.000	0.000	0.004	0.433	16480	19.5	0.120	11	1.9	5.2	2.0	0.005	137483	130883	pg1418_o2nofp.cx10a_c8r32
142857	0	0	0.0	533.4	60.5	0.000	0.000	0.004	0.434	17013	19.5	0.119	11	1.9	5.2	0.4	0.003	143384	137987	pg150_o2nofp.cx10a_c8r32
143885	0	0	0.0	541.1	61.4	0.000	0.000	0.004	0.437	17060	19.9	0.119	11	1.9	5.2	1.7	0.002	143683	136285	pg1513_o2nofp.cx10a_c8r32
142857	0	0	0.0	532.9	60.4	0.000	0.000	0.004	0.433	16959	19.8	0.119	11	1.9	5.2	1.7	0.002	142884	138284	pg160_o2nofp.cx10a_c8r32
141844	0	0	0.0	532.9	60.5	0.000	0.000	0.004	0.437	16918	19.7	0.119	11	1.9	5.2	0.4	0.002	143472	137884	pg169_o2nofp.cx10a_c8r32
140845	0	0	0.0	529.9	60.1	0.000	0.000	0.004	0.437	14473	19.6	0.103	11	1.9	5.2	1.6	0.002	142079	135682	pg170_o2nofp.cx10a_c8r32
138889	0	0	0.0	524.3	59.4	0.000	0.000	0.004	0.438	14300	19.8	0.103	11	1.9	5.2	1.6	0.003	140680	132885	pg175_o2nofp.cx10a_c8r32
140845	0	0	0.0	526.6	59.7	0.000	0.000	0.004	0.434	14333	19.8	0.102	11	1.9	5.2	1.2	0.002	141075	133683	pg18beta1_o2nofp.cx10b_c8r32
141844	0	0	0.0	529.4	60.0	0.000	0.000	0.004	0.433	14363	19.9	0.101	11	1.9	5.2	1.6	0.002	141782	134184	pg18beta1_o2nofp.cx10c_c8r32
139860	0	0	0.0	524.6	59.5	0.000	0.000	0.004	0.435	14210	19.8	0.102	11	1.9	5.2	1.6	0.002	140983	133285	pg18beta1_o2nofp.cx10d_c8r32

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
322582	0	0	0.0	644.2	78.8	0.000	0.000	0.002	0.250	1934	11.4	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg140_o2nofp.cx10a_c8r32
333335	0	0	0.0	756.9	92.7	0.000	0.000	0.002	0.285	2049	11.3	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg1418_o2nofp.cx10a_c8r32
350879	0	0	0.0	704.2	86.3	0.000	0.000	0.002	0.252	2046	11.3	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg150_o2nofp.cx10a_c8r32
363638	0	1	0.0	846.2	104.0	0.000	0.000	0.002	0.293	1584	11.5	0.004	3	3.9	8.9	2.1	0.002	NA	NA	pg1513_o2nofp.cx10a_c8r32
370372	0	1	0.0	848.2	104.3	0.000	0.000	0.002	0.288	1662	11.5	0.004	2	3.9	8.9	2.1	0.002	NA	NA	pg160_o2nofp.cx10a_c8r32
357145	0	0	0.0	720.9	88.4	0.000	0.000	0.002	0.253	2163	11.4	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg169_o2nofp.cx10a_c8r32
370372	0	0	0.0	543.8	66.6	0.000	0.000	0.001	0.184	1707	11.5	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg170_o2nofp.cx10a_c8r32
384617	0	0	0.0	616.1	75.4	0.000	0.000	0.002	0.201	1997	11.7	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg175_o2nofp.cx10a_c8r32
384617	0	0	0.0	619.5	75.9	0.000	0.000	0.002	0.202	1954	11.7	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg18beta1_o2nofp.cx10b_c8r32
377360	0	0	0.0	605.8	74.1	0.000	0.000	0.002	0.201	1933	11.5	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg18beta1_o2nofp.cx10c_c8r32
377360	0	0	0.0	602.5	73.7	0.000	0.000	0.002	0.200	1928	11.5	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg18beta1_o2nofp.cx10d_c8r32

l.i1

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

Average throughput:

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
pg140_o2nofp.cx10a_c8r3252.10647.8930.001nonzero0.057
pg1418_o2nofp.cx10a_c8r3255.19544.7950.0010.0090.049
pg150_o2nofp.cx10a_c8r3248.10551.8940.0010.0010.043
pg1513_o2nofp.cx10a_c8r3252.28747.7120.001nonzero0.021
pg160_o2nofp.cx10a_c8r3249.73050.2690.001nonzero0.026
pg169_o2nofp.cx10a_c8r3247.59252.4070.0010.0010.035
pg170_o2nofp.cx10a_c8r3262.83337.1660.0010.0010.033
pg175_o2nofp.cx10a_c8r3261.42338.576nonzero0.0010.030
pg18beta1_o2nofp.cx10b_c8r3255.58444.4110.0040.0010.059
pg18beta1_o2nofp.cx10c_c8r3252.17347.8180.0020.0080.050
pg18beta1_o2nofp.cx10d_c8r3254.23145.7670.0010.0010.028

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
pg140_o2nofp.cx10a_c8r3229.21270.7670.0200.0010.056
pg1418_o2nofp.cx10a_c8r3230.07757.24212.6770.0050.046
pg150_o2nofp.cx10a_c8r3229.66570.3150.0190.0010.044
pg1513_o2nofp.cx10a_c8r3230.35969.6180.023nonzero0.028
pg160_o2nofp.cx10a_c8r3229.30358.35412.343nonzero0.030
pg169_o2nofp.cx10a_c8r3228.67871.2990.0220.0010.035
pg170_o2nofp.cx10a_c8r3227.84260.09812.0590.0010.033
pg175_o2nofp.cx10a_c8r3227.45061.73210.8170.0010.030
pg18beta1_o2nofp.cx10b_c8r3226.74756.50216.7500.0010.027
pg18beta1_o2nofp.cx10c_c8r3227.27069.5593.1650.0060.049
pg18beta1_o2nofp.cx10d_c8r3227.14056.92215.9370.0010.030

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
26828	0	0	0.0	299.5	32.2	0.000	0.000	0.011	1.228	12891	22.9	0.481	68	5.3	32.1	5.2	0.057	21098	14447	pg140_o2nofp.cx10a_c8r32
25332	0	0	0.0	281.4	30.2	0.000	0.000	0.011	1.221	12266	22.4	0.484	71	5.4	32.0	2.5	0.049	19798	9998	pg1418_o2nofp.cx10a_c8r32
26472	0	0	0.0	292.8	31.6	0.000	0.000	0.011	1.224	13313	22.8	0.503	69	5.4	32.1	2.5	0.043	20946	14248	pg150_o2nofp.cx10a_c8r32
26900	0	0	0.0	297.6	32.2	0.000	0.000	0.011	1.225	13542	22.8	0.503	68	5.4	32.1	4.3	0.021	21196	14198	pg1513_o2nofp.cx10a_c8r32
24600	0	0	0.0	272.3	29.4	0.000	0.000	0.011	1.225	12397	22.2	0.504	72	5.4	32.1	3.6	0.026	18747	9948	pg160_o2nofp.cx10a_c8r32
26127	0	0	0.0	289.2	31.3	0.000	0.000	0.011	1.226	13086	22.8	0.501	70	5.4	32.1	5.4	0.035	20347	14198	pg169_o2nofp.cx10a_c8r32
24969	0	0	0.0	278.1	30.6	0.000	0.000	0.011	1.255	10337	21.9	0.414	70	5.3	32.1	4.0	0.033	21598	8699	pg170_o2nofp.cx10a_c8r32
25413	0	0	0.0	282.8	31.1	0.000	0.000	0.011	1.254	10500	22.1	0.413	70	5.3	32.0	5.3	0.030	22546	8448	pg175_o2nofp.cx10a_c8r32
22688	0	0	0.0	253.2	28.0	0.000	0.000	0.011	1.266	9423	21.4	0.415	75	5.4	32.0	4.2	0.059	15748	8849	pg18beta1_o2nofp.cx10b_c8r32
24184	0	0	0.0	272.0	30.1	0.000	0.000	0.011	1.273	10125	21.9	0.419	72	5.4	32.0	1.5	0.050	18447	9648	pg18beta1_o2nofp.cx10c_c8r32
22792	0	0	0.0	255.7	28.3	0.000	0.000	0.011	1.272	9502	21.5	0.417	75	5.4	32.1	4.8	0.028	15848	9098	pg18beta1_o2nofp.cx10d_c8r32

l.i2

l.i2: continue load after secondary indexes created with 5 inserts per transaction. Graphs for performance per 1-second interval are here.

Average throughput:

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
pg140_o2nofp.cx10a_c8r3258.69441.306nonzerononzero0.004
pg1418_o2nofp.cx10a_c8r3258.66541.335nonzerononzerononzero0.031
pg150_o2nofp.cx10a_c8r3258.03141.969nonzerononzero0.007
pg1513_o2nofp.cx10a_c8r3259.77240.228nonzerononzerononzero0.050
pg160_o2nofp.cx10a_c8r3254.88345.117nonzerononzerononzero0.025
pg169_o2nofp.cx10a_c8r3256.13943.861nonzerononzero0.005
pg170_o2nofp.cx10a_c8r3261.50538.495nonzerononzero0.010
pg175_o2nofp.cx10a_c8r3258.21841.781nonzerononzerononzero0.036
pg18beta1_o2nofp.cx10b_c8r3256.58743.412nonzerononzerononzero0.032
pg18beta1_o2nofp.cx10c_c8r3254.09045.909nonzerononzero0.008
pg18beta1_o2nofp.cx10d_c8r3256.05643.944nonzerononzero0.032

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg140_o2nofp.cx10a_c8r321.96631.53666.4960.0020.014
pg1418_o2nofp.cx10a_c8r321.79040.69856.9660.546nonzero0.032
pg150_o2nofp.cx10a_c8r321.90632.90465.1870.0020.014
pg1513_o2nofp.cx10a_c8r321.85128.43669.7100.002nonzero0.051
pg160_o2nofp.cx10a_c8r322.02039.69858.1010.181nonzero0.026
pg169_o2nofp.cx10a_c8r321.53832.61865.8430.0020.015
pg170_o2nofp.cx10a_c8r321.63840.31254.2173.8330.010
pg175_o2nofp.cx10a_c8r321.72737.20657.9443.123nonzero0.026
pg18beta1_o2nofp.cx10b_c8r321.57537.72558.9901.710nonzero0.033
pg18beta1_o2nofp.cx10c_c8r321.57338.72558.1821.5200.014
pg18beta1_o2nofp.cx10d_c8r321.59938.99358.6830.724nonzero0.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
3516	0	0	0.0	62.2	6.0	0.000	0.000	0.018	1.744	16260	16.3	4.624	371	5.4	35.0	1.0	0.004	2665	1825	pg140_o2nofp.cx10a_c8r32
3322	0	0	0.0	60.3	5.8	0.000	0.000	0.018	1.776	15365	16.3	4.625	393	5.4	34.9	0.2	0.031	2315	1140	pg1418_o2nofp.cx10a_c8r32
3515	0	0	0.0	60.1	6.0	0.000	0.000	0.017	1.742	16171	16.2	4.601	369	5.4	35.0	0.6	0.007	2670	1910	pg150_o2nofp.cx10a_c8r32
3598	0	0	0.0	61.4	6.1	0.000	0.000	0.017	1.737	16635	16.3	4.623	362	5.4	35.0	0.2	0.050	2810	1785	pg1513_o2nofp.cx10a_c8r32
3287	0	0	0.0	57.4	5.7	0.000	0.000	0.017	1.765	15175	16.2	4.616	394	5.4	34.9	1.5	0.025	2315	1245	pg160_o2nofp.cx10a_c8r32
3511	0	0	0.0	60.6	6.0	0.000	0.000	0.017	1.753	16164	16.2	4.604	369	5.4	35.1	0.2	0.005	2685	1755	pg169_o2nofp.cx10a_c8r32
3168	0	0	0.0	55.0	5.4	0.000	0.000	0.017	1.733	12248	15.8	3.867	399	5.4	34.5	0.3	0.010	2225	875	pg170_o2nofp.cx10a_c8r32
3229	0	0	0.0	55.3	5.5	0.000	0.000	0.017	1.745	12479	15.9	3.865	394	5.4	34.7	5.1	0.036	2375	1020	pg175_o2nofp.cx10a_c8r32
3089	0	0	0.0	53.5	5.2	0.000	0.000	0.017	1.724	11917	15.9	3.858	412	5.4	34.3	0.3	0.032	2110	1100	pg18beta1_o2nofp.cx10b_c8r32
3109	0	0	0.0	54.2	5.3	0.000	0.000	0.017	1.749	12031	15.9	3.869	409	5.4	34.5	1.5	0.008	2180	1080	pg18beta1_o2nofp.cx10c_c8r32
3233	0	0	0.0	55.2	5.4	0.000	0.000	0.017	1.725	12494	16.0	3.865	396	5.4	34.4	0.8	0.032	2275	1200	pg18beta1_o2nofp.cx10d_c8r32

qr100.L1

qr100.L1: 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
pg140_o2nofp.cx10a_c8r3299.9960.004nonzerononzero0.009
pg1418_o2nofp.cx10a_c8r3299.9960.004nonzerononzero0.009
pg150_o2nofp.cx10a_c8r3299.9970.003nonzero0.001
pg1513_o2nofp.cx10a_c8r3299.9980.0020.001
pg160_o2nofp.cx10a_c8r3299.9980.002nonzero0.001
pg169_o2nofp.cx10a_c8r3299.9980.002nonzero0.001
pg170_o2nofp.cx10a_c8r3299.9980.0020.001
pg175_o2nofp.cx10a_c8r3299.9980.0020.001
pg18beta1_o2nofp.cx10b_c8r3299.9980.002nonzero0.001
pg18beta1_o2nofp.cx10c_c8r3299.9980.0020.001
pg18beta1_o2nofp.cx10d_c8r3299.9980.0020.001

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
pg140_o2nofp.cx10a_c8r320.02899.9440.0280.006
pg1418_o2nofp.cx10a_c8r3299.9440.0560.006
pg150_o2nofp.cx10a_c8r320.27899.6670.0560.006
pg1513_o2nofp.cx10a_c8r321.08398.8610.0560.006
pg160_o2nofp.cx10a_c8r320.38999.5560.0560.006
pg169_o2nofp.cx10a_c8r320.88999.0560.0560.006
pg170_o2nofp.cx10a_c8r322.72297.2500.0280.006
pg175_o2nofp.cx10a_c8r320.19499.7780.0280.006
pg18beta1_o2nofp.cx10b_c8r320.52899.4170.0560.006
pg18beta1_o2nofp.cx10c_c8r322.47297.4720.0560.006
pg18beta1_o2nofp.cx10d_c8r320.66799.3060.0280.006

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg140_o2nofp.cx10a_c8r3248.05651.9440.002
pg1418_o2nofp.cx10a_c8r3250.66749.3330.002
pg150_o2nofp.cx10a_c8r3244.88955.1110.002
pg1513_o2nofp.cx10a_c8r3253.08346.9170.002
pg160_o2nofp.cx10a_c8r3247.97252.0280.002
pg169_o2nofp.cx10a_c8r3259.77840.2220.002
pg170_o2nofp.cx10a_c8r3251.22248.7780.002
pg175_o2nofp.cx10a_c8r3252.25047.7500.002
pg18beta1_o2nofp.cx10b_c8r3250.91749.0830.002
pg18beta1_o2nofp.cx10c_c8r3254.19445.8060.002
pg18beta1_o2nofp.cx10d_c8r3249.58350.4170.002

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	15036	0	0.0	13.4	0.6	0.000	0.000	0.134	6.453	57441	12.4	3.820	66	5.4	35.0	0.1	0.009	15038	14733	pg140_o2nofp.cx10a_c8r32
100	15080	0	0.0	13.4	0.6	0.000	0.000	0.134	6.450	57637	12.4	3.822	66	5.4	34.9	0.1	0.009	15086	14750	pg1418_o2nofp.cx10a_c8r32
100	15335	0	0.0	11.3	0.6	0.000	0.000	0.113	6.237	58551	12.4	3.818	65	5.4	35.0	0.1	0.001	15325	15070	pg150_o2nofp.cx10a_c8r32
100	15133	0	0.0	11.3	0.6	0.000	0.000	0.113	6.254	57782	12.4	3.818	66	5.4	35.0	0.1	0.001	15134	14878	pg1513_o2nofp.cx10a_c8r32
100	15236	0	0.0	11.3	0.6	0.000	0.000	0.113	6.242	58171	12.4	3.818	65	5.4	34.9	0.1	0.001	15245	15022	pg160_o2nofp.cx10a_c8r32
100	15289	0	0.0	11.3	0.6	0.000	0.000	0.113	6.245	58376	12.4	3.818	65	5.4	35.1	0.1	0.001	15294	14990	pg169_o2nofp.cx10a_c8r32
100	15258	0	0.0	10.5	0.6	0.000	0.000	0.105	6.297	58280	12.4	3.820	65	5.4	34.5	0.1	0.001	15246	15022	pg170_o2nofp.cx10a_c8r32
100	15276	0	0.0	10.5	0.6	0.000	0.000	0.105	6.258	58351	12.4	3.820	65	5.4	34.7	0.1	0.001	15262	15038	pg175_o2nofp.cx10a_c8r32
100	14983	0	0.0	10.6	0.6	0.000	0.000	0.106	6.294	57198	12.4	3.818	66	5.4	34.4	0.1	0.001	15005	14526	pg18beta1_o2nofp.cx10b_c8r32
100	14966	0	0.0	10.5	0.6	0.000	0.000	0.105	6.290	57134	12.4	3.818	66	5.4	34.5	0.2	0.001	15005	14558	pg18beta1_o2nofp.cx10c_c8r32
100	14865	0	0.0	10.5	0.6	0.000	0.000	0.105	6.295	56782	12.4	3.820	67	5.4	34.4	0.1	0.001	14894	14429	pg18beta1_o2nofp.cx10d_c8r32

qp100.L2

qp100.L2: point 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
pg140_o2nofp.cx10a_c8r3298.6081.391nonzero0.002
pg1418_o2nofp.cx10a_c8r3298.4041.596nonzero0.001
pg150_o2nofp.cx10a_c8r3298.4111.589nonzero0.001
pg1513_o2nofp.cx10a_c8r3298.2811.7190.001
pg160_o2nofp.cx10a_c8r3298.1111.889nonzero0.001
pg169_o2nofp.cx10a_c8r3298.2971.703nonzero0.001
pg170_o2nofp.cx10a_c8r3298.4921.508nonzero0.001
pg175_o2nofp.cx10a_c8r3298.0831.917nonzero0.001
pg18beta1_o2nofp.cx10b_c8r3298.5221.478nonzero0.001
pg18beta1_o2nofp.cx10c_c8r3298.1611.839nonzero0.002
pg18beta1_o2nofp.cx10d_c8r3297.9972.003nonzero0.001

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
pg140_o2nofp.cx10a_c8r3299.9440.0560.005
pg1418_o2nofp.cx10a_c8r3299.9440.0560.005
pg150_o2nofp.cx10a_c8r3299.9720.0280.006
pg1513_o2nofp.cx10a_c8r3299.9440.0560.006
pg160_o2nofp.cx10a_c8r3299.9440.0560.005
pg169_o2nofp.cx10a_c8r3299.9440.0560.009
pg170_o2nofp.cx10a_c8r3299.9720.0280.005
pg175_o2nofp.cx10a_c8r3299.9440.0560.005
pg18beta1_o2nofp.cx10b_c8r3299.9440.0560.006
pg18beta1_o2nofp.cx10c_c8r3299.7220.2780.010
pg18beta1_o2nofp.cx10d_c8r3299.9440.0560.006

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg140_o2nofp.cx10a_c8r3214.27885.7220.004
pg1418_o2nofp.cx10a_c8r3210.38989.6110.004
pg150_o2nofp.cx10a_c8r326.50093.4720.0280.005
pg1513_o2nofp.cx10a_c8r3211.77888.1940.0280.004
pg160_o2nofp.cx10a_c8r3210.30689.6670.0280.004
pg169_o2nofp.cx10a_c8r327.69492.3060.004
pg170_o2nofp.cx10a_c8r328.55691.4170.0280.004
pg175_o2nofp.cx10a_c8r327.02892.9440.0280.004
pg18beta1_o2nofp.cx10b_c8r320.72299.2500.0280.005
pg18beta1_o2nofp.cx10c_c8r324.19495.7780.0280.004
pg18beta1_o2nofp.cx10d_c8r320.16799.8060.0280.004

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	6166	0	0.0	42.8	1.4	0.000	0.000	0.428	14.374	25526	13.3	4.139	173	5.4	35.0	0.1	0.002	6175	5983	pg140_o2nofp.cx10a_c8r32
100	6168	0	0.0	42.8	1.4	0.000	0.000	0.428	14.325	25517	13.2	4.137	171	5.4	34.9	0.2	0.001	6191	5967	pg1418_o2nofp.cx10a_c8r32
100	6193	0	0.0	40.7	1.4	0.000	0.000	0.407	14.107	25332	13.0	4.091	168	5.4	35.0	0.1	0.001	6223	5951	pg150_o2nofp.cx10a_c8r32
100	6192	0	0.0	40.5	1.4	0.000	0.000	0.405	14.109	25328	12.9	4.091	167	5.4	35.0	0.1	0.001	6222	5951	pg1513_o2nofp.cx10a_c8r32
100	6148	0	0.0	40.6	1.4	0.000	0.000	0.406	14.111	25153	12.9	4.091	168	5.4	34.9	0.2	0.001	6175	5935	pg160_o2nofp.cx10a_c8r32
100	6219	0	0.0	40.6	1.4	0.000	0.000	0.406	14.115	25437	13.0	4.090	167	5.4	35.1	0.2	0.001	6271	5935	pg169_o2nofp.cx10a_c8r32
100	6170	0	0.0	39.3	1.4	0.000	0.000	0.393	14.093	25232	13.1	4.090	170	5.4	34.5	0.1	0.001	6206	5935	pg170_o2nofp.cx10a_c8r32
100	6135	0	0.0	39.4	1.4	0.000	0.000	0.394	14.108	25094	12.9	4.090	168	5.4	34.7	0.5	0.001	6175	5919	pg175_o2nofp.cx10a_c8r32
100	6020	0	0.0	39.4	1.4	0.000	0.000	0.394	14.116	24653	12.8	4.095	170	5.4	34.4	0.1	0.001	6015	5903	pg18beta1_o2nofp.cx10b_c8r32
100	5994	0	0.0	39.3	1.4	0.000	0.000	0.393	14.146	24540	12.7	4.094	169	5.4	34.5	0.1	0.002	5967	5903	pg18beta1_o2nofp.cx10c_c8r32
100	5734	0	0.0	39.5	1.4	0.000	0.000	0.396	14.137	23547	13.4	4.107	187	5.4	34.4	0.1	0.001	5711	5519	pg18beta1_o2nofp.cx10d_c8r32

qr500.L3

qr500.L3: 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
pg140_o2nofp.cx10a_c8r3299.9940.006nonzero0.002
pg1418_o2nofp.cx10a_c8r3299.9940.006nonzero0.002
pg150_o2nofp.cx10a_c8r3299.9970.003nonzero0.002
pg1513_o2nofp.cx10a_c8r3299.9950.005nonzero0.002
pg160_o2nofp.cx10a_c8r3299.9950.005nonzero0.003
pg169_o2nofp.cx10a_c8r3299.9950.005nonzerononzero0.006
pg170_o2nofp.cx10a_c8r3299.9960.004nonzero0.002
pg175_o2nofp.cx10a_c8r3299.9970.003nonzero0.002
pg18beta1_o2nofp.cx10b_c8r3299.9960.004nonzero0.002
pg18beta1_o2nofp.cx10c_c8r3299.9960.004nonzerononzero0.031
pg18beta1_o2nofp.cx10d_c8r3299.9960.004nonzero0.003

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg140_o2nofp.cx10a_c8r3222.26777.6440.0890.010
pg1418_o2nofp.cx10a_c8r3214.94484.8560.2000.011
pg150_o2nofp.cx10a_c8r3224.97874.9890.0330.009
pg1513_o2nofp.cx10a_c8r3230.44469.4890.0670.010
pg160_o2nofp.cx10a_c8r3222.74477.2390.0170.010
pg169_o2nofp.cx10a_c8r3224.38375.4940.1220.010
pg170_o2nofp.cx10a_c8r3229.82270.1220.0560.010
pg175_o2nofp.cx10a_c8r3226.05673.9220.0220.010
pg18beta1_o2nofp.cx10b_c8r3229.65670.3220.0220.007
pg18beta1_o2nofp.cx10c_c8r3229.07270.7060.2220.011
pg18beta1_o2nofp.cx10d_c8r3228.81171.1440.0440.010

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
pg140_o2nofp.cx10a_c8r3224.70074.9560.3440.010
pg1418_o2nofp.cx10a_c8r3223.90075.9170.1830.010
pg150_o2nofp.cx10a_c8r3223.38376.4280.1890.008
pg1513_o2nofp.cx10a_c8r3219.30080.5500.1500.010
pg160_o2nofp.cx10a_c8r3223.15676.6280.2170.006
pg169_o2nofp.cx10a_c8r3223.57275.5830.8440.010
pg170_o2nofp.cx10a_c8r3218.55680.3111.1330.012
pg175_o2nofp.cx10a_c8r3219.41779.4671.1170.007
pg18beta1_o2nofp.cx10b_c8r3222.36777.0110.6220.006
pg18beta1_o2nofp.cx10c_c8r3215.65083.5940.7560.011
pg18beta1_o2nofp.cx10d_c8r3218.45680.9330.6110.010

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
500	14633	0	0.0	52.1	1.8	0.000	0.000	0.104	3.728	56101	13.1	3.834	72	5.4	35.0	0.3	0.002	14558	14013	pg140_o2nofp.cx10a_c8r32
500	14394	0	0.0	52.4	1.8	0.000	0.000	0.105	3.768	55164	13.0	3.832	72	5.4	34.9	0.3	0.002	14350	13790	pg1418_o2nofp.cx10a_c8r32
500	14677	0	0.0	50.0	1.8	0.000	0.000	0.100	3.675	56221	13.0	3.831	71	5.4	35.0	5.3	0.002	14621	14030	pg150_o2nofp.cx10a_c8r32
500	14453	0	0.0	50.0	1.8	0.000	0.000	0.100	3.675	55335	13.0	3.829	72	5.4	35.0	0.3	0.002	14414	13854	pg1513_o2nofp.cx10a_c8r32
500	14699	0	0.0	50.2	1.8	0.000	0.000	0.100	3.675	56278	13.0	3.829	71	5.4	34.9	2.8	0.003	14621	14030	pg160_o2nofp.cx10a_c8r32
500	14718	0	0.0	50.2	1.8	0.000	0.000	0.101	3.719	56384	13.1	3.831	71	5.4	35.2	5.5	0.006	14637	14094	pg169_o2nofp.cx10a_c8r32
500	14563	0	0.0	49.5	1.8	0.000	0.000	0.099	3.706	55731	12.9	3.827	71	5.4	34.5	0.3	0.002	14509	13854	pg170_o2nofp.cx10a_c8r32
500	14429	0	0.0	49.5	1.8	0.000	0.000	0.099	3.678	55214	13.0	3.827	72	5.4	34.7	0.3	0.002	14382	13709	pg175_o2nofp.cx10a_c8r32
500	14276	0	0.0	49.5	1.8	0.000	0.000	0.099	3.689	54668	12.9	3.829	72	5.4	34.4	0.3	0.002	14254	13550	pg18beta1_o2nofp.cx10b_c8r32
500	14236	0	0.0	49.6	1.8	0.000	0.000	0.099	3.745	54486	13.0	3.827	73	5.4	34.5	0.3	0.031	14238	13550	pg18beta1_o2nofp.cx10c_c8r32
500	14316	0	0.0	49.6	1.8	0.000	0.000	0.099	3.695	54788	12.9	3.827	72	5.4	34.4	4.7	0.003	14318	13629	pg18beta1_o2nofp.cx10d_c8r32

qp500.L4

qp500.L4: point 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
pg140_o2nofp.cx10a_c8r3298.8471.153nonzero0.002
pg1418_o2nofp.cx10a_c8r3298.3291.671nonzero0.003
pg150_o2nofp.cx10a_c8r3298.3431.657nonzero0.002
pg1513_o2nofp.cx10a_c8r3298.3391.661nonzero0.002
pg160_o2nofp.cx10a_c8r3298.1901.810nonzero0.002
pg169_o2nofp.cx10a_c8r3298.0651.935nonzero0.002
pg170_o2nofp.cx10a_c8r3298.1431.857nonzero0.002
pg175_o2nofp.cx10a_c8r3298.1231.877nonzero0.002
pg18beta1_o2nofp.cx10b_c8r3298.1711.829nonzero0.002
pg18beta1_o2nofp.cx10c_c8r3298.0041.996nonzero0.001
pg18beta1_o2nofp.cx10d_c8r3297.8392.161nonzero0.002

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
pg140_o2nofp.cx10a_c8r3213.46786.5220.0110.009
pg1418_o2nofp.cx10a_c8r329.93990.0110.0500.009
pg150_o2nofp.cx10a_c8r329.65090.1890.1560.0060.018
pg1513_o2nofp.cx10a_c8r3214.12885.6780.1940.011
pg160_o2nofp.cx10a_c8r328.70091.2000.1000.010
pg169_o2nofp.cx10a_c8r3213.48386.4780.0390.010
pg170_o2nofp.cx10a_c8r3216.15083.7170.1330.010
pg175_o2nofp.cx10a_c8r3210.62289.2390.1390.010
pg18beta1_o2nofp.cx10b_c8r3215.67884.2940.0280.010
pg18beta1_o2nofp.cx10c_c8r3215.82284.1610.0110.0060.021
pg18beta1_o2nofp.cx10d_c8r3213.56786.3060.1280.013

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
pg140_o2nofp.cx10a_c8r3220.81178.8890.3000.008
pg1418_o2nofp.cx10a_c8r3222.14477.5610.2940.009
pg150_o2nofp.cx10a_c8r3218.96180.8110.2220.0060.017
pg1513_o2nofp.cx10a_c8r3220.56779.1780.2560.010
pg160_o2nofp.cx10a_c8r3218.80080.7890.4110.004
pg169_o2nofp.cx10a_c8r3222.98973.5893.4220.009
pg170_o2nofp.cx10a_c8r3219.23379.3391.4280.011
pg175_o2nofp.cx10a_c8r3217.57281.0781.3500.010
pg18beta1_o2nofp.cx10b_c8r3216.90682.2170.8780.005
pg18beta1_o2nofp.cx10c_c8r3217.50081.6720.8220.0060.019
pg18beta1_o2nofp.cx10d_c8r3217.17882.0280.7940.011

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
500	6278	0	0.0	30.8	2.3	0.000	0.000	0.062	4.638	26101	13.4	4.158	171	5.4	34.0	0.3	0.002	6303	6031	pg140_o2nofp.cx10a_c8r32
500	6150	0	0.0	30.9	2.3	0.000	0.000	0.062	4.643	25593	13.4	4.162	174	5.5	34.0	0.3	0.003	6159	5951	pg1418_o2nofp.cx10a_c8r32
500	6226	0	0.0	29.1	2.3	0.000	0.000	0.058	4.668	25609	13.4	4.113	172	5.5	34.0	0.3	0.002	6271	5967	pg150_o2nofp.cx10a_c8r32
500	6188	0	0.0	29.0	2.3	0.000	0.000	0.058	4.658	25444	13.4	4.112	173	5.5	34.0	0.3	0.002	6207	5951	pg1513_o2nofp.cx10a_c8r32
500	6152	0	0.0	28.8	2.2	0.000	0.000	0.058	4.602	25313	13.4	4.115	174	5.5	34.0	2.9	0.002	6175	5935	pg160_o2nofp.cx10a_c8r32
500	6143	0	0.0	28.9	2.3	0.000	0.000	0.058	4.629	25276	13.5	4.115	176	5.5	34.1	2.9	0.002	6191	5919	pg169_o2nofp.cx10a_c8r32
500	6106	0	0.0	27.7	2.3	0.000	0.000	0.055	4.648	25096	13.4	4.110	176	5.5	34.1	0.3	0.002	6127	5919	pg170_o2nofp.cx10a_c8r32
500	6089	0	0.0	27.8	2.3	0.000	0.000	0.056	4.666	25024	13.5	4.110	177	5.5	34.1	0.3	0.002	6111	5919	pg175_o2nofp.cx10a_c8r32
500	6013	0	0.0	28.1	2.2	0.000	0.000	0.056	4.568	24729	13.5	4.113	180	5.4	34.0	0.2	0.002	5999	5903	pg18beta1_o2nofp.cx10b_c8r32
500	6011	0	0.0	28.2	2.2	0.000	0.000	0.056	4.570	24726	13.5	4.113	180	5.4	34.0	0.3	0.001	5999	5903	pg18beta1_o2nofp.cx10c_c8r32
500	5710	0	0.0	28.3	2.3	0.000	0.000	0.057	4.636	23555	13.5	4.126	189	5.5	34.1	0.3	0.002	5663	5519	pg18beta1_o2nofp.cx10d_c8r32

qr1000.L5

qr1000.L5: 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
pg140_o2nofp.cx10a_c8r3299.9940.006nonzero0.002
pg1418_o2nofp.cx10a_c8r3299.9940.006nonzero0.002
pg150_o2nofp.cx10a_c8r3299.9950.005nonzero0.002
pg1513_o2nofp.cx10a_c8r3299.9960.004nonzero0.002
pg160_o2nofp.cx10a_c8r3299.9960.004nonzero0.002
pg169_o2nofp.cx10a_c8r3299.9960.004nonzero0.003
pg170_o2nofp.cx10a_c8r3299.9960.004nonzerononzero0.004
pg175_o2nofp.cx10a_c8r3299.9960.004nonzero0.002
pg18beta1_o2nofp.cx10b_c8r3299.9940.006nonzerononzero0.006
pg18beta1_o2nofp.cx10c_c8r3299.9940.006nonzero0.003
pg18beta1_o2nofp.cx10d_c8r3299.9940.006nonzero0.004

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg140_o2nofp.cx10a_c8r3241.14258.8360.0220.010
pg1418_o2nofp.cx10a_c8r3237.86462.1280.0080.010
pg150_o2nofp.cx10a_c8r3243.56756.4250.0080.008
pg1513_o2nofp.cx10a_c8r3248.26951.7190.0110.010
pg160_o2nofp.cx10a_c8r3241.58358.3860.0310.010
pg169_o2nofp.cx10a_c8r3242.52857.4610.0110.006
pg170_o2nofp.cx10a_c8r3247.23352.7640.0030.005
pg175_o2nofp.cx10a_c8r3242.98357.0080.0080.006
pg18beta1_o2nofp.cx10b_c8r3242.09457.8470.0580.010
pg18beta1_o2nofp.cx10c_c8r3248.80851.1780.0140.010
pg18beta1_o2nofp.cx10d_c8r3243.91756.0780.0060.005

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For 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
pg140_o2nofp.cx10a_c8r3222.10677.7560.1390.005
pg1418_o2nofp.cx10a_c8r3222.86177.0780.0610.004
pg150_o2nofp.cx10a_c8r3221.36478.5610.0750.005
pg1513_o2nofp.cx10a_c8r3224.48675.4080.1060.004
pg160_o2nofp.cx10a_c8r3219.47280.4220.1060.009
pg169_o2nofp.cx10a_c8r3224.02867.6478.3250.007
pg170_o2nofp.cx10a_c8r3218.78180.5940.6250.005
pg175_o2nofp.cx10a_c8r3219.37280.0780.5500.005
pg18beta1_o2nofp.cx10b_c8r3216.50883.0330.4580.011
pg18beta1_o2nofp.cx10c_c8r3218.34281.0940.5640.005
pg18beta1_o2nofp.cx10d_c8r3217.77281.8390.3890.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
1000	14490	0	0.0	32.8	2.7	0.000	0.000	0.033	2.772	55750	13.4	3.848	74	5.5	32.4	0.3	0.002	14462	13886	pg140_o2nofp.cx10a_c8r32
999	14309	0	0.0	32.8	2.7	0.000	0.000	0.033	2.767	55096	13.3	3.850	74	5.5	32.4	0.3	0.002	14334	13709	pg1418_o2nofp.cx10a_c8r32
999	14746	0	0.0	30.5	2.7	0.000	0.000	0.031	2.734	56717	13.3	3.846	72	5.5	32.4	0.3	0.002	14686	14094	pg150_o2nofp.cx10a_c8r32
1000	14408	0	0.0	30.6	2.7	0.000	0.000	0.031	2.739	55392	13.3	3.845	74	5.5	32.4	0.3	0.002	14414	13789	pg1513_o2nofp.cx10a_c8r32
999	14584	0	0.0	30.8	2.7	0.000	0.000	0.031	2.760	56100	13.4	3.847	74	5.5	32.4	2.8	0.002	14558	13934	pg160_o2nofp.cx10a_c8r32
999	14642	0	0.0	30.6	2.7	0.000	0.000	0.031	2.744	56323	13.4	3.847	73	5.5	32.4	3.1	0.003	14605	14013	pg169_o2nofp.cx10a_c8r32
999	14556	0	0.0	30.1	2.7	0.000	0.000	0.030	2.740	55912	13.3	3.841	73	5.5	32.4	0.3	0.004	14558	13870	pg170_o2nofp.cx10a_c8r32
1000	14499	0	0.0	30.0	2.7	0.000	0.000	0.030	2.735	55663	13.4	3.839	74	5.5	32.4	0.3	0.002	14526	13789	pg175_o2nofp.cx10a_c8r32
1000	14191	0	0.0	33.8	2.7	0.000	0.000	0.034	2.714	54511	13.3	3.841	75	5.5	32.4	0.3	0.006	14190	13470	pg18beta1_o2nofp.cx10b_c8r32
999	14277	0	0.0	33.3	2.6	0.000	0.000	0.033	2.701	54848	13.3	3.842	75	5.5	32.4	0.3	0.003	14301	13566	pg18beta1_o2nofp.cx10c_c8r32
999	14369	0	0.0	33.4	2.6	0.000	0.000	0.033	2.708	55201	13.4	3.842	75	5.5	32.4	0.3	0.004	14382	13614	pg18beta1_o2nofp.cx10d_c8r32

qp1000.L6

qp1000.L6: point 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
pg140_o2nofp.cx10a_c8r3298.7991.201nonzero0.003
pg1418_o2nofp.cx10a_c8r3298.4001.600nonzero0.002
pg150_o2nofp.cx10a_c8r3298.3651.635nonzerononzero0.040
pg1513_o2nofp.cx10a_c8r3298.2861.714nonzero0.002
pg160_o2nofp.cx10a_c8r3298.2771.723nonzero0.002
pg169_o2nofp.cx10a_c8r3298.1861.814nonzerononzero0.033
pg170_o2nofp.cx10a_c8r3298.0341.966nonzero0.002
pg175_o2nofp.cx10a_c8r3297.9142.086nonzero0.001
pg18beta1_o2nofp.cx10b_c8r3298.2141.786nonzero0.002
pg18beta1_o2nofp.cx10c_c8r3298.0571.943nonzero0.002
pg18beta1_o2nofp.cx10d_c8r3298.0411.959nonzero0.002

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
pg140_o2nofp.cx10a_c8r3239.73660.2500.0110.0030.025
pg1418_o2nofp.cx10a_c8r3231.05068.9390.0060.0060.020
pg150_o2nofp.cx10a_c8r3241.80658.1830.0060.0060.022
pg1513_o2nofp.cx10a_c8r3243.08656.9000.0110.0030.021
pg160_o2nofp.cx10a_c8r3238.41961.5690.0030.0080.027
pg169_o2nofp.cx10a_c8r3245.08954.9000.0060.0060.025
pg170_o2nofp.cx10a_c8r3243.85056.1390.0110.015
pg175_o2nofp.cx10a_c8r3240.98659.0030.0060.0060.026
pg18beta1_o2nofp.cx10b_c8r3236.23363.7560.0110.009
pg18beta1_o2nofp.cx10c_c8r3238.38661.6060.0080.008
pg18beta1_o2nofp.cx10d_c8r3233.47866.5080.0140.009

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
pg140_o2nofp.cx10a_c8r3230.13369.6420.2220.0030.022
pg1418_o2nofp.cx10a_c8r3228.85070.9780.1670.0060.018
pg150_o2nofp.cx10a_c8r3228.40671.4000.1890.0060.020
pg1513_o2nofp.cx10a_c8r3231.04768.7670.1830.0030.020
pg160_o2nofp.cx10a_c8r3231.17568.5420.2750.0080.025
pg169_o2nofp.cx10a_c8r3234.59754.60310.7940.0060.023
pg170_o2nofp.cx10a_c8r3225.94473.4560.6000.013
pg175_o2nofp.cx10a_c8r3228.57870.8170.6000.0060.023
pg18beta1_o2nofp.cx10b_c8r3218.16781.2970.5360.005
pg18beta1_o2nofp.cx10c_c8r3216.63182.7530.6170.005
pg18beta1_o2nofp.cx10d_c8r3219.45080.0440.5060.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
1000	6266	0	0.0	33.4	2.7	0.000	0.000	0.033	2.780	26256	13.5	4.190	172	5.5	30.3	0.2	0.003	6287	6015	pg140_o2nofp.cx10a_c8r32
999	6130	0	0.0	33.1	2.7	0.000	0.000	0.033	2.776	25726	13.5	4.197	176	5.5	30.2	0.2	0.002	6143	5951	pg1418_o2nofp.cx10a_c8r32
999	6200	0	0.0	31.2	2.7	0.000	0.000	0.031	2.745	25719	13.5	4.148	174	5.5	30.2	3.5	0.040	6223	5951	pg150_o2nofp.cx10a_c8r32
999	6156	0	0.0	31.2	2.7	0.000	0.000	0.031	2.740	25550	13.5	4.150	175	5.5	30.3	0.2	0.002	6175	5934	pg1513_o2nofp.cx10a_c8r32
999	6150	0	0.0	31.3	2.7	0.000	0.000	0.031	2.766	25519	13.6	4.150	177	5.5	30.3	2.1	0.002	6175	5935	pg160_o2nofp.cx10a_c8r32
999	6164	0	0.0	31.2	2.7	0.000	0.000	0.031	2.764	25580	13.6	4.150	176	5.5	30.3	2.1	0.033	6191	5919	pg169_o2nofp.cx10a_c8r32
999	6072	0	0.0	29.8	2.7	0.000	0.000	0.030	2.756	25149	13.6	4.142	179	5.5	30.3	0.4	0.002	6095	5903	pg170_o2nofp.cx10a_c8r32
999	6082	0	0.0	29.8	2.7	0.000	0.000	0.030	2.744	25188	13.6	4.142	179	5.5	30.3	0.4	0.001	6111	5903	pg175_o2nofp.cx10a_c8r32
1000	6003	0	0.0	28.1	2.7	0.000	0.000	0.028	2.736	24862	13.6	4.141	181	5.5	30.2	0.3	0.002	5983	5887	pg18beta1_o2nofp.cx10b_c8r32
999	5985	0	0.0	28.1	2.7	0.000	0.000	0.028	2.731	24810	13.6	4.145	182	5.5	30.2	0.3	0.002	5967	5887	pg18beta1_o2nofp.cx10c_c8r32
999	5731	0	0.0	28.2	2.7	0.000	0.000	0.028	2.724	23830	14.1	4.158	197	5.5	30.2	0.3	0.002	5727	5503	pg18beta1_o2nofp.cx10d_c8r32

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
139860	0	0	0.0	523.5	59.2	0.000	0.000	0.004	0.433	16764	19.7	0.120	11	1.9	5.2	0.8	0.003	140183	135583	pg140_o2nofp.cx10a_c8r32
136986	0	0	0.0	513.2	57.9	0.000	0.000	0.004	0.433	16480	19.5	0.120	11	1.9	5.2	2.0	0.005	137483	130883	pg1418_o2nofp.cx10a_c8r32
142857	0	0	0.0	533.4	60.5	0.000	0.000	0.004	0.434	17013	19.5	0.119	11	1.9	5.2	0.4	0.003	143384	137987	pg150_o2nofp.cx10a_c8r32
143885	0	0	0.0	541.1	61.4	0.000	0.000	0.004	0.437	17060	19.9	0.119	11	1.9	5.2	1.7	0.002	143683	136285	pg1513_o2nofp.cx10a_c8r32
142857	0	0	0.0	532.9	60.4	0.000	0.000	0.004	0.433	16959	19.8	0.119	11	1.9	5.2	1.7	0.002	142884	138284	pg160_o2nofp.cx10a_c8r32
141844	0	0	0.0	532.9	60.5	0.000	0.000	0.004	0.437	16918	19.7	0.119	11	1.9	5.2	0.4	0.002	143472	137884	pg169_o2nofp.cx10a_c8r32
140845	0	0	0.0	529.9	60.1	0.000	0.000	0.004	0.437	14473	19.6	0.103	11	1.9	5.2	1.6	0.002	142079	135682	pg170_o2nofp.cx10a_c8r32
138889	0	0	0.0	524.3	59.4	0.000	0.000	0.004	0.438	14300	19.8	0.103	11	1.9	5.2	1.6	0.003	140680	132885	pg175_o2nofp.cx10a_c8r32
140845	0	0	0.0	526.6	59.7	0.000	0.000	0.004	0.434	14333	19.8	0.102	11	1.9	5.2	1.2	0.002	141075	133683	pg18beta1_o2nofp.cx10b_c8r32
141844	0	0	0.0	529.4	60.0	0.000	0.000	0.004	0.433	14363	19.9	0.101	11	1.9	5.2	1.6	0.002	141782	134184	pg18beta1_o2nofp.cx10c_c8r32
139860	0	0	0.0	524.6	59.5	0.000	0.000	0.004	0.435	14210	19.8	0.102	11	1.9	5.2	1.6	0.002	140983	133285	pg18beta1_o2nofp.cx10d_c8r32

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
322582	0	0	0.0	644.2	78.8	0.000	0.000	0.002	0.250	1934	11.4	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg140_o2nofp.cx10a_c8r32
333335	0	0	0.0	756.9	92.7	0.000	0.000	0.002	0.285	2049	11.3	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg1418_o2nofp.cx10a_c8r32
350879	0	0	0.0	704.2	86.3	0.000	0.000	0.002	0.252	2046	11.3	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg150_o2nofp.cx10a_c8r32
363638	0	1	0.0	846.2	104.0	0.000	0.000	0.002	0.293	1584	11.5	0.004	3	3.9	8.9	2.1	0.002	NA	NA	pg1513_o2nofp.cx10a_c8r32
370372	0	1	0.0	848.2	104.3	0.000	0.000	0.002	0.288	1662	11.5	0.004	2	3.9	8.9	2.1	0.002	NA	NA	pg160_o2nofp.cx10a_c8r32
357145	0	0	0.0	720.9	88.4	0.000	0.000	0.002	0.253	2163	11.4	0.006	3	3.9	8.9	2.1	0.002	NA	NA	pg169_o2nofp.cx10a_c8r32
370372	0	0	0.0	543.8	66.6	0.000	0.000	0.001	0.184	1707	11.5	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg170_o2nofp.cx10a_c8r32
384617	0	0	0.0	616.1	75.4	0.000	0.000	0.002	0.201	1997	11.7	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg175_o2nofp.cx10a_c8r32
384617	0	0	0.0	619.5	75.9	0.000	0.000	0.002	0.202	1954	11.7	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg18beta1_o2nofp.cx10b_c8r32
377360	0	0	0.0	605.8	74.1	0.000	0.000	0.002	0.201	1933	11.5	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg18beta1_o2nofp.cx10c_c8r32
377360	0	0	0.0	602.5	73.7	0.000	0.000	0.002	0.200	1928	11.5	0.005	2	3.9	8.9	2.1	0.002	NA	NA	pg18beta1_o2nofp.cx10d_c8r32

l.i1

l.i1: continue load after secondary indexes created with 50 inserts per transaction

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
26828	0	0	0.0	299.5	32.2	0.000	0.000	0.011	1.228	12891	22.9	0.481	68	5.3	32.1	5.2	0.057	21098	14447	pg140_o2nofp.cx10a_c8r32
25332	0	0	0.0	281.4	30.2	0.000	0.000	0.011	1.221	12266	22.4	0.484	71	5.4	32.0	2.5	0.049	19798	9998	pg1418_o2nofp.cx10a_c8r32
26472	0	0	0.0	292.8	31.6	0.000	0.000	0.011	1.224	13313	22.8	0.503	69	5.4	32.1	2.5	0.043	20946	14248	pg150_o2nofp.cx10a_c8r32
26900	0	0	0.0	297.6	32.2	0.000	0.000	0.011	1.225	13542	22.8	0.503	68	5.4	32.1	4.3	0.021	21196	14198	pg1513_o2nofp.cx10a_c8r32
24600	0	0	0.0	272.3	29.4	0.000	0.000	0.011	1.225	12397	22.2	0.504	72	5.4	32.1	3.6	0.026	18747	9948	pg160_o2nofp.cx10a_c8r32
26127	0	0	0.0	289.2	31.3	0.000	0.000	0.011	1.226	13086	22.8	0.501	70	5.4	32.1	5.4	0.035	20347	14198	pg169_o2nofp.cx10a_c8r32
24969	0	0	0.0	278.1	30.6	0.000	0.000	0.011	1.255	10337	21.9	0.414	70	5.3	32.1	4.0	0.033	21598	8699	pg170_o2nofp.cx10a_c8r32
25413	0	0	0.0	282.8	31.1	0.000	0.000	0.011	1.254	10500	22.1	0.413	70	5.3	32.0	5.3	0.030	22546	8448	pg175_o2nofp.cx10a_c8r32
22688	0	0	0.0	253.2	28.0	0.000	0.000	0.011	1.266	9423	21.4	0.415	75	5.4	32.0	4.2	0.059	15748	8849	pg18beta1_o2nofp.cx10b_c8r32
24184	0	0	0.0	272.0	30.1	0.000	0.000	0.011	1.273	10125	21.9	0.419	72	5.4	32.0	1.5	0.050	18447	9648	pg18beta1_o2nofp.cx10c_c8r32
22792	0	0	0.0	255.7	28.3	0.000	0.000	0.011	1.272	9502	21.5	0.417	75	5.4	32.1	4.8	0.028	15848	9098	pg18beta1_o2nofp.cx10d_c8r32

l.i2

l.i2: continue load after secondary indexes created with 5 inserts per transaction

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
3516	0	0	0.0	62.2	6.0	0.000	0.000	0.018	1.744	16260	16.3	4.624	371	5.4	35.0	1.0	0.004	2665	1825	pg140_o2nofp.cx10a_c8r32
3322	0	0	0.0	60.3	5.8	0.000	0.000	0.018	1.776	15365	16.3	4.625	393	5.4	34.9	0.2	0.031	2315	1140	pg1418_o2nofp.cx10a_c8r32
3515	0	0	0.0	60.1	6.0	0.000	0.000	0.017	1.742	16171	16.2	4.601	369	5.4	35.0	0.6	0.007	2670	1910	pg150_o2nofp.cx10a_c8r32
3598	0	0	0.0	61.4	6.1	0.000	0.000	0.017	1.737	16635	16.3	4.623	362	5.4	35.0	0.2	0.050	2810	1785	pg1513_o2nofp.cx10a_c8r32
3287	0	0	0.0	57.4	5.7	0.000	0.000	0.017	1.765	15175	16.2	4.616	394	5.4	34.9	1.5	0.025	2315	1245	pg160_o2nofp.cx10a_c8r32
3511	0	0	0.0	60.6	6.0	0.000	0.000	0.017	1.753	16164	16.2	4.604	369	5.4	35.1	0.2	0.005	2685	1755	pg169_o2nofp.cx10a_c8r32
3168	0	0	0.0	55.0	5.4	0.000	0.000	0.017	1.733	12248	15.8	3.867	399	5.4	34.5	0.3	0.010	2225	875	pg170_o2nofp.cx10a_c8r32
3229	0	0	0.0	55.3	5.5	0.000	0.000	0.017	1.745	12479	15.9	3.865	394	5.4	34.7	5.1	0.036	2375	1020	pg175_o2nofp.cx10a_c8r32
3089	0	0	0.0	53.5	5.2	0.000	0.000	0.017	1.724	11917	15.9	3.858	412	5.4	34.3	0.3	0.032	2110	1100	pg18beta1_o2nofp.cx10b_c8r32
3109	0	0	0.0	54.2	5.3	0.000	0.000	0.017	1.749	12031	15.9	3.869	409	5.4	34.5	1.5	0.008	2180	1080	pg18beta1_o2nofp.cx10c_c8r32
3233	0	0	0.0	55.2	5.4	0.000	0.000	0.017	1.725	12494	16.0	3.865	396	5.4	34.4	0.8	0.032	2275	1200	pg18beta1_o2nofp.cx10d_c8r32

qr100.L1

qr100.L1: range queries with 100 insert/s per client

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	15036	0	0.0	13.4	0.6	0.000	0.000	0.134	6.453	57441	12.4	3.820	66	5.4	35.0	0.1	0.009	15038	14733	pg140_o2nofp.cx10a_c8r32
100	15080	0	0.0	13.4	0.6	0.000	0.000	0.134	6.450	57637	12.4	3.822	66	5.4	34.9	0.1	0.009	15086	14750	pg1418_o2nofp.cx10a_c8r32
100	15335	0	0.0	11.3	0.6	0.000	0.000	0.113	6.237	58551	12.4	3.818	65	5.4	35.0	0.1	0.001	15325	15070	pg150_o2nofp.cx10a_c8r32
100	15133	0	0.0	11.3	0.6	0.000	0.000	0.113	6.254	57782	12.4	3.818	66	5.4	35.0	0.1	0.001	15134	14878	pg1513_o2nofp.cx10a_c8r32
100	15236	0	0.0	11.3	0.6	0.000	0.000	0.113	6.242	58171	12.4	3.818	65	5.4	34.9	0.1	0.001	15245	15022	pg160_o2nofp.cx10a_c8r32
100	15289	0	0.0	11.3	0.6	0.000	0.000	0.113	6.245	58376	12.4	3.818	65	5.4	35.1	0.1	0.001	15294	14990	pg169_o2nofp.cx10a_c8r32
100	15258	0	0.0	10.5	0.6	0.000	0.000	0.105	6.297	58280	12.4	3.820	65	5.4	34.5	0.1	0.001	15246	15022	pg170_o2nofp.cx10a_c8r32
100	15276	0	0.0	10.5	0.6	0.000	0.000	0.105	6.258	58351	12.4	3.820	65	5.4	34.7	0.1	0.001	15262	15038	pg175_o2nofp.cx10a_c8r32
100	14983	0	0.0	10.6	0.6	0.000	0.000	0.106	6.294	57198	12.4	3.818	66	5.4	34.4	0.1	0.001	15005	14526	pg18beta1_o2nofp.cx10b_c8r32
100	14966	0	0.0	10.5	0.6	0.000	0.000	0.105	6.290	57134	12.4	3.818	66	5.4	34.5	0.2	0.001	15005	14558	pg18beta1_o2nofp.cx10c_c8r32
100	14865	0	0.0	10.5	0.6	0.000	0.000	0.105	6.295	56782	12.4	3.820	67	5.4	34.4	0.1	0.001	14894	14429	pg18beta1_o2nofp.cx10d_c8r32

qp100.L2

qp100.L2: point queries with 100 insert/s per client

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	6166	0	0.0	42.8	1.4	0.000	0.000	0.428	14.374	25526	13.3	4.139	173	5.4	35.0	0.1	0.002	6175	5983	pg140_o2nofp.cx10a_c8r32
100	6168	0	0.0	42.8	1.4	0.000	0.000	0.428	14.325	25517	13.2	4.137	171	5.4	34.9	0.2	0.001	6191	5967	pg1418_o2nofp.cx10a_c8r32
100	6193	0	0.0	40.7	1.4	0.000	0.000	0.407	14.107	25332	13.0	4.091	168	5.4	35.0	0.1	0.001	6223	5951	pg150_o2nofp.cx10a_c8r32
100	6192	0	0.0	40.5	1.4	0.000	0.000	0.405	14.109	25328	12.9	4.091	167	5.4	35.0	0.1	0.001	6222	5951	pg1513_o2nofp.cx10a_c8r32
100	6148	0	0.0	40.6	1.4	0.000	0.000	0.406	14.111	25153	12.9	4.091	168	5.4	34.9	0.2	0.001	6175	5935	pg160_o2nofp.cx10a_c8r32
100	6219	0	0.0	40.6	1.4	0.000	0.000	0.406	14.115	25437	13.0	4.090	167	5.4	35.1	0.2	0.001	6271	5935	pg169_o2nofp.cx10a_c8r32
100	6170	0	0.0	39.3	1.4	0.000	0.000	0.393	14.093	25232	13.1	4.090	170	5.4	34.5	0.1	0.001	6206	5935	pg170_o2nofp.cx10a_c8r32
100	6135	0	0.0	39.4	1.4	0.000	0.000	0.394	14.108	25094	12.9	4.090	168	5.4	34.7	0.5	0.001	6175	5919	pg175_o2nofp.cx10a_c8r32
100	6020	0	0.0	39.4	1.4	0.000	0.000	0.394	14.116	24653	12.8	4.095	170	5.4	34.4	0.1	0.001	6015	5903	pg18beta1_o2nofp.cx10b_c8r32
100	5994	0	0.0	39.3	1.4	0.000	0.000	0.393	14.146	24540	12.7	4.094	169	5.4	34.5	0.1	0.002	5967	5903	pg18beta1_o2nofp.cx10c_c8r32
100	5734	0	0.0	39.5	1.4	0.000	0.000	0.396	14.137	23547	13.4	4.107	187	5.4	34.4	0.1	0.001	5711	5519	pg18beta1_o2nofp.cx10d_c8r32

qr500.L3

qr500.L3: range queries with 500 insert/s per client

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
500	14633	0	0.0	52.1	1.8	0.000	0.000	0.104	3.728	56101	13.1	3.834	72	5.4	35.0	0.3	0.002	14558	14013	pg140_o2nofp.cx10a_c8r32
500	14394	0	0.0	52.4	1.8	0.000	0.000	0.105	3.768	55164	13.0	3.832	72	5.4	34.9	0.3	0.002	14350	13790	pg1418_o2nofp.cx10a_c8r32
500	14677	0	0.0	50.0	1.8	0.000	0.000	0.100	3.675	56221	13.0	3.831	71	5.4	35.0	5.3	0.002	14621	14030	pg150_o2nofp.cx10a_c8r32
500	14453	0	0.0	50.0	1.8	0.000	0.000	0.100	3.675	55335	13.0	3.829	72	5.4	35.0	0.3	0.002	14414	13854	pg1513_o2nofp.cx10a_c8r32
500	14699	0	0.0	50.2	1.8	0.000	0.000	0.100	3.675	56278	13.0	3.829	71	5.4	34.9	2.8	0.003	14621	14030	pg160_o2nofp.cx10a_c8r32
500	14718	0	0.0	50.2	1.8	0.000	0.000	0.101	3.719	56384	13.1	3.831	71	5.4	35.2	5.5	0.006	14637	14094	pg169_o2nofp.cx10a_c8r32
500	14563	0	0.0	49.5	1.8	0.000	0.000	0.099	3.706	55731	12.9	3.827	71	5.4	34.5	0.3	0.002	14509	13854	pg170_o2nofp.cx10a_c8r32
500	14429	0	0.0	49.5	1.8	0.000	0.000	0.099	3.678	55214	13.0	3.827	72	5.4	34.7	0.3	0.002	14382	13709	pg175_o2nofp.cx10a_c8r32
500	14276	0	0.0	49.5	1.8	0.000	0.000	0.099	3.689	54668	12.9	3.829	72	5.4	34.4	0.3	0.002	14254	13550	pg18beta1_o2nofp.cx10b_c8r32
500	14236	0	0.0	49.6	1.8	0.000	0.000	0.099	3.745	54486	13.0	3.827	73	5.4	34.5	0.3	0.031	14238	13550	pg18beta1_o2nofp.cx10c_c8r32
500	14316	0	0.0	49.6	1.8	0.000	0.000	0.099	3.695	54788	12.9	3.827	72	5.4	34.4	4.7	0.003	14318	13629	pg18beta1_o2nofp.cx10d_c8r32

qp500.L4

qp500.L4: point queries with 500 insert/s per client

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
500	6278	0	0.0	30.8	2.3	0.000	0.000	0.062	4.638	26101	13.4	4.158	171	5.4	34.0	0.3	0.002	6303	6031	pg140_o2nofp.cx10a_c8r32
500	6150	0	0.0	30.9	2.3	0.000	0.000	0.062	4.643	25593	13.4	4.162	174	5.5	34.0	0.3	0.003	6159	5951	pg1418_o2nofp.cx10a_c8r32
500	6226	0	0.0	29.1	2.3	0.000	0.000	0.058	4.668	25609	13.4	4.113	172	5.5	34.0	0.3	0.002	6271	5967	pg150_o2nofp.cx10a_c8r32
500	6188	0	0.0	29.0	2.3	0.000	0.000	0.058	4.658	25444	13.4	4.112	173	5.5	34.0	0.3	0.002	6207	5951	pg1513_o2nofp.cx10a_c8r32
500	6152	0	0.0	28.8	2.2	0.000	0.000	0.058	4.602	25313	13.4	4.115	174	5.5	34.0	2.9	0.002	6175	5935	pg160_o2nofp.cx10a_c8r32
500	6143	0	0.0	28.9	2.3	0.000	0.000	0.058	4.629	25276	13.5	4.115	176	5.5	34.1	2.9	0.002	6191	5919	pg169_o2nofp.cx10a_c8r32
500	6106	0	0.0	27.7	2.3	0.000	0.000	0.055	4.648	25096	13.4	4.110	176	5.5	34.1	0.3	0.002	6127	5919	pg170_o2nofp.cx10a_c8r32
500	6089	0	0.0	27.8	2.3	0.000	0.000	0.056	4.666	25024	13.5	4.110	177	5.5	34.1	0.3	0.002	6111	5919	pg175_o2nofp.cx10a_c8r32
500	6013	0	0.0	28.1	2.2	0.000	0.000	0.056	4.568	24729	13.5	4.113	180	5.4	34.0	0.2	0.002	5999	5903	pg18beta1_o2nofp.cx10b_c8r32
500	6011	0	0.0	28.2	2.2	0.000	0.000	0.056	4.570	24726	13.5	4.113	180	5.4	34.0	0.3	0.001	5999	5903	pg18beta1_o2nofp.cx10c_c8r32
500	5710	0	0.0	28.3	2.3	0.000	0.000	0.057	4.636	23555	13.5	4.126	189	5.5	34.1	0.3	0.002	5663	5519	pg18beta1_o2nofp.cx10d_c8r32

qr1000.L5

qr1000.L5: range queries with 1000 insert/s per client

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
1000	14490	0	0.0	32.8	2.7	0.000	0.000	0.033	2.772	55750	13.4	3.848	74	5.5	32.4	0.3	0.002	14462	13886	pg140_o2nofp.cx10a_c8r32
999	14309	0	0.0	32.8	2.7	0.000	0.000	0.033	2.767	55096	13.3	3.850	74	5.5	32.4	0.3	0.002	14334	13709	pg1418_o2nofp.cx10a_c8r32
999	14746	0	0.0	30.5	2.7	0.000	0.000	0.031	2.734	56717	13.3	3.846	72	5.5	32.4	0.3	0.002	14686	14094	pg150_o2nofp.cx10a_c8r32
1000	14408	0	0.0	30.6	2.7	0.000	0.000	0.031	2.739	55392	13.3	3.845	74	5.5	32.4	0.3	0.002	14414	13789	pg1513_o2nofp.cx10a_c8r32
999	14584	0	0.0	30.8	2.7	0.000	0.000	0.031	2.760	56100	13.4	3.847	74	5.5	32.4	2.8	0.002	14558	13934	pg160_o2nofp.cx10a_c8r32
999	14642	0	0.0	30.6	2.7	0.000	0.000	0.031	2.744	56323	13.4	3.847	73	5.5	32.4	3.1	0.003	14605	14013	pg169_o2nofp.cx10a_c8r32
999	14556	0	0.0	30.1	2.7	0.000	0.000	0.030	2.740	55912	13.3	3.841	73	5.5	32.4	0.3	0.004	14558	13870	pg170_o2nofp.cx10a_c8r32
1000	14499	0	0.0	30.0	2.7	0.000	0.000	0.030	2.735	55663	13.4	3.839	74	5.5	32.4	0.3	0.002	14526	13789	pg175_o2nofp.cx10a_c8r32
1000	14191	0	0.0	33.8	2.7	0.000	0.000	0.034	2.714	54511	13.3	3.841	75	5.5	32.4	0.3	0.006	14190	13470	pg18beta1_o2nofp.cx10b_c8r32
999	14277	0	0.0	33.3	2.6	0.000	0.000	0.033	2.701	54848	13.3	3.842	75	5.5	32.4	0.3	0.003	14301	13566	pg18beta1_o2nofp.cx10c_c8r32
999	14369	0	0.0	33.4	2.6	0.000	0.000	0.033	2.708	55201	13.4	3.842	75	5.5	32.4	0.3	0.004	14382	13614	pg18beta1_o2nofp.cx10d_c8r32

qp1000.L6

qp1000.L6: point queries with 1000 insert/s per client

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
1000	6266	0	0.0	33.4	2.7	0.000	0.000	0.033	2.780	26256	13.5	4.190	172	5.5	30.3	0.2	0.003	6287	6015	pg140_o2nofp.cx10a_c8r32
999	6130	0	0.0	33.1	2.7	0.000	0.000	0.033	2.776	25726	13.5	4.197	176	5.5	30.2	0.2	0.002	6143	5951	pg1418_o2nofp.cx10a_c8r32
999	6200	0	0.0	31.2	2.7	0.000	0.000	0.031	2.745	25719	13.5	4.148	174	5.5	30.2	3.5	0.040	6223	5951	pg150_o2nofp.cx10a_c8r32
999	6156	0	0.0	31.2	2.7	0.000	0.000	0.031	2.740	25550	13.5	4.150	175	5.5	30.3	0.2	0.002	6175	5934	pg1513_o2nofp.cx10a_c8r32
999	6150	0	0.0	31.3	2.7	0.000	0.000	0.031	2.766	25519	13.6	4.150	177	5.5	30.3	2.1	0.002	6175	5935	pg160_o2nofp.cx10a_c8r32
999	6164	0	0.0	31.2	2.7	0.000	0.000	0.031	2.764	25580	13.6	4.150	176	5.5	30.3	2.1	0.033	6191	5919	pg169_o2nofp.cx10a_c8r32
999	6072	0	0.0	29.8	2.7	0.000	0.000	0.030	2.756	25149	13.6	4.142	179	5.5	30.3	0.4	0.002	6095	5903	pg170_o2nofp.cx10a_c8r32
999	6082	0	0.0	29.8	2.7	0.000	0.000	0.030	2.744	25188	13.6	4.142	179	5.5	30.3	0.4	0.001	6111	5903	pg175_o2nofp.cx10a_c8r32
1000	6003	0	0.0	28.1	2.7	0.000	0.000	0.028	2.736	24862	13.6	4.141	181	5.5	30.2	0.3	0.002	5983	5887	pg18beta1_o2nofp.cx10b_c8r32
999	5985	0	0.0	28.1	2.7	0.000	0.000	0.028	2.731	24810	13.6	4.145	182	5.5	30.2	0.3	0.002	5967	5887	pg18beta1_o2nofp.cx10c_c8r32
999	5731	0	0.0	28.2	2.7	0.000	0.000	0.028	2.724	23830	14.1	4.158	197	5.5	30.2	0.3	0.002	5727	5503	pg18beta1_o2nofp.cx10d_c8r32

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	99.980	0.020	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg140_o2nofp.cx10a_c8r32
0.000	99.979	0.020	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1418_o2nofp.cx10a_c8r32
0.000	99.984	0.015	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg150_o2nofp.cx10a_c8r32
0.000	99.989	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1513_o2nofp.cx10a_c8r32
0.000	99.987	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg160_o2nofp.cx10a_c8r32
0.000	99.986	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg169_o2nofp.cx10a_c8r32
0.000	99.988	0.012	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg170_o2nofp.cx10a_c8r32
0.000	99.982	0.018	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg175_o2nofp.cx10a_c8r32
0.000	99.989	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10b_c8r32
0.000	99.984	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10c_c8r32
0.000	99.980	0.020	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10d_c8r32

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	52.106	47.893	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.057	pg140_o2nofp.cx10a_c8r32
0.000	55.195	44.795	0.001	0.009	0.000	0.000	0.000	0.000	0.000	0.049	pg1418_o2nofp.cx10a_c8r32
0.000	48.105	51.894	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.043	pg150_o2nofp.cx10a_c8r32
0.000	52.287	47.712	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.021	pg1513_o2nofp.cx10a_c8r32
0.000	49.730	50.269	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg160_o2nofp.cx10a_c8r32
0.000	47.592	52.407	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.035	pg169_o2nofp.cx10a_c8r32
0.000	62.833	37.166	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.033	pg170_o2nofp.cx10a_c8r32
0.000	61.423	38.576	nonzero	0.001	0.000	0.000	0.000	0.000	0.000	0.030	pg175_o2nofp.cx10a_c8r32
0.000	55.584	44.411	0.004	0.001	0.000	0.000	0.000	0.000	0.000	0.059	pg18beta1_o2nofp.cx10b_c8r32
0.000	52.173	47.818	0.002	0.008	0.000	0.000	0.000	0.000	0.000	0.050	pg18beta1_o2nofp.cx10c_c8r32
0.000	54.231	45.767	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.028	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	29.212	70.767	0.020	0.001	0.000	0.000	0.000	0.000	0.000	0.056	pg140_o2nofp.cx10a_c8r32
0.000	30.077	57.242	12.677	0.005	0.000	0.000	0.000	0.000	0.000	0.046	pg1418_o2nofp.cx10a_c8r32
0.000	29.665	70.315	0.019	0.001	0.000	0.000	0.000	0.000	0.000	0.044	pg150_o2nofp.cx10a_c8r32
0.000	30.359	69.618	0.023	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	pg1513_o2nofp.cx10a_c8r32
0.000	29.303	58.354	12.343	nonzero	0.000	0.000	0.000	0.000	0.000	0.030	pg160_o2nofp.cx10a_c8r32
0.000	28.678	71.299	0.022	0.001	0.000	0.000	0.000	0.000	0.000	0.035	pg169_o2nofp.cx10a_c8r32
0.000	27.842	60.098	12.059	0.001	0.000	0.000	0.000	0.000	0.000	0.033	pg170_o2nofp.cx10a_c8r32
0.000	27.450	61.732	10.817	0.001	0.000	0.000	0.000	0.000	0.000	0.030	pg175_o2nofp.cx10a_c8r32
0.000	26.747	56.502	16.750	0.001	0.000	0.000	0.000	0.000	0.000	0.027	pg18beta1_o2nofp.cx10b_c8r32
0.000	27.270	69.559	3.165	0.006	0.000	0.000	0.000	0.000	0.000	0.049	pg18beta1_o2nofp.cx10c_c8r32
0.000	27.140	56.922	15.937	0.001	0.000	0.000	0.000	0.000	0.000	0.030	pg18beta1_o2nofp.cx10d_c8r32

l.i2

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
58.694	41.306	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg140_o2nofp.cx10a_c8r32
58.665	41.335	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.031	pg1418_o2nofp.cx10a_c8r32
58.031	41.969	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg150_o2nofp.cx10a_c8r32
59.772	40.228	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.050	pg1513_o2nofp.cx10a_c8r32
54.883	45.117	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg160_o2nofp.cx10a_c8r32
56.139	43.861	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg169_o2nofp.cx10a_c8r32
61.505	38.495	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg170_o2nofp.cx10a_c8r32
58.218	41.781	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	pg175_o2nofp.cx10a_c8r32
56.587	43.412	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	pg18beta1_o2nofp.cx10b_c8r32
54.090	45.909	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg18beta1_o2nofp.cx10c_c8r32
56.056	43.944	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
1.966	31.536	66.496	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg140_o2nofp.cx10a_c8r32
1.790	40.698	56.966	0.546	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	pg1418_o2nofp.cx10a_c8r32
1.906	32.904	65.187	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg150_o2nofp.cx10a_c8r32
1.851	28.436	69.710	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.051	pg1513_o2nofp.cx10a_c8r32
2.020	39.698	58.101	0.181	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg160_o2nofp.cx10a_c8r32
1.538	32.618	65.843	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg169_o2nofp.cx10a_c8r32
1.638	40.312	54.217	3.833	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg170_o2nofp.cx10a_c8r32
1.727	37.206	57.944	3.123	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg175_o2nofp.cx10a_c8r32
1.575	37.725	58.990	1.710	nonzero	0.000	0.000	0.000	0.000	0.000	0.033	pg18beta1_o2nofp.cx10b_c8r32
1.573	38.725	58.182	1.520	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg18beta1_o2nofp.cx10c_c8r32
1.599	38.993	58.683	0.724	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	pg18beta1_o2nofp.cx10d_c8r32

qr100.L1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.996	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg140_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1418_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg150_o2nofp.cx10a_c8r32
99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1513_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg160_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg169_o2nofp.cx10a_c8r32
99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg170_o2nofp.cx10a_c8r32
99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg175_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg18beta1_o2nofp.cx10b_c8r32
99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg18beta1_o2nofp.cx10c_c8r32
99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.028	99.944	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg140_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1418_o2nofp.cx10a_c8r32
0.000	0.278	99.667	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg150_o2nofp.cx10a_c8r32
0.000	1.083	98.861	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1513_o2nofp.cx10a_c8r32
0.000	0.389	99.556	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg160_o2nofp.cx10a_c8r32
0.000	0.889	99.056	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg169_o2nofp.cx10a_c8r32
0.000	2.722	97.250	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg170_o2nofp.cx10a_c8r32
0.000	0.194	99.778	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg175_o2nofp.cx10a_c8r32
0.000	0.528	99.417	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10b_c8r32
0.000	2.472	97.472	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.667	99.306	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	48.056	51.944	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg140_o2nofp.cx10a_c8r32
0.000	50.667	49.333	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1418_o2nofp.cx10a_c8r32
0.000	44.889	55.111	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg150_o2nofp.cx10a_c8r32
0.000	53.083	46.917	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1513_o2nofp.cx10a_c8r32
0.000	47.972	52.028	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg160_o2nofp.cx10a_c8r32
0.000	59.778	40.222	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg169_o2nofp.cx10a_c8r32
0.000	51.222	48.778	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg170_o2nofp.cx10a_c8r32
0.000	52.250	47.750	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg175_o2nofp.cx10a_c8r32
0.000	50.917	49.083	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10b_c8r32
0.000	54.194	45.806	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10c_c8r32
0.000	49.583	50.417	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10d_c8r32

qp100.L2

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
98.608	1.391	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg140_o2nofp.cx10a_c8r32
98.404	1.596	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1418_o2nofp.cx10a_c8r32
98.411	1.589	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg150_o2nofp.cx10a_c8r32
98.281	1.719	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1513_o2nofp.cx10a_c8r32
98.111	1.889	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg160_o2nofp.cx10a_c8r32
98.297	1.703	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg169_o2nofp.cx10a_c8r32
98.492	1.508	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg170_o2nofp.cx10a_c8r32
98.083	1.917	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg175_o2nofp.cx10a_c8r32
98.522	1.478	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg18beta1_o2nofp.cx10b_c8r32
98.161	1.839	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10c_c8r32
97.997	2.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg140_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg150_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg160_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg169_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg170_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg175_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	99.722	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	14.278	85.722	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg140_o2nofp.cx10a_c8r32
0.000	10.389	89.611	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1418_o2nofp.cx10a_c8r32
0.000	6.500	93.472	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg150_o2nofp.cx10a_c8r32
0.000	11.778	88.194	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1513_o2nofp.cx10a_c8r32
0.000	10.306	89.667	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg160_o2nofp.cx10a_c8r32
0.000	7.694	92.306	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg169_o2nofp.cx10a_c8r32
0.000	8.556	91.417	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg170_o2nofp.cx10a_c8r32
0.000	7.028	92.944	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg175_o2nofp.cx10a_c8r32
0.000	0.722	99.250	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10b_c8r32
0.000	4.194	95.778	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.167	99.806	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg18beta1_o2nofp.cx10d_c8r32

qr500.L3

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg140_o2nofp.cx10a_c8r32
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1418_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg150_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1513_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg160_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg169_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg170_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg175_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10b_c8r32
99.996	0.004	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.031	pg18beta1_o2nofp.cx10c_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	22.267	77.644	0.089	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg140_o2nofp.cx10a_c8r32
0.000	14.944	84.856	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1418_o2nofp.cx10a_c8r32
0.000	24.978	74.989	0.033	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg150_o2nofp.cx10a_c8r32
0.000	30.444	69.489	0.067	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1513_o2nofp.cx10a_c8r32
0.000	22.744	77.239	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg160_o2nofp.cx10a_c8r32
0.000	24.383	75.494	0.122	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg169_o2nofp.cx10a_c8r32
0.000	29.822	70.122	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg170_o2nofp.cx10a_c8r32
0.000	26.056	73.922	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg175_o2nofp.cx10a_c8r32
0.000	29.656	70.322	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg18beta1_o2nofp.cx10b_c8r32
0.000	29.072	70.706	0.222	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg18beta1_o2nofp.cx10c_c8r32
0.000	28.811	71.144	0.044	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	24.700	74.956	0.344	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg140_o2nofp.cx10a_c8r32
0.000	23.900	75.917	0.183	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1418_o2nofp.cx10a_c8r32
0.000	23.383	76.428	0.189	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg150_o2nofp.cx10a_c8r32
0.000	19.300	80.550	0.150	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1513_o2nofp.cx10a_c8r32
0.000	23.156	76.628	0.217	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg160_o2nofp.cx10a_c8r32
0.000	23.572	75.583	0.844	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg169_o2nofp.cx10a_c8r32
0.000	18.556	80.311	1.133	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg170_o2nofp.cx10a_c8r32
0.000	19.417	79.467	1.117	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg175_o2nofp.cx10a_c8r32
0.000	22.367	77.011	0.622	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10b_c8r32
0.000	15.650	83.594	0.756	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg18beta1_o2nofp.cx10c_c8r32
0.000	18.456	80.933	0.611	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10d_c8r32

qp500.L4

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
98.847	1.153	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg140_o2nofp.cx10a_c8r32
98.329	1.671	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg1418_o2nofp.cx10a_c8r32
98.343	1.657	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg150_o2nofp.cx10a_c8r32
98.339	1.661	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1513_o2nofp.cx10a_c8r32
98.190	1.810	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg160_o2nofp.cx10a_c8r32
98.065	1.935	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg169_o2nofp.cx10a_c8r32
98.143	1.857	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg170_o2nofp.cx10a_c8r32
98.123	1.877	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg175_o2nofp.cx10a_c8r32
98.171	1.829	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10b_c8r32
98.004	1.996	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg18beta1_o2nofp.cx10c_c8r32
97.839	2.161	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	13.467	86.522	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg140_o2nofp.cx10a_c8r32
0.000	9.939	90.011	0.050	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1418_o2nofp.cx10a_c8r32
0.000	9.650	90.189	0.156	0.006	0.000	0.000	0.000	0.000	0.000	0.018	pg150_o2nofp.cx10a_c8r32
0.000	14.128	85.678	0.194	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1513_o2nofp.cx10a_c8r32
0.000	8.700	91.200	0.100	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg160_o2nofp.cx10a_c8r32
0.000	13.483	86.478	0.039	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg169_o2nofp.cx10a_c8r32
0.000	16.150	83.717	0.133	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg170_o2nofp.cx10a_c8r32
0.000	10.622	89.239	0.139	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg175_o2nofp.cx10a_c8r32
0.000	15.678	84.294	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10b_c8r32
0.000	15.822	84.161	0.011	0.006	0.000	0.000	0.000	0.000	0.000	0.021	pg18beta1_o2nofp.cx10c_c8r32
0.000	13.567	86.306	0.128	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	20.811	78.889	0.300	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg140_o2nofp.cx10a_c8r32
0.000	22.144	77.561	0.294	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1418_o2nofp.cx10a_c8r32
0.000	18.961	80.811	0.222	0.006	0.000	0.000	0.000	0.000	0.000	0.017	pg150_o2nofp.cx10a_c8r32
0.000	20.567	79.178	0.256	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1513_o2nofp.cx10a_c8r32
0.000	18.800	80.789	0.411	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg160_o2nofp.cx10a_c8r32
0.000	22.989	73.589	3.422	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg169_o2nofp.cx10a_c8r32
0.000	19.233	79.339	1.428	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg170_o2nofp.cx10a_c8r32
0.000	17.572	81.078	1.350	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg175_o2nofp.cx10a_c8r32
0.000	16.906	82.217	0.878	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10b_c8r32
0.000	17.500	81.672	0.822	0.006	0.000	0.000	0.000	0.000	0.000	0.019	pg18beta1_o2nofp.cx10c_c8r32
0.000	17.178	82.028	0.794	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg18beta1_o2nofp.cx10d_c8r32

qr1000.L5

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg140_o2nofp.cx10a_c8r32
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1418_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg150_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1513_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg160_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg169_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg170_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg175_o2nofp.cx10a_c8r32
99.994	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg18beta1_o2nofp.cx10b_c8r32
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg18beta1_o2nofp.cx10c_c8r32
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	41.142	58.836	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg140_o2nofp.cx10a_c8r32
0.000	37.864	62.128	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1418_o2nofp.cx10a_c8r32
0.000	43.567	56.425	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg150_o2nofp.cx10a_c8r32
0.000	48.269	51.719	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1513_o2nofp.cx10a_c8r32
0.000	41.583	58.386	0.031	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg160_o2nofp.cx10a_c8r32
0.000	42.528	57.461	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg169_o2nofp.cx10a_c8r32
0.000	47.233	52.764	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg170_o2nofp.cx10a_c8r32
0.000	42.983	57.008	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg175_o2nofp.cx10a_c8r32
0.000	42.094	57.847	0.058	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10b_c8r32
0.000	48.808	51.178	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10c_c8r32
0.000	43.917	56.078	0.006	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	22.106	77.756	0.139	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg140_o2nofp.cx10a_c8r32
0.000	22.861	77.078	0.061	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1418_o2nofp.cx10a_c8r32
0.000	21.364	78.561	0.075	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg150_o2nofp.cx10a_c8r32
0.000	24.486	75.408	0.106	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1513_o2nofp.cx10a_c8r32
0.000	19.472	80.422	0.106	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg160_o2nofp.cx10a_c8r32
0.000	24.028	67.647	8.325	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg169_o2nofp.cx10a_c8r32
0.000	18.781	80.594	0.625	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg170_o2nofp.cx10a_c8r32
0.000	19.372	80.078	0.550	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg175_o2nofp.cx10a_c8r32
0.000	16.508	83.033	0.458	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg18beta1_o2nofp.cx10b_c8r32
0.000	18.342	81.094	0.564	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10c_c8r32
0.000	17.772	81.839	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10d_c8r32

qp1000.L6

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
98.799	1.201	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg140_o2nofp.cx10a_c8r32
98.400	1.600	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1418_o2nofp.cx10a_c8r32
98.365	1.635	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.040	pg150_o2nofp.cx10a_c8r32
98.286	1.714	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1513_o2nofp.cx10a_c8r32
98.277	1.723	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg160_o2nofp.cx10a_c8r32
98.186	1.814	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.033	pg169_o2nofp.cx10a_c8r32
98.034	1.966	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg170_o2nofp.cx10a_c8r32
97.914	2.086	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg175_o2nofp.cx10a_c8r32
98.214	1.786	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10b_c8r32
98.057	1.943	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10c_c8r32
98.041	1.959	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	39.736	60.250	0.011	0.003	0.000	0.000	0.000	0.000	0.000	0.025	pg140_o2nofp.cx10a_c8r32
0.000	31.050	68.939	0.006	0.006	0.000	0.000	0.000	0.000	0.000	0.020	pg1418_o2nofp.cx10a_c8r32
0.000	41.806	58.183	0.006	0.006	0.000	0.000	0.000	0.000	0.000	0.022	pg150_o2nofp.cx10a_c8r32
0.000	43.086	56.900	0.011	0.003	0.000	0.000	0.000	0.000	0.000	0.021	pg1513_o2nofp.cx10a_c8r32
0.000	38.419	61.569	0.003	0.008	0.000	0.000	0.000	0.000	0.000	0.027	pg160_o2nofp.cx10a_c8r32
0.000	45.089	54.900	0.006	0.006	0.000	0.000	0.000	0.000	0.000	0.025	pg169_o2nofp.cx10a_c8r32
0.000	43.850	56.139	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg170_o2nofp.cx10a_c8r32
0.000	40.986	59.003	0.006	0.006	0.000	0.000	0.000	0.000	0.000	0.026	pg175_o2nofp.cx10a_c8r32
0.000	36.233	63.756	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg18beta1_o2nofp.cx10b_c8r32
0.000	38.386	61.606	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg18beta1_o2nofp.cx10c_c8r32
0.000	33.478	66.508	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	30.133	69.642	0.222	0.003	0.000	0.000	0.000	0.000	0.000	0.022	pg140_o2nofp.cx10a_c8r32
0.000	28.850	70.978	0.167	0.006	0.000	0.000	0.000	0.000	0.000	0.018	pg1418_o2nofp.cx10a_c8r32
0.000	28.406	71.400	0.189	0.006	0.000	0.000	0.000	0.000	0.000	0.020	pg150_o2nofp.cx10a_c8r32
0.000	31.047	68.767	0.183	0.003	0.000	0.000	0.000	0.000	0.000	0.020	pg1513_o2nofp.cx10a_c8r32
0.000	31.175	68.542	0.275	0.008	0.000	0.000	0.000	0.000	0.000	0.025	pg160_o2nofp.cx10a_c8r32
0.000	34.597	54.603	10.794	0.006	0.000	0.000	0.000	0.000	0.000	0.023	pg169_o2nofp.cx10a_c8r32
0.000	25.944	73.456	0.600	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg170_o2nofp.cx10a_c8r32
0.000	28.578	70.817	0.600	0.006	0.000	0.000	0.000	0.000	0.000	0.023	pg175_o2nofp.cx10a_c8r32
0.000	18.167	81.297	0.536	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10b_c8r32
0.000	16.631	82.753	0.617	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10c_c8r32
0.000	19.450	80.044	0.506	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg18beta1_o2nofp.cx10d_c8r32