Execution Plan Analyzer
Visualize query execution plans as interactive trees and detect performance issues. Supports SQL Server, PostgreSQL, and MySQL. Everything runs in your browser.
Paste an execution plan and click Analyze
Node Details
Est. Rows
Act. Rows
Cost %
Time (ms)
Properties
Issues
Issues Found
issuesNo performance issues detected
Your execution plan looks good!
Plan Details
Memory Desired
Memory Granted
Memory Max Used
Insufficient Grant
Excessive Grant
Compile Time
Compile CPU
Cached Plan Size
Max DOP
Parallel Branches
Stale Statistics
| Table | Statistic | Modifications | Sample % |
|---|---|---|---|
Statistics with high modification counts or very low sampling rates may cause poor cardinality estimates. Consider running UPDATE STATISTICS.
Client-side only
Your execution plans never leave your browser. All parsing and analysis is performed locally.
Multi-platform
Supports SQL Server (SHOWPLAN_XML), PostgreSQL (EXPLAIN JSON), and MySQL (EXPLAIN FORMAT=JSON).
30+ detection rules
Detects table scans, key lookups, implicit conversions, TempDB spills, row estimate skew, and more.
Found an issue?
Submit your execution plan so we can fix parsing or detection errors.
How to use the execution plan analyzer
Paste a supported SQL Server XML, PostgreSQL JSON, or MySQL JSON execution plan to explore operators and warnings as an interactive tree. Interpret estimates alongside runtime evidence from your own environment.
When to use it
- Trace expensive branches and understand operator relationships.
- Review estimate mismatches, scans, joins, memory grants, and warnings.
- Navigate large plans visually before returning to the source query.
- Keep sensitive plan review local unless you explicitly submit a failing sample.
Continue with the database tools directory, browse technical articles, or check the SQL Server release tracker.