PostgreSQL Performance Runbook

Executes diagnostic queries against PostgreSQL using pg_stat_statements, pg_stat_activity, and pg_locks system views. Identifies slow queries, lock contention, bloated tables via pgstattuple, and generates EXPLAIN ANALYZE reports with buffer statistics.

agentskillexchange Updated 28 repo stars

File contents

agentskillexchange/skills/tree/main/skills/postgresql-performance-runbook commit 8a0265bc4e

Frequently asked questions

npx skillmds@latest add agentskillexchange/postgresql-performance-runbook