postgres-checkup | Postgres Health Check and SQL Performance Analysis

postgres-checkup β is a Shell library. postgres-checkup β has no bugs, it has no vulnerabilities and it has low support. However postgres-checkup β has a Non-SPDX License. You can download it from GitLab.

Postgres Checkup (postgres-checkup) is a new-generation diagnostics tool that allows users to collect deep analysis of the health of a Postgres database. It aims to detect and describe all current and potential issues in the fields of database performance, scalability, and security, providing advices how to resolve or prevent them. Compared to a monitoring system, postgres-checkup goes deeper into the analysis of the database system and environment. It combines numerous internal characteristics of the database with data about resources and OS, producing multiple comprehensive reports. These reports use formats which are easily readable both by humans and machines and which are extremely oriented to DBA problem-solving. Monitoring systems constantly collect telemetry, help to react to issues more quickly, and are useful for post-mortem analyses. At the same time, checkups are needed for a different purpose: detect issues at a very early stage, advising on how to prevent them. This procedure is to be done on a regular basis — weekly, monthly, or quarterly. Additionally, it is recommended to run it immediately before and after any major change in the database server.