explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gpJO

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.303 ↑ 1.0 10 1

Limit (cost=0.57..563.56 rows=10 width=43) (actual time=0.147..0.303 rows=10 loops=1)

2. 0.154 0.301 ↑ 18,553.5 10 1

GroupAggregate (cost=0.57..10,445,421.94 rows=185,535 width=43) (actual time=0.146..0.301 rows=10 loops=1)

  • Group Key: year, commodity_code
3. 0.147 0.147 ↑ 285,639.1 797 1

Index Only Scan using cda_year_commodity2 on comtrade_data_annual (cost=0.57..7,597,423.58 rows=227,654,334 width=16) (actual time=0.043..0.147 rows=797 loops=1)

  • Heap Fetches: 0