explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9OuV : first

Settings

Optimization(s) for this plan:

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

Finalize Aggregate (cost=166,907.22..166,907.23 rows=1 width=8) (actual time=722.346..722.346 rows=1 loops=1)

2. 3.269 723.668 ↓ 1.5 3 1

Gather (cost=166,907.00..166,907.21 rows=2 width=8) (actual time=722.265..723.668 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 112.009 720.399 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=165,907.00..165,907.01 rows=1 width=8) (actual time=720.399..720.399 rows=1 loops=3)

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

Parallel Index Only Scan using scheduling__executi_8d7109_idx on scheduling_attempt (cost=0.57..163,411.29 rows=998,285 width=0) (actual time=0.018..608.390 rows=1,249,352 loops=3)

  • Index Cond: (execution_time >= '2020-06-21 01:50:36.241152+00'::timestamp with time zone)
  • Heap Fetches: 1,270,636