Optimizing ClickHouse query performance

on YouTube ↗42m

" summary

Practical techniques for improving ClickHouse query performance, including how a CI/CD infrastructure is used to test for regressions, detect slow queries, and prioritize which query hotspots to optimize first. The talk describes concrete testing and monitoring practices within the CI/CD pipeline rather than theoretical tuning.

AI-written summary · about

" chapters (10)

1. 0:00Introduction
2. 0:27ClickHouse architecture
3. 4:23Testing and performance
4. 10:18NLP optimization example
5. 11:42ClickHouse introspection
6. 15:12Abstractions and algorithms
7. 17:40Aggregation and specialization
8. 21:31Working with libraries
9. 22:57Optimization ninja tricks
10. 33:36Summary and Q&A

" related talks

• 57mQuery Performance Analysis in ClickHouseAleksey Milovidov · HighLoad++ Moscow 2018
• 59mEffective Use of ClickHouseAleksey Milovidov · HighLoad++ 2017
• 53mClickHouse Is Slowing DownKirill Shvakov · HighLoad++ Moscow 2018
• 49mSolving real business cases with ClickHouseDmitriy Cherobaev · Saint HighLoad++ 2025
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017
• 42mTips & Tricks to Keep Your Queries under 100ms with ClickHouse®Javi Santana · OSA Con 2022
• 51mTheory and practice of using ClickHouse in real applicationsAleksandr Zaytsev · Backend Conf 2018
• 53mClickHouse capabilities for advanced developersAleksey Milovidov · Backend Conf 2018