QUERY PLAN
Aggregate (cost=99.53..99.54 rows=1 width=8)
-> Sort (cost=99.51..99.52 rows=1 width=224)
Sort Key: s.created_at DESC
InitPlan 1 (returns $0)
-> Aggregate (cost=48.13..48.14 rows=1 width=32)
-> Seq Scan on tbl_tasks s_1 (cost=0.00..44.90 rows=1290 width=13)
Filter: (tree_path IS NOT NULL)
-> Group (cost=51.36..51.37 rows=1 width=224)
Group Key: s.id
-> Sort (cost=51.36..51.36 rows=1 width=12)
Sort Key: s.id
-> Seq Scan on tbl_tasks s (cost=0.00..51.35 rows=1 width=12)
Filter: ((parent_id IS NULL) AND (tree_path @> $0) AND (task_group_id = 206))