explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evvy

Settings
# exclusive inclusive rows x rows loops node
1. 419.189 603.759 ↓ 1.0 400,000 1

Sort (cost=48,403.05..49,401.93 rows=399,549 width=6) (actual time=396.215..603.759 rows=400,000 loops=1)

  • Sort Key: v DESC
  • Sort Method: external merge Disk: 6288kB
2. 184.570 184.570 ↓ 1.0 400,000 1

Seq Scan on s1 (cost=0.00..5,765.49 rows=399,549 width=6) (actual time=0.009..184.570 rows=400,000 loops=1)

Planning time : 0.774 ms
Execution time : 764.367 ms