Aggregate (cost=225.60..225.61 rows=1 width=8) |
-> Nested Loop (cost=0.00..225.60 rows=1 width=4) |
Join Filter: (otc.operation_task_id = ot.id) |
-> Seq Scan on tbl_operation_task_contacts otc (cost=0.00..219.41 rows=1 width=8) |
Filter: ((complete_at >= '2025-08-04 00:00:00+08'::timestamp with time zone) AND (complete_at <= '2025-08-04 23:59:59+08'::timestamp with time zone)) |
-> Seq Scan on tbl_operation_tasks ot (cost=0.00..6.06 rows=10 width=4) |
Filter: (head_of = ANY ('{5332,1001,5087,5300,5311,5295,1013,1004,1005,5449}'::integer[])) |