💻 Software & APIschatgpt
SQL: explain plan walkthrough for analysts
Turn EXPLAIN output into plain-language bottlenecks and index ideas.
👁 12 조회수📦 0 구매
SQLperformanceanalytics
설명
Paste dialect, query, and plan. Get sequential steps, likely bottleneck, and safe next experiments (no destructive commands assumed).
예시 출력
1) Nested loop on … 2) Seq scan on large table … Suggestion: composite index on (a,b) — verify cardinality…
프롬프트 내용
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.리뷰 (0)
No reviews yet. Be the first to review this prompt!
유사 프롬프트
💼
chatgpt
Sprint retro: facilitation guide + board template
Timed agenda, prompts, and actions with owners for remote teams.
agileretrofacilitation
$2.49
🎨
chatgpt
Twitter/X thread from one thesis
Hook, 8–12 posts, CTA, and hashtag discipline.
socialthreadthought-leadership
Free