explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ahga : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #KKHm; plan #qfJN; plan #uBx; plan #rrDY; plan #96Cj; plan #lh2c

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 3,135.556 14,064.956 ↓ 2.3 3,255,665 1

WindowAgg (cost=199,036.53..260,359.06 rows=1,442,883 width=200) (actual time=10,094.921..14,064.956 rows=3,255,665 loops=1)

2. 10,269.742 10,929.400 ↓ 2.3 3,255,665 1

Sort (cost=199,036.53..202,643.74 rows=1,442,883 width=180) (actual time=10,094.904..10,929.400 rows=3,255,665 loops=1)

  • Sort Key: year, time_period, origin_grouper, origin_rollup, destination_grouper, destination_rollup, aircraft_type_grouper, legality_value
  • Sort Method: external merge Disk: 223,000kB
3. 659.658 659.658 ↓ 2.3 3,255,665 1

Seq Scan on ra (cost=0.00..51,425.83 rows=1,442,883 width=180) (actual time=0.027..659.658 rows=3,255,665 loops=1)

Planning time : 0.146 ms
Execution time : 15,844.565 ms