💻 Software & APIschatgpt
SQL: explain plan walkthrough for analysts
Turn EXPLAIN output into plain-language bottlenecks and index ideas.
👁 4 views📦 0 purchases
SQLperformanceanalytics
Description
Paste dialect, query, and plan. Get sequential steps, likely bottleneck, and safe next experiments (no destructive commands assumed).
Example Output
1) Nested loop on … 2) Seq scan on large table … Suggestion: composite index on (a,b) — verify cardinality…
Prompt Content
Dialect: {{SQL_DIALECT}}
Query:
```sql
{{QUERY}}
```
EXPLAIN (or EXPLAIN ANALYZE) output:
```
{{PLAN}}
```
Explain to a data analyst (not a DBA):
1) Execution story in 5–8 bullets (order of operations).
2) Likely bottleneck with evidence from the plan.
3) 3 optimization ideas: index candidates (with columns), rewrite ideas, stats/maintenance notes — mark "verify with DBA" where needed.
4) What *not* to do (common mistakes).
If the plan is missing, say what to capture next.Reviews (0)
No reviews yet. Be the first to review this prompt!
Similar Prompts
💼
chatgpt
Sprint retro: facilitation guide + board template
Timed agenda, prompts, and actions with owners for remote teams.
agileretrofacilitation
$2.49
💼
chatgpt
Pitch deck: problem slide in one tight story
Headline, subtext, and speaker notes for a single high-impact slide.
pitchstartupsslides
$2.99