explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 11AH

Settings
# exclusive inclusive rows x rows loops node
1. 1,131.983 7,999.343 ↑ 1.0 10 1

Limit (cost=1,000.59..2,097,094.63 rows=10 width=37) (actual time=423.880..7,999.343 rows=10 loops=1)

2. 0.000 6,867.360 ↑ 3.1 10 1

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

  • Group Key: year
3. 0.000 7,999.229 ↑ 2.0 31 1

Gather Merge (cost=1,000.59..6,498,891.25 rows=62 width=37) (actual time=151.608..7,999.229 rows=31 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 9,180.465 18,572.793 ↑ 2.6 12 3

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

  • Group Key: year
5. 9,392.328 9,392.328 ↑ 5.6 17,040,034 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=1.100..3,130.776 rows=17,040,034 loops=3)

  • Heap Fetches: 0