DataPilot
Back to Troubleshooter

How to use the Troubleshooter

Paste an execution plan, deadlock graph, or EXPLAIN output and get instant rule-based findings with fixes — then an AI deep review and follow-up chat.

Quick start

  1. 1On Plan Analyzer, paste your plan/EXPLAIN text or Attach plan file or screenshot(s).
  2. 2Click Analyze to see the detected type and findings with fixes.
  3. 3Click AI deep review for root-cause reasoning, then ask follow-ups.

Plan Analyzer

Paste SQL Server showplan XML, deadlock XML, or PostgreSQL EXPLAIN / EXPLAIN ANALYZE — or attach a plan file or screenshots. It detects the artifact type and lists findings with a severity and a Fix for each. New to it? Use Load sample to try it instantly.

AI deep review & chat

Click AI deep review to reason over the plan for a root cause and remediation (it reads attached screenshots too). Then use the suggested chips or type a follow-up — the plan and findings stay in context.

Ask a DBA

The second tab is a full expert chat for general help — rewrite queries, write scripts, or read a screenshot or YouTube video — when you don't have a specific plan to analyze.

Tips for the best results

  • Up to 10 screenshots, read together as one plan; images must be under 8 MB.
  • Attach .sqlplan, .xdl, .xml, .sql, .txt or paste text — Office/PDF files are rejected.
  • With screenshots only (no pasted text), the instant checks are skipped — click AI deep review to read the plan.
  • Your plan, findings, and chat persist across navigation; Clear chat resets only the conversation.