Postgres Daily Check

This skill is designed to perform comprehensive daily health checks on a PostgreSQL database. It leverages a suite of specialized SQL queries and analysis logic to provide insights into database availability, performance, activity, maintenance, storage, replication, and archiving status. The skill aims to identify potential issues such as blocking locks, long-running queries, transaction ID wraparound risks, bloat in tables and indexes, connection bottlenecks, and archiving failures.

digoal Updated

File contents

digoal/postgres_skill commit a4ef7d1622

Frequently asked questions

npx get-skill add digoal/postgres-daily-check