explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AlHl : Eric shuffled

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 6,738.740 ↓ 4.0 20 1

Sort (cost=243,440.05..243,440.06 rows=5 width=16) (actual time=6,738.736..6,738.740 rows=20 loops=1)

  • Sort Key: r.monthly_release_year, r.monthly_release_month
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=57284 read=133742
2.          

CTE numbers

3. 0.027 6,738.645 ↑ 1.0 20 1

Finalize GroupAggregate (cost=243,437.92..243,438.42 rows=20 width=12) (actual time=6,738.611..6,738.645 rows=20 loops=1)

  • Group Key: q.release_key
  • Buffers: shared hit=57283 read=133742
4. 0.000 6,738.618 ↓ 1.5 60 1

Sort (cost=243,437.92..243,438.02 rows=40 width=12) (actual time=6,738.605..6,738.618 rows=60 loops=1)

  • Sort Key: q.release_key
  • Sort Method: quicksort Memory: 27kB
  • Buffers: shared hit=57283 read=133742
5. 18.039 6,739.459 ↓ 1.5 60 1

Gather (cost=243,432.65..243,436.85 rows=40 width=12) (actual time=6,738.539..6,739.459 rows=60 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=57283 read=133742
6. 2,140.782 6,721.420 ↑ 1.0 20 3

Partial HashAggregate (cost=242,432.65..242,432.85 rows=20 width=12) (actual time=6,721.413..6,721.420 rows=20 loops=3)

  • Group Key: q.release_key
  • Buffers: shared hit=57283 read=133742
7. 4,580.638 4,580.638 ↑ 1.2 2,741,907 3

Parallel Seq Scan on dfo_by_quarter q (cost=0.00..225,296.77 rows=3,427,177 width=4) (actual time=0.103..4,580.638 rows=2,741,907 loops=3)

  • Buffers: shared hit=57283 read=133742
8. 0.033 6,738.719 ↓ 4.0 20 1

Hash Join (cost=1.11..1.58 rows=5 width=16) (actual time=6,738.662..6,738.719 rows=20 loops=1)

  • Hash Cond: (n.release_key = r.release_id)
  • Buffers: shared hit=57284 read=133742
9. 6,738.660 6,738.660 ↑ 1.0 20 1

CTE Scan on numbers n (cost=0.00..0.40 rows=20 width=12) (actual time=6,738.614..6,738.660 rows=20 loops=1)

  • Buffers: shared hit=57283 read=133742
10. 0.010 0.026 ↓ 4.0 20 1

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

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

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

  • Buffers: shared hit=1