pghealth is a health check tool that allows you to instantly view the health status of your PostgreSQL database.
The overall health is represented as a percentage, based on a collection of scored metrics.
Each metric includes a clear explanation and its individual score, along with actionable recommendations on how to improve it.
Getting started with pghealth is pretty simple β just install the required extensions and connect your database. If you're ready, let's get started!
β Agent-free architecture β No local monitoring agent installation required.
π Requires specific PostgreSQL extensions (see the Installing Extensions section).
π§ The database host must run on a Linux-based operating system.
π Supported versions: PostgreSQL 13, 14, 15, 16, 17, 18
𧩠Currently supports self-managed PostgreSQL instances only. Managed database services (e.g., AWS RDS, Google Cloud SQL, Azure Database for PostgreSQL) are not yet supported.
Learn how to install extentions on your PostgreSQL instance
Learn how to enable pg_stat_statements and add it to shared_preload_libraries.
Learn how to enable logging_collector and configure PostgreSQL logging settings.
Learn how to enable and configure Query Advisor AI for PostgreSQL to get automated insights on slow or inefficient queries.
Getting started with pghealth
