explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oPVp

Settings
# exclusive inclusive rows x rows loops node
1. 1,047.477 8,196.062 ↑ 1.0 10 1

Limit (cost=1,000.59..2,097,094.63 rows=10 width=37) (actual time=954.038..8,196.062 rows=10 loops=1)

2. 0.000 7,148.585 ↑ 3.1 10 1

Finalize GroupAggregate (cost=1,000.59..6,498,892.11 rows=31 width=37) (actual time=954.036..7,148.585 rows=10 loops=1)

  • Group Key: year
3. 0.000 8,195.954 ↑ 2.0 31 1

Gather Merge (cost=1,000.59..6,498,891.25 rows=62 width=37) (actual time=690.474..8,195.954 rows=31 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 8,680.644 17,885.142 ↑ 2.6 12 3

Partial GroupAggregate (cost=0.57..6,497,884.07 rows=31 width=37) (actual time=135.975..5,961.714 rows=12 loops=3)

  • Group Key: year
5. 9,204.498 9,204.498 ↑ 5.6 17,040,047 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.455..3,068.166 rows=17,040,047 loops=3)

  • Heap Fetches: 0