/usr/bin/clickhouse-benchmark

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/