QUERY PLAN
Limit (cost=96.41..96.42 rows=1 width=191)
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)
-> Sort (cost=49.78..49.78 rows=1 width=191)
Sort Key: s.created_at DESC
-> Group (cost=49.76..49.77 rows=1 width=191)
Group Key: s.id
-> Sort (cost=49.76..49.77 rows=1 width=191)
Sort Key: s.id
-> Seq Scan on tbl_tasks s (cost=0.00..49.75 rows=1 width=191)
Filter: ((parent_id IS NULL) AND (tree_path @> $0) AND (task_group_id = 203))