explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R8ld

Settings
# exclusive inclusive rows x rows loops node
1. 44,642.823 86,488.929 ↑ 2.9 12,914,958 1

GroupAggregate (cost=0.57..12,586,880.59 rows=37,471,840 width=47) (actual time=0.036..86,488.929 rows=12,914,958 loops=1)

  • Group Key: year, commodity_code, reporter_code
2. 41,846.106 41,846.106 ↑ 1.0 241,347,818 1

Index Only Scan using cda_tv_y_cc_rc2 on comtrade_data_annual (cost=0.57..8,456,875.25 rows=244,107,156 width=20) (actual time=0.011..41,846.106 rows=241,347,818 loops=1)

  • Heap Fetches: 0