explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CqUA

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 15,152.294 ↓ 4.0 20 1

Sort (cost=340,571.07..340,571.08 rows=5 width=16) (actual time=15,152.290..15,152.294 rows=20 loops=1)

  • Sort Key: r.monthly_release_year, r.monthly_release_month
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=57461 read=133565
2. 2,733.972 15,152.262 ↓ 4.0 20 1

HashAggregate (cost=340,570.96..340,571.01 rows=5 width=16) (actual time=15,152.256..15,152.262 rows=20 loops=1)

  • Group Key: r.release_id
  • Buffers: shared hit=57461 read=133565
3. 4,399.438 12,418.290 ↓ 1.0 8,225,722 1

Hash Right Join (cost=1.11..299,444.84 rows=8,225,224 width=8) (actual time=0.723..12,418.290 rows=8,225,722 loops=1)

  • Hash Cond: (q.release_key = r.release_id)
  • Buffers: shared hit=57461 read=133565
4. 8,018.828 8,018.828 ↓ 1.0 8,225,722 1

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

  • Buffers: shared hit=57460 read=133565
5. 0.010 0.024 ↓ 4.0 20 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.024..0.024 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
6. 0.014 0.014 ↓ 4.0 20 1

Seq Scan on dfo_release r (cost=0.00..1.05 rows=5 width=8) (actual time=0.006..0.014 rows=20 loops=1)

  • Buffers: shared hit=1