QUERY PLAN
HashAggregate (cost=136.13..136.52 rows=39 width=12)
Group Key: remain_task.task_group_id
-> Hash Anti Join (cost=61.02..135.87 rows=52 width=4)
Hash Cond: (remain_task.id = child_task.parent_id)
-> Seq Scan on tbl_tasks remain_task (cost=0.00..73.93 rows=53 width=8)
Filter: ((status <> 1) AND (task_group_id = ANY ('{206,203,202,201,189,188,187,94,90,88,87,85,83,79,78,74}'::integer[])))
-> Hash (cost=44.90..44.90 rows=1290 width=4)
-> Seq Scan on tbl_tasks child_task (cost=0.00..44.90 rows=1290 width=4)