explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2aCr

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

Finalize GroupAggregate (cost=1,000.59..1,499,489.60 rows=602,410 width=43) (actual rows= loops=)

  • Group Key: gl_journal_id
  • JIT:
  • Functions: 6
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,000.59..1,482,923.33 rows=1,204,820 width=43) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=0.56..1,342,857.18 rows=602,410 width=43) (actual rows= loops=)

  • Group Key: gl_journal_id
4. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using gljournalid on glglobal40m (cost=0.56..1,250,496.97 rows=16,966,018 width=21) (actual rows= loops=)