Introduction
TraceHouse is a real-time monitoring and visualization tool for ClickHouse databases. It shows what's happening inside your ClickHouse cluster through resource attribution, visual exploration, and system table analysis.
Key Features
| Feature | Description |
|---|---|
| Overview | See live CPU, memory, disk I/O, and network usage attributed to queries, merges, mutations, and other work |
| Time Travel | Correlate historical resource usage with the queries, merges, mutations, and events active at any point in time |
| Analytics | Analyze ordering-key efficiency, run diagnostic SQL, build dashboards, and compare trends and correlations |
| Events | Investigate query failures, DDL, server, replication, Keeper, and storage events with their source evidence |
| Queries | Monitor live and historical queries, then inspect resource usage, scan efficiency, and distributed execution |
| Merges and Mutations | Track active and historical work with progress, ETA, throughput, classification, and dependencies |
| Database Explorer | Browse databases, tables, parts, columns, merge history, lineage, and storage efficiency |
| Cluster and Replication | Visualize cluster topology, node health, replica state, queue depth, and replication lag |
| Engine Internals | Inspect thread pools, memory allocation, CPU sampling, primary-key indexes, and dictionaries |
Next Steps
- Getting Started - choose how to install and run TraceHouse
- Explore Features - see what TraceHouse can show you