explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KVwc

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

Sort (cost=1,942.21..1,944.31 rows=839 width=807) (actual rows= loops=)

  • Sort Key: roles.name
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=211.55..1,901.47 rows=839 width=807) (actual rows= loops=)

  • Hash Cond: (roles.role_family_id = "roleFamily".id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=178.60..1,866.30 rows=839 width=755) (actual rows= loops=)

  • Hash Cond: (roles.id = skills_join.role_id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=49.98..1,734.09 rows=839 width=708) (actual rows= loops=)

  • Hash Cond: (features_join.role_id = roles.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=32.79..1,708.02 rows=3,356 width=205) (actual rows= loops=)

  • Hash Cond: (features_join.feature_id = features.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on roles_features features_join (cost=0.00..1,471.53 rows=77,053 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=32.46..32.46 rows=26 width=193) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on features (cost=0.00..32.46 rows=26 width=193) (actual rows= loops=)

  • Filter: (type <> 'ONET'::citext)
9. 0.000 0.000 ↓ 0.0

Hash (cost=15.75..15.75 rows=115 width=507) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on roles (cost=0.00..15.75 rows=115 width=507) (actual rows= loops=)

  • Filter: (company_id = 15631)
11. 0.000 0.000 ↓ 0.0

Hash (cost=128.33..128.33 rows=24 width=51) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.28..128.33 rows=24 width=51) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on roles_skills skills_join (cost=0.00..1.24 rows=24 width=12) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using skills_pkey on skills (cost=0.28..5.29 rows=1 width=43) (actual rows= loops=)

  • Index Cond: (skills_join.skill_id = id)
15. 0.000 0.000 ↓ 0.0

Hash (cost=20.20..20.20 rows=1,020 width=52) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on role_families "roleFamily" (cost=0.00..20.20 rows=1,020 width=52) (actual rows= loops=)