PostgreSQL Performance Engineering

Skill Resources

• Activation and cross-agent notes: references/activation.md
• Use ultrathink or the deepest available reasoning mode before changing architecture, security, migration, or performance-critical paths.
• Template: templates/explain-review.md

Index creation is the beginning of PostgreSQL performance work, not the end. Production performance problems are usually about the query planner making wrong decisions — and the planner's decisions are only as good as its statistics.

Reading EXPLAIN ANALYZE Correctly