TSBS benchmark result 2022-09-20

[github-actions]

Write

time,per. metric/s,metric total,overall metric/s,per. row/s,row total,overall row/s
1663671801,239978.02,2.400000E+06,239978.02,23997.80,2.400000E+05,23997.80
1663671811,259965.13,5.000000E+06,249971.78,25996.51,5.000000E+05,24997.18
1663671821,240051.32,7.400000E+06,246665.68,24005.13,7.400000E+05,24666.57
1663671831,239977.62,9.800000E+06,244993.56,23997.76,9.800000E+05,24499.36
1663671841,239931.57,1.220000E+07,243980.95,23993.16,1.220000E+06,24398.09
1663671851,230083.00,1.450000E+07,241665.47,23008.30,1.450000E+06,24166.55
1663671861,249992.38,1.700000E+07,242855.06,24999.24,1.700000E+06,24285.51
1663671871,250001.56,1.950000E+07,243748.36,25000.16,1.950000E+06,24374.84
1663671881,239994.72,2.190000E+07,243331.28,23999.47,2.190000E+06,24333.13
1663671891,230008.14,2.420000E+07,241999.02,23000.81,2.420000E+06,24199.90
1663671901,229989.30,2.650000E+07,240907.18,22998.93,2.650000E+06,24090.72
1663671911,259872.95,2.910000E+07,242488.36,25987.30,2.910000E+06,24248.84
1663671921,240116.74,3.150000E+07,242306.02,24011.67,3.150000E+06,24230.60
1663671931,240006.58,3.390000E+07,242141.78,24000.66,3.390000E+06,24214.18
1663671941,239943.37,3.630000E+07,241995.19,23994.34,3.630000E+06,24199.52
1663671951,230055.45,3.860000E+07,241249.13,23005.55,3.860000E+06,24124.91
1663671961,249988.67,4.110000E+07,241763.24,24998.87,4.110000E+06,24176.32
1663671971,249800.17,4.360000E+07,242210.08,24980.02,4.360000E+06,24221.01
1663671981,240197.93,4.600000E+07,242104.26,24019.79,4.600000E+06,24210.43
1663671991,229928.59,4.830000E+07,241495.30,22992.86,4.830000E+06,24149.53
1663672001,230087.09,5.060000E+07,240952.26,23008.71,5.060000E+06,24095.23
1663672011,249965.97,5.310000E+07,241362.03,24996.60,5.310000E+06,24136.20
1663672021,250017.65,5.560000E+07,241738.33,25001.76,5.560000E+06,24173.83
1663672031,240016.20,5.800000E+07,241666.58,24001.62,5.800000E+06,24166.66
1663672041,219951.39,6.020000E+07,240797.79,21995.14,6.020000E+06,24079.78
1663672051,239943.33,6.260000E+07,240764.92,23994.33,6.260000E+06,24076.49
1663672061,250000.62,6.510000E+07,241106.97,25000.06,6.510000E+06,24110.70
1663672071,249796.28,6.760000E+07,241417.54,24979.63,6.760000E+06,24141.75
1663672081,240301.84,7.000000E+07,241379.12,24030.18,7.000000E+06,24137.91

Summary:
loaded 72000000 metrics in 298.328sec with 1 workers (mean rate 241345.15 metrics/sec)
loaded 7200000 rows in 298.328sec with 1 workers (mean rate 24134.52 rows/sec)

Query

Run complete after 1000 queries with 1 workers (Overall query rate 9.58 queries/sec):
CeresDB 5 cpu metric(s), random    8 hosts, random 1h0m0s by 1m:
min:    75.64ms, med:    93.06ms, mean:   104.38ms, max:  197.85ms, stddev:    25.89ms, sum: 104.4sec, count: 1000
all queries                                                    :
min:    75.64ms, med:    93.06ms, mean:   104.38ms, max:  197.85ms, stddev:    25.89ms, sum: 104.4sec, count: 1000
wall clock time: 104.420046sec