HashAggregate (cost=476.84..476.94 rows=10 width=4) |
Group Key: client.sales_rep |
-> Hash Left Join (cost=151.63..475.46 rows=553 width=4) |
Hash Cond: (p.client_id = client.id) |
-> Hash Join (cost=18.73..341.10 rows=553 width=4) |
Hash Cond: (p.id = prr.project_id) |
-> Seq Scan on tbl_projects p (cost=0.00..302.23 rows=2923 width=8) |
-> Hash (cost=11.81..11.81 rows=553 width=4) |
-> Seq Scan on tbl_project_remind_receivers prr (cost=0.00..11.81 rows=553 width=4) |
Filter: (user_id = 1001) |
-> Hash (cost=107.96..107.96 rows=1996 width=8) |
-> Seq Scan on tbl_clients client (cost=0.00..107.96 rows=1996 width=8) |