explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HDpB : 1 Sort

Settings
# exclusive inclusive rows x rows loops node
1. 569.197 2,639.659 ↑ 1.0 1,000,001 1

WindowAgg (cost=135,042.46..155,042.48 rows=1,000,001 width=47) (actual time=1,555.005..2,639.659 rows=1,000,001 loops=1)

2. 1,893.425 2,070.462 ↑ 1.0 1,000,001 1

Sort (cost=135,042.46..137,542.46 rows=1,000,001 width=15) (actual time=1,554.989..2,070.462 rows=1,000,001 loops=1)

  • Sort Key: c1, c2
  • Sort Method: external merge  Disk: 25,960kB
3. 177.037 177.037 ↑ 1.0 1,000,001 1

Seq Scan on t (cost=0.00..18,294.01 rows=1,000,001 width=15) (actual time=0.013..177.037 rows=1,000,001 loops=1)

Planning time : 0.115 ms
Execution time : 2,693.935 ms