Query Performance Analysis in ClickHouse

on YouTube ↗57m

" summary

Covers diagnosing slow ClickHouse queries by showing where to look in execution plans and resource usage. Describes techniques and tools to analyze whether a query uses CPU, memory, or I/O efficiently and how to find optimizations to speed it up.

AI-written summary · about

" chapters (16)

1. 0:00Introduction
2. 2:16System resources usage
3. 5:41CPU analysis and optimization
4. 10:39CPU bottlenecks and frequency
5. 14:21Performance analysis with perf
6. 14:42Disk usage and optimization
7. 23:12Memory myths and reality
8. 25:18Network common issues
9. 26:44Diagnostic tools
10. 31:42ClickHouse query monitoring
11. 33:30Past issue analysis
12. 34:13Query tracing
13. 37:01Query execution metrics
14. 40:23Query optimization example
15. 44:54Flow analysis with tprof
16. 47:49Q&A

" related talks

• 42mOptimizing ClickHouse query performanceMaksim Kita · Saint HighLoad++ 2022
• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 37mFinding Bottlenecks in ClickHouse: Profiling, Heatmaps & FlamegraphsEugene Klimov · PG Armenia x Percona University – Yerevan, August 28, 2025
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 49mSolving real business cases with ClickHouseDmitriy Cherobaev · Saint HighLoad++ 2025
• 42mTips & Tricks to Keep Your Queries under 100ms with ClickHouse®Javi Santana · OSA Con 2022
• 50mQuery Analysis in MySQL, PostgreSQL, MongoDBPetr Zaytsev · HighLoad++ 2019
• 51mTheory and practice of using ClickHouse in real applicationsAleksandr Zaytsev · Backend Conf 2018