explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sUwM

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 427.264 ↑ 1,250.0 3 1

Hash Join (cost=6,516.83..26,611.18 rows=3,750 width=8) (actual time=35.239..427.264 rows=3 loops=1)

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

Hash Join (cost=5,823.30..25,907.81 rows=3,750 width=4) (actual time=27.219..419.239 rows=3 loops=1)

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

Hash Join (cost=5,594.35..25,668.67 rows=3,876 width=4) (actual time=22.279..414.295 rows=3 loops=1)

  • Hash Cond: (sp_playlist_listings.sp_track_id = s.id)
4. 165.382 165.382 ↑ 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.029..165.382 rows=776,103 loops=1)

5. 0.018 0.158 ↑ 2,014.0 1 1

Hash (cost=5,569.17..5,569.17 rows=2,014 width=4) (actual time=0.158..0.158 rows=1 loops=1)

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

Bitmap Heap Scan on sp_tracks s (cost=48.05..5,569.17 rows=2,014 width=4) (actual time=0.139..0.140 rows=1 loops=1)

  • Recheck Cond: ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = 'USRH10200195'::citext)
  • Filter: (isrc IS NOT NULL)
  • Heap Blocks: exact=1
7. 0.113 0.113 ↑ 2,016.0 1 1

Bitmap Index Scan on index_sp_tracks_on_sanitized_isrc (cost=0.00..47.54 rows=2,016 width=0) (actual time=0.113..0.113 rows=1 loops=1)

  • Index Cond: ((upper(replace((isrc)::text, '-'::text, ''::text)))::citext = 'USRH10200195'::citext)
8. 2.377 4.921 ↑ 1.0 6,829 1

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

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

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

  • Filter: current
  • Rows Removed by Filter: 230
10. 3.563 7.997 ↑ 1.0 9,890 1

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

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

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

Planning time : 2.407 ms
Execution time : 430.464 ms