explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QHbL

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

Hash Join (cost=17.99..34.89 rows=3 width=118) (actual rows= loops=)

  • Hash Cond: (ed.emp_id = es.emp_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on employeedetails ed (cost=0.00..15.00 rows=500 width=122) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=17.95..17.95 rows=3 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on employeesalary es (cost=0.00..17.95 rows=3 width=4) (actual rows= loops=)