explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8idF : Optimization for: plan #9m2r

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 7.151 7.400 ↑ 1.0 1,000 1

Sort (cost=202.83..205.33 rows=1,000 width=1,028) (actual time=7.279..7.400 rows=1,000 loops=1)

  • Sort Key: phone_number
  • Sort Method: quicksort Memory: 2,040kB
2. 0.249 0.249 ↑ 1.0 1,000 1

Seq Scan on employees e (cost=0.00..153.00 rows=1,000 width=1,028) (actual time=0.015..0.249 rows=1,000 loops=1)