TSBS benchmark 2022-09-20T20:41:59

[github-actions]

Write

time,per. metric/s,metric total,overall metric/s,per. row/s,row total,overall row/s
1663677294,229825.27,2.300000E+06,229825.27,22982.53,2.300000E+05,22982.53
1663677304,230165.55,4.600000E+06,229995.28,23016.55,4.600000E+05,22999.53
1663677314,229594.33,6.900000E+06,229861.48,22959.43,6.900000E+05,22986.15
1663677324,230394.87,9.200000E+06,229994.59,23039.49,9.200000E+05,22999.46
1663677334,230008.86,1.150000E+07,229997.45,23000.89,1.150000E+06,22999.74
1663677344,200010.51,1.350000E+07,224999.89,20001.05,1.350000E+06,22499.99
1663677354,229794.43,1.580000E+07,225685.35,22979.44,1.580000E+06,22568.53
1663677364,230024.27,1.810000E+07,226227.60,23002.43,1.810000E+06,22622.76
1663677374,240153.69,2.050000E+07,227773.93,24015.37,2.050000E+06,22777.39
1663677384,210027.80,2.260000E+07,225999.55,21002.78,2.260000E+06,22599.96
1663677394,199997.09,2.460000E+07,223635.67,19999.71,2.460000E+06,22363.57
1663677404,239915.23,2.700000E+07,224992.73,23991.52,2.700000E+06,22499.27
1663677414,230065.34,2.930000E+07,225382.82,23006.53,2.930000E+06,22538.28
1663677424,229645.55,3.160000E+07,225687.73,22964.55,3.160000E+06,22568.77
1663677434,220283.29,3.380000E+07,225327.91,22028.33,3.380000E+06,22532.79
1663677444,219467.08,3.600000E+07,224960.78,21946.71,3.600000E+06,22496.08
1663677454,210586.48,3.810000E+07,224117.59,21058.65,3.810000E+06,22411.76
1663677464,229996.92,4.040000E+07,224444.22,22999.69,4.040000E+06,22444.42
1663677474,229984.64,4.270000E+07,224735.84,22998.46,4.270000E+06,22473.58
1663677484,239938.84,4.510000E+07,225496.17,23993.88,4.510000E+06,22549.62
1663677494,219927.32,4.730000E+07,225230.91,21992.73,4.730000E+06,22523.09
1663677504,200056.17,4.930000E+07,224086.95,20005.62,4.930000E+06,22408.69
1663677514,220083.52,5.150000E+07,223912.95,22008.35,5.150000E+06,22391.29
1663677524,239979.17,5.390000E+07,224582.43,23997.92,5.390000E+06,22458.24
1663677534,230004.90,5.620000E+07,224799.32,23000.49,5.620000E+06,22479.93
1663677544,219993.07,5.840000E+07,224614.46,21999.31,5.840000E+06,22461.45
1663677554,209948.91,6.050000E+07,224071.17,20994.89,6.050000E+06,22407.12
1663677564,229837.46,6.280000E+07,224277.25,22983.75,6.280000E+06,22427.72
1663677574,230242.29,6.510000E+07,224482.72,23024.23,6.510000E+06,22448.27
1663677584,229899.10,6.740000E+07,224663.34,22989.91,6.740000E+06,22466.33
1663677594,220090.98,6.960000E+07,224515.91,22009.10,6.960000E+06,22451.59
1663677604,219990.50,7.180000E+07,224374.48,21999.05,7.180000E+06,22437.45

Summary:
loaded 72000000 metrics in 320.531sec with 1 workers (mean rate 224627.56 metrics/sec)
loaded 7200000 rows in 320.531sec with 1 workers (mean rate 22462.76 rows/sec)

Query

Run complete after 1000 queries with 1 workers (Overall query rate 8.80 queries/sec):
CeresDB 5 cpu metric(s), random    8 hosts, random 1h0m0s by 1m:
min:    81.40ms, med:   101.25ms, mean:   113.66ms, max:  248.69ms, stddev:    28.78ms, sum: 113.7sec, count: 1000
all queries                                                    :
min:    81.40ms, med:   101.25ms, mean:   113.66ms, max:  248.69ms, stddev:    28.78ms, sum: 113.7sec, count: 1000
wall clock time: 113.709326sec