SQL Explain Plan
Visualize SQL EXPLAIN plan output as a parsed operation tree
Dialect:
mysql
postgresql
sqlite
tsql
EXPLAIN Output
Seq Scan on users (cost=0.00..10.50 rows=100 width=50) Filter: (active = true) Hash Join (cost=10.00..55.00 rows=50 width=100) Hash Cond: (users.id = posts.user_id) -> Seq Scan on posts (cost=0.00..8.00 rows=50 width=50)
Parsed Operations (3)
1
Seq Scan
rows: 100
2
Hash Join
rows: 50
3
Seq Scan
rows: 50