Skip to main content
Services in ClickHouse Cloud come with out-of-the-box monitoring components that serve users with dashboards and notifications. By default, all users in the Cloud Console can access these dashboards.

Dashboards

Service health

The Service Health dashboard can be used to monitor the high-level health of a service. ClickHouse Cloud scrapes and stores metrics displayed on this dashboard from system tables so they can be viewed when a service is idled.

Resource utilization

The Infrastructure dashboard provides a detailed view of resources being used by the ClickHouse process. ClickHouse Cloud scrapes and stores metrics displayed on this dashboard from system tables so they can be viewed when a service is idled.

Memory and CPU

The Allocated CPU and Allocated Memory graphs display the total compute resources available for each replica in your service. These allocations can be changed by using ClickHouse Cloud’s scaling features. The Memory Usage and CPU Usage graphs estimate how much CPU and memory is actually being utilized by ClickHouse processes in each replica, including queries as well as background processes like merges.
Performance degradationIf the memory or CPU utilization is approaching the allocated memory or CPU, you may begin to experience performance degradation. To resolve, we recommend:
  • Optimizing your queries
  • Changing the partitioning of your table engines
  • Adding more compute resources to your service using scaling
These are the corresponding system table metrics displayed on these graphs:

Data transfer

Graphs display data ingress and egress from ClickHouse Cloud. Learn more about network data transfer.

Advanced dashboard

This dashboard is a modified version of the built-in advanced observability dashboard, with each series representing metrics per replica. This dashboard can be useful for monitoring and troubleshooting ClickHouse-specific issues.
ClickHouse Cloud scrapes and stores metrics displayed on this dashboard from system tables so they can be viewed even when a service is idled. Accessing these metrics does not issue a query to the underlying service and will not wake idle services.
The table below maps each graph in the Advanced Dashboard to its corresponding ClickHouse metric, system table source, and aggregation type: For detailed information on each visualization and how to use them for troubleshooting, see the advanced dashboard documentation.

Query insights

The Query Insights feature makes ClickHouse’s built-in query log easier to use through various visualizations and tables. ClickHouse’s system.query_log table is a key source of information for query optimization, debugging, and monitoring overall cluster health and performance. After selecting a service, the Monitoring navigation item in the left sidebar expands to reveal a Query insights sub-item:

Top-level metrics

The stat boxes at the top represent basic query metrics over the selected time period. Beneath them, time-series charts show query volume, latency, and error rate broken down by query kind (select, insert, other). The latency chart can be adjusted to display p50, p90, and p99 latencies:

Recent queries

A table displays query log entries grouped by normalized query hash and user over the selected time window. Recent queries can be filtered and sorted by any available field, and the table can be configured to display or hide additional fields such as tables, p90, and p99 latencies:

Query drill-down

Selecting a query from the recent queries table will open a flyout containing metrics and information specific to the selected query: All metrics in the Query info tab are aggregated metrics, but we can also view metrics from individual runs by selecting the Query history tab: From this pane, the Settings and Profile Events items for each query run can be expanded to reveal additional information.
Last modified on June 19, 2026