explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.410 0.629 ↑ 1.0 1,000 1

Sort (cost=89.10..91.60 rows=1,000 width=10) (actual time=0.545..0.629 rows=1,000 loops=1)

  • Sort Key: employee_id, phone_number DESC
  • Sort Method: quicksort Memory: 71kB
2. 0.219 0.219 ↑ 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.025..0.219 rows=1,000 loops=1)

  • Heap Fetches: 0
Planning time : 0.147 ms
Execution time : 0.712 ms