Visualize Query Metrics

Pulse provides real-time visualization for ClickHouse query activity, execution performance, and data transfer.

Use the charts to:

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.

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.

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.

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.

Last updated on

Was this page helpful?