HashAggregate (cost=340.57..340.68 rows=11 width=4) |
Group Key: client.sales_rep |
-> Hash Left Join (cost=326.55..339.42 rows=461 width=4) |
Hash Cond: (p.client_id = client.id) |
-> Hash Join (cost=198.11..209.77 rows=461 width=4) |
Hash Cond: (prr.project_id = p.id) |
-> Seq Scan on tbl_project_remind_receivers prr (cost=0.00..10.45 rows=461 width=4) |
Filter: (user_id = 1001) |
-> Hash (cost=163.05..163.05 rows=2805 width=8) |
-> Seq Scan on tbl_projects p (cost=0.00..163.05 rows=2805 width=8) |
-> Hash (cost=104.86..104.86 rows=1886 width=8) |
-> Seq Scan on tbl_clients client (cost=0.00..104.86 rows=1886 width=8) |