explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rrDY : Optimization for: Optimization for: Optimization for: plan #KKHm; plan #qfJN; plan #uBx

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,486.615 7,565.247 ↓ 9.6 3,255,665 1

Finalize GroupAggregate (cost=394,986.76..530,852.26 rows=339,650 width=60) (actual time=3,221.890..7,565.247 rows=3,255,665 loops=1)

  • Group Key: origin_grouper, destination_grouper, origin_rollup, destination_rollup, year, time_period, competitor_id, aircraft_type_grouper
2. 1,463.373 6,078.632 ↓ 4.9 3,324,967 1

Gather Merge (cost=394,986.76..512,171.51 rows=679,300 width=60) (actual time=3,221.877..6,078.632 rows=3,324,967 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 654.239 4,615.259 ↓ 3.3 1,108,322 3 / 3

Partial GroupAggregate (cost=393,986.73..432,763.41 rows=339,650 width=60) (actual time=3,213.313..4,615.259 rows=1,108,322 loops=3)

  • Group Key: origin_grouper, destination_grouper, origin_rollup, destination_rollup, year, time_period, competitor_id, aircraft_type_grouper
4. 3,477.005 3,961.020 ↑ 1.2 1,132,166 3 / 3

Sort (cost=393,986.73..397,524.75 rows=1,415,207 width=60) (actual time=3,213.299..3,961.020 rows=1,132,166 loops=3)

  • Sort Key: origin_grouper, destination_grouper, origin_rollup, destination_rollup, year, time_period, competitor_id, aircraft_type_grouper
  • Sort Method: external merge Disk: 82,128kB
  • Worker 0: Sort Method: external merge Disk: 82,000kB
  • Worker 1: Sort Method: external merge Disk: 82,000kB
5. 484.015 484.015 ↑ 1.2 1,132,166 3 / 3

Parallel Seq Scan on "ALL_AGG" da (cost=0.00..142,984.07 rows=1,415,207 width=60) (actual time=0.059..484.015 rows=1,132,166 loops=3)

Planning time : 0.327 ms
Execution time : 9,247.244 ms