Hello
I have a super slow DB query again. ? There are up to 30 of these queries running at the same time and they're running for hours. In fact I have to kill them after 6-8 hours because they are producing an incredible high load on the system.

SELECT `uri-id` FROM `post-view` WHERE (`gravity` IN (0, 6) AND `private` = 0 AND `network` IN ('dfrn', 'dspr', 'stat', 'apub') AND `parent-author-blocked` = 0 AND `parent-author-hidden` = 0 AND `visible` AND NOT `deleted` AND NOT `author-blocked` AND NOT `owner-blocked` AND (NOT `causer-blocked` OR `causer-id` = 0 OR `causer-id` IS NULL) AND NOT `contact-blocked` AND ((NOT `contact-readonly` AND NOT `contact-pending` AND (`contact-rel` IN (2, 3))) OR `self` OR `gravity` != 0 OR `contact-uid` = 0) AND NOT `post-view`.`uri-id` IN (SELECT `uri-id` ... ... (truncated)
Line is truncated because it doesn't fit into my terminal window. ?

Maybe @heluecht has an idea what that query is doing and why it is so slow.

Thank you.