| Aggregate (cost=519.44..519.45 rows=1 width=8) |
| -> Group (cost=519.40..519.41 rows=2 width=4) |
| Group Key: c.id |
| -> Sort (cost=519.40..519.41 rows=2 width=4) |
| Sort Key: c.id |
| -> Hash Join (cost=299.32..519.39 rows=2 width=4) |
| Hash Cond: (ca.case_id = c.id) |
| -> Seq Scan on tbl_case_assignments ca (cost=0.00..217.55 rows=962 width=4) |
| Filter: ((assignment_status = ANY ('{1,2}'::integer[])) AND (engineer_id = 5085)) |
| -> Hash (cost=299.07..299.07 rows=20 width=8) |
| -> Seq Scan on tbl_cases c (cost=0.00..299.07 rows=20 width=8) |
| Filter: (case_status = ANY ('{1,2,3}'::integer[])) |