explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zZDS

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,605,370.36..1,805,371.32 rows=10,000,048 width=12) (actual rows= loops=)

  • (actual time=3667.207..4280.582 rows=2 loops=1)
  • Group Key: ((id % 2))
  • Sort Key: ((id % 2))
  • Sort Method: external merge Disk: 137000kB
2. 0.000 0.000 ↓ 0.0

Sort (cost=1,605,370.36..1,630,370.48 rows=10,000,048 width=4) (actual rows= loops=)

  • (actual time=3057.351..3866.446 rows=10000000 loops=1)
3. 0.000 0.000 ↓ 0.0

Seq Scan on t_demo (cost=0.00..169,248.60 rows=10,000,048 width=4) (actual rows= loops=)

  • (actual time=65.470..876.695 rows=10000000 loops=1)