explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RgRU

Settings
# exclusive inclusive rows x rows loops node
1. 20,134.827 20,619.016 ↑ 1.0 5,000,000 1

Sort (cost=733,466.92..745,966.92 rows=5,000,000 width=11) (actual time=15,114.141..20,619.016 rows=5,000,000 loops=1)

  • Sort Key: x
  • Sort Method: external merge Disk: 102736kB
2. 484.189 484.189 ↑ 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.011..484.189 rows=5,000,000 loops=1)

Planning time : 0.225 ms
Execution time : 20,904.908 ms