PostgreSQL Slow Query Diagnosis

Summary

Provides a systematic workflow for diagnosing and optimising slow PostgreSQL queries by analysing execution plans, index opportunities, and table statistics. It utilises pgtuner-mcp tools to identify resource-intensive queries and recommend actionable performance improvements.