explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8UBL

Settings
# exclusive inclusive rows x rows loops node
1. 676.262 49,474.203 ↓ 1.1 208,986 1

Finalize GroupAggregate (cost=1,000.59..7,507,319.40 rows=185,535 width=43) (actual time=5.912..49,474.203 rows=208,986 loops=1)

  • Group Key: year, commodity_code
2. 0.000 48,797.941 ↓ 1.3 494,049 1

Gather Merge (cost=1,000.59..7,501,289.51 rows=371,070 width=43) (actual time=5.849..48,797.941 rows=494,049 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 59,408.025 119,034.255 ↑ 1.1 164,683 3

Partial GroupAggregate (cost=0.57..7,457,458.80 rows=185,535 width=43) (actual time=0.060..39,678.085 rows=164,683 loops=3)

  • Group Key: year, commodity_code
4. 59,626.230 59,626.230 ↑ 1.2 76,144,543 3

Parallel Index Only Scan using cda_year_commodity2 on comtrade_data_annual (cost=0.57..6,269,439.96 rows=94,855,972 width=16) (actual time=0.015..19,875.410 rows=76,144,543 loops=3)

  • Heap Fetches: 0