Skip to content

Hunting Non Optimised Queries in ClickHouse

YouTube Video: F1jWWZojEmI

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.

Related videos

YouTube Video: XVu4pb_6mHw

Meetups

HPE EdgeConnect: From MySQL to ClickHouse Cloud

Vignesh Senapathy, Sr.Principal Devops Engineer, explain why HPE moved its telemetry from MySQL to ClickHouse Cloud

YouTube Video: 95TslI4AqwY

User stories, Meetups

How Equativ powers real-time advertising products with ClickHouse Cloud

Adrien Coulaud and Jean-Denis Costa explain how Equativ uses ClickHouse Cloud for customer-facing reporting, fast lookups, and operational feedback across its advertising products.

YouTube Video: mc3K4unjRKQ

Meetups

ClickHouse Bangkok Meetup - NEOZO Cloud

Presented by, Maximilian (Max) Simmoteit, Solutions Architect - Data @ NEOZO Cloud, at our Bangkok Meetup.

Follow us

XBlueskySlackGithubTelegramMeetupRSS