explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4VM7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3,960.034 26,668.079 ↓ 1.4 8,501,041 1

GroupAggregate (cost=2,081,069.290..2,256,717.020 rows=6,244,648 width=16) (actual time=19,569.870..26,668.079 rows=8,501,041 loops=1)

  • Output: kilo, (kilo % 2), five(*)
  • Group Key: oscar.kilo
  • Buffers: shared hit=116 read=57,459, temp read=67,363 written=67,597
2. 22,708.045 22,708.045 ↑ 1.0 13,011,589 1

Sort (cost=2,081,069.290..2,113,599.170 rows=13,011,950 width=4) (actual time=19,569.799..22,708.045 rows=13,011,589 loops=1)

  • Output: kilo
  • Sort Key: oscar.kilo
  • Sort Method: external merge Disk: 178,320kB
  • Buffers: shared hit=116 read=57,459, temp read=67,363 written=67,597
  • -> Seq Scan on public.numeros (cost=0.00..187694.50 rows=13,011,950 width=4) (actual time=0.115..4630.644 rows=13,011,589 loops=
  • Output: kilo
  • Buffers: shared hit=116 read=57,459
Planning time : 0.269 ms
Execution time : 27,282.794 ms