explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ppxO

Settings

Optimization(s) for this plan:

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

Limit (cost=2,944,777.87..2,975,775.52 rows=15 width=582) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..4,046,227.85 rows=1,958 width=582) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan Backward using albums_albumstatuscode_idx on albums a (cost=0.29..638.49 rows=1,958 width=493) (actual rows= loops=)

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

Index Scan using users_idx_id on users u (cost=0.42..1.90 rows=1 width=89) (actual rows= loops=)

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

SubPlan (for Nested Loop Left Join)

6. 0.000 0.000 ↓ 0.0

Aggregate (cost=2,064.28..2,064.29 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.43..2,059.49 rows=1,915 width=8) (actual rows= loops=)

  • Index Cond: (albumid = a.id)