QUERY PLAN
Sort (cost=99.51..99.52 rows=1 width=191)
Sort Key: s.created_at
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=191)
Group Key: s.id
-> Sort (cost=51.36..51.36 rows=1 width=191)
Sort Key: s.id
-> Seq Scan on tbl_tasks s (cost=0.00..51.35 rows=1 width=191)
Filter: ((tree_path @> $0) AND (parent_id = 1596))