explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6nPh

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

Sort (cost=2,021.06..2,021.16 rows=209 width=5,302) (actual rows= loops=)

  • Sort Key: p0.name, p0.inserted_at DESC
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1,010.05..2,019.45 rows=209 width=5,302) (actual rows= loops=)

  • Hash Cond: (p1.cloned_from = p0.id)
3. 0.000 0.000 ↓ 0.0

Index Scan using programs_user_id_index on programs p1 (cost=0.08..1,009.24 rows=456 width=2,651) (actual rows= loops=)

  • Index Cond: (user_id = 19,679)
  • Filter: (NOT archived)
4. 0.000 0.000 ↓ 0.0

Hash (cost=1,009.24..1,009.24 rows=209 width=2,651) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using programs_user_id_index on programs p0 (cost=0.08..1,009.24 rows=209 width=2,651) (actual rows= loops=)

  • Index Cond: (user_id = 19,679)
  • Filter: ((cloned_from IS NULL) AND (NOT archived))