/usr/bin/clickhouse-chdig

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)
  background-schedule-pool      Show background schedule pool tasks (system.background_schedule_pool)
  background-schedule-pool-log  Show background schedule pool logs (system.background_schedule_pool_log)
  table-parts                   Show table parts (system.parts)
  asynchronous-inserts          Show asynchronous inserts (system.asynchronous_inserts)
  part-log                      Show part log (system.part_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>
          Limit for logs [default: 100000]
      --skip-unavailable-shards
          Skip unavailable shards in distributed queries
  -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>
          Use short option -b, like atop(1) has Begin of the time interval to look at [default: 1hour]
  -e, --end <END>
          End of the time interval [default: ]
      --wrap
          Wrap long lines
      --no-strip-hostname-suffix
          Disable stripping common hostname prefix and suffix in queries and logs views
      --completion <COMPLETION>
          [possible values: bash, elvish, fish, powershell, zsh]
      --log <LOG>
          Log (for debugging chdig itself)
      --pastila-clickhouse-host <PASTILA_CLICKHOUSE_HOST>
          Pastila ClickHouse backend for uploading and sharing flamegraphs [default: https://uzg8q0g12h.eu-central-1.aws.clickhouse.cloud/?user=paste]
      --pastila-url <PASTILA_URL>
          pastila.nl URL (only to show direct link to pastila in logs) [default: https://pastila.nl/]
  -h, --help
          Print help
  -V, --version
          Print version