Hosted by

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.
© 2016-2023 ClickHouse, Inc.