explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ymya

Settings
# exclusive inclusive rows x rows loops node
1. 0.461 1,737.933 ↓ 402.0 402 1

Nested Loop (cost=1.71..11,494.60 rows=1 width=138) (actual time=0.504..1,737.933 rows=402 loops=1)

2. 3.504 1,729.030 ↓ 402.0 402 1

Nested Loop (cost=1.28..11,492.15 rows=1 width=134) (actual time=0.492..1,729.030 rows=402 loops=1)

3. 2.012 1,707.064 ↓ 49.6 3,077 1

Nested Loop (cost=0.87..11,464.73 rows=62 width=77) (actual time=0.478..1,707.064 rows=3,077 loops=1)

4. 0.272 0.272 ↑ 1.0 154 1

Index Scan using index_it_songs_on_it_account_id on it_songs (cost=0.43..155.19 rows=158 width=45) (actual time=0.010..0.272 rows=154 loops=1)

  • Index Cond: (it_account_id = 5,648)
5. 1,704.780 1,704.780 ↑ 3.5 20 154

Index Scan using index_am_processed_playlist_listings_on_it_song_id_and_current on am_processed_playlist_listings (cost=0.43..70.89 rows=69 width=40) (actual time=0.492..11.070 rows=20 loops=154)

  • Index Cond: (it_song_id = it_songs.id)
6. 18.462 18.462 ↓ 0.0 0 3,077

Index Scan using am_playlists_pkey on am_playlists (cost=0.41..0.44 rows=1 width=65) (actual time=0.006..0.006 rows=0 loops=3,077)

  • Index Cond: (id = am_processed_playlist_listings.am_playlist_id)
  • Filter: ((name)::text ~~ 'Top 100: %'::text)
  • Rows Removed by Filter: 1
7. 8.442 8.442 ↑ 1.0 1 402

Index Scan using it_collections_pkey on it_collections (cost=0.43..2.45 rows=1 width=12) (actual time=0.021..0.021 rows=1 loops=402)

  • Index Cond: (id = it_songs.it_collection_id)
Planning time : 0.780 ms
Execution time : 1,738.056 ms