Loading...
Visualize SQL explain online for free. See query execution plans graphically. Optimize SQL performance.
Parse and visualize SQL EXPLAIN output
Supported Formats
• MySQL/MariaDB: Standard table format from EXPLAIN
• PostgreSQL: JSON format from EXPLAIN (FORMAT JSON)
• Displays operation tree, row estimates, and query costs
• All parsing is done client-side in your browser
Example commands:
MySQL: EXPLAIN SELECT * FROM users WHERE id = 1;
PostgreSQL: EXPLAIN (FORMAT JSON) SELECT * FROM users;
Execute EXPLAIN on your query
Enter EXPLAIN results
See execution plan tree
Identify slow operations
Execute EXPLAIN on your query
Enter EXPLAIN results
See execution plan tree
Identify slow operations
Supports EXPLAIN output from MySQL and PostgreSQL in both tabular and JSON formats.
The tree shows query operations hierarchically. Higher cost and row estimates indicate potential bottlenecks.
Focus on operations with high row estimates, full table scans, or operations without index usage.
Currently shows the execution plan. Use this to identify issues like missing indexes or inefficient joins.