explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cnQZ : Optimization for: plan #bOZJ

Settings

Optimization path:

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

Limit (cost=144,667,058,275.21..144,667,058,277.54 rows=20 width=128) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=144,667,058,275.21..144,667,545,706.64 rows=4,177,692 width=128) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=144,667,057,275.18..144,667,062,497.30 rows=2,088,846 width=128) (actual rows= loops=)

  • Sort Key: trackr_song.spins DESC
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on trackr_song (cost=0.43..144,666,760,490.15 rows=2,088,846 width=128) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
5.          

SubPlan (forParallel Seq Scan)

6. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..67,374.29 rows=753,083 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Unique (cost=0.43..60,666.88 rows=753,083 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using matching_match_song_id_2cec8c63 on matching_match u0 (cost=0.43..55,400.53 rows=2,106,540 width=4) (actual rows= loops=)