[PREMIUM] PostgreSQL Performance Troubleshooting Checklist

Your database is slow. Your users are angry. Here's exactly what to check and in what order.

---

Table of Contents

1. Phase 1 — Gather Context (2 min)

2. Phase 2 — Check for Active Problems (5 min)

3. Phase 3 — Analyze the Slow Query (10 min)

4. Phase 4 — Check Index Health (10 min)

5. Phase 5 — Check Table Health & Vacuum Status (10 min)

6. Phase 6 — Check Server Resources (5 min)

   • Memory

   • I/O & Checkpoints

   • Connections

7. Phase 7 — Check Top Resource-Consuming Queries (5 min)

8. Phase 8 — Check Application-Level Patterns (5 min)

9. Phase 9 — Document & Fix

10. Skip the Manual Work? → PostgreSQL Health Check

---