Prompt · Developer Tools

Query Plan Explainer

Translates EXPLAIN ANALYZE output into plain English with the fix.

Have ready: Paste the EXPLAIN ANALYZE output

Fill in · 3 fields

PASTE THE FULL PLANPOSTGRESQL 16 / MYSQL 8 / ETC.PASTE THE QUERY

Your prompt

Explain this query plan in plain English and tell me how to fix it.

EXPLAIN (ANALYZE, BUFFERS) output:
[PASTE THE FULL PLAN]
Database + version: [POSTGRESQL 16 / MYSQL 8 / ETC.]
The query (if not obvious from the plan):
[PASTE THE QUERY]

Deliver:
1. Walk the plan top-down: what each node does and how many rows it really processed vs estimated, highlight where the planner's estimates are badly wrong and why that matters.
2. The bottleneck node(s) in one sentence each.
3. The fix: index changes (exact DDL), query rewrite, or statistics update, ranked by expected impact.
4. What "good" looks like: the plan shape I should see after the fix.
5. One thing to check first if the same query is sometimes fast and sometimes slow (parameter sniffing / plan caching / bloat).

Teach me to read the plan, don't just hand me the answer.

Paste it into Muse or any assistant. Blank fields stay as [brackets].

More like this

Postmortem Draft

Serialization Chooser