explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ISKI

Settings
# exclusive inclusive rows x rows loops node
1. 458.381 5,467.906 ↓ 1.2 1,550,059 1

Finalize GroupAggregate (cost=332,446.84..700,116.05 rows=1,271,613 width=16) (actual time=2,649.271..5,467.906 rows=1,550,059 loops=1)

  • Output: numero, ((numero % 2)), count(*)
  • Group Key: numeros.numero, ((numeros.numero % 2))
  • Buffers: shared hit=1137 read=7308, temp read=4203 written=4216
2. 1,830.432 5,009.525 ↓ 1.2 3,035,440 1

Gather Merge (cost=332,446.84..665,146.70 rows=2,543,226 width=16) (actual time=2,647.390..5,009.525 rows=3,035,440 loops=1)

  • Output: numero, ((numero % 2)), (PARTIAL count(*))
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=2893 read=21855, temp read=12290 written=12328
3. 317.352 3,179.093 ↑ 1.3 1,011,813 3 / 3

Partial GroupAggregate (cost=331,446.82..370,595.29 rows=1,271,613 width=16) (actual time=2,595.230..3,179.093 rows=1,011,813 loops=3)

  • Output: numero, ((numero % 2)), PARTIAL count(*)
  • Group Key: numeros.numero, ((numeros.numero % 2))
  • Buffers: shared hit=2893 read=21855, temp read=12290 written=12328
  • Worker 0: actual time=2565.885..3126.441 rows=1014165 loops=1
  • Buffers: shared hit=693 read=7358, temp read=3994 written=4006
  • Worker 1: actual time=2573.125..3177.009 rows=994546 loops=1
  • Buffers: shared hit=1063 read=7189, temp read=4093 written=4106
4. 2,861.741 2,861.741 ↑ 1.3 1,860,184 3 / 3

Sort (cost=331,446.82..337,260.14 rows=2,325,331 width=8) (actual time=2,594.397..2,861.741 rows=1,860,184 loops=3)

  • Output: numero, ((numero % 2))
  • Sort Key: numeros.numero, ((numeros.numero % 2))
  • Sort Method: external merge Disk: 33624kB
  • Worker 0: Sort Method: external merge Disk: 31952kB
  • Worker 1: Sort Method: external merge Disk: 32744kB
  • Buffers: shared hit=2893 read=21855, temp read=12290 written=12328
  • Worker 0: actual time=2565.267..2812.096 rows=1813424 loops=1
  • Buffers: shared hit=693 read=7358, temp read=3994 written=4006
  • Worker 1: actual time=2572.265..2870.268 rows=1858558 loops=1
  • Buffers: shared hit=1063 read=7189, temp read=4093 written=4106
  • -> Parallel Seq Scan on public.numeros (cost=0.00..53760.64 rows=2325331 width=8) (actual time=0.088..630.897 rows=18601
  • Output: numero, (numero % 2)
  • Buffers: shared hit=2839 read=21855
  • Worker 0: actual time=0.042..556.153 rows=1813424 loops=1
  • Buffers: shared hit=666 read=7358
  • Worker 1: actual time=0.191..617.067 rows=1858558 loops=1
  • Buffers: shared hit=1036 read=7189
Planning time : 0.315 ms
Execution time : 5,528.124 ms