Under the Hood of an Analytical Database
summary
An overview of how analytic query engines turn high-level queries into results, using Elasticsearch and its ES|QL language as the running example. Covers the components of query processing: parser and AST, logical plan, optimizer, query planner (including filter pushdown), physical plan, and columnar execution, concluding with how to read and use EXPLAIN to optimize queries.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 6:47Elasticsearch ESQL creation
- 9:55Analytical query language
- 13:24Nine planner phases
- 25:24Logical to physical plan
- 32:10Distributed optimization
- 34:19Q&A
related talks
18mApparently, you can "debug" your SQL queries
52mUnderstanding PostgreSQL Query Plans (aka EXPLAIN)
57mBuilding a Scalable Analytical Solution Using IaaS and Elasticsearch
47mMake sense of your (big) data using Elasticsearch
20mLevel up your SQL skills as a developer
41mBetter Data Exploration and Visualisation with Elasticsearch and Kibana
03mIntervista a David Pilato
43mThe denormalized query engine design pattern