Unique (cost=146.17..146.28 rows=11 width=4) |
-> Sort (cost=146.17..146.23 rows=21 width=4) |
Sort Key: client.sales_rep |
-> Nested Loop Left Join (cost=0.56..145.71 rows=21 width=4) |
-> Nested Loop (cost=0.28..136.70 rows=21 width=4) |
-> Seq Scan on tbl_project_remind_receivers prr (cost=0.00..10.45 rows=21 width=4) |
Filter: (user_id = 1004) |
-> Index Scan using tbl_projects_pkey on tbl_projects p (cost=0.28..6.01 rows=1 width=8) |
Index Cond: (id = prr.project_id) |
-> Index Scan using tbl_clients_pkey on tbl_clients client (cost=0.28..0.43 rows=1 width=8) |
Index Cond: (id = p.client_id) |