Execution Plan Analysis · Clinic

Cardinality & Estimates Clinic

Debug bad row estimates that poison join orders—statistics health, histogram gaps, and correlation blind spots.

Duration
10 days · micro cohort
Skill focus
Advanced
Platform lens
PostgreSQL
Tuition (informational)
₩610,000

Overview

Short clinic focused on the statistical layer beneath plans. You learn to read histogram endpoints, detect stale stats smells, and communicate when a data model change—not an index—is the real fix.

What is included

  • Live histogram walkthroughs
  • Correlation case studies
  • Checklist for stats refresh vs code change

Outcomes

  • Recommend stats refresh vs model change with evidence
  • Read histogram charts without chasing noise

Primary coach

Marcus Bell

Maintains long-form guides on wait events, latch contention, and plan shape regressions.

FAQ

Prerequisites?

Completion of Execution Plan Reading Intensive or equivalent experience is strongly recommended.

Multi-column stats?

Covered briefly; deep multi-column statistics tuning is deferred to private engagements.

Limitation?

No coverage of proprietary cloud auto-tuning knobs beyond publicly documented behavior.

Experience notes

  • Helped our data science liaison understand why “just add an index” failed twice.

    Client in enterprise IT

  • ★★★★☆ — dense material; office hours saved me when my histogram looked nothing like the sample.

    Aya · DBA · 4/5

Tuition is informational on this static preview. Enrollment teams confirm availability, tax treatment, and any employer procurement paperwork steps. See Returns & Refunds for eligibility framing.