explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MMPj

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 38,774.589 76,050.285 ↑ 1.0 31 3

Partial GroupAggregate (cost=0.57..6,497,884.07 rows=31 width=37) (actual time=121.307..25,350.095 rows=31 loops=3)

  • Group Key: year
4. 37,275.696 37,275.696 ↑ 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.016..12,425.232 rows=76,144,543 loops=3)

  • Heap Fetches: 0