explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TLnq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=5,343,402.51..5,399,648.85 rows=15 width=1,581) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..7,533,259.81 rows=2,009 width=1,581) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using albums_idx_ismixtape_albumstatu_createdon on albums a (cost=0.29..660.27 rows=2,009 width=493) (actual rows= loops=)

  • Index Cond: ((ismixtape = false) AND (albumstatuscode = 2))
  • Filter: (NOT ismixtape)
4. 0.000 0.000 ↓ 0.0

Index Scan using users_idx_id on users u (cost=0.42..1.80 rows=1 width=1,088) (actual rows= loops=)

  • Index Cond: (id = a.uploadedby)
5.          

SubPlan (for Nested Loop Left Join)

6. 0.000 0.000 ↓ 0.0

Aggregate (cost=3,747.60..3,747.61 rows=1 width=8) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Only Scan using albumviews_idx_albumid on albumviews (cost=0.44..3,737.98 rows=3,850 width=8) (actual rows= loops=)

  • Index Cond: (albumid = a.id)