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) query-patterns Show queries grouped by normalized_query_hash with duration distribution (from system.query_log) merges Show merges for MergeTree engine (system.merges) s3-queue Show S3 Queue (system.s3queue_metadata_cache) azure-queue Show Azure Queue (system.azure_queue_metadata_cache) 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) error-log Show errors over time (system.error_log) 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) asynchronous-insert-log Show asynchronous insert log (system.asynchronous_insert_log) part-log Show part log (system.part_log) metric-log Show metrics with average per-second rates (system.metric_log) asynchronous-metric-log Show asynchronous metrics with average values (system.asynchronous_metric_log) cpu-flamegraph Show server CPU flamegraph (system.trace_log) real-flamegraph Show server real (wall-clock) flamegraph (system.trace_log) memory-flamegraph Show server memory flamegraph (system.trace_log) memory-sample-flamegraph Show server memory sample flamegraph (system.trace_log) jemalloc-sample-flamegraph Show server jemalloc sample flamegraph (system.trace_log) memory-allocated-without-check-flamegraph Show server MemoryAllocatedWithoutCheck flamegraph (system.trace_log) events-flamegraph Show server profile events flamegraph (system.trace_log) live-flamegraph Show server live flamegraph (system.stack_trace) jemalloc-flamegraph Show server jemalloc heap flamegraph client Spawn client inside chdig export Export data in various formats help Print this message or the help of the given subcommand(s) Options: -u, --url [env: CHDIG_URL=] --host Overrides host in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_HOST=] --port Overrides port in --url (for clickhouse-client compatibility) --user Overrides user in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_USER=] --password Overrides password in --url (for clickhouse-client compatibility) [env: CLICKHOUSE_PASSWORD=] --secure Overrides secure=1 in --url (for clickhouse-client compatibility) -k, --accept-invalid-certificate Do not verify the server TLS certificate (overrides skip_verify=1 in --url, for clickhouse-client compatibility) [aliases: --skip-verify, --insecure] --config ClickHouse like config (with some advanced features) [env: CLICKHOUSE_CONFIG=] -C, --connection -c, --cluster [] --database Database with the system tables, e.g. a preserved copy; overrides database in --url (for clickhouse-client compatibility; default: system) [env: CLICKHOUSE_DATABASE=] --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 for logs [default: 1000000] --logs-order Sort order for logs (desc returns the newest --limit rows, useful for long backups) [default: asc] [possible values: asc, desc] --skip-unavailable-shards Skip unavailable shards in distributed queries -d, --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 Use short option -b, like atop(1) has Begin of the time interval to look at [default: 1hour] -e, --end End of the time interval [default: ""] --wrap Wrap long lines --align-log-columns Pad log columns (host, thread_id, query_id, level, logger_name) to a common width (makes seeking by columns exact) --logs-in-dialog Open logs (query logs, table logs, ...) in a dialog instead of a split pane --no-strip-hostname-suffix Disable stripping common hostname prefix and suffix in queries and logs views --no-color Disable relative log-scale row coloring (e.g. query duration coloring in the query patterns view) --queries-limit Limit for number of queries to render in queries views [default: 10000] --query-id Specified query_id for commands that support it -o, --output Output path for CLI export (derived automatically when omitted) --completion [possible values: bash, elvish, fish, powershell, zsh] --log Log (for debugging chdig itself) --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.nl URL (only to show direct link to pastila in logs) [default: https://pastila.nl/] --pastila-compression Compress (gzip) content before encrypting when sharing to pastila (adds .gz to the URL) --no-pastila-compression --chdig-config Path to chdig config file (YAML) [env: CHDIG_CONFIG=] -h, --help Print help -V, --version Print version