explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v2AZ : Optimization for: plan #ADZB

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 1,725.445 ↑ 1.0 1 1

Finalize Aggregate (cost=949,558.24..949,558.26 rows=1 width=8) (actual time=1,725.445..1,725.445 rows=1 loops=1)

  • Buffers: shared hit=28946 read=899815 written=85
  • JIT:
  • Functions: 27
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 5.089 ms, Inlining 313.181 ms, Optimization 173.703 ms, Emission 109.214 ms, Total 601.187 ms
2. 42.647 1,746.119 ↓ 1.2 5 1

Gather (cost=949,558.03..949,558.23 rows=4 width=8) (actual time=1,725.162..1,746.119 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=28946 read=899815 written=85
3. 105.871 1,703.472 ↑ 1.0 1 5 / 5

Partial Aggregate (cost=948,558.03..948,558.04 rows=1 width=8) (actual time=1,703.472..1,703.472 rows=1 loops=5)

  • Buffers: shared hit=28946 read=899815 written=85
4. 1,597.601 1,597.601 ↑ 1.2 1,275,646 5 / 5

Parallel Seq Scan on docmanager_sendings (cost=0.00..944,598.62 rows=1,583,762 width=0) (actual time=119.596..1,597.601 rows=1,275,646 loops=5)

  • Filter: (document_id IS NOT NULL)
  • Buffers: shared hit=28946 read=899815 written=85
Planning time : 0.316 ms
Execution time : 1,747.898 ms