pgFirstAid
Easy-to-deploy, open source PostgreSQL function that provides a prioritized list of actions to improve database stability and performance.
Inspired by Brent Ozar's FirstResponderKit for SQL Server, pgFirstAid is designed for everyone to use—not just DBAs! Get actionable health insights from your PostgreSQL database in seconds.
Features
Zero Dependencies - Single SQL function, no external tools required
- Single SQL function, no external tools required Comprehensive Checks - 12 (and growing!) built-in health checks covering critical performance and stability issues
- 12 (and growing!) built-in health checks covering critical performance and stability issues Prioritized Results - Issues ranked by severity (CRITICAL → HIGH → MEDIUM → LOW → INFO)
- Issues ranked by severity (CRITICAL → HIGH → MEDIUM → LOW → INFO) Actionable Recommendations - Each issue includes specific remediation steps
- Each issue includes specific remediation steps Documentation Links - Direct links to official PostgreSQL documentation for deeper learning
Quick Start
... continue reading