The Best Monitoring Tool For ClickHouse
Query Dog is a powerful tool for ClickHouse performance optimisation. Visualise query performance and background activity, identify bottlenecks and optimise cluster performance with a single container.
Query Log Visualisation
Stop searching through system tables. Query Dog provides an intuitive timeline view of all executed queries, helping you visually spot concurrency issues and locking contention instantly.
Resource Profiling
Drill down into memory and CPU usage per query. Correlate high resource consumption with specific users or query patterns to optimise cluster stability.
Background Operations
Understand merge and mutation activity and how this is impacting your system and performance. Monitor part movements and background task queues.
System Metrics
Track key system metrics including memory usage, disk I/O, network throughput, and thread pool utilisation to ensure optimal cluster health.
Errors and Logs
Identify errors and warnings in key log files. Surface critical issues from system logs to help you troubleshoot and resolve problems quickly.
Explain Plan Analysis
Visualise execution plans and pipelines. Identify inefficient full table scans, poor index usage, and excessive data transfer.