explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZEkH : Optimization for: Optimization for: first; plan #9OuV; plan #Hope

Settings

Optimization path:

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

Finalize Aggregate (cost=178,460.34..178,460.35 rows=1 width=8) (actual time=364.122..364.122 rows=1 loops=1)

  • Output: count('id')
2. 5.566 365.113 ↓ 1.5 3 1

Gather (cost=178,460.12..178,460.33 rows=2 width=8) (actual time=360.933..365.113 rows=3 loops=1)

  • Output: (PARTIAL count('id'))
  • Workers Planned: 2
  • Workers Launched: 2
3. 115.189 359.547 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=177,460.12..177,460.13 rows=1 width=8) (actual time=359.547..359.547 rows=1 loops=3)

  • Output: PARTIAL count('id')
  • Worker 0: actual time=360.739..360.740 rows=1 loops=1
  • Worker 1: actual time=357.181..357.181 rows=1 loops=1
4. 244.358 244.358 ↑ 1.2 1,249,352 3 / 3

Parallel Index Only Scan using scheduling__executi_8d7109_idx on ad_96d5be.scheduling_attempt (cost=0.57..173,770.98 rows=1,475,658 width=0) (actual time=0.019..244.358 rows=1,249,352 loops=3)

  • Index Cond: (scheduling_attempt.execution_time >= '2020-06-21 01:50:36.241152+00'::timestamp with time zone)
  • Heap Fetches: 0
  • Worker 0: actual time=0.016..251.787 rows=1,095,311 loops=1
  • Worker 1: actual time=0.022..239.290 rows=1,271,654 loops=1