/usr/bin/chdig

Dig into ClickHouse with TUI interface

Usage: 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