explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dLUa : Optimization for: Optimization for: plan #vNkP; plan #GRVN

Settings

Optimization path:

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

Limit (cost=128,229.03..128,229.13 rows=10 width=83) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Unique (cost=128,229.03..128,229.83 rows=80 width=83) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=128,229.03..128,229.23 rows=80 width=83) (actual rows= loops=)

  • Sort Key: (sum(g.g45usd)) DESC, country.name, (sum(((g.g42 * g.g23) * g.g23scale)))
4. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=128,215.87..128,226.50 rows=80 width=83) (actual rows= loops=)

  • Group Key: country.name
5. 0.000 0.000 ↓ 0.0

Gather Merge (cost=128,215.87..128,224.48 rows=66 width=83) (actual rows= loops=)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=127,215.85..127,216.84 rows=33 width=83) (actual rows= loops=)

  • Group Key: country.name
7. 0.000 0.000 ↓ 0.0

Sort (cost=127,215.85..127,215.93 rows=33 width=43) (actual rows= loops=)

  • Sort Key: country.name
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8.65..127,215.01 rows=33 width=43) (actual rows= loops=)

  • Hash Cond: ((g.g15)::text = (country.code)::text)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on good_goodmodel g (cost=0.00..127,205.11 rows=27 width=27) (actual rows= loops=)

  • Filter: ((g33)::text ~~ '7210490000%'::text)
10. 0.000 0.000 ↓ 0.0

Hash (cost=5.51..5.51 rows=251 width=35) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on good_countrymodel country (cost=0.00..5.51 rows=251 width=35) (actual rows= loops=)