explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y1Uy

Settings
# exclusive inclusive rows x rows loops node
1. 1,052.914 13,388.810 ↓ 1.3 1,701,675 1

Finalize GroupAggregate (cost=360,787.72..731,311.97 rows=1,275,180 width=16) (actual time=6,843.745..13,388.810 rows=1,701,675 loops=1)

  • Output: numero, ((numero % 2)), count(*)
  • Group Key: numeros.numero, ((numeros.numero % 2))
  • Buffers: shared hit=119 read=9135, temp read=4606 written=4620
2. 4,431.036 12,335.896 ↓ 1.4 3,503,347 1

Gather Merge (cost=360,787.72..696,244.52 rows=2,550,360 width=16) (actual time=6,843.691..12,335.896 rows=3,503,347 loops=1)

  • Output: numero, ((numero % 2)), (PARTIAL count(*))
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=384 read=26370, temp read=13289 written=13330
3. 631.501 7,904.860 ↑ 1.1 1,167,782 3 / 3

Partial GroupAggregate (cost=359,787.70..400,869.67 rows=1,275,180 width=16) (actual time=6,731.023..7,904.860 rows=1,167,782 loops=3)

  • Output: numero, ((numero % 2)), PARTIAL count(*)
  • Group Key: numeros.numero, ((numeros.numero % 2))
  • Buffers: shared hit=384 read=26370, temp read=13289 written=13330
  • Worker 0: actual time=6689.685..7816.428 rows=1150990 loops=1
  • Buffers: shared hit=195 read=8639, temp read=4383 written=4397
  • Worker 1: actual time=6729.470..7861.446 rows=1152862 loops=1
  • Buffers: shared hit=70 read=8596, temp read=4300 written=4313
4. 7,273.359 7,273.359 ↑ 1.3 2,011,370 3 / 3

Sort (cost=359,787.70..366,073.25 rows=2,514,222 width=8) (actual time=6,730.966..7,273.359 rows=2,011,370 loops=3)

  • Output: numero, ((numero % 2))
  • Sort Key: numeros.numero, ((numeros.numero % 2))
  • Sort Method: external merge Disk: 36848kB
  • Worker 0: Sort Method: external merge Disk: 35064kB
  • Worker 1: Sort Method: external merge Disk: 34400kB
  • Buffers: shared hit=384 read=26370, temp read=13289 written=13330
  • Worker 0: actual time=6689.620..7208.918 rows=1990292 loops=1
  • Buffers: shared hit=195 read=8639, temp read=4383 written=4397
  • Worker 1: actual time=6729.416..7252.356 rows=1952414 loops=1
  • Buffers: shared hit=70 read=8596, temp read=4300 written=4313
  • -> Parallel Seq Scan on public.numeros (cost=0.00..58127.77 rows=2514222 width=8) (actual time=0.768..1967.517 rows=2011370 loo
  • Output: numero, (numero % 2)
  • Buffers: shared hit=330 read=26370
  • Worker 0: actual time=0.392..1975.502 rows=1990292 loops=1
  • Buffers: shared hit=168 read=8639
  • Worker 1: actual time=0.423..2005.783 rows=1952414 loops=1
  • Buffers: shared hit=43 read=8596
Planning time : 0.926 ms
Execution time : 13,563.830 ms