| GroupAggregate (cost=1598.44..1601.96 rows=176 width=53) |
| Group Key: sub.id, sub.name |
| -> Sort (cost=1598.44..1598.88 rows=176 width=49) |
| Sort Key: sub.id, sub.name |
| -> Subquery Scan on sub (cost=1588.80..1591.88 rows=176 width=49) |
| -> Group (cost=1588.80..1590.12 rows=176 width=49) |
| Group Key: client.id, c.project_id |
| -> Sort (cost=1588.80..1589.24 rows=176 width=49) |
| Sort Key: client.id, c.project_id |
| -> Hash Left Join (cost=1323.25..1582.24 rows=176 width=49) |
| Hash Cond: (c.client_id = client.id) |
| -> Hash Join (cost=1190.34..1448.86 rows=176 width=8) |
| Hash Cond: (ca.case_id = c.id) |
| -> Seq Scan on tbl_case_assignments ca (cost=0.00..242.52 rows=6094 width=4) |
| Filter: (engineer_id = ANY ('{1017,5085,1001,5248,1015,1022,5296,1023}'::integer[])) |
| -> Hash (cost=1187.47..1187.47 rows=229 width=12) |
| -> Subquery Scan on c (cost=1184.04..1187.47 rows=229 width=12) |
| -> Group (cost=1184.04..1185.18 rows=229 width=285) |
| Group Key: c_1.id |
| -> Sort (cost=1184.04..1184.61 rows=229 width=12) |
| Sort Key: c_1.id |
| -> Hash Right Join (cost=1052.63..1175.06 rows=229 width=12) |
| Hash Cond: (cs.case_id = c_1.id) |
| -> Seq Scan on tbl_case_services cs (cost=0.00..104.66 rows=6766 width=4) |
| -> Hash (cost=1049.77..1049.77 rows=229 width=12) |
| -> Seq Scan on tbl_cases c_1 (cost=0.00..1049.77 rows=229 width=12) |
| Filter: ((project_id IS NOT NULL) AND (case_type = 2) AND (((case_status = 5) AND (closed_at >= '2025-01-01 00:00:00+08'::timestamp with time zone) AND (closed_at <= '2025-12-31 23:59:59+08'::timestamp with time zone)) OR ((case_status = ANY ('{3,1,2,4}'::integer[])) AND (start_at >= '2025-01-01 00:00:00+08'::timestamp with time zone) AND (start_at <= '2025-12-31 23:59:59+08'::timestamp with time zone))) AND ((deduct_points_from = ANY ('{1001,5049,5301,5022,5209,5026,5293,5309,5356,5329,5299,5303,5302,5332,5047,1026,5096,5070,5448,5420,1029,5037,5087,1008,5048,5043,5045,5230,5031,5088,5208,1003,5294,5357,5044,1030,5076,5300,5027,5089,5311,5066,5069,5364,1009,5295,1013,5128,5203,1025,5032,5075,1004,5072,5033,5359,5412,5409,5229,1005,5304,5449,5358,1006,5093}'::integer[])) OR (deduct_points_from IS NULL))) |
| -> Hash (cost=107.96..107.96 rows=1996 width=45) |
| -> Seq Scan on tbl_clients client (cost=0.00..107.96 rows=1996 width=45) |