| GroupAggregate (cost=261.90..262.35 rows=12 width=76) |
| Group Key: pa.engineer_id |
| -> Sort (cost=261.90..261.93 rows=12 width=50) |
| Sort Key: pa.engineer_id |
| -> Hash Join (cost=244.40..261.69 rows=12 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=53 width=14) |
| -> Seq Scan on tbl_projects p (cost=0.00..201.37 rows=53 width=14) |
| Filter: ((bargain_date >= '2026-01-01'::date) AND (bargain_date <= '2026-12-31'::date) AND (project_status = 3)) |