Introduction

This is a report for the insert benchmark with 800M 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 800M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 4m+1m 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 larger than memory. 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 1422732760523475186145415291385051612356480
pg1418_o2nofp.cx10a_c8r32 1387682805053445185144715361379551812239482
pg150_o2nofp.cx10a_c8r32 1446393030303271176146375311394051612308475
pg1513_o2nofp.cx10a_c8r32 1467623030303370174143895371384651612035475
pg160_o2nofp.cx10a_c8r32 1445613046463292176145765311399751712212477
pg169_o2nofp.cx10a_c8r32 1431903034903358165142665261352451611989475
pg170_o2nofp.cx10a_c8r32 1437563059273033158145405341383751812017481
pg175_o2nofp.cx10a_c8r32 1446133133573170161146605321390651812081481
pg18beta1_o2nofp.cx10b_c8r32 1444043144653021158143435341355651811871478
pg18beta1_o2nofp.cx10c_c8r32 1428573203843108154144455291346651311699473
pg18beta1_o2nofp.cx10d_c8r32 1440923128673142158144465301370851211982473

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.020.990.991.001.011.001.000.991.00
pg150_o2nofp.cx10a_c8r32 1.021.100.940.951.011.001.011.001.000.99
pg1513_o2nofp.cx10a_c8r32 1.031.100.970.940.991.021.001.000.970.99
pg160_o2nofp.cx10a_c8r32 1.021.100.950.951.001.001.011.000.990.99
pg169_o2nofp.cx10a_c8r32 1.011.100.970.890.980.990.981.000.970.99
pg170_o2nofp.cx10a_c8r32 1.011.110.870.851.001.011.001.000.971.00
pg175_o2nofp.cx10a_c8r32 1.021.140.910.871.011.011.001.000.981.00
pg18beta1_o2nofp.cx10b_c8r32 1.011.140.870.850.991.010.981.000.961.00
pg18beta1_o2nofp.cx10c_c8r32 1.001.160.890.830.991.000.970.990.950.99
pg18beta1_o2nofp.cx10d_c8r32 1.011.130.900.850.991.000.990.990.970.99

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_c8r32100100500500999999
pg1418_o2nofp.cx10a_c8r32100100500500999999
pg150_o2nofp.cx10a_c8r32100100500500999999
pg1513_o2nofp.cx10a_c8r32100100500500999999
pg160_o2nofp.cx10a_c8r32100100500500999999
pg169_o2nofp.cx10a_c8r32100100500500999999
pg170_o2nofp.cx10a_c8r32100100500500999999
pg175_o2nofp.cx10a_c8r32100100500500999999
pg18beta1_o2nofp.cx10b_c8r32100100500500999999
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.9630.0320.0050.0010.037
pg1418_o2nofp.cx10a_c8r3299.9670.0280.0050.0010.060
pg150_o2nofp.cx10a_c8r3299.8880.0980.0120.002nonzero0.070
pg1513_o2nofp.cx10a_c8r3299.9730.0230.0030.002nonzero0.077
pg160_o2nofp.cx10a_c8r3299.9720.0230.0030.0020.061
pg169_o2nofp.cx10a_c8r3299.9670.0270.0040.0020.048
pg170_o2nofp.cx10a_c8r3299.9700.0240.0040.0030.058
pg175_o2nofp.cx10a_c8r3299.9740.0210.0030.001nonzero0.072
pg18beta1_o2nofp.cx10b_c8r3299.9720.0230.0040.0010.040
pg18beta1_o2nofp.cx10c_c8r3299.8370.1550.0060.002nonzero0.069
pg18beta1_o2nofp.cx10d_c8r3299.9680.0260.0050.0010.047

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
142273	0	28	0.2	530.2	58.6	0.000	0.002	0.004	0.422	16737	20.5	0.118	12	76.5	116.6	20.0	0.037	142283	139380	pg140_o2nofp.cx10a_c8r32
138768	0	25	0.2	523.3	57.2	0.000	0.001	0.004	0.422	16284	20.0	0.117	12	76.5	116.6	7.6	0.060	138684	135981	pg1418_o2nofp.cx10a_c8r32
144639	0	27	0.2	541.9	59.5	0.000	0.001	0.004	0.421	17081	20.6	0.118	11	76.5	116.6	0.8	0.070	145680	124483	pg150_o2nofp.cx10a_c8r32
146762	0	28	0.2	549.6	60.3	0.000	0.002	0.004	0.421	17131	20.7	0.117	11	76.5	116.6	2.2	0.077	146783	143480	pg1513_o2nofp.cx10a_c8r32
144561	0	26	0.2	542.9	59.6	0.000	0.001	0.004	0.422	16865	20.6	0.117	11	76.5	116.6	18.9	0.061	144982	141281	pg160_o2nofp.cx10a_c8r32
143190	0	26	0.2	535.7	59.1	0.000	0.001	0.004	0.423	16710	20.4	0.117	11	76.5	116.6	18.1	0.048	143672	140380	pg169_o2nofp.cx10a_c8r32
143756	0	25	0.2	539.0	59.5	0.000	0.001	0.004	0.424	14352	20.5	0.100	11	76.5	116.6	18.5	0.058	144284	140980	pg170_o2nofp.cx10a_c8r32
144613	0	25	0.2	540.5	59.4	0.000	0.001	0.004	0.421	14417	20.5	0.100	11	76.5	116.6	18.2	0.072	145480	140883	pg175_o2nofp.cx10a_c8r32
144404	0	25	0.2	539.0	59.3	0.000	0.001	0.004	0.421	14394	20.4	0.100	11	76.5	116.6	18.4	0.040	145282	140780	pg18beta1_o2nofp.cx10b_c8r32
142857	0	24	0.2	532.2	58.5	0.000	0.001	0.004	0.419	14651	20.7	0.103	12	76.5	116.6	18.5	0.069	143081	132682	pg18beta1_o2nofp.cx10c_c8r32
144092	0	26	0.2	540.4	59.4	0.000	0.001	0.004	0.422	14461	20.5	0.100	11	76.5	116.6	18.9	0.047	144982	140681	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
276052	0	731	90.6	841.6	100.9	0.003	0.336	0.003	0.374	367	12.9	0.001	4	153.6	193.7	23.4	0.004	NA	NA	pg140_o2nofp.cx10a_c8r32
280505	0	742	92.1	860.2	102.4	0.003	0.336	0.003	0.374	375	12.9	0.001	4	153.6	193.7	23.4	0.005	NA	NA	pg1418_o2nofp.cx10a_c8r32
303030	0	834	101.9	958.8	113.2	0.003	0.344	0.003	0.383	425	12.9	0.001	3	153.6	193.7	23.4	0.003	NA	NA	pg150_o2nofp.cx10a_c8r32
303030	0	824	102.1	955.3	113.2	0.003	0.345	0.003	0.382	451	12.9	0.001	3	153.6	193.7	23.4	0.002	NA	NA	pg1513_o2nofp.cx10a_c8r32
304646	0	826	102.6	958.7	114.0	0.003	0.345	0.003	0.383	454	12.9	0.001	3	153.6	193.7	23.5	0.004	NA	NA	pg160_o2nofp.cx10a_c8r32
303490	0	823	102.2	956.0	113.7	0.003	0.345	0.003	0.384	447	12.9	0.001	3	153.6	193.7	23.5	0.003	NA	NA	pg169_o2nofp.cx10a_c8r32
305927	0	828	102.9	968.2	114.0	0.003	0.344	0.003	0.382	353	13.0	0.001	3	153.6	193.7	23.4	0.002	NA	NA	pg170_o2nofp.cx10a_c8r32
313357	0	849	105.5	998.0	116.9	0.003	0.345	0.003	0.382	474	12.9	0.002	3	153.6	193.7	23.4	0.004	NA	NA	pg175_o2nofp.cx10a_c8r32
314465	0	852	105.9	1001.6	117.1	0.003	0.345	0.003	0.381	449	13.0	0.001	3	153.6	193.7	23.4	0.005	NA	NA	pg18beta1_o2nofp.cx10b_c8r32
320384	0	868	107.8	1010.4	119.7	0.003	0.345	0.003	0.382	1270	13.4	0.004	3	153.6	193.7	23.4	0.003	NA	NA	pg18beta1_o2nofp.cx10c_c8r32
312867	0	848	105.3	996.8	116.8	0.003	0.345	0.003	0.382	999	13.4	0.003	3	153.6	193.7	23.4	0.003	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_c8r3298.2961.7020.0010.072
pg1418_o2nofp.cx10a_c8r3298.2591.7410.050
pg150_o2nofp.cx10a_c8r3298.3941.6060.050
pg1513_o2nofp.cx10a_c8r3298.3381.6630.053
pg160_o2nofp.cx10a_c8r3298.4831.5170.055
pg169_o2nofp.cx10a_c8r3298.4211.5790.052
pg170_o2nofp.cx10a_c8r3298.6011.3990.050
pg175_o2nofp.cx10a_c8r3298.4491.5510.058
pg18beta1_o2nofp.cx10b_c8r3298.4191.5810.059
pg18beta1_o2nofp.cx10c_c8r3298.3231.6780.054
pg18beta1_o2nofp.cx10d_c8r3298.4421.5580.055

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_c8r320.41116.62551.02031.9440.032
pg1418_o2nofp.cx10a_c8r320.77116.47450.36132.3940.031
pg150_o2nofp.cx10a_c8r320.42415.36348.50935.7050.029
pg1513_o2nofp.cx10a_c8r320.41915.58545.51938.4770.030
pg160_o2nofp.cx10a_c8r320.32316.51144.46438.7030.030
pg169_o2nofp.cx10a_c8r320.50416.21245.12938.1550.030
pg170_o2nofp.cx10a_c8r320.47615.44039.61144.4720.037
pg175_o2nofp.cx10a_c8r320.42916.10243.01440.4550.033
pg18beta1_o2nofp.cx10b_c8r320.51115.05438.48845.9480.034
pg18beta1_o2nofp.cx10c_c8r321.01414.86641.44442.6760.033
pg18beta1_o2nofp.cx10d_c8r320.57315.32642.01442.0870.033

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
3475	0	4990	39.5	4123.4	70.5	1.436	11.634	1.187	20.774	11453	15.6	3.296	359	154.3	194.3	23.0	0.072	3300	2100	pg140_o2nofp.cx10a_c8r32
3445	0	4950	39.2	4086.5	69.8	1.437	11.646	1.186	20.748	11340	15.5	3.292	360	154.3	194.3	23.0	0.050	3299	2000	pg1418_o2nofp.cx10a_c8r32
3271	0	4704	37.2	3908.6	66.8	1.438	11.661	1.195	20.928	10748	15.4	3.286	377	154.3	194.3	22.8	0.050	3100	1900	pg150_o2nofp.cx10a_c8r32
3370	0	4845	38.4	4031.3	69.0	1.438	11.656	1.196	20.959	11042	15.4	3.277	366	154.3	194.3	22.8	0.053	3000	2050	pg1513_o2nofp.cx10a_c8r32
3292	0	4727	37.4	3902.8	66.7	1.436	11.638	1.185	20.750	10790	15.3	3.277	372	154.3	194.3	23.0	0.055	2900	1800	pg160_o2nofp.cx10a_c8r32
3358	0	4824	38.2	3965.5	67.7	1.436	11.642	1.181	20.634	11044	15.5	3.288	369	154.3	194.3	23.1	0.052	2950	1800	pg169_o2nofp.cx10a_c8r32
3033	0	4362	34.5	3597.8	61.4	1.438	11.660	1.186	20.735	9844	15.1	3.246	398	154.3	194.3	22.9	0.050	2650	1750	pg170_o2nofp.cx10a_c8r32
3170	0	4558	36.1	3791.7	64.9	1.438	11.659	1.196	20.968	10262	15.0	3.238	379	154.3	194.3	22.7	0.058	2650	1850	pg175_o2nofp.cx10a_c8r32
3021	0	4347	34.4	3622.3	62.0	1.439	11.667	1.199	21.008	9796	14.9	3.243	395	154.3	194.3	22.9	0.059	2600	1550	pg18beta1_o2nofp.cx10b_c8r32
3108	0	4469	35.4	3721.0	63.9	1.438	11.657	1.197	21.068	10063	15.0	3.238	386	154.3	194.3	23.0	0.054	2749	1750	pg18beta1_o2nofp.cx10c_c8r32
3142	0	4519	35.8	3742.2	63.9	1.438	11.654	1.191	20.827	10167	14.9	3.236	379	154.3	194.3	22.9	0.055	2600	1800	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_c8r326.99092.6780.3230.0090.035
pg1418_o2nofp.cx10a_c8r326.92692.7410.3290.0040.023
pg150_o2nofp.cx10a_c8r327.42192.2100.3610.0070.021
pg1513_o2nofp.cx10a_c8r326.99292.6260.3730.0090.023
pg160_o2nofp.cx10a_c8r327.10192.6160.2750.0080.033
pg169_o2nofp.cx10a_c8r326.83492.8530.3040.0080.032
pg170_o2nofp.cx10a_c8r3211.27688.6700.0500.0030.037
pg175_o2nofp.cx10a_c8r3210.54589.4030.0480.0040.025
pg18beta1_o2nofp.cx10b_c8r329.48990.4560.0520.0030.027
pg18beta1_o2nofp.cx10c_c8r3210.74889.2000.0500.0030.036
pg18beta1_o2nofp.cx10d_c8r3210.64989.3030.0470.0020.022

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_c8r3299.9990.0010.099
pg1418_o2nofp.cx10a_c8r3299.9990.0010.100
pg150_o2nofp.cx10a_c8r3299.9990.0010.101
pg1513_o2nofp.cx10a_c8r3299.9990.0010.097
pg160_o2nofp.cx10a_c8r3299.9990.0010.098
pg169_o2nofp.cx10a_c8r3299.9990.0010.098
pg170_o2nofp.cx10a_c8r3299.9990.0010.097
pg175_o2nofp.cx10a_c8r3299.9990.0010.097
pg18beta1_o2nofp.cx10b_c8r3299.9990.0010.101
pg18beta1_o2nofp.cx10c_c8r3299.9990.0010.102
pg18beta1_o2nofp.cx10d_c8r3299.9990.0010.104

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
186	0	203	2.1	547.0	8.6	1.095	11.643	2.944	47.192	1451	13.1	7.810	5640	154.5	194.5	3.1	0.035	185	160	pg140_o2nofp.cx10a_c8r32
185	0	199	1.6	535.3	7.3	1.072	8.766	2.889	40.575	1426	13.1	7.697	5656	154.5	194.5	23.3	0.023	185	160	pg1418_o2nofp.cx10a_c8r32
176	0	188	1.5	506.6	7.0	1.072	8.763	2.887	41.073	1297	12.9	7.391	5880	154.4	194.5	23.3	0.021	175	140	pg150_o2nofp.cx10a_c8r32
174	0	186	1.5	500.9	7.0	1.073	8.779	2.884	41.118	1304	12.9	7.505	5941	154.4	194.5	23.3	0.023	175	145	pg1513_o2nofp.cx10a_c8r32
176	0	189	1.5	509.0	7.1	1.073	8.775	2.887	41.104	1314	12.9	7.456	5854	154.4	194.5	23.3	0.033	175	145	pg160_o2nofp.cx10a_c8r32
165	0	177	1.4	487.1	6.8	1.072	8.768	2.945	41.798	1246	12.9	7.531	6239	154.4	194.5	23.3	0.032	165	135	pg169_o2nofp.cx10a_c8r32
158	0	169	1.4	463.9	6.5	1.071	8.759	2.933	41.859	1090	12.8	6.893	6473	154.4	191.7	23.4	0.037	160	130	pg170_o2nofp.cx10a_c8r32
161	0	172	1.4	471.0	6.6	1.072	8.770	2.929	41.733	1109	12.8	6.898	6368	154.4	194.5	23.4	0.025	160	135	pg175_o2nofp.cx10a_c8r32
158	0	170	1.4	465.6	6.5	1.072	8.768	2.939	41.885	1084	12.8	6.841	6465	154.4	191.4	23.4	0.027	160	125	pg18beta1_o2nofp.cx10b_c8r32
154	0	164	1.3	450.5	6.3	1.072	8.761	2.935	41.769	1061	12.8	6.912	6671	154.5	191.4	23.3	0.036	155	120	pg18beta1_o2nofp.cx10c_c8r32
158	0	169	1.3	465.3	6.5	1.072	8.764	2.951	42.065	1086	12.8	6.885	6493	154.4	191.6	23.4	0.022	155	125	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.9940.006nonzerononzero0.009
pg1418_o2nofp.cx10a_c8r3299.9960.004nonzerononzero0.010
pg150_o2nofp.cx10a_c8r3299.9960.003nonzerononzero0.010
pg1513_o2nofp.cx10a_c8r3299.9960.004nonzerononzero0.009
pg160_o2nofp.cx10a_c8r3299.9960.003nonzerononzero0.009
pg169_o2nofp.cx10a_c8r3299.9960.003nonzerononzero0.010
pg170_o2nofp.cx10a_c8r3299.9970.003nonzerononzero0.009
pg175_o2nofp.cx10a_c8r3299.9970.003nonzerononzero0.009
pg18beta1_o2nofp.cx10b_c8r3299.9960.003nonzerononzero0.010
pg18beta1_o2nofp.cx10c_c8r3299.9960.003nonzerononzero0.010
pg18beta1_o2nofp.cx10d_c8r3299.9960.003nonzerononzero0.010

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_c8r3256.80643.1940.023
pg1418_o2nofp.cx10a_c8r3259.69440.3060.025
pg150_o2nofp.cx10a_c8r3256.08343.9170.025
pg1513_o2nofp.cx10a_c8r3255.36144.6390.025
pg160_o2nofp.cx10a_c8r3255.91744.0830.026
pg169_o2nofp.cx10a_c8r3255.55644.4440.026
pg170_o2nofp.cx10a_c8r3260.27839.7220.026
pg175_o2nofp.cx10a_c8r3260.00040.0000.024
pg18beta1_o2nofp.cx10b_c8r3260.36139.6390.024
pg18beta1_o2nofp.cx10c_c8r3260.88939.1110.026
pg18beta1_o2nofp.cx10d_c8r3259.94440.0560.026

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg140_o2nofp.cx10a_c8r3251.88948.0560.0560.010
pg1418_o2nofp.cx10a_c8r3251.38948.5280.0830.010
pg150_o2nofp.cx10a_c8r3250.33349.5560.1110.010
pg1513_o2nofp.cx10a_c8r3253.66746.2500.0830.010
pg160_o2nofp.cx10a_c8r3251.72248.2220.0560.010
pg169_o2nofp.cx10a_c8r3244.83355.1110.0560.010
pg170_o2nofp.cx10a_c8r3251.11148.8060.0830.010
pg175_o2nofp.cx10a_c8r3244.91755.0000.0830.010
pg18beta1_o2nofp.cx10b_c8r3248.44451.5000.0560.010
pg18beta1_o2nofp.cx10c_c8r3251.30648.6110.0830.010
pg18beta1_o2nofp.cx10d_c8r3245.08354.8330.0830.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
100	14541	112	0.9	48.5	1.7	0.008	0.066	0.485	17.778	55824	12.4	3.839	68	154.5	192.5	23.3	0.009	14526	14254	pg140_o2nofp.cx10a_c8r32
100	14471	112	0.9	45.4	1.7	0.008	0.066	0.454	17.504	55549	12.5	3.839	69	154.5	192.2	23.3	0.010	14478	14238	pg1418_o2nofp.cx10a_c8r32
100	14637	111	0.9	44.9	1.7	0.008	0.065	0.449	17.424	56121	12.4	3.834	68	154.5	191.7	23.3	0.010	14622	14446	pg150_o2nofp.cx10a_c8r32
100	14389	111	0.9	42.1	1.7	0.008	0.066	0.421	17.188	55176	12.5	3.835	69	154.5	191.7	23.3	0.009	14398	14126	pg1513_o2nofp.cx10a_c8r32
100	14576	111	0.9	44.0	1.7	0.008	0.065	0.440	17.360	55919	12.4	3.836	68	154.5	192.4	23.3	0.009	14574	14302	pg160_o2nofp.cx10a_c8r32
100	14266	112	0.9	39.5	1.7	0.008	0.067	0.395	16.972	54739	12.6	3.837	71	154.5	193.3	23.3	0.010	14254	14030	pg169_o2nofp.cx10a_c8r32
100	14540	112	0.9	64.4	1.9	0.008	0.066	0.644	19.202	55740	12.6	3.834	69	154.5	190.7	23.4	0.009	14558	14286	pg170_o2nofp.cx10a_c8r32
100	14660	112	0.9	64.7	1.9	0.008	0.065	0.647	19.241	56201	12.4	3.834	68	154.5	192.2	23.4	0.009	14654	14414	pg175_o2nofp.cx10a_c8r32
100	14343	111	0.9	65.3	1.9	0.008	0.065	0.653	19.290	55024	12.6	3.836	70	154.5	192.1	23.4	0.010	14334	14094	pg18beta1_o2nofp.cx10b_c8r32
100	14445	112	0.9	67.0	1.9	0.008	0.064	0.670	19.435	55381	12.5	3.834	69	154.5	189.9	23.4	0.010	14446	14174	pg18beta1_o2nofp.cx10c_c8r32
100	14446	111	0.9	66.3	1.9	0.008	0.064	0.664	19.391	55417	12.6	3.836	70	154.5	193.1	23.4	0.010	14430	14206	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_c8r320.64399.3260.0210.0090.021
pg1418_o2nofp.cx10a_c8r320.78999.2000.0110.008
pg150_o2nofp.cx10a_c8r320.69899.2900.0120.008
pg1513_o2nofp.cx10a_c8r320.81099.1790.0110.007
pg160_o2nofp.cx10a_c8r320.73799.2520.0110.008
pg169_o2nofp.cx10a_c8r320.64299.3410.0180.008
pg170_o2nofp.cx10a_c8r320.77899.2100.0110.011
pg175_o2nofp.cx10a_c8r320.72499.2660.0100.007
pg18beta1_o2nofp.cx10b_c8r320.77799.2110.0120.008
pg18beta1_o2nofp.cx10c_c8r320.72099.2680.0120.007
pg18beta1_o2nofp.cx10d_c8r320.78399.2060.0110.007

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_c8r3291.7508.2500.027
pg1418_o2nofp.cx10a_c8r3292.2787.7220.021
pg150_o2nofp.cx10a_c8r3293.0007.0000.023
pg1513_o2nofp.cx10a_c8r3292.4177.5830.020
pg160_o2nofp.cx10a_c8r3291.3618.6390.024
pg169_o2nofp.cx10a_c8r3293.0286.9720.020
pg170_o2nofp.cx10a_c8r3299.5830.4170.024
pg175_o2nofp.cx10a_c8r3299.4720.5280.019
pg18beta1_o2nofp.cx10b_c8r3299.4440.5560.019
pg18beta1_o2nofp.cx10c_c8r3299.4440.5560.020
pg18beta1_o2nofp.cx10d_c8r3299.5560.4440.019

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_c8r3299.8610.1390.010
pg1418_o2nofp.cx10a_c8r3299.9720.0280.008
pg150_o2nofp.cx10a_c8r3299.9720.0280.009
pg1513_o2nofp.cx10a_c8r320.02899.9440.0280.009
pg160_o2nofp.cx10a_c8r3299.9720.0280.008
pg169_o2nofp.cx10a_c8r3299.9720.0280.008
pg170_o2nofp.cx10a_c8r3299.9720.0280.008
pg175_o2nofp.cx10a_c8r3299.2220.7780.008
pg18beta1_o2nofp.cx10b_c8r3299.9720.0280.008
pg18beta1_o2nofp.cx10c_c8r3297.7502.2500.009
pg18beta1_o2nofp.cx10d_c8r3299.9720.0280.009

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	529	6909	54.3	369.2	4.2	13.062	105.120	3.696	43.480	15624	4.0	29.540	605	154.5	192.5	23.3	0.021	544	368	pg140_o2nofp.cx10a_c8r32
100	536	6991	55.0	372.1	4.3	13.050	105.064	3.725	43.678	15804	3.7	29.502	553	154.5	192.3	23.3	0.008	560	368	pg1418_o2nofp.cx10a_c8r32
100	531	6952	54.7	368.4	4.2	13.103	105.522	3.688	43.356	15646	3.6	29.487	543	154.5	191.7	23.3	0.008	544	368	pg150_o2nofp.cx10a_c8r32
100	537	6999	55.0	371.7	4.3	13.043	105.003	3.717	43.576	15752	3.7	29.354	552	154.5	191.7	23.3	0.007	560	368	pg1513_o2nofp.cx10a_c8r32
100	531	6935	54.5	369.3	4.2	13.055	105.082	3.697	43.430	15611	3.7	29.388	557	154.5	192.4	23.3	0.008	560	352	pg160_o2nofp.cx10a_c8r32
100	526	6876	54.1	373.9	4.3	13.060	105.152	3.743	43.798	15478	3.7	29.397	562	154.5	193.3	23.3	0.008	544	352	pg169_o2nofp.cx10a_c8r32
100	534	6962	54.7	346.4	4.1	13.038	104.959	3.464	41.574	15666	3.7	29.337	554	154.5	190.7	23.4	0.011	560	368	pg170_o2nofp.cx10a_c8r32
100	532	6939	54.6	345.9	4.1	13.046	105.026	3.459	41.571	15612	3.6	29.351	541	154.5	192.3	23.4	0.007	560	368	pg175_o2nofp.cx10a_c8r32
100	534	6957	54.7	345.6	4.1	13.037	104.962	3.456	41.526	15655	3.7	29.339	555	154.5	192.1	23.4	0.008	560	368	pg18beta1_o2nofp.cx10b_c8r32
100	529	6938	54.5	343.9	4.0	13.106	105.501	3.439	41.408	15603	3.7	29.473	559	154.5	189.9	23.4	0.007	560	352	pg18beta1_o2nofp.cx10c_c8r32
100	530	6911	54.3	344.3	4.0	13.043	104.957	3.443	41.452	15550	3.7	29.346	559	154.5	193.1	23.4	0.007	560	352	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.9810.018nonzerononzerononzero0.017
pg1418_o2nofp.cx10a_c8r3299.9830.016nonzerononzerononzero0.033
pg150_o2nofp.cx10a_c8r3299.9830.017nonzerononzerononzero0.042
pg1513_o2nofp.cx10a_c8r3299.9820.017nonzero0.001nonzero0.031
pg160_o2nofp.cx10a_c8r3299.9820.017nonzero0.001nonzero0.045
pg169_o2nofp.cx10a_c8r3299.9800.019nonzero0.001nonzero0.033
pg170_o2nofp.cx10a_c8r3299.9840.015nonzerononzerononzero0.020
pg175_o2nofp.cx10a_c8r3299.9850.015nonzerononzerononzero0.025
pg18beta1_o2nofp.cx10b_c8r3299.9830.016nonzerononzerononzero0.032
pg18beta1_o2nofp.cx10c_c8r3299.9830.016nonzerononzerononzero0.025
pg18beta1_o2nofp.cx10d_c8r3299.9830.017nonzerononzerononzero0.036

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_c8r3292.6787.3220.035
pg1418_o2nofp.cx10a_c8r3291.6068.3940.033
pg150_o2nofp.cx10a_c8r3291.6118.3890.031
pg1513_o2nofp.cx10a_c8r3291.4398.5610.031
pg160_o2nofp.cx10a_c8r3291.6338.3670.030
pg169_o2nofp.cx10a_c8r3291.5118.4890.028
pg170_o2nofp.cx10a_c8r3293.4396.5610.025
pg175_o2nofp.cx10a_c8r3293.4896.5110.025
pg18beta1_o2nofp.cx10b_c8r3293.4176.5830.030
pg18beta1_o2nofp.cx10c_c8r3293.8286.1720.031
pg18beta1_o2nofp.cx10d_c8r3293.7226.2780.030

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_c8r3245.97854.0220.014
pg1418_o2nofp.cx10a_c8r3246.65653.3440.015
pg150_o2nofp.cx10a_c8r3243.06756.9330.014
pg1513_o2nofp.cx10a_c8r3243.08356.9170.014
pg160_o2nofp.cx10a_c8r3242.81757.1830.015
pg169_o2nofp.cx10a_c8r3242.80057.2000.015
pg170_o2nofp.cx10a_c8r3243.07256.9280.014
pg175_o2nofp.cx10a_c8r3242.39457.6060.014
pg18beta1_o2nofp.cx10b_c8r3240.78959.2110.015
pg18beta1_o2nofp.cx10c_c8r3241.40658.5940.015
pg18beta1_o2nofp.cx10d_c8r3236.75063.2500.015

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	13850	869	6.9	282.7	8.6	0.063	0.512	0.565	17.631	54779	13.6	3.955	79	154.6	190.1	23.3	0.017	13854	13342	pg140_o2nofp.cx10a_c8r32
500	13795	869	6.9	276.6	8.5	0.063	0.514	0.553	17.463	54567	13.6	3.955	79	154.6	190.4	23.3	0.033	13806	13294	pg1418_o2nofp.cx10a_c8r32
500	13940	869	6.9	277.3	8.5	0.062	0.509	0.555	17.519	55126	13.6	3.955	78	154.6	190.3	23.3	0.042	13950	13421	pg150_o2nofp.cx10a_c8r32
500	13846	868	6.9	271.2	8.5	0.063	0.512	0.542	17.340	54724	13.6	3.952	79	154.6	190.3	23.3	0.031	13839	13326	pg1513_o2nofp.cx10a_c8r32
500	13997	870	6.9	274.8	8.5	0.062	0.507	0.550	17.458	55329	13.6	3.953	78	154.6	190.5	23.3	0.045	14014	13438	pg160_o2nofp.cx10a_c8r32
500	13524	870	6.9	257.8	8.3	0.064	0.524	0.516	17.073	53497	13.7	3.956	81	154.6	190.9	23.3	0.033	13534	12990	pg169_o2nofp.cx10a_c8r32
500	13837	868	6.9	345.2	9.3	0.063	0.512	0.691	19.074	54688	13.7	3.952	79	154.6	188.3	23.4	0.020	13854	13326	pg170_o2nofp.cx10a_c8r32
500	13906	869	6.9	345.5	9.3	0.062	0.510	0.691	19.081	54947	13.7	3.951	79	154.6	190.4	23.4	0.025	13934	13422	pg175_o2nofp.cx10a_c8r32
500	13556	869	6.9	347.2	9.3	0.064	0.524	0.694	19.110	53588	13.7	3.953	81	154.6	190.3	23.4	0.032	13582	13038	pg18beta1_o2nofp.cx10b_c8r32
500	13466	868	6.9	350.6	9.4	0.064	0.526	0.702	19.202	53269	13.7	3.956	81	154.6	190.0	23.4	0.025	13470	12958	pg18beta1_o2nofp.cx10c_c8r32
500	13708	869	6.9	349.7	9.4	0.063	0.518	0.699	19.171	54168	13.8	3.951	81	154.6	190.7	23.4	0.036	13710	13166	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_c8r320.36599.6020.0270.0050.019
pg1418_o2nofp.cx10a_c8r320.40699.5850.0100.008
pg150_o2nofp.cx10a_c8r320.38699.6030.0110.009
pg1513_o2nofp.cx10a_c8r320.36999.6210.0100.008
pg160_o2nofp.cx10a_c8r320.38299.6100.0080.008
pg169_o2nofp.cx10a_c8r320.36599.6250.0100.007
pg170_o2nofp.cx10a_c8r320.39099.5990.0110.008
pg175_o2nofp.cx10a_c8r320.41599.5760.0090.007
pg18beta1_o2nofp.cx10b_c8r320.42299.5690.0090.007
pg18beta1_o2nofp.cx10c_c8r320.38699.6050.0090.008
pg18beta1_o2nofp.cx10d_c8r320.39099.6000.0090.008

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.3500.6500.024
pg1418_o2nofp.cx10a_c8r3299.7500.2500.018
pg150_o2nofp.cx10a_c8r3299.7000.3000.019
pg1513_o2nofp.cx10a_c8r3299.7110.2890.020
pg160_o2nofp.cx10a_c8r3299.7110.2890.020
pg169_o2nofp.cx10a_c8r3299.7110.2890.021
pg170_o2nofp.cx10a_c8r3299.7440.2560.021
pg175_o2nofp.cx10a_c8r3299.7610.2390.020
pg18beta1_o2nofp.cx10b_c8r3299.7390.2610.018
pg18beta1_o2nofp.cx10c_c8r3299.7670.2330.019
pg18beta1_o2nofp.cx10d_c8r3299.6560.3440.020

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_c8r3298.3061.6940.043
pg1418_o2nofp.cx10a_c8r3298.3391.6610.042
pg150_o2nofp.cx10a_c8r3298.5611.4390.043
pg1513_o2nofp.cx10a_c8r3298.9061.0940.042
pg160_o2nofp.cx10a_c8r3297.6002.4000.042
pg169_o2nofp.cx10a_c8r3298.2561.7440.043
pg170_o2nofp.cx10a_c8r3290.0069.9940.041
pg175_o2nofp.cx10a_c8r3294.5335.4670.042
pg18beta1_o2nofp.cx10b_c8r3289.69410.3060.043
pg18beta1_o2nofp.cx10c_c8r3287.94412.0560.043
pg18beta1_o2nofp.cx10d_c8r3288.89411.1060.044

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	516	7637	59.9	1616.8	18.8	14.814	119.029	3.234	38.478	17126	6.0	33.222	931	154.6	188.7	23.3	0.019	528	400	pg140_o2nofp.cx10a_c8r32
500	518	7682	60.3	1625.7	18.9	14.815	119.059	3.253	38.646	17221	5.7	33.214	880	154.6	189.1	23.3	0.008	528	416	pg1418_o2nofp.cx10a_c8r32
500	516	7676	60.3	1619.4	18.8	14.874	119.569	3.241	38.541	17144	5.7	33.218	884	154.6	189.0	23.3	0.009	528	400	pg150_o2nofp.cx10a_c8r32
500	516	7644	60.0	1626.9	18.9	14.829	119.160	3.256	38.653	17069	5.7	33.112	885	154.6	189.0	23.3	0.008	528	416	pg1513_o2nofp.cx10a_c8r32
500	517	7652	60.1	1622.1	18.8	14.813	119.033	3.244	38.562	17083	5.9	33.069	914	154.6	189.1	23.3	0.008	528	416	pg160_o2nofp.cx10a_c8r32
500	516	7642	60.0	1641.1	19.0	14.813	119.054	3.282	38.870	17063	5.8	33.074	899	154.6	189.3	23.3	0.007	528	416	pg169_o2nofp.cx10a_c8r32
500	518	7665	60.2	1548.2	18.2	14.809	119.008	3.098	37.335	17093	5.6	33.024	865	154.6	186.8	23.4	0.008	528	416	pg170_o2nofp.cx10a_c8r32
500	518	7671	60.2	1547.0	18.2	14.806	118.980	3.096	37.329	17108	5.6	33.020	865	154.6	188.7	23.4	0.007	528	416	pg175_o2nofp.cx10a_c8r32
500	518	7669	60.2	1546.5	18.2	14.806	118.999	3.095	37.315	17105	5.7	33.022	880	154.6	188.7	23.4	0.007	528	416	pg18beta1_o2nofp.cx10b_c8r32
500	513	7640	59.9	1541.8	18.2	14.903	119.759	3.085	37.235	17023	5.7	33.209	890	154.6	188.3	23.4	0.008	528	416	pg18beta1_o2nofp.cx10c_c8r32
500	512	7599	59.6	1543.7	18.2	14.830	119.165	3.087	37.257	16941	6.0	33.063	937	154.6	188.8	23.4	0.008	528	416	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.9440.0520.0020.001nonzerononzero0.098
pg1418_o2nofp.cx10a_c8r3299.9490.0470.0030.001nonzerononzero0.101
pg150_o2nofp.cx10a_c8r3299.9500.0460.0030.001nonzerononzero0.088
pg1513_o2nofp.cx10a_c8r3299.9460.0500.0030.002nonzerononzero0.089
pg160_o2nofp.cx10a_c8r3299.9490.0470.0030.001nonzerononzero0.085
pg169_o2nofp.cx10a_c8r3299.9470.0490.0030.001nonzerononzero0.090
pg170_o2nofp.cx10a_c8r3299.9530.0440.0030.001nonzerononzero0.091
pg175_o2nofp.cx10a_c8r3299.9550.0410.0020.001nonzerononzero0.096
pg18beta1_o2nofp.cx10b_c8r3299.9500.0460.0030.001nonzerononzero0.091
pg18beta1_o2nofp.cx10c_c8r3299.9490.0470.0030.001nonzerononzero0.091
pg18beta1_o2nofp.cx10d_c8r3299.9510.0450.0030.001nonzerononzero0.089

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_c8r3296.6313.3690.025
pg1418_o2nofp.cx10a_c8r3296.8643.1360.023
pg150_o2nofp.cx10a_c8r3296.7503.2500.023
pg1513_o2nofp.cx10a_c8r3296.7833.2170.023
pg160_o2nofp.cx10a_c8r3297.0222.9780.023
pg169_o2nofp.cx10a_c8r3296.8973.1030.023
pg170_o2nofp.cx10a_c8r3296.9563.0440.022
pg175_o2nofp.cx10a_c8r3296.6193.3810.022
pg18beta1_o2nofp.cx10b_c8r3297.0222.9780.022
pg18beta1_o2nofp.cx10c_c8r3296.7533.2470.028
pg18beta1_o2nofp.cx10d_c8r3297.0642.9360.022

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.04477.9560.063
pg1418_o2nofp.cx10a_c8r3224.97575.0220.0030.064
pg150_o2nofp.cx10a_c8r3215.19784.8030.064
pg1513_o2nofp.cx10a_c8r3216.16183.8390.063
pg160_o2nofp.cx10a_c8r3211.36188.6390.063
pg169_o2nofp.cx10a_c8r3214.21985.7810.064
pg170_o2nofp.cx10a_c8r324.26795.7330.061
pg175_o2nofp.cx10a_c8r328.80691.1940.062
pg18beta1_o2nofp.cx10b_c8r324.93695.0610.0030.065
pg18beta1_o2nofp.cx10c_c8r328.80691.1920.0030.066
pg18beta1_o2nofp.cx10d_c8r324.40095.5970.0030.066

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
999	12356	1489	11.9	895.5	18.4	0.120	0.990	0.896	18.883	50560	18.6	4.092	120	154.8	187.8	23.3	0.098	12366	11630	pg140_o2nofp.cx10a_c8r32
999	12239	1488	11.9	880.8	18.2	0.122	0.999	0.882	18.703	50137	18.4	4.097	120	154.8	188.2	23.3	0.101	12254	11486	pg1418_o2nofp.cx10a_c8r32
999	12308	1488	11.9	886.1	18.3	0.121	0.993	0.887	18.775	50365	18.7	4.092	122	154.8	188.1	23.3	0.088	12318	11598	pg150_o2nofp.cx10a_c8r32
999	12035	1489	11.9	875.9	18.2	0.124	1.016	0.877	18.640	49321	18.7	4.098	124	154.8	188.1	23.3	0.089	12062	11278	pg1513_o2nofp.cx10a_c8r32
999	12212	1488	11.9	884.0	18.3	0.122	1.001	0.885	18.739	49975	19.0	4.092	124	154.8	188.2	23.3	0.085	12222	11391	pg160_o2nofp.cx10a_c8r32
999	11989	1488	11.9	863.0	18.0	0.124	1.019	0.864	18.455	49114	18.8	4.097	125	154.8	188.4	23.3	0.090	12014	11182	pg169_o2nofp.cx10a_c8r32
999	12017	1488	11.9	951.0	19.2	0.124	1.017	0.952	19.693	49178	19.4	4.092	129	154.8	186.1	23.4	0.091	12030	11278	pg170_o2nofp.cx10a_c8r32
999	12081	1489	11.9	953.1	19.2	0.123	1.013	0.954	19.709	49400	19.2	4.089	127	154.8	187.8	23.4	0.096	12094	11295	pg175_o2nofp.cx10a_c8r32
999	11871	1490	12.0	950.7	19.2	0.125	1.031	0.952	19.707	48631	19.4	4.097	131	154.8	187.8	23.4	0.091	11886	11118	pg18beta1_o2nofp.cx10b_c8r32
999	11699	1488	11.9	953.2	19.3	0.127	1.045	0.954	19.732	47945	19.1	4.098	131	154.8	187.4	23.4	0.091	11710	10958	pg18beta1_o2nofp.cx10c_c8r32
999	11982	1488	11.9	952.1	19.2	0.124	1.020	0.953	19.713	49028	19.4	4.092	130	154.8	187.9	23.4	0.089	11998	11198	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_c8r320.14799.3380.5100.0050.038
pg1418_o2nofp.cx10a_c8r320.16599.3010.5330.0020.044
pg150_o2nofp.cx10a_c8r320.15198.8870.9590.0030.042
pg1513_o2nofp.cx10a_c8r320.14898.8411.0080.0030.038
pg160_o2nofp.cx10a_c8r320.15199.0600.7860.0020.040
pg169_o2nofp.cx10a_c8r320.14798.8491.0010.0030.039
pg170_o2nofp.cx10a_c8r320.17499.1220.7020.0020.046
pg175_o2nofp.cx10a_c8r320.17299.1560.6690.0020.044
pg18beta1_o2nofp.cx10b_c8r320.16499.0710.7630.0020.042
pg18beta1_o2nofp.cx10c_c8r320.14599.0220.8310.0020.043
pg18beta1_o2nofp.cx10d_c8r320.15499.0050.8380.0020.043

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_c8r3298.9781.0220.052
pg1418_o2nofp.cx10a_c8r3299.0001.0000.046
pg150_o2nofp.cx10a_c8r3298.0111.9890.055
pg1513_o2nofp.cx10a_c8r3297.7922.2080.051
pg160_o2nofp.cx10a_c8r3298.2691.7310.052
pg169_o2nofp.cx10a_c8r3297.9112.0890.051
pg170_o2nofp.cx10a_c8r3298.9391.0610.058
pg175_o2nofp.cx10a_c8r3298.9641.0360.053
pg18beta1_o2nofp.cx10b_c8r3298.7441.2560.063
pg18beta1_o2nofp.cx10c_c8r3298.5751.4250.054
pg18beta1_o2nofp.cx10d_c8r3298.6081.3920.047

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_c8r3299.9970.0030.101
pg1418_o2nofp.cx10a_c8r3299.9970.0030.103
pg150_o2nofp.cx10a_c8r3299.9970.0030.104
pg1513_o2nofp.cx10a_c8r3299.9970.0030.101
pg160_o2nofp.cx10a_c8r3299.9970.0030.101
pg169_o2nofp.cx10a_c8r3299.9940.0060.100
pg170_o2nofp.cx10a_c8r3299.9970.0030.098
pg175_o2nofp.cx10a_c8r3299.9970.0030.098
pg18beta1_o2nofp.cx10b_c8r3299.9970.0030.106
pg18beta1_o2nofp.cx10c_c8r3299.9970.0030.107
pg18beta1_o2nofp.cx10d_c8r3299.9970.0030.105

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
999	480	8368	65.6	2770.3	34.9	17.440	140.100	2.774	35.767	18722	13.4	39.020	2234	155.0	192.3	23.3	0.038	496	352	pg140_o2nofp.cx10a_c8r32
999	482	8398	65.9	2785.3	34.9	17.424	139.974	2.789	35.769	18754	12.7	38.908	2108	155.0	192.5	23.3	0.044	496	352	pg1418_o2nofp.cx10a_c8r32
999	475	8330	65.4	2774.5	34.8	17.544	140.956	2.776	35.662	18539	13.2	39.046	2224	155.0	192.4	23.3	0.042	496	352	pg150_o2nofp.cx10a_c8r32
999	475	8308	65.2	2788.5	35.0	17.495	140.545	2.792	35.884	18484	13.1	38.922	2207	155.0	192.5	23.3	0.038	496	352	pg1513_o2nofp.cx10a_c8r32
999	477	8329	65.3	2777.4	34.8	17.458	140.243	2.779	35.640	18525	13.4	38.829	2247	155.0	192.4	23.3	0.040	496	352	pg160_o2nofp.cx10a_c8r32
999	475	8298	65.1	2801.8	35.0	17.480	140.456	2.803	35.877	18458	13.3	38.883	2241	155.0	192.6	23.3	0.039	480	368	pg169_o2nofp.cx10a_c8r32
999	481	8372	65.7	2720.0	34.7	17.413	139.891	2.722	35.514	18553	14.0	38.589	2329	155.0	190.9	23.4	0.046	496	352	pg170_o2nofp.cx10a_c8r32
999	481	8382	65.8	2711.0	33.7	17.418	139.922	2.713	34.493	18572	13.8	38.596	2294	155.0	190.9	23.4	0.044	496	368	pg175_o2nofp.cx10a_c8r32
999	478	8338	65.4	2710.8	33.6	17.448	140.180	2.712	34.465	18465	14.3	38.639	2394	155.0	190.9	23.4	0.042	496	352	pg18beta1_o2nofp.cx10b_c8r32
999	473	8313	65.2	2710.3	33.7	17.578	141.222	2.714	34.556	18402	14.1	38.914	2385	155.0	190.6	23.4	0.043	480	352	pg18beta1_o2nofp.cx10c_c8r32
999	473	8283	65.0	2708.4	33.5	17.508	140.637	2.712	34.334	18341	14.3	38.768	2418	155.0	190.7	23.4	0.043	480	352	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
142273	0	28	0.2	530.2	58.6	0.000	0.002	0.004	0.422	16737	20.5	0.118	12	76.5	116.6	20.0	0.037	142283	139380	pg140_o2nofp.cx10a_c8r32
138768	0	25	0.2	523.3	57.2	0.000	0.001	0.004	0.422	16284	20.0	0.117	12	76.5	116.6	7.6	0.060	138684	135981	pg1418_o2nofp.cx10a_c8r32
144639	0	27	0.2	541.9	59.5	0.000	0.001	0.004	0.421	17081	20.6	0.118	11	76.5	116.6	0.8	0.070	145680	124483	pg150_o2nofp.cx10a_c8r32
146762	0	28	0.2	549.6	60.3	0.000	0.002	0.004	0.421	17131	20.7	0.117	11	76.5	116.6	2.2	0.077	146783	143480	pg1513_o2nofp.cx10a_c8r32
144561	0	26	0.2	542.9	59.6	0.000	0.001	0.004	0.422	16865	20.6	0.117	11	76.5	116.6	18.9	0.061	144982	141281	pg160_o2nofp.cx10a_c8r32
143190	0	26	0.2	535.7	59.1	0.000	0.001	0.004	0.423	16710	20.4	0.117	11	76.5	116.6	18.1	0.048	143672	140380	pg169_o2nofp.cx10a_c8r32
143756	0	25	0.2	539.0	59.5	0.000	0.001	0.004	0.424	14352	20.5	0.100	11	76.5	116.6	18.5	0.058	144284	140980	pg170_o2nofp.cx10a_c8r32
144613	0	25	0.2	540.5	59.4	0.000	0.001	0.004	0.421	14417	20.5	0.100	11	76.5	116.6	18.2	0.072	145480	140883	pg175_o2nofp.cx10a_c8r32
144404	0	25	0.2	539.0	59.3	0.000	0.001	0.004	0.421	14394	20.4	0.100	11	76.5	116.6	18.4	0.040	145282	140780	pg18beta1_o2nofp.cx10b_c8r32
142857	0	24	0.2	532.2	58.5	0.000	0.001	0.004	0.419	14651	20.7	0.103	12	76.5	116.6	18.5	0.069	143081	132682	pg18beta1_o2nofp.cx10c_c8r32
144092	0	26	0.2	540.4	59.4	0.000	0.001	0.004	0.422	14461	20.5	0.100	11	76.5	116.6	18.9	0.047	144982	140681	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
276052	0	731	90.6	841.6	100.9	0.003	0.336	0.003	0.374	367	12.9	0.001	4	153.6	193.7	23.4	0.004	NA	NA	pg140_o2nofp.cx10a_c8r32
280505	0	742	92.1	860.2	102.4	0.003	0.336	0.003	0.374	375	12.9	0.001	4	153.6	193.7	23.4	0.005	NA	NA	pg1418_o2nofp.cx10a_c8r32
303030	0	834	101.9	958.8	113.2	0.003	0.344	0.003	0.383	425	12.9	0.001	3	153.6	193.7	23.4	0.003	NA	NA	pg150_o2nofp.cx10a_c8r32
303030	0	824	102.1	955.3	113.2	0.003	0.345	0.003	0.382	451	12.9	0.001	3	153.6	193.7	23.4	0.002	NA	NA	pg1513_o2nofp.cx10a_c8r32
304646	0	826	102.6	958.7	114.0	0.003	0.345	0.003	0.383	454	12.9	0.001	3	153.6	193.7	23.5	0.004	NA	NA	pg160_o2nofp.cx10a_c8r32
303490	0	823	102.2	956.0	113.7	0.003	0.345	0.003	0.384	447	12.9	0.001	3	153.6	193.7	23.5	0.003	NA	NA	pg169_o2nofp.cx10a_c8r32
305927	0	828	102.9	968.2	114.0	0.003	0.344	0.003	0.382	353	13.0	0.001	3	153.6	193.7	23.4	0.002	NA	NA	pg170_o2nofp.cx10a_c8r32
313357	0	849	105.5	998.0	116.9	0.003	0.345	0.003	0.382	474	12.9	0.002	3	153.6	193.7	23.4	0.004	NA	NA	pg175_o2nofp.cx10a_c8r32
314465	0	852	105.9	1001.6	117.1	0.003	0.345	0.003	0.381	449	13.0	0.001	3	153.6	193.7	23.4	0.005	NA	NA	pg18beta1_o2nofp.cx10b_c8r32
320384	0	868	107.8	1010.4	119.7	0.003	0.345	0.003	0.382	1270	13.4	0.004	3	153.6	193.7	23.4	0.003	NA	NA	pg18beta1_o2nofp.cx10c_c8r32
312867	0	848	105.3	996.8	116.8	0.003	0.345	0.003	0.382	999	13.4	0.003	3	153.6	193.7	23.4	0.003	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
3475	0	4990	39.5	4123.4	70.5	1.436	11.634	1.187	20.774	11453	15.6	3.296	359	154.3	194.3	23.0	0.072	3300	2100	pg140_o2nofp.cx10a_c8r32
3445	0	4950	39.2	4086.5	69.8	1.437	11.646	1.186	20.748	11340	15.5	3.292	360	154.3	194.3	23.0	0.050	3299	2000	pg1418_o2nofp.cx10a_c8r32
3271	0	4704	37.2	3908.6	66.8	1.438	11.661	1.195	20.928	10748	15.4	3.286	377	154.3	194.3	22.8	0.050	3100	1900	pg150_o2nofp.cx10a_c8r32
3370	0	4845	38.4	4031.3	69.0	1.438	11.656	1.196	20.959	11042	15.4	3.277	366	154.3	194.3	22.8	0.053	3000	2050	pg1513_o2nofp.cx10a_c8r32
3292	0	4727	37.4	3902.8	66.7	1.436	11.638	1.185	20.750	10790	15.3	3.277	372	154.3	194.3	23.0	0.055	2900	1800	pg160_o2nofp.cx10a_c8r32
3358	0	4824	38.2	3965.5	67.7	1.436	11.642	1.181	20.634	11044	15.5	3.288	369	154.3	194.3	23.1	0.052	2950	1800	pg169_o2nofp.cx10a_c8r32
3033	0	4362	34.5	3597.8	61.4	1.438	11.660	1.186	20.735	9844	15.1	3.246	398	154.3	194.3	22.9	0.050	2650	1750	pg170_o2nofp.cx10a_c8r32
3170	0	4558	36.1	3791.7	64.9	1.438	11.659	1.196	20.968	10262	15.0	3.238	379	154.3	194.3	22.7	0.058	2650	1850	pg175_o2nofp.cx10a_c8r32
3021	0	4347	34.4	3622.3	62.0	1.439	11.667	1.199	21.008	9796	14.9	3.243	395	154.3	194.3	22.9	0.059	2600	1550	pg18beta1_o2nofp.cx10b_c8r32
3108	0	4469	35.4	3721.0	63.9	1.438	11.657	1.197	21.068	10063	15.0	3.238	386	154.3	194.3	23.0	0.054	2749	1750	pg18beta1_o2nofp.cx10c_c8r32
3142	0	4519	35.8	3742.2	63.9	1.438	11.654	1.191	20.827	10167	14.9	3.236	379	154.3	194.3	22.9	0.055	2600	1800	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
186	0	203	2.1	547.0	8.6	1.095	11.643	2.944	47.192	1451	13.1	7.810	5640	154.5	194.5	3.1	0.035	185	160	pg140_o2nofp.cx10a_c8r32
185	0	199	1.6	535.3	7.3	1.072	8.766	2.889	40.575	1426	13.1	7.697	5656	154.5	194.5	23.3	0.023	185	160	pg1418_o2nofp.cx10a_c8r32
176	0	188	1.5	506.6	7.0	1.072	8.763	2.887	41.073	1297	12.9	7.391	5880	154.4	194.5	23.3	0.021	175	140	pg150_o2nofp.cx10a_c8r32
174	0	186	1.5	500.9	7.0	1.073	8.779	2.884	41.118	1304	12.9	7.505	5941	154.4	194.5	23.3	0.023	175	145	pg1513_o2nofp.cx10a_c8r32
176	0	189	1.5	509.0	7.1	1.073	8.775	2.887	41.104	1314	12.9	7.456	5854	154.4	194.5	23.3	0.033	175	145	pg160_o2nofp.cx10a_c8r32
165	0	177	1.4	487.1	6.8	1.072	8.768	2.945	41.798	1246	12.9	7.531	6239	154.4	194.5	23.3	0.032	165	135	pg169_o2nofp.cx10a_c8r32
158	0	169	1.4	463.9	6.5	1.071	8.759	2.933	41.859	1090	12.8	6.893	6473	154.4	191.7	23.4	0.037	160	130	pg170_o2nofp.cx10a_c8r32
161	0	172	1.4	471.0	6.6	1.072	8.770	2.929	41.733	1109	12.8	6.898	6368	154.4	194.5	23.4	0.025	160	135	pg175_o2nofp.cx10a_c8r32
158	0	170	1.4	465.6	6.5	1.072	8.768	2.939	41.885	1084	12.8	6.841	6465	154.4	191.4	23.4	0.027	160	125	pg18beta1_o2nofp.cx10b_c8r32
154	0	164	1.3	450.5	6.3	1.072	8.761	2.935	41.769	1061	12.8	6.912	6671	154.5	191.4	23.3	0.036	155	120	pg18beta1_o2nofp.cx10c_c8r32
158	0	169	1.3	465.3	6.5	1.072	8.764	2.951	42.065	1086	12.8	6.885	6493	154.4	191.6	23.4	0.022	155	125	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	14541	112	0.9	48.5	1.7	0.008	0.066	0.485	17.778	55824	12.4	3.839	68	154.5	192.5	23.3	0.009	14526	14254	pg140_o2nofp.cx10a_c8r32
100	14471	112	0.9	45.4	1.7	0.008	0.066	0.454	17.504	55549	12.5	3.839	69	154.5	192.2	23.3	0.010	14478	14238	pg1418_o2nofp.cx10a_c8r32
100	14637	111	0.9	44.9	1.7	0.008	0.065	0.449	17.424	56121	12.4	3.834	68	154.5	191.7	23.3	0.010	14622	14446	pg150_o2nofp.cx10a_c8r32
100	14389	111	0.9	42.1	1.7	0.008	0.066	0.421	17.188	55176	12.5	3.835	69	154.5	191.7	23.3	0.009	14398	14126	pg1513_o2nofp.cx10a_c8r32
100	14576	111	0.9	44.0	1.7	0.008	0.065	0.440	17.360	55919	12.4	3.836	68	154.5	192.4	23.3	0.009	14574	14302	pg160_o2nofp.cx10a_c8r32
100	14266	112	0.9	39.5	1.7	0.008	0.067	0.395	16.972	54739	12.6	3.837	71	154.5	193.3	23.3	0.010	14254	14030	pg169_o2nofp.cx10a_c8r32
100	14540	112	0.9	64.4	1.9	0.008	0.066	0.644	19.202	55740	12.6	3.834	69	154.5	190.7	23.4	0.009	14558	14286	pg170_o2nofp.cx10a_c8r32
100	14660	112	0.9	64.7	1.9	0.008	0.065	0.647	19.241	56201	12.4	3.834	68	154.5	192.2	23.4	0.009	14654	14414	pg175_o2nofp.cx10a_c8r32
100	14343	111	0.9	65.3	1.9	0.008	0.065	0.653	19.290	55024	12.6	3.836	70	154.5	192.1	23.4	0.010	14334	14094	pg18beta1_o2nofp.cx10b_c8r32
100	14445	112	0.9	67.0	1.9	0.008	0.064	0.670	19.435	55381	12.5	3.834	69	154.5	189.9	23.4	0.010	14446	14174	pg18beta1_o2nofp.cx10c_c8r32
100	14446	111	0.9	66.3	1.9	0.008	0.064	0.664	19.391	55417	12.6	3.836	70	154.5	193.1	23.4	0.010	14430	14206	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	529	6909	54.3	369.2	4.2	13.062	105.120	3.696	43.480	15624	4.0	29.540	605	154.5	192.5	23.3	0.021	544	368	pg140_o2nofp.cx10a_c8r32
100	536	6991	55.0	372.1	4.3	13.050	105.064	3.725	43.678	15804	3.7	29.502	553	154.5	192.3	23.3	0.008	560	368	pg1418_o2nofp.cx10a_c8r32
100	531	6952	54.7	368.4	4.2	13.103	105.522	3.688	43.356	15646	3.6	29.487	543	154.5	191.7	23.3	0.008	544	368	pg150_o2nofp.cx10a_c8r32
100	537	6999	55.0	371.7	4.3	13.043	105.003	3.717	43.576	15752	3.7	29.354	552	154.5	191.7	23.3	0.007	560	368	pg1513_o2nofp.cx10a_c8r32
100	531	6935	54.5	369.3	4.2	13.055	105.082	3.697	43.430	15611	3.7	29.388	557	154.5	192.4	23.3	0.008	560	352	pg160_o2nofp.cx10a_c8r32
100	526	6876	54.1	373.9	4.3	13.060	105.152	3.743	43.798	15478	3.7	29.397	562	154.5	193.3	23.3	0.008	544	352	pg169_o2nofp.cx10a_c8r32
100	534	6962	54.7	346.4	4.1	13.038	104.959	3.464	41.574	15666	3.7	29.337	554	154.5	190.7	23.4	0.011	560	368	pg170_o2nofp.cx10a_c8r32
100	532	6939	54.6	345.9	4.1	13.046	105.026	3.459	41.571	15612	3.6	29.351	541	154.5	192.3	23.4	0.007	560	368	pg175_o2nofp.cx10a_c8r32
100	534	6957	54.7	345.6	4.1	13.037	104.962	3.456	41.526	15655	3.7	29.339	555	154.5	192.1	23.4	0.008	560	368	pg18beta1_o2nofp.cx10b_c8r32
100	529	6938	54.5	343.9	4.0	13.106	105.501	3.439	41.408	15603	3.7	29.473	559	154.5	189.9	23.4	0.007	560	352	pg18beta1_o2nofp.cx10c_c8r32
100	530	6911	54.3	344.3	4.0	13.043	104.957	3.443	41.452	15550	3.7	29.346	559	154.5	193.1	23.4	0.007	560	352	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	13850	869	6.9	282.7	8.6	0.063	0.512	0.565	17.631	54779	13.6	3.955	79	154.6	190.1	23.3	0.017	13854	13342	pg140_o2nofp.cx10a_c8r32
500	13795	869	6.9	276.6	8.5	0.063	0.514	0.553	17.463	54567	13.6	3.955	79	154.6	190.4	23.3	0.033	13806	13294	pg1418_o2nofp.cx10a_c8r32
500	13940	869	6.9	277.3	8.5	0.062	0.509	0.555	17.519	55126	13.6	3.955	78	154.6	190.3	23.3	0.042	13950	13421	pg150_o2nofp.cx10a_c8r32
500	13846	868	6.9	271.2	8.5	0.063	0.512	0.542	17.340	54724	13.6	3.952	79	154.6	190.3	23.3	0.031	13839	13326	pg1513_o2nofp.cx10a_c8r32
500	13997	870	6.9	274.8	8.5	0.062	0.507	0.550	17.458	55329	13.6	3.953	78	154.6	190.5	23.3	0.045	14014	13438	pg160_o2nofp.cx10a_c8r32
500	13524	870	6.9	257.8	8.3	0.064	0.524	0.516	17.073	53497	13.7	3.956	81	154.6	190.9	23.3	0.033	13534	12990	pg169_o2nofp.cx10a_c8r32
500	13837	868	6.9	345.2	9.3	0.063	0.512	0.691	19.074	54688	13.7	3.952	79	154.6	188.3	23.4	0.020	13854	13326	pg170_o2nofp.cx10a_c8r32
500	13906	869	6.9	345.5	9.3	0.062	0.510	0.691	19.081	54947	13.7	3.951	79	154.6	190.4	23.4	0.025	13934	13422	pg175_o2nofp.cx10a_c8r32
500	13556	869	6.9	347.2	9.3	0.064	0.524	0.694	19.110	53588	13.7	3.953	81	154.6	190.3	23.4	0.032	13582	13038	pg18beta1_o2nofp.cx10b_c8r32
500	13466	868	6.9	350.6	9.4	0.064	0.526	0.702	19.202	53269	13.7	3.956	81	154.6	190.0	23.4	0.025	13470	12958	pg18beta1_o2nofp.cx10c_c8r32
500	13708	869	6.9	349.7	9.4	0.063	0.518	0.699	19.171	54168	13.8	3.951	81	154.6	190.7	23.4	0.036	13710	13166	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	516	7637	59.9	1616.8	18.8	14.814	119.029	3.234	38.478	17126	6.0	33.222	931	154.6	188.7	23.3	0.019	528	400	pg140_o2nofp.cx10a_c8r32
500	518	7682	60.3	1625.7	18.9	14.815	119.059	3.253	38.646	17221	5.7	33.214	880	154.6	189.1	23.3	0.008	528	416	pg1418_o2nofp.cx10a_c8r32
500	516	7676	60.3	1619.4	18.8	14.874	119.569	3.241	38.541	17144	5.7	33.218	884	154.6	189.0	23.3	0.009	528	400	pg150_o2nofp.cx10a_c8r32
500	516	7644	60.0	1626.9	18.9	14.829	119.160	3.256	38.653	17069	5.7	33.112	885	154.6	189.0	23.3	0.008	528	416	pg1513_o2nofp.cx10a_c8r32
500	517	7652	60.1	1622.1	18.8	14.813	119.033	3.244	38.562	17083	5.9	33.069	914	154.6	189.1	23.3	0.008	528	416	pg160_o2nofp.cx10a_c8r32
500	516	7642	60.0	1641.1	19.0	14.813	119.054	3.282	38.870	17063	5.8	33.074	899	154.6	189.3	23.3	0.007	528	416	pg169_o2nofp.cx10a_c8r32
500	518	7665	60.2	1548.2	18.2	14.809	119.008	3.098	37.335	17093	5.6	33.024	865	154.6	186.8	23.4	0.008	528	416	pg170_o2nofp.cx10a_c8r32
500	518	7671	60.2	1547.0	18.2	14.806	118.980	3.096	37.329	17108	5.6	33.020	865	154.6	188.7	23.4	0.007	528	416	pg175_o2nofp.cx10a_c8r32
500	518	7669	60.2	1546.5	18.2	14.806	118.999	3.095	37.315	17105	5.7	33.022	880	154.6	188.7	23.4	0.007	528	416	pg18beta1_o2nofp.cx10b_c8r32
500	513	7640	59.9	1541.8	18.2	14.903	119.759	3.085	37.235	17023	5.7	33.209	890	154.6	188.3	23.4	0.008	528	416	pg18beta1_o2nofp.cx10c_c8r32
500	512	7599	59.6	1543.7	18.2	14.830	119.165	3.087	37.257	16941	6.0	33.063	937	154.6	188.8	23.4	0.008	528	416	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
999	12356	1489	11.9	895.5	18.4	0.120	0.990	0.896	18.883	50560	18.6	4.092	120	154.8	187.8	23.3	0.098	12366	11630	pg140_o2nofp.cx10a_c8r32
999	12239	1488	11.9	880.8	18.2	0.122	0.999	0.882	18.703	50137	18.4	4.097	120	154.8	188.2	23.3	0.101	12254	11486	pg1418_o2nofp.cx10a_c8r32
999	12308	1488	11.9	886.1	18.3	0.121	0.993	0.887	18.775	50365	18.7	4.092	122	154.8	188.1	23.3	0.088	12318	11598	pg150_o2nofp.cx10a_c8r32
999	12035	1489	11.9	875.9	18.2	0.124	1.016	0.877	18.640	49321	18.7	4.098	124	154.8	188.1	23.3	0.089	12062	11278	pg1513_o2nofp.cx10a_c8r32
999	12212	1488	11.9	884.0	18.3	0.122	1.001	0.885	18.739	49975	19.0	4.092	124	154.8	188.2	23.3	0.085	12222	11391	pg160_o2nofp.cx10a_c8r32
999	11989	1488	11.9	863.0	18.0	0.124	1.019	0.864	18.455	49114	18.8	4.097	125	154.8	188.4	23.3	0.090	12014	11182	pg169_o2nofp.cx10a_c8r32
999	12017	1488	11.9	951.0	19.2	0.124	1.017	0.952	19.693	49178	19.4	4.092	129	154.8	186.1	23.4	0.091	12030	11278	pg170_o2nofp.cx10a_c8r32
999	12081	1489	11.9	953.1	19.2	0.123	1.013	0.954	19.709	49400	19.2	4.089	127	154.8	187.8	23.4	0.096	12094	11295	pg175_o2nofp.cx10a_c8r32
999	11871	1490	12.0	950.7	19.2	0.125	1.031	0.952	19.707	48631	19.4	4.097	131	154.8	187.8	23.4	0.091	11886	11118	pg18beta1_o2nofp.cx10b_c8r32
999	11699	1488	11.9	953.2	19.3	0.127	1.045	0.954	19.732	47945	19.1	4.098	131	154.8	187.4	23.4	0.091	11710	10958	pg18beta1_o2nofp.cx10c_c8r32
999	11982	1488	11.9	952.1	19.2	0.124	1.020	0.953	19.713	49028	19.4	4.092	130	154.8	187.9	23.4	0.089	11998	11198	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
999	480	8368	65.6	2770.3	34.9	17.440	140.100	2.774	35.767	18722	13.4	39.020	2234	155.0	192.3	23.3	0.038	496	352	pg140_o2nofp.cx10a_c8r32
999	482	8398	65.9	2785.3	34.9	17.424	139.974	2.789	35.769	18754	12.7	38.908	2108	155.0	192.5	23.3	0.044	496	352	pg1418_o2nofp.cx10a_c8r32
999	475	8330	65.4	2774.5	34.8	17.544	140.956	2.776	35.662	18539	13.2	39.046	2224	155.0	192.4	23.3	0.042	496	352	pg150_o2nofp.cx10a_c8r32
999	475	8308	65.2	2788.5	35.0	17.495	140.545	2.792	35.884	18484	13.1	38.922	2207	155.0	192.5	23.3	0.038	496	352	pg1513_o2nofp.cx10a_c8r32
999	477	8329	65.3	2777.4	34.8	17.458	140.243	2.779	35.640	18525	13.4	38.829	2247	155.0	192.4	23.3	0.040	496	352	pg160_o2nofp.cx10a_c8r32
999	475	8298	65.1	2801.8	35.0	17.480	140.456	2.803	35.877	18458	13.3	38.883	2241	155.0	192.6	23.3	0.039	480	368	pg169_o2nofp.cx10a_c8r32
999	481	8372	65.7	2720.0	34.7	17.413	139.891	2.722	35.514	18553	14.0	38.589	2329	155.0	190.9	23.4	0.046	496	352	pg170_o2nofp.cx10a_c8r32
999	481	8382	65.8	2711.0	33.7	17.418	139.922	2.713	34.493	18572	13.8	38.596	2294	155.0	190.9	23.4	0.044	496	368	pg175_o2nofp.cx10a_c8r32
999	478	8338	65.4	2710.8	33.6	17.448	140.180	2.712	34.465	18465	14.3	38.639	2394	155.0	190.9	23.4	0.042	496	352	pg18beta1_o2nofp.cx10b_c8r32
999	473	8313	65.2	2710.3	33.7	17.578	141.222	2.714	34.556	18402	14.1	38.914	2385	155.0	190.6	23.4	0.043	480	352	pg18beta1_o2nofp.cx10c_c8r32
999	473	8283	65.0	2708.4	33.5	17.508	140.637	2.712	34.334	18341	14.3	38.768	2418	155.0	190.7	23.4	0.043	480	352	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.963	0.032	0.005	0.001	0.000	0.000	0.000	0.000	0.000	0.037	pg140_o2nofp.cx10a_c8r32
0.000	99.967	0.028	0.005	0.001	0.000	0.000	0.000	0.000	0.000	0.060	pg1418_o2nofp.cx10a_c8r32
0.000	99.888	0.098	0.012	0.002	nonzero	0.000	0.000	0.000	0.000	0.070	pg150_o2nofp.cx10a_c8r32
0.000	99.973	0.023	0.003	0.002	nonzero	0.000	0.000	0.000	0.000	0.077	pg1513_o2nofp.cx10a_c8r32
0.000	99.972	0.023	0.003	0.002	0.000	0.000	0.000	0.000	0.000	0.061	pg160_o2nofp.cx10a_c8r32
0.000	99.967	0.027	0.004	0.002	0.000	0.000	0.000	0.000	0.000	0.048	pg169_o2nofp.cx10a_c8r32
0.000	99.970	0.024	0.004	0.003	0.000	0.000	0.000	0.000	0.000	0.058	pg170_o2nofp.cx10a_c8r32
0.000	99.974	0.021	0.003	0.001	nonzero	0.000	0.000	0.000	0.000	0.072	pg175_o2nofp.cx10a_c8r32
0.000	99.972	0.023	0.004	0.001	0.000	0.000	0.000	0.000	0.000	0.040	pg18beta1_o2nofp.cx10b_c8r32
0.000	99.837	0.155	0.006	0.002	nonzero	0.000	0.000	0.000	0.000	0.069	pg18beta1_o2nofp.cx10c_c8r32
0.000	99.968	0.026	0.005	0.001	0.000	0.000	0.000	0.000	0.000	0.047	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	0.000	0.000	98.296	1.702	0.001	0.000	0.000	0.000	0.000	0.072	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.259	1.741	0.000	0.000	0.000	0.000	0.000	0.050	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.394	1.606	0.000	0.000	0.000	0.000	0.000	0.050	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.338	1.663	0.000	0.000	0.000	0.000	0.000	0.053	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.483	1.517	0.000	0.000	0.000	0.000	0.000	0.055	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.421	1.579	0.000	0.000	0.000	0.000	0.000	0.052	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.601	1.399	0.000	0.000	0.000	0.000	0.000	0.050	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.449	1.551	0.000	0.000	0.000	0.000	0.000	0.058	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.419	1.581	0.000	0.000	0.000	0.000	0.000	0.059	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	98.323	1.678	0.000	0.000	0.000	0.000	0.000	0.054	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	98.442	1.558	0.000	0.000	0.000	0.000	0.000	0.055	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.411	16.625	51.020	31.944	0.000	0.000	0.000	0.000	0.000	0.032	pg140_o2nofp.cx10a_c8r32
0.000	0.771	16.474	50.361	32.394	0.000	0.000	0.000	0.000	0.000	0.031	pg1418_o2nofp.cx10a_c8r32
0.000	0.424	15.363	48.509	35.705	0.000	0.000	0.000	0.000	0.000	0.029	pg150_o2nofp.cx10a_c8r32
0.000	0.419	15.585	45.519	38.477	0.000	0.000	0.000	0.000	0.000	0.030	pg1513_o2nofp.cx10a_c8r32
0.000	0.323	16.511	44.464	38.703	0.000	0.000	0.000	0.000	0.000	0.030	pg160_o2nofp.cx10a_c8r32
0.000	0.504	16.212	45.129	38.155	0.000	0.000	0.000	0.000	0.000	0.030	pg169_o2nofp.cx10a_c8r32
0.000	0.476	15.440	39.611	44.472	0.000	0.000	0.000	0.000	0.000	0.037	pg170_o2nofp.cx10a_c8r32
0.000	0.429	16.102	43.014	40.455	0.000	0.000	0.000	0.000	0.000	0.033	pg175_o2nofp.cx10a_c8r32
0.000	0.511	15.054	38.488	45.948	0.000	0.000	0.000	0.000	0.000	0.034	pg18beta1_o2nofp.cx10b_c8r32
0.000	1.014	14.866	41.444	42.676	0.000	0.000	0.000	0.000	0.000	0.033	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.573	15.326	42.014	42.087	0.000	0.000	0.000	0.000	0.000	0.033	pg18beta1_o2nofp.cx10d_c8r32

l.i2

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	6.990	92.678	0.323	0.009	0.000	0.000	0.000	0.000	0.000	0.035	pg140_o2nofp.cx10a_c8r32
0.000	6.926	92.741	0.329	0.004	0.000	0.000	0.000	0.000	0.000	0.023	pg1418_o2nofp.cx10a_c8r32
0.000	7.421	92.210	0.361	0.007	0.000	0.000	0.000	0.000	0.000	0.021	pg150_o2nofp.cx10a_c8r32
0.000	6.992	92.626	0.373	0.009	0.000	0.000	0.000	0.000	0.000	0.023	pg1513_o2nofp.cx10a_c8r32
0.000	7.101	92.616	0.275	0.008	0.000	0.000	0.000	0.000	0.000	0.033	pg160_o2nofp.cx10a_c8r32
0.000	6.834	92.853	0.304	0.008	0.000	0.000	0.000	0.000	0.000	0.032	pg169_o2nofp.cx10a_c8r32
0.000	11.276	88.670	0.050	0.003	0.000	0.000	0.000	0.000	0.000	0.037	pg170_o2nofp.cx10a_c8r32
0.000	10.545	89.403	0.048	0.004	0.000	0.000	0.000	0.000	0.000	0.025	pg175_o2nofp.cx10a_c8r32
0.000	9.489	90.456	0.052	0.003	0.000	0.000	0.000	0.000	0.000	0.027	pg18beta1_o2nofp.cx10b_c8r32
0.000	10.748	89.200	0.050	0.003	0.000	0.000	0.000	0.000	0.000	0.036	pg18beta1_o2nofp.cx10c_c8r32
0.000	10.649	89.303	0.047	0.002	0.000	0.000	0.000	0.000	0.000	0.022	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.099	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.100	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.101	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.097	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.098	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.098	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.097	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.097	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.101	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.102	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	99.999	0.001	0.000	0.000	0.000	0.000	0.104	pg18beta1_o2nofp.cx10d_c8r32

qr100.L1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.994	0.006	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.010	pg1418_o2nofp.cx10a_c8r32
99.996	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg150_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1513_o2nofp.cx10a_c8r32
99.996	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg160_o2nofp.cx10a_c8r32
99.996	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg169_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg170_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg175_o2nofp.cx10a_c8r32
99.996	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10b_c8r32
99.996	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10c_c8r32
99.996	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	56.806	43.194	0.000	0.000	0.000	0.000	0.000	0.023	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	59.694	40.306	0.000	0.000	0.000	0.000	0.000	0.025	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	56.083	43.917	0.000	0.000	0.000	0.000	0.000	0.025	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	55.361	44.639	0.000	0.000	0.000	0.000	0.000	0.025	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	55.917	44.083	0.000	0.000	0.000	0.000	0.000	0.026	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	55.556	44.444	0.000	0.000	0.000	0.000	0.000	0.026	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	60.278	39.722	0.000	0.000	0.000	0.000	0.000	0.026	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	60.000	40.000	0.000	0.000	0.000	0.000	0.000	0.024	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	60.361	39.639	0.000	0.000	0.000	0.000	0.000	0.024	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	60.889	39.111	0.000	0.000	0.000	0.000	0.000	0.026	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	59.944	40.056	0.000	0.000	0.000	0.000	0.000	0.026	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	51.889	48.056	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg140_o2nofp.cx10a_c8r32
0.000	51.389	48.528	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1418_o2nofp.cx10a_c8r32
0.000	50.333	49.556	0.111	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg150_o2nofp.cx10a_c8r32
0.000	53.667	46.250	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1513_o2nofp.cx10a_c8r32
0.000	51.722	48.222	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg160_o2nofp.cx10a_c8r32
0.000	44.833	55.111	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg169_o2nofp.cx10a_c8r32
0.000	51.111	48.806	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg170_o2nofp.cx10a_c8r32
0.000	44.917	55.000	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg175_o2nofp.cx10a_c8r32
0.000	48.444	51.500	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10b_c8r32
0.000	51.306	48.611	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10c_c8r32
0.000	45.083	54.833	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg18beta1_o2nofp.cx10d_c8r32

qp100.L2

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.643	99.326	0.021	0.009	0.000	0.000	0.000	0.000	0.000	0.021	pg140_o2nofp.cx10a_c8r32
0.000	0.789	99.200	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1418_o2nofp.cx10a_c8r32
0.000	0.698	99.290	0.012	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg150_o2nofp.cx10a_c8r32
0.000	0.810	99.179	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1513_o2nofp.cx10a_c8r32
0.000	0.737	99.252	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg160_o2nofp.cx10a_c8r32
0.000	0.642	99.341	0.018	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg169_o2nofp.cx10a_c8r32
0.000	0.778	99.210	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg170_o2nofp.cx10a_c8r32
0.000	0.724	99.266	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg175_o2nofp.cx10a_c8r32
0.000	0.777	99.211	0.012	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.720	99.268	0.012	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.783	99.206	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	91.750	8.250	0.000	0.000	0.000	0.000	0.000	0.027	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	92.278	7.722	0.000	0.000	0.000	0.000	0.000	0.021	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	93.000	7.000	0.000	0.000	0.000	0.000	0.000	0.023	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	92.417	7.583	0.000	0.000	0.000	0.000	0.000	0.020	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	91.361	8.639	0.000	0.000	0.000	0.000	0.000	0.024	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	93.028	6.972	0.000	0.000	0.000	0.000	0.000	0.020	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.583	0.417	0.000	0.000	0.000	0.000	0.000	0.024	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.472	0.528	0.000	0.000	0.000	0.000	0.000	0.019	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.444	0.556	0.000	0.000	0.000	0.000	0.000	0.019	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	99.444	0.556	0.000	0.000	0.000	0.000	0.000	0.020	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	99.556	0.444	0.000	0.000	0.000	0.000	0.000	0.019	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	99.861	0.139	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg140_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.008	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.009	pg150_o2nofp.cx10a_c8r32
0.000	0.028	99.944	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg160_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.008	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.008	pg170_o2nofp.cx10a_c8r32
0.000	0.000	99.222	0.778	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg175_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	97.750	2.250	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg18beta1_o2nofp.cx10d_c8r32

qr500.L3

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.981	0.018	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.017	pg140_o2nofp.cx10a_c8r32
99.983	0.016	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.033	pg1418_o2nofp.cx10a_c8r32
99.983	0.017	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.042	pg150_o2nofp.cx10a_c8r32
99.982	0.017	nonzero	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.031	pg1513_o2nofp.cx10a_c8r32
99.982	0.017	nonzero	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.045	pg160_o2nofp.cx10a_c8r32
99.980	0.019	nonzero	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.033	pg169_o2nofp.cx10a_c8r32
99.984	0.015	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	pg170_o2nofp.cx10a_c8r32
99.985	0.015	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg175_o2nofp.cx10a_c8r32
99.983	0.016	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	pg18beta1_o2nofp.cx10b_c8r32
99.983	0.016	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg18beta1_o2nofp.cx10c_c8r32
99.983	0.017	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	92.678	7.322	0.000	0.000	0.000	0.000	0.000	0.035	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	91.606	8.394	0.000	0.000	0.000	0.000	0.000	0.033	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	91.611	8.389	0.000	0.000	0.000	0.000	0.000	0.031	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	91.439	8.561	0.000	0.000	0.000	0.000	0.000	0.031	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	91.633	8.367	0.000	0.000	0.000	0.000	0.000	0.030	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	91.511	8.489	0.000	0.000	0.000	0.000	0.000	0.028	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	93.439	6.561	0.000	0.000	0.000	0.000	0.000	0.025	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	93.489	6.511	0.000	0.000	0.000	0.000	0.000	0.025	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	93.417	6.583	0.000	0.000	0.000	0.000	0.000	0.030	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	93.828	6.172	0.000	0.000	0.000	0.000	0.000	0.031	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	93.722	6.278	0.000	0.000	0.000	0.000	0.000	0.030	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	45.978	54.022	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg140_o2nofp.cx10a_c8r32
0.000	0.000	46.656	53.344	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	43.067	56.933	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg150_o2nofp.cx10a_c8r32
0.000	0.000	43.083	56.917	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	42.817	57.183	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg160_o2nofp.cx10a_c8r32
0.000	0.000	42.800	57.200	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg169_o2nofp.cx10a_c8r32
0.000	0.000	43.072	56.928	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg170_o2nofp.cx10a_c8r32
0.000	0.000	42.394	57.606	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg175_o2nofp.cx10a_c8r32
0.000	0.000	40.789	59.211	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	41.406	58.594	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	36.750	63.250	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg18beta1_o2nofp.cx10d_c8r32

qp500.L4

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.365	99.602	0.027	0.005	0.000	0.000	0.000	0.000	0.000	0.019	pg140_o2nofp.cx10a_c8r32
0.000	0.406	99.585	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1418_o2nofp.cx10a_c8r32
0.000	0.386	99.603	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg150_o2nofp.cx10a_c8r32
0.000	0.369	99.621	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1513_o2nofp.cx10a_c8r32
0.000	0.382	99.610	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg160_o2nofp.cx10a_c8r32
0.000	0.365	99.625	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg169_o2nofp.cx10a_c8r32
0.000	0.390	99.599	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg170_o2nofp.cx10a_c8r32
0.000	0.415	99.576	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg175_o2nofp.cx10a_c8r32
0.000	0.422	99.569	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.386	99.605	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.390	99.600	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	99.350	0.650	0.000	0.000	0.000	0.000	0.000	0.024	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.750	0.250	0.000	0.000	0.000	0.000	0.000	0.018	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.700	0.300	0.000	0.000	0.000	0.000	0.000	0.019	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.711	0.289	0.000	0.000	0.000	0.000	0.000	0.020	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.711	0.289	0.000	0.000	0.000	0.000	0.000	0.020	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.711	0.289	0.000	0.000	0.000	0.000	0.000	0.021	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.744	0.256	0.000	0.000	0.000	0.000	0.000	0.021	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.761	0.239	0.000	0.000	0.000	0.000	0.000	0.020	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.739	0.261	0.000	0.000	0.000	0.000	0.000	0.018	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	99.767	0.233	0.000	0.000	0.000	0.000	0.000	0.019	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	99.656	0.344	0.000	0.000	0.000	0.000	0.000	0.020	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	98.306	1.694	0.000	0.000	0.000	0.000	0.000	0.043	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.339	1.661	0.000	0.000	0.000	0.000	0.000	0.042	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.561	1.439	0.000	0.000	0.000	0.000	0.000	0.043	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.906	1.094	0.000	0.000	0.000	0.000	0.000	0.042	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	97.600	2.400	0.000	0.000	0.000	0.000	0.000	0.042	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.256	1.744	0.000	0.000	0.000	0.000	0.000	0.043	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	90.006	9.994	0.000	0.000	0.000	0.000	0.000	0.041	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	94.533	5.467	0.000	0.000	0.000	0.000	0.000	0.042	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	89.694	10.306	0.000	0.000	0.000	0.000	0.000	0.043	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	87.944	12.056	0.000	0.000	0.000	0.000	0.000	0.043	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	88.894	11.106	0.000	0.000	0.000	0.000	0.000	0.044	pg18beta1_o2nofp.cx10d_c8r32

qr1000.L5

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.944	0.052	0.002	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.098	pg140_o2nofp.cx10a_c8r32
99.949	0.047	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.101	pg1418_o2nofp.cx10a_c8r32
99.950	0.046	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.088	pg150_o2nofp.cx10a_c8r32
99.946	0.050	0.003	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.089	pg1513_o2nofp.cx10a_c8r32
99.949	0.047	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.085	pg160_o2nofp.cx10a_c8r32
99.947	0.049	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.090	pg169_o2nofp.cx10a_c8r32
99.953	0.044	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.091	pg170_o2nofp.cx10a_c8r32
99.955	0.041	0.002	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.096	pg175_o2nofp.cx10a_c8r32
99.950	0.046	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.091	pg18beta1_o2nofp.cx10b_c8r32
99.949	0.047	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.091	pg18beta1_o2nofp.cx10c_c8r32
99.951	0.045	0.003	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.089	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	96.631	3.369	0.000	0.000	0.000	0.000	0.000	0.025	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	96.864	3.136	0.000	0.000	0.000	0.000	0.000	0.023	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	96.750	3.250	0.000	0.000	0.000	0.000	0.000	0.023	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	96.783	3.217	0.000	0.000	0.000	0.000	0.000	0.023	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	97.022	2.978	0.000	0.000	0.000	0.000	0.000	0.023	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	96.897	3.103	0.000	0.000	0.000	0.000	0.000	0.023	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	96.956	3.044	0.000	0.000	0.000	0.000	0.000	0.022	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	96.619	3.381	0.000	0.000	0.000	0.000	0.000	0.022	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	97.022	2.978	0.000	0.000	0.000	0.000	0.000	0.022	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	96.753	3.247	0.000	0.000	0.000	0.000	0.000	0.028	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	97.064	2.936	0.000	0.000	0.000	0.000	0.000	0.022	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	22.044	77.956	0.000	0.000	0.000	0.000	0.000	0.063	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	24.975	75.022	0.003	0.000	0.000	0.000	0.000	0.064	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	15.197	84.803	0.000	0.000	0.000	0.000	0.000	0.064	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	16.161	83.839	0.000	0.000	0.000	0.000	0.000	0.063	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	11.361	88.639	0.000	0.000	0.000	0.000	0.000	0.063	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	14.219	85.781	0.000	0.000	0.000	0.000	0.000	0.064	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	4.267	95.733	0.000	0.000	0.000	0.000	0.000	0.061	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	8.806	91.194	0.000	0.000	0.000	0.000	0.000	0.062	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	4.936	95.061	0.003	0.000	0.000	0.000	0.000	0.065	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	8.806	91.192	0.003	0.000	0.000	0.000	0.000	0.066	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	4.400	95.597	0.003	0.000	0.000	0.000	0.000	0.066	pg18beta1_o2nofp.cx10d_c8r32

qp1000.L6

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.147	99.338	0.510	0.005	0.000	0.000	0.000	0.000	0.000	0.038	pg140_o2nofp.cx10a_c8r32
0.000	0.165	99.301	0.533	0.002	0.000	0.000	0.000	0.000	0.000	0.044	pg1418_o2nofp.cx10a_c8r32
0.000	0.151	98.887	0.959	0.003	0.000	0.000	0.000	0.000	0.000	0.042	pg150_o2nofp.cx10a_c8r32
0.000	0.148	98.841	1.008	0.003	0.000	0.000	0.000	0.000	0.000	0.038	pg1513_o2nofp.cx10a_c8r32
0.000	0.151	99.060	0.786	0.002	0.000	0.000	0.000	0.000	0.000	0.040	pg160_o2nofp.cx10a_c8r32
0.000	0.147	98.849	1.001	0.003	0.000	0.000	0.000	0.000	0.000	0.039	pg169_o2nofp.cx10a_c8r32
0.000	0.174	99.122	0.702	0.002	0.000	0.000	0.000	0.000	0.000	0.046	pg170_o2nofp.cx10a_c8r32
0.000	0.172	99.156	0.669	0.002	0.000	0.000	0.000	0.000	0.000	0.044	pg175_o2nofp.cx10a_c8r32
0.000	0.164	99.071	0.763	0.002	0.000	0.000	0.000	0.000	0.000	0.042	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.145	99.022	0.831	0.002	0.000	0.000	0.000	0.000	0.000	0.043	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.154	99.005	0.838	0.002	0.000	0.000	0.000	0.000	0.000	0.043	pg18beta1_o2nofp.cx10d_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	98.978	1.022	0.000	0.000	0.000	0.000	0.000	0.052	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	99.000	1.000	0.000	0.000	0.000	0.000	0.000	0.046	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.011	1.989	0.000	0.000	0.000	0.000	0.000	0.055	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	97.792	2.208	0.000	0.000	0.000	0.000	0.000	0.051	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.269	1.731	0.000	0.000	0.000	0.000	0.000	0.052	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	97.911	2.089	0.000	0.000	0.000	0.000	0.000	0.051	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.939	1.061	0.000	0.000	0.000	0.000	0.000	0.058	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.964	1.036	0.000	0.000	0.000	0.000	0.000	0.053	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	98.744	1.256	0.000	0.000	0.000	0.000	0.000	0.063	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	98.575	1.425	0.000	0.000	0.000	0.000	0.000	0.054	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	98.608	1.392	0.000	0.000	0.000	0.000	0.000	0.047	pg18beta1_o2nofp.cx10d_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.101	pg140_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.103	pg1418_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.104	pg150_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.101	pg1513_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.101	pg160_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.994	0.006	0.000	0.000	0.000	0.000	0.100	pg169_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.098	pg170_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.098	pg175_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.106	pg18beta1_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.107	pg18beta1_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	99.997	0.003	0.000	0.000	0.000	0.000	0.105	pg18beta1_o2nofp.cx10d_c8r32