explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MkV1

Settings
# exclusive inclusive rows x rows loops node
1. 78,373.078 674,059.915 ↓ 4.5 2,594,400 1

Finalize GroupAggregate (cost=4,077,634.63..4,412,420.49 rows=577,624 width=75) (actual time=295,559.228..674,059.915 rows=2,594,400 loops=1)

  • Output: gl_journal_id, sum(gl_local_amount), sum(gl_foreign_amount)
  • Group Key: glglobal40m.gl_journal_id
  • JIT:
  • Functions: 24
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 9.979 ms, Inlining 157.989 ms, Optimization 314.437 ms, Emission 223.687 ms, Total 706.091 ms
2. 76,651.572 595,686.837 ↓ 6.4 7,385,453 1

Gather Merge (cost=4,077,634.63..4,389,315.53 rows=1,155,248 width=75) (actual time=295,557.922..595,686.837 rows=7,385,453 loops=1)

  • Output: gl_journal_id, (PARTIAL sum(gl_local_amount)), (PARTIAL sum(gl_foreign_amount))
  • Workers Planned: 2
  • Workers Launched: 2
3. 120,209.865 519,035.265 ↓ 4.3 2,461,818 3 / 3

Partial GroupAggregate (cost=4,076,634.61..4,254,971.22 rows=577,624 width=75) (actual time=295,411.663..519,035.265 rows=2,461,818 loops=3)

  • Output: gl_journal_id, PARTIAL sum(gl_local_amount), PARTIAL sum(gl_foreign_amount)
  • Group Key: glglobal40m.gl_journal_id
  • Worker 0: actual time=295,380.824..517002.842 rows=2,461,041 loops=1
  • Worker 1: actual time=295,300.316..517341.752 rows=2,461,582 loops=1
4. 261,543.886 398,825.400 ↑ 1.3 13,572,366 3 / 3

Sort (cost=4,076,634.61..4,119,052.67 rows=16,967,225 width=24) (actual time=295,404.448..398,825.400 rows=13,572,366 loops=3)

  • Output: gl_journal_id, gl_local_amount, gl_foreign_amount
  • Sort Key: glglobal40m.gl_journal_id
  • Sort Method: external merge Disk: 463,336kB
  • Worker 0: Sort Method: external merge Disk: 463,488kB
  • Worker 1: Sort Method: external merge Disk: 462,672kB
  • Worker 0: actual time=295,375.891..397839.175 rows=13,582,548 loops=1
  • Worker 1: actual time=295,290.277..397974.073 rows=13,558,074 loops=1
5. 137,281.514 137,281.514 ↑ 1.3 13,572,366 3 / 3

Parallel Seq Scan on public.glglobal40m (cost=0.00..1,343,263.25 rows=16,967,225 width=24) (actual time=234.088..137,281.514 rows=13,572,366 loops=3)

  • Output: gl_journal_id, gl_local_amount, gl_foreign_amount
  • Worker 0: actual time=229.525..137571.463 rows=13,582,548 loops=1
  • Worker 1: actual time=229.476..136786.515 rows=13,558,074 loops=1
Planning time : 1.972 ms
Execution time : 692,502.657 ms