QUERY PLAN
Sort (cost=299.73..299.73 rows=1 width=248)
Sort Key: s.created_at DESC
InitPlan 1 (returns $0)
-> Aggregate (cost=146.94..146.95 rows=1 width=32)
-> Seq Scan on tbl_tasks s_1 (cost=0.00..146.82 rows=44 width=13)
Filter: ((tree_path IS NOT NULL) AND (head_of = 1001))
-> Group (cost=152.76..152.77 rows=1 width=248)
Group Key: s.id
-> Sort (cost=152.76..152.77 rows=1 width=248)
Sort Key: s.id
-> Seq Scan on tbl_tasks s (cost=0.00..152.75 rows=1 width=248)
Filter: ((tree_path @> $0) AND (head_of = 1001) AND (parent_id = 1569))