OS Manuals

/opt/iamguarded/clickhouse/bin/clickhouse-chdig

From clickhouse-25.11-iamguarded-compat 25.11.9.34-r9 (enterprise-packages), captured 2026-11-08 by running clickhouse-chdig --help (exit 0). permalink

Also provided by 9 other package versions
Dig into ClickHouse with TUI interface

Usage: clickhouse-chdig [OPTIONS] [COMMAND]

Commands:
  queries             Show now running queries (from system.processes)
  last-queries        Show last running queries (from system.query_log)
  slow-queries        Show slow (slower then 1 second, ordered by duration) queries (from system.query_log)
  merges              Show merges for MergeTree engine (system.merges)
  s3-queue            Show S3 Queue (system.s3queue)
  mutations           Show mutations for MergeTree engine (system.mutations)
  replication-queue   Show replication queue for ReplicatedMergeTree engine (system.replication_queue)
  replicated-fetches  Show fetches for ReplicatedMergeTree engine (system.replicated_fetches)
  replicas            Show information about replicas (system.replicas)
  tables              Tables
  errors              Show all errors that happened in a server since start (system.errors)
  backups             Show information about backups (system.backups)
  dictionaries        Show information about dictionaries (system.dictionaries)
  server-logs         Show server logs (system.text_log)
  loggers             Show loggers (system.text_log)
  client              Spawn client inside chdig
  help                Print this message or the help of the given subcommand(s)

Options:
  -u, --url <URL>
          [env: CHDIG_URL=]
      --host <HOST>
          Overrides host in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_HOST=]
      --port <PORT>
          Overrides port in --url (for clickhouse-client compatibility)
      --user <USER>
          Overrides user in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_USER=]
      --password <PASSWORD>
          Overrides password in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_PASSWORD=]
      --secure
          Overrides secure=1 in --url (for clickhouse-client compatibility)
      --config <CONFIG>
          ClickHouse like config (with some advanced features) [env: CLICKHOUSE_CONFIG=]
  -C, --connection <CONNECTION>

  -c, --cluster <CLUSTER>

      --history
          Aggregate system.*_log historical data, using merge()
      --no-history

      --internal-queries
          Do not hide internal (spawned by chdig) queries
      --no-internal-queries

      --limit <LIMIT>
          [default: 100000]
  -d, --delay-interval <DELAY_INTERVAL>
          [default: 30000]
  -g, --group-by
          Grouping distributed queries (turned on by default in --cluster mode)
  -G, --no-group-by

      --no-subqueries
          Do not accumulate metrics for subqueries in the initial query
  -b, --start <START>
          Begin of the time interval to look at [default: 1hour]
  -e, --end <END>
          End of the time interval [default: ]
      --wrap
          Wrap long lines (more CPU greedy)
      --completion <COMPLETION>
          [possible values: bash, elvish, fish, powershell, zsh]
      --log <LOG>
          Log (for debugging chdig itself)
  -h, --help
          Print help
  -V, --version
          Print version
Options (25)
OptionDescriptionSource
-u, --url URL[env: CHDIG_URL=]help
--host HOSTOverrides host in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_HOST=]help
--port PORTOverrides port in --url (for clickhouse-client compatibility)help
--user USEROverrides user in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_USER=]help
--password PASSWORDOverrides password in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_PASSWORD=]help
--secureOverrides secure=1 in --url (for clickhouse-client compatibility)help
--config CONFIGClickHouse like config (with some advanced features) [env: CLICKHOUSE_CONFIG=]help
-C, --connection CONNECTIONhelp
-c, --cluster CLUSTERhelp
--historyAggregate system.*_log historical data, using merge()help
--no-historyhelp
--internal-queriesDo not hide internal (spawned by chdig) querieshelp
--no-internal-querieshelp
--limit LIMIT[default: 100000]help
-d, --delay-interval DELAY_INTERVAL[default: 30000]help
-g, --group-byGrouping distributed queries (turned on by default in --cluster mode)help
-G, --no-group-byhelp
--no-subqueriesDo not accumulate metrics for subqueries in the initial queryhelp
-b, --start STARTBegin of the time interval to look at [default: 1hour]help
-e, --end ENDEnd of the time interval [default: ]help
--wrapWrap long lines (more CPU greedy)help
--completion COMPLETION[possible values: bash, elvish, fish, powershell, zsh]help
--log LOGLog (for debugging chdig itself)help
-h, --helpPrint helphelp
-V, --versionPrint versionhelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.