ClickHouse system table info
This Grafana dashboard provides real-time insights into ClickHouse performance and resource utilization by querying system tables
This Grafana dashboard provides real-time insights into ClickHouse performance and resource utilization by querying system tables. Key metrics include:
Query Process List
Displays active queries from system.processes, showing: Query execution time Memory usage User/IP source Query status (running, pending) Disk Utilization
Tracks storage metrics from system.disks and system.parts:
Total/used disk space per path Data compression ratios Partition-level disk consumption Table Sizes
Summarizes table metrics from system.tables:
Disk space per table/engine (e.g., MergeTree, Replicated) Row counts and partition distribution Replication lag for distributed tables Column-Level Details
Analyzes field characteristics via system.columns:
Data type distribution Column size on disk Compression efficiency per field
Implementation Notes Data Source: Direct ClickHouse SQL queries to system tables.
Visualizations: Combines time-series graphs, gauges for thresholds, and sortable tables.
Use Cases:
Identify slow/hung queries via process list. Predict storage scaling needs from disk/utilization trends. Optimize schema based on column size statistics.
Data source config
Collector config:
Upload an updated version of an exported dashboard.json file from Grafana
| Revision | Description | Created | |
|---|---|---|---|
| Download |
ClickHouse
Monitor ClickHouse with Grafana. Easily keep tabs on your instance or cluster with Grafana Cloud's out-of-the-box monitoring solution.
Learn more