explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MO7F

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

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

2. 0.141 0.276 ↑ 18,553.5 10 1

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

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

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

  • Heap Fetches: 0