In this 3-hour, recorded workshop, you will learn how to optimize queries in ClickHouse. We will dive deep into techniques to improve query performance, such as effective use of primary keys, skipping indexes, materialized views, and projections. We'll also explore strategies to avoid common pitfalls, like inefficient joins and improper data types while utilizing ClickHouse’s query logs and CPU/memory profiling to identify bottlenecks. By the end of the session, you’ll be equipped with the tools and knowledge to measure and optimize your queries.