Not able to query across tree structure with millions of links

Filtering the parameters themselves is no issue at all, thats blazingly fast. Even aggregating the buckets is quite performant. But as soon i go one level further its super slow…