Advanced dashboard in ClickHouse Cloud

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/cloud/features/08_monitoring/advanced_dashboard.md)

Monitoring your database system in a production environment is vital to
understanding your deployment health so that you can prevent or solve outages.

The advanced dashboard is a lightweight tool designed to give you deep insights
into your ClickHouse system and its environment, helping you stay ahead of
performance bottlenecks, system failures, and inefficiencies.

The advanced dashboard is available in both ClickHouse OSS (Open Source Software)
and Cloud. In this article we will show you how to use the advanced dashboard in
Cloud.

## Accessing the advanced dashboard[​](#accessing-the-advanced-dashboard "Direct link to Accessing the advanced dashboard")

The advanced dashboard can be accessed by navigating to:

- Left side panel
  - `Monitoring` → `Advanced dashboard`

## Accessing the native advanced dashboard[​](#accessing-the-native-advanced-dashboard "Direct link to Accessing the native advanced dashboard")

The native advanced dashboard can be accessed by navigating to:

- Left side panel
  - `Monitoring` → `Advanced dashboard`
  - Clicking `You can still access the native advanced dashboard.`

This will open the native advanced dashboard in a new tab. You will need to
authenticate to access the dashboard.

Each visualization has a SQL query associated with it that populates it. You can
edit this query by clicking on the pen icon.

## Out-of-box visualizations[​](#out-of-box-visualizations "Direct link to Out-of-box visualizations")

The default charts in the Advanced Dashboard are designed to provide real-time
visibility into your ClickHouse system. Below is a list with descriptions for
each chart. They're grouped into three categories to help you navigate them.

### ClickHouse specific[​](#clickhouse-specific "Direct link to ClickHouse specific")

These metrics are tailored to monitor the health and performance of your
ClickHouse instance.

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Metric Description|  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Queries Per Second Tracks the rate of queries being processed|  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Selected Rows/Sec Indicates the number of rows being read by queries|  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Inserted Rows/Sec Measures the data ingestion rate|  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | | Total MergeTree Parts Shows the number of active parts in MergeTree tables, helping identify unbatched inserts|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | Max Parts for Partition Highlights the maximum number of parts in any partition|  |  |  |  | | --- | --- | --- | --- | | Queries Running Displays the number of queries currently executing|  |  | | --- | --- | | Selected Bytes Per Second Indicates the volume of data being read by queries | | | | | | | | | | | | | | | |

### System health specific[​](#system-health-specific "Direct link to System health specific")

Monitoring the underlying system is just as important as watching ClickHouse itself.

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Metric Description|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | IO Wait Tracks I/O wait times|  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | CPU Wait Measures delays caused by CPU resource contention|  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Read From Disk Tracks the number of bytes read from disks or block devices|  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Read From Filesystem Tracks the number of bytes read from the filesystem, including page cache|  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | | Memory (tracked, bytes) Shows memory usage for processes tracked by ClickHouse|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | Load Average (15 minutes) Report the current load average 15 from the system|  |  |  |  | | --- | --- | --- | --- | | OS CPU Usage (Userspace) CPU Usage running userspace code|  |  | | --- | --- | | OS CPU Usage (Kernel) CPU Usage running kernel code | | | | | | | | | | | | | | | | | |

## ClickHouse Cloud specific[​](#clickhouse-cloud-specific "Direct link to ClickHouse Cloud specific")

ClickHouse Cloud stores data using object storage (S3 type). Monitoring this
interface can help detect issues.

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Metric Description|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | S3 Read wait Measures the latency of read requests to S3|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | S3 read errors per second Tracks the read errors rate|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Read From S3 (bytes/sec) Tracks the rate data is read from S3 storage|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Disk S3 write req/sec Monitors the frequency of write operations to S3 storage|  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Disk S3 read req/sec Monitors the frequency of read operations to S3 storage|  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Page cache hit rate The hit rate of the page cache|  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Filesystem cache hit rate Hit rate of the filesystem cache|  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | | Filesystem cache size The current size of the filesystem cache|  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | | Network send bytes/sec Tracks the current speed of incoming network traffic|  |  |  |  | | --- | --- | --- | --- | | Network receive bytes/sec Tracks the current speed of outbound network traffic|  |  | | --- | --- | | Concurrent network connections Tracks the number of current concurrent network connections | | | | | | | | | | | | | | | | | | | | | | | |

## Identifying issues using the advanced dashboard[​](#identifying-issues-with-the-advanced-dashboard "Direct link to Identifying issues using the advanced dashboard")

Having this real-time view of the health of your ClickHouse service greatly helps
mitigate issues before they impact your business or help solve them. Below are a
few issues you can spot using the advanced dashboard.

### Unbatched inserts[​](#unbatched-inserts "Direct link to Unbatched inserts")

As described in the [best practices documentation](/docs/best-practices/selecting-an-insert-strategy#batch-inserts-if-synchronous), it is recommended to always
bulk insert data into ClickHouse if able to do so synchronously.