Analyse and Tune Your ClickHouse Queries
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.
$ # Clone the repository git clone https://github.com/benjaminwootton/querydog.git cd querydog # Configure your ClickHouse connection cp querydog.yaml.example querydog.yaml # Edit querydog.yaml with your ClickHouse details # Add your test queries in the ./queries folder # Build and run docker compose up --build
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.
Explain Plan Analysis
Visualise execution plans and pipelines. Identify inefficient full table scans, poor index usage, and excessive data transfer.
Resource Profiling
Drill down into memory and CPU usage per query. Correlate high resource consumption with specific users or query patterns to optimize 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 utilization 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.