explain.depesz.com

PostgreSQL's explain analyze made readable

Result: voj6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 282,206.981 ↑ 1.0 31 1

Finalize GroupAggregate (cost=1,000.59..9,758,019.27 rows=31 width=37) (actual time=499.712..282,206.981 rows=31 loops=1)

  • Group Key: year
2. 0.000 282,208.081 ↓ 1.5 93 1

Gather Merge (cost=1,000.59..9,758,018.42 rows=62 width=37) (actual time=183.362..282,208.081 rows=93 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 45,002.979 662,418.531 ↑ 1.0 31 3

Partial GroupAggregate (cost=0.57..9,757,011.24 rows=31 width=37) (actual time=181.239..220,806.177 rows=31 loops=3)

  • Group Key: year
4. 617,415.552 617,415.552 ↑ 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=10) (actual time=0.016..205,805.184 rows=76,144,543 loops=3)

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