Unique (cost=18.14..18.15 rows=1 width=4) |
-> Sort (cost=18.14..18.15 rows=1 width=4) |
Sort Key: client.sales_rep |
-> Nested Loop Left Join (cost=0.56..18.13 rows=1 width=4) |
-> Nested Loop (cost=0.28..17.70 rows=1 width=4) |
-> Seq Scan on tbl_project_remind_receivers prr (cost=0.00..9.40 rows=1 width=4) |
Filter: (user_id = 1000) |
-> Index Scan using tbl_projects_pkey on tbl_projects p (cost=0.28..8.30 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) |