FindPrompts

Slow Query Diagnostic & Tuning AdvisorPREMIUM

Diagnose a slow SQL query from its EXPLAIN plan and produce a prioritized, evidence-based tuning plan.

6/11/2026
Prompt
## 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 30,000+ expert-crafted prompts — with Pro.

Unlock with Pro

Command Palette

Search for a command to run...