advanced · self-paced
Query Plan Deep Dive
6 weeks · 8 hrs/week
For engineers who already read plans occasionally but want predictable methodology. Each module pairs a lecture with a diff-based lab showing plan shifts.
What ships in this outline
- Plan diff workflow in CI (conceptual)
- Statistics health checks you can automate lightly
- Work_mem and spill to disk demos
- Parallelism toggles with safety notes
- Mentor-reviewed investigation memo
Outcomes
- Write a hypothesis-driven plan investigation under two pages
- Recommend a statistics fix vs an index change with evidence
- Identify a join order change worth escalating
Lead mentor
Lin Okada
SRE turned database mentor; previously owned incident reviews for query regressions.
FAQ
PostgreSQL 15+ examples; MySQL users get a conversion appendix.
Labs assume modest VMs; no GPU.
Auto-tuning commercial appliances are explicitly out of scope.
Experience notes
“Spill-to-disk lab reproduced a customer ticket. Our runbook now cites your checklist verbatim.”