explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FE8R

Settings
# exclusive inclusive rows x rows loops node
1. 41,138.699 240,279.525 ↓ 4.3 2,594,400 1

Finalize GroupAggregate (cost=1,000.59..1,499,489.60 rows=602,410 width=43) (actual time=167.784..240,279.525 rows=2,594,400 loops=1)

  • Output: gl_journal_id, sum(gl_local_amount)
  • Group Key: glglobal40m.gl_journal_id
  • JIT:
  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 3.875 ms, Inlining 157.447 ms, Optimization 94.021 ms, Emission 87.276 ms, Total 342.619 ms
2. 0.000 199,140.826 ↓ 2.3 2,797,703 1

Gather Merge (cost=1,000.59..1,482,923.33 rows=1,204,820 width=43) (actual time=167.415..199,140.826 rows=2,797,703 loops=1)

  • Output: gl_journal_id, (PARTIAL sum(gl_local_amount))
  • Workers Planned: 2
  • Workers Launched: 2
3. 106,638.712 205,650.847 ↓ 1.5 932,568 3 / 3

Partial GroupAggregate (cost=0.56..1,342,857.18 rows=602,410 width=43) (actual time=113.682..205,650.847 rows=932,568 loops=3)

  • Output: gl_journal_id, PARTIAL sum(gl_local_amount)
  • Group Key: glglobal40m.gl_journal_id
  • Worker 0: actual time=109.631..246814.811 rows=1,118,752 loops=1
  • Worker 1: actual time=110.085..246788.407 rows=1,118,725 loops=1
4. 99,012.135 99,012.135 ↑ 1.3 13,572,366 3 / 3

Parallel Index Only Scan using gljournalid on public.glglobal40m (cost=0.56..1,250,496.97 rows=16,966,018 width=21) (actual time=0.087..99,012.135 rows=13,572,366 loops=3)

  • Output: gl_journal_id, gl_local_amount
  • Heap Fetches: 0
  • Worker 0: actual time=0.071..118744.981 rows=16,276,823 loops=1
  • Worker 1: actual time=0.067..118833.466 rows=16,278,204 loops=1
Planning time : 0.082 ms
Execution time : 259,330.550 ms