otel-collector/receiver/clickhousesystemtablesreceiver/README.md

Clickhouse System Tables Receiver

Connects to clickhouse to collect monitoring data from clickhouse system tables

Only collects logs from query_log table right now. Support for other system tables like query_views_log, query_thread_log etc may be added later as needed.

Example Configuration

receivers:
  clickhousesystemtablesreceiver:
    # required
    dsn: tcp://clickhouse:9000/

    # optional. Should be set to name of the cluster when scraping query logs from a clustered Clickhouse deployment
    cluster_name: "cluster-name"

    query_log_scrape_config:
      scrape_interval_seconds: 20
      # required. min_scrape_delay_seconds must be set to a duration larger
      # than flush_interval_milliseconds settings for query_log
      # For details, see https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings#query-log
      min_scrape_delay_seconds: 8