| Aggregate (cost=509.91..509.92 rows=1 width=8) |
| -> Group (cost=509.89..509.90 rows=1 width=4) |
| Group Key: c.id |
| -> Sort (cost=509.89..509.89 rows=1 width=4) |
| Sort Key: c.id |
| -> Nested Loop (cost=288.48..509.88 rows=1 width=4) |
| -> Hash Right Join (cost=288.21..472.14 rows=5 width=8) |
| Hash Cond: (ca.case_id = c.id) |
| -> Seq Scan on tbl_case_assignments ca (cost=0.00..162.94 rows=7994 width=4) |
| -> Hash (cost=288.14..288.14 rows=5 width=8) |
| -> Seq Scan on tbl_cases c (cost=0.00..288.14 rows=5 width=8) |
| Filter: (case_status = ANY ('{1,2,3,4}'::integer[])) |
| -> Index Scan using tbl_clients_pkey on tbl_clients cl (cost=0.28..7.50 rows=1 width=4) |
| Index Cond: (id = c.client_id) |
| Filter: (sales_rep = 1001) |