explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8roM

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

Sort (cost=340,571.07..340,571.08 rows=5 width=16) (actual rows= loops=)

  • Sort Key: r.monthly_release_year, r.monthly_release_month
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=340,570.96..340,571.01 rows=5 width=16) (actual rows= loops=)

  • Group Key: r.release_id
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1.11..299,444.84 rows=8,225,224 width=8) (actual rows= loops=)

  • Hash Cond: (q.release_key = r.release_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on dfo_by_quarter q (cost=0.00..273,277.24 rows=8,225,224 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=1.05..1.05 rows=5 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on dfo_release r (cost=0.00..1.05 rows=5 width=8) (actual rows= loops=)