QUERY PLAN
Aggregate (cost=96.43..96.44 rows=1 width=8)
-> Sort (cost=96.41..96.42 rows=1 width=224)
Sort Key: s.created_at DESC
InitPlan 1 (returns $0)
-> Aggregate (cost=46.63..46.64 rows=1 width=32)
-> Seq Scan on tbl_tasks s_1 (cost=0.00..43.50 rows=1250 width=13)
Filter: (tree_path IS NOT NULL)
-> Group (cost=49.76..49.77 rows=1 width=224)
Group Key: s.id
-> Sort (cost=49.76..49.77 rows=1 width=12)
Sort Key: s.id
-> Seq Scan on tbl_tasks s (cost=0.00..49.75 rows=1 width=12)
Filter: ((parent_id IS NULL) AND (tree_path @> $0) AND (task_group_id = 203))