explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pbce

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 32,123.132 ↑ 1.0 31 1

Finalize GroupAggregate (cost=1,000.59..6,498,892.11 rows=31 width=37) (actual time=335.560..32,123.132 rows=31 loops=1)

  • Group Key: year
2. 0.000 32,124.107 ↓ 1.5 93 1

Gather Merge (cost=1,000.59..6,498,891.25 rows=62 width=37) (actual time=123.725..32,124.107 rows=93 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 38,132.634 74,746.695 ↑ 1.0 31 3

Partial GroupAggregate (cost=0.57..6,497,884.07 rows=31 width=37) (actual time=121.418..24,915.565 rows=31 loops=3)

  • Group Key: year
4. 36,614.061 36,614.061 ↑ 1.2 76,144,543 3

Parallel Index Only Scan using cda_tv_y on comtrade_data_annual (cost=0.57..5,549,323.96 rows=94,855,972 width=10) (actual time=0.022..12,204.687 rows=76,144,543 loops=3)

  • Heap Fetches: 0