explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q2uT

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 2.319 ↓ 5.8 150 1

Limit (cost=759.78..759.84 rows=26 width=1,903) (actual time=2.290..2.319 rows=150 loops=1)

2. 1.811 2.300 ↓ 5.8 150 1

Sort (cost=759.78..759.84 rows=26 width=1,903) (actual time=2.289..2.300 rows=150 loops=1)

  • Sort Key: t0."position", t0.internal_position DESC
  • Sort Method: quicksort Memory: 322kB
3. 0.195 0.489 ↓ 11.3 293 1

Nested Loop (cost=0.85..759.17 rows=26 width=1,903) (actual time=0.067..0.489 rows=293 loops=1)

4. 0.044 0.044 ↑ 1.0 1 1

Index Scan using playlists_name_index on playlists p1 (cost=0.42..8.44 rows=1 width=879) (actual time=0.043..0.044 rows=1 loops=1)

  • Index Cond: ((name)::text = 'golden-state-warriors_ts'::text)
5. 0.250 0.250 ↓ 1.5 293 1

Index Scan using tracks_playlist_id_index on tracks t0 (cost=0.43..748.72 rows=201 width=1,024) (actual time=0.019..0.250 rows=293 loops=1)

  • Index Cond: (playlist_id = p1.id)