explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JeYQ

Settings
# exclusive inclusive rows x rows loops node
1. 42,643.408 252,573.204 ↓ 4.3 2,594,400 1

Finalize GroupAggregate (cost=1,000.59..1,499,489.60 rows=602,410 width=43) (actual time=144.461..252,573.204 rows=2,594,400 loops=1)

  • Group Key: gl_journal_id
  • JIT:
  • Functions: 12
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.915 ms, Inlining 101.380 ms, Optimization 69.012 ms, Emission 75.584 ms, Total 252.891 ms
2. 0.000 209,929.796 ↓ 2.3 2,797,478 1

Gather Merge (cost=1,000.59..1,482,923.33 rows=1,204,820 width=43) (actual time=144.169..209,929.796 rows=2,797,478 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 111,960.592 215,822.945 ↓ 1.5 932,493 3 / 3

Partial GroupAggregate (cost=0.56..1,342,857.18 rows=602,410 width=43) (actual time=82.568..215,822.945 rows=932,493 loops=3)

  • Group Key: gl_journal_id
4. 103,862.353 103,862.353 ↑ 1.3 13,572,366 3 / 3

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

  • Heap Fetches: 0
Planning time : 0.079 ms
Execution time : 272,259.437 ms