GroupAggregate (cost=1333.46..1334.20 rows=42 width=12) |
Group Key: client_id |
-> Sort (cost=1333.46..1333.56 rows=43 width=8) |
Sort Key: client_id |
-> Bitmap Heap Scan on tbl_work_logs (cost=45.64..1332.29 rows=43 width=8) |
Recheck Cond: (client_id = ANY ('{2125,85,2138,3326,57,101,2205,1276,20}'::integer[])) |
Filter: ((NOT is_draft) 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)) |
-> Bitmap Index Scan on tbl_work_logs_client_id_idx (cost=0.00..45.63 rows=938 width=0) |
Index Cond: (client_id = ANY ('{2125,85,2138,3326,57,101,2205,1276,20}'::integer[])) |