explain.depesz.com

PostgreSQL's explain analyze made readable

Result: crLR : Optimization for: plan #WuEi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 11,908.257 ↑ 21,199.2 10 1

Gather Merge (cost=64,737.37..94,517.95 rows=211,992 width=55) (actual time=11,851.276..11,908.257 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 672.687 35,412.300 ↑ 458.9 231 3

Partial GroupAggregate (cost=63,737.35..69,048.79 rows=105,996 width=55) (actual time=11,436.476..11,804.100 rows=231 loops=3)

  • Group Key: vdnumber, province, event
3. 34,739.613 34,739.613 ↑ 65.4 4,336 3

Sort (cost=63,737.35..64,445.93 rows=283,432 width=51) (actual time=11,436.096..11,579.871 rows=4,336 loops=3)

  • Sort Key: vdnumber, province
  • Sort Method: external merge Disk: 13592kB
  • Worker 0: Sort Method: external merge Disk: 12768kB