explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GRVN : Optimization for: plan #vNkP

Settings

Optimization path:

Optimization(s) for this plan:

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

Sort (cost=216,959.27..216,961.21 rows=775 width=284) (actual rows= loops=)

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

GroupAggregate (cost=150,225.10..216,922.08 rows=775 width=284) (actual rows= loops=)

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

Sort (cost=150,225.10..150,255.75 rows=12,260 width=26) (actual rows= loops=)

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

Gather (cost=1,000.00..149,392.54 rows=12,260 width=26) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on good_goodmodel g (cost=0.00..147,166.54 rows=5,108 width=26) (actual rows= loops=)

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

SubPlan (forGroupAggregate)

7. 0.000 0.000 ↓ 0.0

Limit (cost=0.00..85.81 rows=1 width=42) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on good_goodmodel (cost=0.00..157,544.10 rows=1,836 width=42) (actual rows= loops=)

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