postgres-performance-tuning

Guides diagnosis and repair of PostgreSQL performance problems by reading EXPLAIN ANALYZE plans, choosing and creating the right indexes, rewriting N+1 and spill-prone queries, partitioning oversized tables, sizing memory and pool settings, and ranking slow or bloated queries with pg_stat_statements. Use when a query is slow, a plan shows sequential scans, disk spills, or stale row estimates, when tables bloat or connections run out, or when preparing a production configuration. Not for designing schemas from scratch, running migrations, non-PostgreSQL databases, or disaster recovery.

Version

v1.0.0

Size

15 KB

Updated

2026-10-06

Your client verifies the signature before reading. This explicit manual read is available on every plan. Free automatically loads five chosen skills; paid plans automatically load relevant skills across the library.