Comment 4 for bug 787294

SELECT BugTask.bug FROM BugTask
          JOIN StructuralSubscription ON BugTask.product = StructuralSubscription.product
         OR BugTask.productseries = StructuralSubscription.productseries
         OR (BugTask.distribution = StructuralSubscription.distribution
         AND (BugTask.sourcepackagename = StructuralSubscription.sourcepackagename
              OR StructuralSubscription.sourcepackagename IS NULL))
         OR BugTask.distroseries = StructuralSubscription.distroseries
         OR BugTask.milestone = StructuralSubscription.milestone
         WHERE
            BugTask.status IN (10, 15, 20, 21, 22,25)
           AND StructuralSubscription.subscriber = 343381;

- even though the plan before was suggesting that the bug scan was the culprit, this query itself is the crux of the issue.
Time: 81575.535 ms
2596 rows