QUERY PLAN
HashAggregate (cost=138.73..139.20 rows=47 width=12)
Group Key: remain_task.task_group_id
-> Hash Anti Join (cost=59.12..138.39 rows=68 width=4)
Hash Cond: (remain_task.id = child_task.parent_id)
-> Seq Scan on tbl_tasks remain_task (cost=0.00..77.88 rows=70 width=8)
Filter: ((status <> 1) AND (task_group_id = ANY ('{203,139,106,96,94,90,89,88,87,85,84,83,80,79,78,76,75,74,73,72}'::integer[])))
-> Hash (cost=43.50..43.50 rows=1250 width=4)
-> Seq Scan on tbl_tasks child_task (cost=0.00..43.50 rows=1250 width=4)