explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CRvd

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 27.498 ↑ 1.0 10 1

Limit (cost=0.57..20,940.40 rows=10 width=43) (actual time=25.525..27.498 rows=10 loops=1)

2. 0.203 27.495 ↑ 18,553.5 10 1

GroupAggregate (cost=0.57..388,507,084.75 rows=185,535 width=43) (actual time=25.524..27.495 rows=10 loops=1)

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

Index Scan using cda_year_commodity on comtrade_data_annual (cost=0.57..385,659,086.39 rows=227,654,334 width=16) (actual time=3.174..27.292 rows=797 loops=1)

  • Filter: (partner_code <> 0)
  • Rows Removed by Filter: 71