Usage: /usr/bin/clickhouse-benchmark [options] < queries.txt Allowed options: --help Print usage summary and exit; combine with --verbose to display all options --verbose Increase output verbosity -q [ --query ] arg query to execute -c [ --concurrency ] arg (=1) number of parallel queries -C [ --max_concurrency ] arg (=0) gradually increase number of parallel queries up to specified value, making one report for every concurrency level -d [ --delay ] arg (=1) delay between intermediate reports in seconds (set 0 to disable reports) --stage arg (=complete) request query processing up to specified stage: complete,fetch_columns ,with_mergeable_state,with_mergeable_st ate_after_aggregation,with_mergeable_st ate_after_aggregation_and_limit -i [ --iterations ] arg (=0) amount of queries to be executed -t [ --timelimit ] arg (=0) stop launch of queries after specified time limit -r [ --randomize ] randomize order of execution -h [ --host ] arg list of hosts --port arg list of ports --roundrobin Instead of comparing queries for different --host/--port just pick one random --host/--port for every query and send query to it. --cumulative prints cumulative data instead of data per interval -s [ --secure ] Use TLS connection -u [ --user ] arg (=default) --password arg --quota_key arg --database arg (=default) --stacktrace print stack traces of exceptions --confidence arg (=5) set the level of confidence for T-test [0=80%, 1=90%, 2=95%, 3=98%, 4=99%, 5=99.5%(default) --query_id arg --query_id_prefix arg --max-consecutive-errors arg (=0) set number of allowed consecutive errors --ignore-error continue testing even if a query fails --reconnect arg (=0) control reconnection behaviour: 0 (never reconnect), 1 (reconnect for every query), or N (reconnect after every N queries) --client-side-time display the time including network communication instead of server-side time; note that for server versions before 22.8 we always display client-side time See also: https://clickhouse.com/docs/operations/utilities/clickhouse-benchmark/