Postgresql Optimization

This is a structured workflow for optimizing PostgreSQL databases, walking you through performance assessment, query analysis with EXPLAIN ANALYZE, indexing strategy, and configuration tuning. It's organized into seven phases that chain together related skills like database-optimizer, sql-optimization-patterns, and postgres-best-practices. The workflow covers the usual suspects: shared_buffers, work_mem, autovacuum settings, and monitoring setup with Grafana. It's most useful if you're dealing with slow queries or need a systematic approach to database tuning rather than random tweaking. The prompts are pretty basic, so you'll need to know what you're looking for, but it keeps you from forgetting steps like scheduling VACUUM or checking table bloat.