explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X0W

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=6,362,988.83..7,407,529.10 rows=37,284 width=44) (actual rows= loops=)

  • Group Key: co.cid
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=6,362,988.83..7,403,241.44 rows=74,568 width=52) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=6,361,988.80..7,393,634.42 rows=37,284 width=52) (actual rows= loops=)

  • Group Key: co.cid
4. 0.000 0.000 ↓ 0.0

Sort (cost=6,361,988.80..6,441,317.48 rows=31,731,470 width=6) (actual rows= loops=)

  • Sort Key: co.cid
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,726.00..1,106,845.09 rows=31,731,470 width=6) (actual rows= loops=)

  • Hash Cond: (cr.offerid = co.offerid)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on course_registrations cr (cost=0.00..761,356.10 rows=31,731,470 width=6) (actual rows= loops=)

  • Filter: (grade IS NOT NULL)
7. 0.000 0.000 ↓ 0.0

Hash (cost=6,163.00..6,163.00 rows=400,000 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on course_offers co (cost=0.00..6,163.00 rows=400,000 width=8) (actual rows= loops=)