chmonitorchmonitor

Guide

Insights

Aggregate query history from system.query_log to surface the most-queried tables, columns, and query patterns over time.

1 min read

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:

The page combines a stats grid (summary counts and rates) with chart sections that visualize trends over configurable time ranges.

Pages

PageRouteWhat it showsSystem tables
Insights/insightsTop tables, top columns, query activity chartssystem.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=authenticated
CHM_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_log tables; queries on this page include LIMIT clauses to keep response times reasonable.

On this page