explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZyFf : Optimization for: plan #4VM7

Settings

Optimization path:

# 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.29..2,256,717.02 rows=6,244,648 width=16) (actual time=19,569.870..26,668.079 rows=8,501,041 loops=1)

  • Output: numero, (numero % 2), count(*)
  • Group Key: numeros.numero
  • Buffers: shared hit=116 read=57459, temp read=67363 written=67597
2. 22,708.045 22,708.045 ↑ 1.0 13,011,589 1

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

  • Output: numero
  • Sort Key: numeros.numero
  • Sort Method: external merge Disk: 178320kB
  • Buffers: shared hit=116 read=57459, temp read=67363 written=67597
  • -> Seq Scan on public.numeros (cost=0.00..187694.50 rows=13011950 width=4) (actual time=0.115..4630.644 rows=13011589 loops=
  • Output: numero
  • Buffers: shared hit=116 read=57459
Planning time : 0.269 ms
Execution time : 27,282.794 ms