Group (cost=13.46..13.53 rows=1 width=40) |
Group Key: u.id, srsb.id |
-> Sort (cost=13.46..13.46 rows=1 width=186) |
Sort Key: srsb.id |
-> Nested Loop Left Join (cost=0.00..13.45 rows=1 width=186) |
-> Nested Loop Left Join (cost=0.00..12.43 rows=1 width=22) |
Join Filter: (u.id = aa.user_id) |
-> Seq Scan on tbl_users u (cost=0.00..7.76 rows=1 width=22) |
Filter: (id = 1001) |
-> Seq Scan on tbl_auth_assignments aa (cost=0.00..4.64 rows=2 width=4) |
Filter: (user_id = 1001) |
-> Seq Scan on tbl_sales_rep_score_bases srsb (cost=0.00..1.01 rows=1 width=164) |