explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KAUZ

Settings
# exclusive inclusive rows x rows loops node
1. 1,220.708 1,435.305 ↑ 1.0 2,000,000 1

Sort (cost=238,165.69..243,165.69 rows=2,000,000 width=8) (actual time=876.986..1,435.305 rows=2,000,000 loops=1)

  • Sort Key: val DESC
  • Sort Method: quicksort Memory: 142903kB
2. 214.597 214.597 ↑ 1.0 2,000,000 1

Seq Scan on numbers (cost=0.00..28,850.00 rows=2,000,000 width=8) (actual time=0.012..214.597 rows=2,000,000 loops=1)

Planning time : 0.046 ms
Execution time : 1,575.321 ms