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.

agentskillexchange Updated 28 repo stars

File contents

agentskillexchange/skills/tree/main/skills/postgresql-performance-diagnostics commit e05cae23c7

Frequently asked questions

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