explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CR4x

Settings
# exclusive inclusive rows x rows loops node
1. 0.107 1.436 ↓ 26.0 26 1

Sort (cost=5.00..5.01 rows=1 width=1,438) (actual time=1.429..1.436 rows=26 loops=1)

  • Sort Key: (COALESCE(tasks.starttime, projectschedule.starttime)), tasks.taskid
  • Sort Method: quicksort Memory: 29kB
2. 0.198 1.329 ↓ 26.0 26 1

Hash Right Join (cost=1.54..4.99 rows=1 width=1,438) (actual time=0.259..1.329 rows=26 loops=1)

  • Hash Cond: (tasks.projectscheduleid = projectschedule.projectscheduleid)
3. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on tasks (cost=0.00..1.07 rows=7 width=1,004) (actual time=0.004..0.006 rows=7 loops=1)

4. 0.056 0.137 ↓ 26.0 26 1

Hash (cost=1.52..1.52 rows=1 width=466) (actual time=0.137..0.137 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
5. 0.081 0.081 ↓ 26.0 26 1

Seq Scan on projectschedule (cost=0.00..1.52 rows=1 width=466) (actual time=0.026..0.081 rows=26 loops=1)

  • Filter: (projectid = 14::numeric)
  • Rows Removed by Filter: 16
6.          

SubPlan (forHash Right Join)

7. 0.806 0.806 ↑ 1.0 1 26

Seq Scan on projectportfolio (cost=0.00..1.27 rows=1 width=418) (actual time=0.021..0.031 rows=1 loops=26)

  • Filter: (projectid = projectschedule.projectid)
  • Rows Removed by Filter: 21
8. 0.052 0.182 ↑ 1.0 1 26

Aggregate (cost=1.06..1.07 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=26)

9. 0.130 0.130 ↓ 0.0 0 26

Seq Scan on taskexceptiondetail (cost=0.00..1.06 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=26)

  • Filter: ((eventiscleared IS NULL) AND (taskid = tasks.taskid))
  • Rows Removed by Filter: 5