PostgreSQL Diagnostic Runbook

Diagnoses PostgreSQL performance issues using pg_stat_statements, pg_stat_activity, and the pgbadger log analyzer. Identifies slow queries, lock contention, and bloat via pgstattuple extension.

Installation

Method 1, Agent Skill Exchange

• Install from the marketplace listing: https://agentskillexchange.com/skills/postgresql-diagnostic-runbook/

Method 2, Git clone

git clone https://github.com/agentskillexchange/skills.git && cd skills/skills/postgresql-diagnostic-runbook

Method 3, Download ZIP

• Download the repository ZIP and extract skills/postgresql-diagnostic-runbook.

Method 4, Manual copy

• Copy this skill folder into your local skills directory, then reload your agent tooling.

Method 5, Fork and sync

• Fork the repository if you want to maintain local edits while syncing upstream changes.

Source

• Agent Skill Exchange