QUERY PLAN
Sort (cost=99.65..99.65 rows=1 width=191)
Sort Key: s.created_at
InitPlan 1 (returns $0)
-> Aggregate (cost=46.73..46.74 rows=1 width=32)
-> Seq Scan on tbl_tasks s_1 (cost=0.00..46.62 rows=43 width=13)
Filter: ((tree_path IS NOT NULL) AND (status = '0'::smallint))
-> Group (cost=52.88..52.89 rows=1 width=191)
Group Key: s.id
-> Sort (cost=52.88..52.89 rows=1 width=191)
Sort Key: s.id
-> Seq Scan on tbl_tasks s (cost=0.00..52.88 rows=1 width=191)
Filter: ((tree_path @> $0) AND (status = '0'::smallint) AND (parent_id = 1667))