explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wkEk : Optimization for: Optimization for: plan #tVBI; plan #lJMr

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.138 2.836 ↑ 1.0 1,000 1

Hash Join (cost=165.78..217.41 rows=1,000 width=15) (actual time=1.426..2.836 rows=1,000 loops=1)

  • Hash Cond: (e.employee_id = s.employee_id)
2. 0.359 0.359 ↑ 1.0 1,000 1

Index Only Scan using employees_employee_id_idx on employees e (cost=0.28..39.27 rows=1,000 width=10) (actual time=0.018..0.359 rows=1,000 loops=1)

  • Heap Fetches: 0
3. 0.638 1.339 ↑ 1.0 1,000 1

Hash (cost=153.00..153.00 rows=1,000 width=10) (actual time=1.339..1.339 rows=1,000 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 50kB
4. 0.701 0.701 ↑ 1.0 1,000 1

Seq Scan on employees s (cost=0.00..153.00 rows=1,000 width=10) (actual time=0.041..0.701 rows=1,000 loops=1)

Planning time : 0.481 ms
Execution time : 2.974 ms