| HashAggregate (cost=42.55..72.26 rows=360 width=40) |
| Group Key: u.id, esb.id |
| -> Nested Loop Left Join (cost=0.14..40.76 rows=360 width=392) |
| -> Nested Loop Left Join (cost=0.14..23.55 rows=1 width=196) |
| Join Filter: (u.id = aa.user_id) |
| -> Index Scan using tbl_users_pkey on tbl_users u (cost=0.14..8.15 rows=1 width=196) |
| Index Cond: (id = 5495) |
| -> Seq Scan on tbl_auth_assignments aa (cost=0.00..15.38 rows=2 width=4) |
| Filter: (user_id = 5495) |
| -> Seq Scan on tbl_engineer_score_bases esb (cost=0.00..13.60 rows=360 width=196) |