Hunting Non Optimised Queries in ClickHouse
Yohann Jardin
Data Engineer and Team Lead at Contentsquare Picture this: Months after the migration your teams crafted new features, you ingest more data, and ClickHouse slows down. Should you scale your cluster, or are there inefficient queries ruining the fun of everyone else?
In this talk, we will see how to leverage system tables to hunt non-optimised queries, using manual and Machine Learning assisted strategies, and how we can use clickhouse-benchmark to confirm our hypotheses.
Recent videos
View all Videos
Meetups
ClickHouse Bangkok Meetup - NEOZO Cloud
Presented by, Maximilian (Max) Simmoteit, Solutions Architect - Data @ NEOZO Cloud, at our Bangkok Meetup.
Meetups
ClickHouse Bangkok Meetup - ClickHouse for Feature Engineering in FinTech
Presented by, Alua Magavyanova, Fraud Data Scientist & Risk Data Analyst @ Yusr Fintech, Dubai, at our Bangkok Meetup.
Meetups, User stories
Click-a-thon 2026 Unfiltered | Saloni Jain, SonyLIV
Saloni Jain, AVP, Data Engineering at Sony Pictures Network (SonyLIV), talks to ClickHouse at Click-a-thon India 2026 about how Sony runs live cricket on real-time analytics with ClickHouse, and what bigger tournaments demand.
Meetups, User stories
Click-a-thon 2026 Unfiltered | Adarsh Kumar, InMobi
Adarsh Kumar, SDE III at InMobi, talks to ClickHouse at Click-a-thon India 2026 about InMobi's central data platform, an in-house talk-to-your-data layer, and routing queries to the right engine.
Follow us
