explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kcDl

Settings
# exclusive inclusive rows x rows loops node
1. 87.692 3,617.128 ↑ 1.0 1 1

Aggregate (cost=173,343.93..173,343.94 rows=1 width=8) (actual time=3,617.128..3,617.128 rows=1 loops=1)

2. 441.196 3,529.436 ↓ 1.1 1,000,000 1

GroupAggregate (cost=143,880.70..161,605.05 rows=939,110 width=14) (actual time=2,357.832..3,529.436 rows=1,000,000 loops=1)

  • Group Key: test_g.year
3. 2,924.991 3,088.240 ↑ 1.0 1,111,100 1

Sort (cost=143,880.70..146,658.45 rows=1,111,100 width=6) (actual time=2,357.822..3,088.240 rows=1,111,100 loops=1)

  • Sort Key: test_g.year
  • Sort Method: external merge Disk: 18304kB
4. 163.249 163.249 ↑ 1.0 1,111,100 1

Seq Scan on test_g (cost=0.00..17,113.00 rows=1,111,100 width=6) (actual time=0.017..163.249 rows=1,111,100 loops=1)

Planning time : 0.121 ms
Execution time : 3,621.971 ms