explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a7oh

Settings
# exclusive inclusive rows x rows loops node
1. 0.105 1,224.124 ↑ 1,250.0 3 1

Hash Join (cost=22,324.10..42,418.46 rows=3,750 width=8) (actual time=891.049..1,224.124 rows=3 loops=1)

  • Hash Cond: (sp_playlist_editions.sp_playlist_id = sp_playlists.id)
2. 0.035 1,215.118 ↑ 1,250.0 3 1

Hash Join (cost=21,630.58..41,715.09 rows=3,750 width=4) (actual time=882.046..1,215.118 rows=3 loops=1)

  • Hash Cond: (sp_playlist_listings.sp_playlist_edition_id = sp_playlist_editions.id)
3. 211.345 1,209.474 ↑ 1,292.0 3 1

Hash Join (cost=21,401.63..41,475.95 rows=3,876 width=4) (actual time=876.406..1,209.474 rows=3 loops=1)

  • Hash Cond: (sp_playlist_listings.sp_track_id = s.id)
4. 141.943 141.943 ↑ 1.0 776,103 1

Seq Scan on sp_playlist_listings (cost=0.00..18,037.03 rows=776,103 width=8) (actual time=0.017..141.943 rows=776,103 loops=1)

5. 0.018 856.186 ↑ 2,014.0 1 1

Hash (cost=21,376.45..21,376.45 rows=2,014 width=4) (actual time=856.186..856.186 rows=1 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
6. 856.168 856.168 ↑ 2,014.0 1 1

Seq Scan on sp_tracks s (cost=0.00..21,376.45 rows=2,014 width=4) (actual time=520.970..856.168 rows=1 loops=1)

  • Filter: ((isrc IS NOT NULL) AND ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = 'USRH10200195'::citext))
  • Rows Removed by Filter: 403,282
7. 2.665 5.609 ↑ 1.0 6,829 1

Hash (cost=143.59..143.59 rows=6,829 width=8) (actual time=5.609..5.609 rows=6,829 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 331kB
8. 2.944 2.944 ↑ 1.0 6,829 1

Seq Scan on sp_playlist_editions (cost=0.00..143.59 rows=6,829 width=8) (actual time=0.038..2.944 rows=6,829 loops=1)

  • Filter: current
  • Rows Removed by Filter: 230
9. 3.838 8.901 ↑ 1.0 9,890 1

Hash (cost=569.90..569.90 rows=9,890 width=8) (actual time=8.901..8.901 rows=9,890 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 503kB
10. 5.063 5.063 ↑ 1.0 9,890 1

Seq Scan on sp_playlists (cost=0.00..569.90 rows=9,890 width=8) (actual time=0.013..5.063 rows=9,890 loops=1)

Planning time : 1.718 ms
Execution time : 1,224.290 ms