| GroupAggregate (cost=262.08..262.60 rows=14 width=76) |
| Group Key: pa.engineer_id |
| -> Sort (cost=262.08..262.11 rows=14 width=50) |
| Sort Key: pa.engineer_id |
| -> Hash Join (cost=244.53..261.81 rows=14 width=50) |
| Hash Cond: (pa.project_id = p.id) |
| -> HashAggregate (cost=42.37..50.97 rows=688 width=40) |
| Group Key: pa.engineer_id, pa.project_id |
| -> Seq Scan on tbl_project_architects pa (cost=0.00..36.99 rows=717 width=12) |
| Filter: (engineer_id = ANY ('{5085,5248,1015,1022,5064,1023}'::integer[])) |
| -> Hash (cost=201.37..201.37 rows=63 width=14) |
| -> Seq Scan on tbl_projects p (cost=0.00..201.37 rows=63 width=14) |
| Filter: ((bargain_date >= '2025-01-01'::date) AND (bargain_date <= '2025-06-15'::date) AND (project_status = 3)) |