duration: 23.487 ms
“Query Text”: “\nupdate comment_aggregates ca set child_count = c.child_count\nfrom (\n select c.id, c.path, count(c2.id) as child_count from comment c\n join comment c2 on c2.path <@ c.path and c2.path != c.path\n and c.path <@ ‘0.1571057’\n group by c.id\n) as c\nwhere ca.comment_id = c.id”,