explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yrl6

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.048 ↑ 5.0 1 1

Nested Loop (cost=0.99..60.40 rows=5 width=8) (actual time=0.047..0.048 rows=1 loops=1)

2. 0.003 0.037 ↑ 5.0 1 1

Nested Loop (cost=0.71..55.68 rows=5 width=4) (actual time=0.036..0.037 rows=1 loops=1)

3. 0.023 0.023 ↑ 5.0 1 1

Index Scan using index_sp_playlist_listings_on_sp_track_id on sp_playlist_listings (cost=0.42..14.18 rows=5 width=4) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: (sp_track_id = 418,492)
4. 0.011 0.011 ↑ 1.0 1 1

Index Scan using sp_playlist_editions_pkey on sp_playlist_editions (cost=0.28..8.30 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = sp_playlist_listings.sp_playlist_edition_id)
  • Filter: current
5. 0.010 0.010 ↑ 1.0 1 1

Index Scan using sp_playlists_pkey on sp_playlists (cost=0.29..0.94 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = sp_playlist_editions.sp_playlist_id)
Planning time : 1.905 ms
Execution time : 0.134 ms