Skip to main content
Kill -9 Club
Sign in

The index a query asked for, and the proof that it worked

Read a slow query's plan, take the index columns from it, build the index without blocking writes, and prove with the same plan that it works.

24 minutesTechnical content last reviewed on 16 Sept 2026

This lesson is for signed-in learners

Create an account to subscribe and record your learning progress.

What this lesson builds

  • Administering PostgreSQL: access, connections and growth
  • Saying what an output proves, and what it leaves open