PgFirstAid: PostgreSQL function for improving stability and performance
6 days ago
- #Open Source
- #PostgreSQL
- #Database Performance
- pgFirstAid is an open-source PostgreSQL function for database health checks.
- Provides prioritized actions to improve database stability and performance.
- Inspired by Brent Ozar's FirstResponderKit for SQL Server.
- Zero dependencies—single SQL function with no external tools required.
- Includes 12+ built-in health checks covering critical performance issues.
- Issues ranked by severity: CRITICAL, HIGH, MEDIUM, LOW, INFO.
- Each issue comes with actionable recommendations and documentation links.
- Easy to deploy—copy and paste the function into PostgreSQL and run it.
- Designed to be lightweight and safe for production systems.
- Works with PostgreSQL 10+ and compatible databases like Amazon RDS, Aurora.
- GPLv3 licensed, made for the PostgreSQL and Open Source community.