explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OhZf

Settings
# exclusive inclusive rows x rows loops node
1. 281.335 70,040.100 ↓ 1.1 208,986 1

Finalize GroupAggregate (cost=10,013,705.54..10,063,029.95 rows=185,535 width=43) (actual time=69,496.625..70,040.100 rows=208,986 loops=1)

  • Group Key: year, commodity_code
2. 0.000 69,758.765 ↓ 1.7 619,810 1

Gather Merge (cost=10,013,705.54..10,057,000.06 rows=371,070 width=43) (actual time=69,496.608..69,758.765 rows=619,810 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 3,368.784 208,178.445 ↓ 1.1 206,603 3

Sort (cost=10,012,705.51..10,013,169.35 rows=185,535 width=43) (actual time=69,358.342..69,392.815 rows=206,603 loops=3)

  • Sort Key: year, commodity_code
  • Sort Method: quicksort Memory: 22228kB
  • Worker 0: Sort Method: quicksort Memory: 22312kB
  • Worker 1: Sort Method: quicksort Memory: 22316kB
4. 92,499.750 204,809.661 ↓ 1.1 206,603 3

Partial HashAggregate (cost=9,994,150.78..9,996,469.96 rows=185,535 width=43) (actual time=68,149.965..68,269.887 rows=206,603 loops=3)

  • Group Key: year, commodity_code
5. 112,309.911 112,309.911 ↑ 1.2 76,144,543 3

Parallel Index Only Scan using agg_tf_part_partial on comtrade_data_annual (cost=0.57..8,808,451.13 rows=94,855,972 width=16) (actual time=1.389..37,436.637 rows=76,144,543 loops=3)

  • Filter: (partner_code <> 0)
  • Rows Removed by Filter: 4304729
  • Heap Fetches: 0