# Postgres Performance

> Use when investigating PostgreSQL query latency, query plans, indexes, locking, N+1 queries, transaction performance, or database bottlenecks.

- Skill: `rhenter/postgres-performance` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rhenter/postgres-performance`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rhenter/postgres-performance/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rhenter (https://skillmd.com/u/rhenter)
- Updated: 2026-09-22
- Page: https://skillmd.com/skills/rhenter/postgres-performance

---


# Postgres Performance

- Measure before optimizing.
- Inspect query plans and index usage when relevant.
- Look for N+1 access and unnecessary round trips.
- Consider cardinality, selectivity, locking, transaction scope, and data volume.