explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZlLT

Settings
# exclusive inclusive rows x rows loops node
1. 293.541 703,788.775 ↑ 1.0 10 1

Limit (cost=22,637,562.92..22,637,566.20 rows=10 width=47) (actual time=703,495.106..703,788.775 rows=10 loops=1)

2. 0.000 703,495.234 ↑ 3,747,184.0 10 1

Finalize GroupAggregate (cost=22,637,562.92..34,941,463.14 rows=37,471,840 width=47) (actual time=703,495.105..703,495.234 rows=10 loops=1)

  • Group Key: year, commodity_code, reporter_code
3. 0.000 703,788.729 ↑ 2,417,538.1 31 1

Gather Merge (cost=22,637,562.92..33,536,269.14 rows=74,943,680 width=47) (actual time=703,495.071..703,788.729 rows=31 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1.800 2,107,661.760 ↑ 113,896.2 329 3

Partial GroupAggregate (cost=22,636,562.89..24,884,908.90 rows=37,471,840 width=47) (actual time=702,552.619..702,553.920 rows=329 loops=3)

  • Group Key: year, commodity_code, reporter_code
5. 1,912,199.352 2,107,659.960 ↑ 74,350.4 1,368 3

Sort (cost=22,636,562.89..22,890,841.18 rows=101,711,315 width=20) (actual time=702,552.584..702,553.320 rows=1,368 loops=3)

  • Sort Key: year, commodity_code, reporter_code
  • Sort Method: external merge Disk: 2508416kB
  • Worker 0: Sort Method: external merge Disk: 2492160kB
  • Worker 1: Sort Method: external merge Disk: 2505288kB
6. 195,460.608 195,460.608 ↑ 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.464..65,153.536 rows=80,449,273 loops=3)

  • Heap Fetches: 0