💻 Software & APIschatgpt
SQL: explain plan walkthrough for analysts
Turn EXPLAIN output into plain-language bottlenecks and index ideas.
👁 5 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
Newsletter issue: curated links + commentary
Hook, 4–6 link blurbs with takeaways, and sign-off matching your voice.
newslettercurationeditorial
Free
🎨
chatgpt
Twitter/X thread from one thesis
Hook, 8–12 posts, CTA, and hashtag discipline.
socialthreadthought-leadership
Free