Hosted by

tom_schreiber.jpg
Tom Schreiber
Consulting Architect

Agenda

0:39
Overview of query execution steps in ClickHouse
1:23
Introspecting query execution steps via EXPLAIN
2:44
The parsed query
3:12
The rewritten query
3:30
The query plan
3:42
The query pipeline
6:26
Tuning a query pipeline in ClickHouse
8:40
A 4-thread pipeline in action
12:07
A 23-thread pipeline in action
13:19
A 50-thread pipeline in action
13:51
Introspecting query execution steps via trace logs
15:33
Introspecting query ressource consumption via query logs
17:14
Summary

Next steps

Get started for free

However you choose to use ClickHouse, it's easy to get started.

Watch 25-minutes Getting Started Video

$ curl https://clickhouse.com/ | sh

There’s a number of alternative options to get started, most notably the official Docker images of ClickHouse. Or, you can start a free 30 day trial of ClickHouse Cloud today.

ClickHouse
ClickHouse source code is published under the Apache 2.0 License. Software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.