QUERY PLAN
Aggregate (cost=225.66..225.67 rows=1 width=8)
-> Nested Loop (cost=0.00..225.66 rows=1 width=4)
Join Filter: (otc.operation_task_id = ot.id)
-> Seq Scan on tbl_operation_task_contacts otc (cost=0.00..219.30 rows=1 width=8)
Filter: ((complete_at >= '2026-07-01 00:00:00+08'::timestamp with time zone) AND (complete_at <= '2026-07-01 23:59:59+08'::timestamp with time zone))
-> Seq Scan on tbl_operation_tasks ot (cost=0.00..6.17 rows=15 width=4)
Filter: (head_of = ANY ('{5500,5499,5332,1001,5087,5300,5311,5295,1013,5476,1004,1005}'::integer[]))