Use the Index, Luke (Postgres)

Purpose

Fix slow Postgres queries with an indexing-first workflow that balances read performance, write overhead, and operational risk.

When to use

Use this skill when:

• Query latency or throughput regresses in Postgres.
• You need concrete index recommendations tied to an EXPLAIN (ANALYZE, BUFFERS) plan.
• You are tuning filters, joins, ORDER BY, GROUP BY, or pagination.

Do not use this skill for:

• Generic ORM cleanup without query-level evidence.
• Cache-first fixes when SQL execution is the bottleneck.