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
SELECT BugTask.bug FROM BugTask ription ON BugTask.product = StructuralSubsc ription. product productseries = StructuralSubsc ription. productseries distribution = StructuralSubsc ription. distribution sourcepackagena me = StructuralSubsc ription. sourcepackagena me ription. sourcepackagena me IS NULL)) distroseries = StructuralSubsc ription. distroseries ription. milestone
BugTask. status IN (10, 15, 20, 21, 22,25) ription. subscriber = 343381;
JOIN StructuralSubsc
OR BugTask.
OR (BugTask.
AND (BugTask.
OR StructuralSubsc
OR BugTask.
OR BugTask.milestone = StructuralSubsc
WHERE
AND StructuralSubsc
- 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