Available now

Why is this query slow?

Two queries can return the same answer, one in a second and the other in an hour. The difference is the plan: the steps the database decides to take.

The database in your browser can show its plan and time your queries, so you see the difference instead of reading about it.

Why data engineers need it

  • Cloud warehouses charge for every second and every byte scanned.
  • Knowing why a query is slow beats guessing at fixes.
  • Row versus column storage changes what "fast" means.

What you will learn

  • What a query plan is, in plain words
  • Reading EXPLAIN output from the bottom up
  • Why column storage and filter pushdown make analytics fast
  • EXPLAIN ANALYZE: real rows and time for every step
  • Finding the join that multiplies rows, and measuring the fix

The lessons

  1. 1Why is this query slow?ProWhat a query plan is, how to read one from the bottom up, and how to find the step that is costing you.

Nothing to install. Nothing to break.

Every lesson runs in your browser, on your laptop or your phone.

Try it now