| HashAggregate (cost=340.19..340.29 rows=10 width=4) |
| Group Key: client.sales_rep |
| -> Hash Left Join (cost=149.10..338.75 rows=578 width=4) |
| Hash Cond: (p.client_id = client.id) |
| -> Hash Join (cost=19.65..207.79 rows=578 width=4) |
| Hash Cond: (p.id = prr.project_id) |
| -> Seq Scan on tbl_projects p (cost=0.00..167.57 rows=2957 width=8) |
| -> Hash (cost=12.43..12.43 rows=578 width=4) |
| -> Seq Scan on tbl_project_remind_receivers prr (cost=0.00..12.43 rows=578 width=4) |
| Filter: (user_id = 1001) |
| -> Hash (cost=105.31..105.31 rows=1931 width=8) |
| -> Seq Scan on tbl_clients client (cost=0.00..105.31 rows=1931 width=8) |