explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kBSL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=29.13..54.95 rows=850 width=156) (actual rows= loops=)

  • Hash Cond: (emp.deptno = dept.deptno)
2. 0.000 0.000 ↓ 0.0

Seq Scan on emp (cost=0.00..17.00 rows=700 width=88) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=18.50..18.50 rows=850 width=68) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on dept (cost=0.00..18.50 rows=850 width=68) (actual rows= loops=)