QUERY PLAN
HashAggregate (cost=143.18..143.66 rows=48 width=12)
Group Key: remain_task.task_group_id
-> Hash Anti Join (cost=61.02..142.83 rows=71 width=4)
Hash Cond: (remain_task.id = child_task.parent_id)
-> Seq Scan on tbl_tasks remain_task (cost=0.00..80.38 rows=73 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=44.90..44.90 rows=1290 width=4)
-> Seq Scan on tbl_tasks child_task (cost=0.00..44.90 rows=1290 width=4)