Visualizing DataFusion physical plans
A staycation project that turns DataFusion EXPLAIN output into an Excalidraw diagram — paste a plan, click Visualize, and see sort order, pushdown, and parallel streams in color.
#Query Planning
5 posts.
(Almost) linear scaling of a star-schema query with Distributed DataFusion
How a two-table product/sales query — sales every 30 minutes for grocery products — stays streaming on one node and scales near-linearly across workers.
Optimizing queries in InfluxDB 3 using progressive evaluation
Which SQL qualifies for ProgressiveEvalExec, how to see it in EXPLAIN, and how mixed overlapping files are still evaluated newest-first.
Making most-recent-value queries hundreds of times faster
How databases optimize queries — and how a ProgressiveEval operator made most-recent-value queries in InfluxDB 3 hundreds of times faster.
How to read InfluxDB 3 query plans
How to read a query plan in InfluxDB 3.0 — logical versus physical plans, EXPLAIN, and a leading-edge example.