explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kbrN

Settings
# exclusive inclusive rows x rows loops node
1. 19,006.180 12,151,255.146 ↑ 2.9 12,914,958 1

Finalize GroupAggregate (cost=22,637,562.92..34,941,463.14 rows=37,471,840 width=47) (actual time=8,518,287.260..12,151,255.146 rows=12,914,958 loops=1)

  • Group Key: year, commodity_code, reporter_code
2. 0.000 12,132,248.966 ↑ 2.4 31,035,004 1

Gather Merge (cost=22,637,562.92..33,536,269.14 rows=74,943,680 width=47) (actual time=8,518,207.248..12,132,248.966 rows=31,035,004 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 87,052.581 30,892,250.529 ↑ 3.6 10,345,001 3

Partial GroupAggregate (cost=22,636,562.89..24,884,908.90 rows=37,471,840 width=47) (actual time=8,237,496.796..10,297,416.843 rows=10,345,001 loops=3)

  • Group Key: year, commodity_code, reporter_code
4. 30,659,029.029 30,805,197.948 ↑ 1.3 80,449,273 3

Sort (cost=22,636,562.89..22,890,841.18 rows=101,711,315 width=20) (actual time=8,237,116.782..10,268,399.316 rows=80,449,273 loops=3)

  • Sort Key: year, commodity_code, reporter_code
  • Sort Method: external merge Disk: 2507072kB
  • Worker 0: Sort Method: external merge Disk: 2487288kB
  • Worker 1: Sort Method: external merge Disk: 2511496kB
5. 146,168.919 146,168.919 ↑ 1.3 80,449,273 3

Parallel Index Only Scan using cda_tv_y_cc_rc2 on comtrade_data_annual (cost=0.57..7,023,128.84 rows=101,711,315 width=20) (actual time=0.665..48,722.973 rows=80,449,273 loops=3)

  • Heap Fetches: 0