Guided Tour
TraceHouse is under active development. The initial focus has been on delivering features. The current phase is about stabilizing and polishing the existing functionality.
Why TraceHouse
ClickHouse exposes detailed internals through its system.* tables — query logs, merge activity, resource usage, part metadata. You can query these directly or build Grafana dashboards on top of them. TraceHouse adds a more interactive UI specialized for ClickHouse — letting you drill from a cluster overview down to a specific query's resource footprint, or from a table's storage layout to the merges that shaped it. It's also a place to experiment with new visualizations that aren't practical to build in a general-purpose dashboarding tool.
What It's Good At
- Understanding workload in real time: see which queries, merges, and background tasks are consuming CPU, memory, and I/O right now
- Investigating specific queries or merges: trace a slow query's resource footprint, or follow a merge from start to finish
- Exploring table structure and storage: inspect parts, columns, compression ratios, and how data is physically organized
- Historical analysis: look at past query patterns, merge throughput, and resource trends over time
What It's Not
TraceHouse is an observability and exploration tool, not a replacement for:
- Alerting: it won't page you at 3am (pair it with Grafana or your existing alerting stack for that)
- Cluster management: it reads system tables, it doesn't manage configuration, users, or schema
- General-purpose dashboards: it's purpose-built for ClickHouse internals, not arbitrary metrics
Features
Time Travel
Replay your cluster's state at any point in the past. Time Travel lets you scrub through historical snapshots of CPU, memory, merges, and queries, useful for post-incident investigation or understanding how workload patterns change over the course of a day.
Query Monitor
A live and historical view of every query running on your cluster. Filter by user, query kind, status, or resource usage. Click into any query to see its full resource profile, execution timeline, and the SQL it ran.
Merge Tracker
Watch merges as they happen and review past merge activity. See which tables are merging, how long merges take, how much I/O they produce, and whether the merge pipeline is keeping up with inserts.
Analytics
Aggregate query and merge data over time to spot trends. Which queries are getting slower? Which tables produce the most merge work? Analytics gives you the longer-term view that real-time monitoring can't.