Query Plan
SQL · Execution Plan · Cost Estimation · Index Analysis
SQL Query
SQL
Enter a SELECT statement to visualise its execution plan
SELECT u.name, u.email, COUNT(o.id) AS order_count, SUM(o.total) AS revenue FROM users u JOIN orders o ON u.id = o.user_id JOIN order_items oi ON o.id = oi.order_id WHERE u.created_at > '2024-01-01' AND o.status = 'completed' GROUP BY u.id, u.name, u.email HAVING COUNT(o.id) > 5 ORDER BY revenue DESC LIMIT 20
▶ Analyse Query
Clear
Execution Plan
Analysis
Enter a SELECT query above and click Analyse Query.