chmonitorInsights
Aggregate query history from system.query_log to surface the most-queried tables, columns, and query patterns over time.
Aggregate query history to see which tables and columns your workload hits most, and how activity trends over time.
Prop
Type
What it does
Insights aggregates system.query_log to surface patterns across your workload: which tables are queried most often, which columns appear most in filters and projections, and how query activity breaks down over time.
Use Insights to answer questions like:
- Which tables get the most read queries?
- Which columns are used most in WHERE clauses?
- Has query volume changed significantly in the past day?
The page combines a stats grid (summary counts and rates) with chart sections that visualize trends over configurable time ranges.
Pages
| Page | Route | What it shows | System tables |
|---|---|---|---|
| Insights | /insights | Top tables, top columns, query activity charts | system.query_log |
Using it
Open /insights for a stats grid of summary counts and rates alongside chart sections that visualize trends over configurable time ranges. Use it to find the most-read tables, the most-filtered columns, and shifts in query volume.
Permissions & access
CHM_FEATURE_INSIGHTS_ACCESS=authenticatedCHM_FEATURE_INSIGHTS_ENABLED=false[features.insights]
enabled = true
access = "authenticated"Configuration
No feature-specific configuration. Query history depth depends on your ClickHouse query_log retention (TTL on the table). The default ClickHouse retention is 30 days.
Notes & limitations
Requires query logging
All data comes from system.query_log. If query logging is disabled on the ClickHouse server, this page shows no data.
- Queries that failed before logging (e.g., parse errors) may not appear.
- Very high-throughput clusters can have large
query_logtables; queries on this page includeLIMITclauses to keep response times reasonable.