explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9EN8 : Optimization for: Optimization for: Optimization for: Optimization for: plan #79d4; plan #0jT3; plan #KPAq; plan #23TP

Settings

Optimization path:

Optimization(s) for this plan:

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

Finalize Aggregate (cost=4,643,666.72..4,643,666.73 rows=1 width=8) (actual time=247,584.619..247,584.619 rows=1 loops=1)

2. 147.757 247,714.463 ↓ 1.5 3 1

Gather (cost=4,643,666.51..4,643,666.72 rows=2 width=8) (actual time=247,583.886..247,714.463 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 723.387 247,566.706 ↑ 1.0 1 3

Partial Aggregate (cost=4,642,666.51..4,642,666.52 rows=1 width=8) (actual time=247,566.706..247,566.706 rows=1 loops=3)

4. 246,843.319 246,843.319 ↑ 11.1 8,750,000 3

Parallel Seq Scan on event_series_partitioned_customer_1 (cost=0.00..4,399,548.42 rows=97,247,234 width=0) (actual time=87,267.020..246,843.319 rows=8,750,000 loops=3)

  • Filter: (customer_id = '1'::text)
Planning time : 0.086 ms
Execution time : 247,714.525 ms