PostgreSQL Performance Diagnostics
Analyzes PostgreSQL query performance using pg_stat_statements, pg_stat_user_tables, and EXPLAIN ANALYZE output. Identifies missing indexes via pg_stat_user_indexes and detects lock contention through pg_locks and pg_stat_activity.
PostgreSQL Performance Diagnostics
Analyzes PostgreSQL query performance using pg_stat_statements, pg_stat_user_tables, and EXPLAIN ANALYZE output. Identifies missing indexes via pg_stat_user_indexes and detects lock contention through pg_locks and pg_stat_activity.
Installation
Method 1, Agent Skill Exchange
- Install from the marketplace listing: https://agentskillexchange.com/skills/postgresql-performance-diagnostics/
Method 2, Git clone
git clone https://github.com/agentskillexchange/skills.git && cd skills/skills/postgresql-performance-diagnostics
Method 3, Download ZIP
- Download the repository ZIP and extract
skills/postgresql-performance-diagnostics.
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.