# Postgres Tuning

> Index selection, EXPLAIN reading and lock diagnosis for PostgreSQL: which scan the planner chose and why, when an index is not used, and how to find the query holding the lock everyone else is waiting on.

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

---


# postgres-tuning

Index selection, EXPLAIN reading and lock diagnosis for PostgreSQL: which scan
the planner chose and why, when an index is not used, and how to find the
query holding the lock everyone else is waiting on.