explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fJtu

Settings

Optimization(s) for this plan:

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

Finalize GroupAggregate (cost=8,172,239.14..11,382,773.49 rows=7,598,605 width=62) (actual rows= loops=)

  • Group Key: agecgr, codmod, anoced, nroced, codage, ctasoc, datvct
  • Filter: (sum(vlrcgr) > '0'::numeric)
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=8,172,239.14..10,812,878.11 rows=15,197,210 width=62) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=8,171,239.11..9,057,742.97 rows=7,598,605 width=62) (actual rows= loops=)

  • Group Key: agecgr, codmod, anoced, nroced, codage, ctasoc, datvct
4. 0.000 0.000 ↓ 0.0

Sort (cost=8,171,239.11..8,250,391.24 rows=31,660,852 width=36) (actual rows= loops=)

  • Sort Key: agecgr, codmod, anoced, nroced, codage, ctasoc, datvct
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on cgra (cost=0.00..1,629,713.52 rows=31,660,852 width=36) (actual rows= loops=)