~/talk

Under the Hood of an Analytical Database

TalkinFrenchat Sunny Tech 2026 · 2026-07-02..07-03· [databases]
slides:none on file

An explanation of how analytical query engines turn a high-level query into results, using Elasticsearch and its ES|QL language as a concrete example. Covers the processing pipeline: the parser and AST, logical planning, the optimizer and query planner (including filter pushdown), the physical plan, and columnar execution; concludes by showing how to read EXPLAIN output to optimize queries.

AI-written summary · about

  1. 0:00Elasticsearch analytics intro
  2. 1:40Open source business model
  3. 3:05ES|QL pipeline language
  4. 5:32ES|QL vs legacy syntax
  5. 8:50Performance gains with ES|QL
  6. 12:01Columnar data processing
  7. 16:47Distributed query engine
  8. 20:31Query planner phases
  9. 27:57Query plan validation
  10. 33:30Optimization rules
  11. 40:12Physical plan execution
  12. 43:01Summary
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.