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
sudo apt-get install apt-transport-https ca-certificates dirmngr sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 8919F6BD2B48D754 echo "deb https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.list sudo apt-get update sudo apt-get install -y clickhouse-server clickhouse-client sudo service clickhouse-server start clickhouse-client # or "clickhouse-client --password" if you set up a password.

There’s a number of alternative options to get started, most notably the official Docker images of ClickHouse. To learn more about our future cloud offerings, contact us.