explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I4Cj

Settings
# exclusive inclusive rows x rows loops node
1. 4,011.255 4,526.601 ↑ 1.0 5,000,000 1

Sort (cost=633,365.42..645,865.42 rows=5,000,000 width=11) (actual time=2,830.284..4,526.601 rows=5,000,000 loops=1)

  • Sort Key: x
  • Sort Method: quicksort Memory: 430984kB
2. 515.346 515.346 ↑ 1.0 5,000,000 1

Seq Scan on t_test (cost=0.00..77,028.00 rows=5,000,000 width=11) (actual time=0.012..515.346 rows=5,000,000 loops=1)

Planning time : 0.036 ms
Execution time : 4,924.276 ms