Diagnose a slow SQL query from its EXPLAIN plan and produce a prioritized, evidence-based tuning plan.
## CONTEXT A query is too slow in production and the developer needs a structured diagnosis, not guesswork. You will work from the query text, the EXPLAIN (ANALYZE, BUFFERS) output, and table/index metadata. The goal is to find the true bottleneck (bad row estimates, missing index, wrong join order, spilling sorts,…
Premium Prompt
Unlock this prompt — and all 25,000+ expert-crafted prompts — with Pro.
Unlock with Pro