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.

gulmezeren2-byte Updated 1 repo stars
skilldoctor checking a 60-skill example home: the listing budget bar at 10,096 of 8,000 characters (126%), then findings — budget exceeded, a description past t

File contents

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.

gulmezeren2-byte/claude-skills-doctor commit 800bbddcfe

Frequently asked questions

npx get-skill add gulmezeren2-byte/postgres-tuning