v.25.9Improvement

You can use clickhouse-benchmark --precise flag

Official CH changelog text
You can use clickhouse-benchmark --precise flag for more precise reporting of QPS and other per-interval metrics. It helps to get consistent QPS in case if durations of queries are comparable to the reporting interval --delay D. #86684 (Sergei Trifonov).
Added the --precise flag to clickhouse-benchmark for more accurate and consistent QPS and per-interval metrics reporting.

Why it matters

This feature addresses the inconsistency of QPS measurements when query durations are close to the configured reporting interval (--delay D). Using the --precise flag helps to obtain more stable and reliable performance metrics during benchmarking.

How to use it

Run the benchmark tool with the --precise flag to enable precise reporting of QPS and other per-interval metrics. Example:

clickhouse-benchmark --precise --delay 1

Related resources

PreviousNext