explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uFU2 : Optimization for: Optimization for: Optimization for: Optimization for: plan #Tsso; plan #FqSQ; plan #QOP8; plan #dpuLd

Settings

Optimization path:

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

Finalize Aggregate (cost=5,956,855.22..5,956,855.23 rows=1 width=8) (actual time=18,949.375..18,949.375 rows=1 loops=1)

2. 18.950 18,954.595 ↓ 1.2 5 1

Gather (cost=5,956,854.80..5,956,855.21 rows=4 width=8) (actual time=18,949.292..18,954.595 rows=5 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 5,735.254 18,935.645 ↑ 1.0 1 5

Partial Aggregate (cost=5,955,854.80..5,955,854.81 rows=1 width=8) (actual time=18,935.645..18,935.645 rows=1 loops=5)

4. 13,200.391 13,200.391 ↑ 1.3 125,460,000 5

Parallel Seq Scan on data (cost=0.00..5,563,792.24 rows=156,825,024 width=0) (actual time=3.091..13,200.391 rows=125,460,000 loops=5)

Planning time : 0.220 ms
Execution time : 18,954.641 ms