explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mom9 : Optimization for: plan #BIph

Settings

Optimization path:

Optimization(s) for this plan:

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

Finalize Aggregate (cost=6,415.99..6,416.01 rows=1 width=32) (actual time=35.082..35.082 rows=1 loops=1)

2. 3.600 37.264 ↓ 2.0 2 1

Gather (cost=6,415.88..6,415.99 rows=1 width=32) (actual time=35.016..37.264 rows=2 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 14.859 33.664 ↑ 1.0 1 2 / 2

Partial Aggregate (cost=5,415.88..5,415.89 rows=1 width=32) (actual time=33.664..33.664 rows=1 loops=2)

4. 18.805 18.805 ↑ 1.2 197,328 2 / 2

Parallel Seq Scan on belege_pro_5min (cost=0.00..4,835.50 rows=232,150 width=8) (actual time=0.010..18.805 rows=197,328 loops=2)

Planning time : 0.046 ms
Execution time : 37.305 ms