Monitor performance in Aiven for ClickHouse®

Monitor your service, fetch query statistics, and use metrics with Datadog, Prometheus, or system tables.

Monitor with Grafana

Push Aiven for ClickHouse® metrics to Aiven for Metrics or Aiven for PostgreSQL®, and integrate with Aiven for Grafana® to monitor your metrics on Grafana dashboards.

Query statistics

Usually, query statistics in ClickHouse can be obtained using the system.query_log table, which stores statistics of each executed query, including memory usage and duration.

Grafana metrics

Browse through metrics that are available via Grafana® for Aiven for

Datadog metrics

Learn what metrics are available via Datadog for Aiven for ClickHouse®

Prometheus metrics

List of all metrics available via Prometheus for Aiven for ClickHouse® services.

System tables

Aiven for ClickHouse® supports multiple types of system tables, which store metadata and system-level information. Querying system tables allows you to check the configuration, performance, and state of your database.