Postgres Query Optimizer

Invoke this skill when you have a slow PostgreSQL query and need to understand why it is slow and how to fix it.

Basic invocation: > Optimize this query: SELECT * FROM orders WHERE created_at > '2026-01-01' AND status = 'pending' > Analyze this EXPLAIN ANALYZE output: [paste output] > Why is this query slow? [paste query and/or plan]

With context: > Here's my table schema and the slow query, suggest indexes > I have this query plan, explain what each node means and where the bottleneck is > This query takes 12 seconds, target is under 200ms — help me get there

The agent analyzes the query, the execution plan (if provided), and the table schema to produce actionable optimization recommendations.