explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jlqc

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

Nested Loop Left Join (cost=9.44..81.10 rows=1 width=2,591) (actual rows= loops=)

  • Join Filter: (uo.user_id = u.id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=9.15..64.63 rows=1 width=2,059) (actual rows= loops=)

  • Join Filter: (ua.user_id = u.id)
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.87..56.31 rows=1 width=2,052) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.73..47.84 rows=1 width=1,540) (actual rows= loops=)

  • Join Filter: (pr.profile_id = p.id)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.73..36.43 rows=1 width=1,536) (actual rows= loops=)

  • Join Filter: (s.id = p.school_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=8.60..28.27 rows=1 width=1,020) (actual rows= loops=)

  • Join Filter: (p.user_id = u.id)
7. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users u (cost=0.29..8.30 rows=1 width=975) (actual rows= loops=)

  • Index Cond: (id = 1000000023)
  • Filter: (deleted_at IS NULL)
8. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=8.31..19.96 rows=1 width=45) (actual rows= loops=)

  • Hash Cond: (c.profile_id = p.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on competences c (cost=0.00..11.30 rows=130 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=41) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using index_profiles_on_user_id on profiles p (cost=0.29..8.30 rows=1 width=41) (actual rows= loops=)

  • Index Cond: (user_id = 1000000023)
  • Filter: (deleted_at IS NULL)
12. 0.000 0.000 ↓ 0.0

Index Scan using schools_pkey on schools s (cost=0.12..8.14 rows=1 width=520) (actual rows= loops=)

  • Filter: (deleted_at IS NULL)
13. 0.000 0.000 ↓ 0.0

Seq Scan on profile_roles pr (cost=0.00..11.40 rows=1 width=8) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (role_id IS NOT NULL))
14. 0.000 0.000 ↓ 0.0

Index Scan using roles_pkey on roles r (cost=0.14..8.16 rows=1 width=520) (actual rows= loops=)

  • Index Cond: (id = pr.role_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using user_activities_user_id_idx on user_activities ua (cost=0.29..8.30 rows=1 width=11) (actual rows= loops=)

  • Index Cond: (user_id = 1000000023)
16. 0.000 0.000 ↓ 0.0

Index Scan using user_organization_user_id on user_organization uo (cost=0.29..8.30 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (user_id = 1000000023)
17.          

SubPlan (for Nested Loop Left Join)

18. 0.000 0.000 ↓ 0.0

Index Scan using publish_houses_pkey on publishing_houses (cost=0.14..8.16 rows=1 width=516) (actual rows= loops=)

  • Index Cond: (id = p.publishing_house_id)