explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1CDe

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.051 ↑ 1.2 4 1

Nested Loop (cost=0.71..55.37 rows=5 width=8) (actual time=0.029..0.051 rows=4 loops=1)

2. 0.019 0.019 ↑ 1.2 4 1

Index Scan using index_processed_sp_playlist_listings_on_sp_track_id on processed_sp_playlist_listings (cost=0.42..13.85 rows=5 width=8) (actual time=0.014..0.019 rows=4 loops=1)

  • Index Cond: (sp_track_id = 541,076)
  • Filter: current
3. 0.028 0.028 ↑ 1.0 1 4

Index Scan using sp_playlists_pkey on sp_playlists (cost=0.29..8.30 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=4)

  • Index Cond: (id = processed_sp_playlist_listings.sp_playlist_id)
Planning time : 0.481 ms
Execution time : 0.099 ms