Usage: clickhouse benchmark [options] < queries.txt Usage: clickhouse benchmark [options] --query "query text" clickhouse-benchmark connects to ClickHouse server, repeatedly sends specified queries and reports query statistics. Multiple queries can be used if passed in TSV format. 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 --queries-format arg (=tsv) format of queries read from standard input: 'tsv' (default, one tab-escaped query per line) or 'script' (parse the input as a script of multiple queries separated by semicolons) -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) --precise enable precise per-interval reporting with weighted metrics --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 --connection arg connection name (define under connections_credentials in client config) --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 --accept-invalid-certificate Ignore certificate verification errors, equal to config parameters openSSL.client.invalidCertificateHandle r.name=AcceptCertificateHandler and openSSL.client.verificationMode=none -u [ --user ] arg --password arg --quota_key arg --database arg --config arg Path to client config --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(=1)] (=0) control reconnection behaviour: 0 (never reconnect), 1 (reconnect for every query), or N (reconnect after every N queries); when given without a value, behaves as 1 --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 --proto_caps arg Enable/disable chunked protocol (comma-separated): chunked_optional, notchunked, notchunked_optional, send_chunked, send_chunked_optional, send_notchunked, send_notchunked_option al, recv_chunked, recv_chunked_optional , recv_notchunked, recv_notchunked_opti onal See also: https://clickhouse.com/docs/operations/utilities/clickhouse-benchmark/