explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

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

Finalize Aggregate (cost=172,896.93..172,896.94 rows=1 width=8) (actual time=722.479..722.479 rows=1 loops=1)

2. 3.340 723.780 ↓ 1.5 3 1

Gather (cost=172,896.71..172,896.92 rows=2 width=8) (actual time=722.457..723.780 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 110.044 720.440 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=171,896.71..171,896.72 rows=1 width=8) (actual time=720.440..720.440 rows=1 loops=3)

4. 610.396 610.396 ↓ 1.3 1,249,352 3 / 3

Parallel Index Only Scan using scheduling__executi_8d7109_idx on scheduling_attempt (cost=0.57..169,401.00 rows=998,285 width=0) (actual time=0.019..610.396 rows=1,249,352 loops=3)

  • Index Cond: ((execution_time >= '2020-06-21 01:50:36.241152+00'::timestamp with time zone) AND (execution_time <= '2020-06-23 08:08:04.074153+00'::timestamp with time zone))
  • Heap Fetches: 1,258,562