explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QWhp

Settings
# exclusive inclusive rows x rows loops node
1. 542.963 54,227.863 ↓ 1.1 208,986 1

Finalize GroupAggregate (cost=1,000.59..7,507,319.40 rows=185,535 width=43) (actual time=6.071..54,227.863 rows=208,986 loops=1)

  • Group Key: year, commodity_code
2. 0.000 53,684.900 ↓ 1.4 511,540 1

Gather Merge (cost=1,000.59..7,501,289.51 rows=371,070 width=43) (actual time=5.995..53,684.900 rows=511,540 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 67,657.485 130,012.038 ↑ 1.1 170,513 3

Partial GroupAggregate (cost=0.57..7,457,458.80 rows=185,535 width=43) (actual time=0.082..43,337.346 rows=170,513 loops=3)

  • Group Key: year, commodity_code
4. 62,354.553 62,354.553 ↑ 1.2 76,144,543 3

Parallel Index Only Scan using cda_year_commodity3 on comtrade_data_annual (cost=0.57..6,269,439.96 rows=94,855,972 width=16) (actual time=0.017..20,784.851 rows=76,144,543 loops=3)

  • Heap Fetches: 0