| GroupAggregate (cost=262.46..263.14 rows=18 width=76) |
| Group Key: pa.engineer_id |
| -> Sort (cost=262.46..262.51 rows=18 width=50) |
| Sort Key: pa.engineer_id |
| -> Hash Join (cost=244.80..262.09 rows=18 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=85 width=14) |
| -> Seq Scan on tbl_projects p (cost=0.00..201.37 rows=85 width=14) |
| Filter: ((bargain_date >= '2025-07-19'::date) AND (bargain_date <= '2025-12-31'::date) AND (project_status = 3)) |