explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lJMr : Optimization for: plan #tVBI

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.791 1.391 ↑ 1.0 1,000 1

Sort (cost=202.83..205.33 rows=1,000 width=15) (actual time=1.322..1.391 rows=1,000 loops=1)

  • Sort Key: employee_id, phone_number
  • Sort Method: quicksort Memory: 82kB
2. 0.600 0.600 ↑ 1.0 1,000 1

Seq Scan on employees e (cost=0.00..153.00 rows=1,000 width=15) (actual time=0.024..0.600 rows=1,000 loops=1)

Planning time : 0.184 ms
Execution time : 1.471 ms