explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vNkP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=581.19..581.23 rows=16 width=283) (actual rows= loops=)

  • Sort Key: (sum(g.g45usd)) DESC
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=549.38..580.87 rows=16 width=283) (actual rows= loops=)

  • Group Key: g.g2code1
3. 0.000 0.000 ↓ 0.0

Sort (cost=549.38..549.48 rows=38 width=25) (actual rows= loops=)

  • Sort Key: g.g2code1
4. 0.000 0.000 ↓ 0.0

Seq Scan on good_goodmodel g (cost=0.00..548.39 rows=38 width=25) (actual rows= loops=)

  • Filter: ((g33)::text ~~ '1512%'::text)
5.          

SubPlan (forGroupAggregate)

6. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..1.92 rows=1 width=36) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on good_goodmodel (cost=0.00..548.39 rows=286 width=36) (actual rows= loops=)

  • Filter: ((g2code1)::text = (g.g2code1)::text)