Visualize Query Metrics
Pulse provides real-time visualization for ClickHouse query activity, execution performance, and data transfer.
Use the charts to:
- Analyze query load and execution latency.
- Identify read/write trends and failure patterns.
- Detect I/O bottlenecks and optimize query throughput.
Steps
In the Pulse UI, go to ClickHouse > Dashboard.
On the ClickHouse Dashboard page, in the Overview tab, you can view the Summary Panel with database statistics.
Set a time range and data refresh interval (for example, 10 s, 20 m, 2 h, 4 d, or 1 w) to ensure charts display timely and meaningful data.
Pulse then displays database statistics in the summary panel and query performance charts.
Summary Panel
The Summary Panel – Database Stats displays key ClickHouse metrics that summarize data stored and managed in the cluster.
These metrics provide a quick overview of data volume, storage distribution, and cluster activity.
| Metric | Description |
|---|---|
| Total Databases | Shows the total number of databases currently managed by ClickHouse. |
| Total Storage (Number of Tables) | Displays the total number of user tables across all databases. |
| Total Number of Tables (System) | Indicates the number of system tables used internally by ClickHouse for metadata and cluster operations. |
| Total Parts | Represents the number of table parts (data segments). A high number may indicate frequent inserts or partitioning activity. |
| Total Rows | Displays the total number of rows across all databases. |
Query Performance Charts
The Query Performance Charts visualize query behavior and efficiency, helping you analyze query load, latency, and error rates.
| Chart | Description |
|---|---|
| Total Bytes Written | Displays the amount of data written to disk or replicated across ClickHouse nodes. |
| Total Bytes Read | Shows the total data read by queries, helping track I/O load and read intensity. |
| Query Rate | Represents the overall rate of queries executed per second, including both reads and writes. |
| Query Time (Microseconds) | Measures the average time taken to execute all queries. |
| Select Query Rate | Tracks the number of SELECT queries executed per second, reflecting the read workload. |
| Select Query Time (Microseconds) | Shows the average time taken to execute SELECT queries, helping assess query performance. |
| Insert Query Rate | Displays the number of INSERT queries executed per second, indicating data-ingestion trends. |
| Insert Query Time (Microseconds) | Measures the time taken to complete INSERT operations, highlighting ingestion efficiency. |
| Failed Queries Rate | Shows the rate of failed queries, helping detect performance issues or system errors early. |
Key Features
Each chart includes the following options and actions:
- Show Anomaly Detection: Displays deviations from the normal pattern based on historical data.
- Tip: Refer to the chart description for more details.
- Refresh: Updates the chart to display the latest available data.
- Maximize: Expands the chart for a full-page view.
- Download: Exports the chart data in .xlsx or .csv format.