explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SHVo

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 46.652 ↑ 1.0 30 1

Finalize GroupAggregate (cost=10,538.08..10,545.91 rows=30 width=37) (actual time=46.573..46.652 rows=30 loops=1)

  • Group Key: year
2. 0.000 49.320 ↓ 1.4 86 1

Gather Merge (cost=10,538.08..10,545.08 rows=60 width=37) (actual time=46.563..49.320 rows=86 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.165 127.716 ↑ 1.0 29 3

Sort (cost=9,538.06..9,538.13 rows=30 width=37) (actual time=42.571..42.572 rows=29 loops=3)

  • Sort Key: year
  • Sort Method: quicksort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 27kB
  • Worker 1: Sort Method: quicksort Memory: 27kB
4. 59.439 127.551 ↑ 1.0 29 3

Partial HashAggregate (cost=9,536.95..9,537.32 rows=30 width=37) (actual time=42.502..42.517 rows=29 loops=3)

  • Group Key: year
5. 68.112 68.112 ↑ 1.2 71,581 3

Parallel Seq Scan on comtrade_data_annual (cost=0.00..8,645.17 rows=89,178 width=13) (actual time=0.018..22.704 rows=71,581 loops=3)

  • Filter: ((partner_code <> 0) AND (trade_flow_code = 2))
  • Rows Removed by Filter: 75628