explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YeK6

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

Hash Join (cost=4.41..31.37 rows=1 width=45) (actual rows= loops=)

  • Output: local_employees.first_name, local_employees.last_name, local_departments.department_name
  • Hash Cond: ((local_departments.department_id)::numeric = local_employees.department_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on public.local_departments (cost=0.00..21.30 rows=1,130 width=36) (actual rows= loops=)

  • Output: local_departments.department_id, local_departments.department_name, local_departments.manager_id, local_departments.location_id
3. 0.000 0.000 ↓ 0.0

Hash (cost=3.07..3.07 rows=107 width=45) (actual rows= loops=)

  • Output: local_employees.first_name, local_employees.last_name, local_employees.department_id
4. 0.000 0.000 ↓ 0.0

Seq Scan on public.local_employees (cost=0.00..3.07 rows=107 width=45) (actual rows= loops=)

  • Output: local_employees.first_name, local_employees.last_name, local_employees.department_id