We have a pretty simple query that is taking as long as 8-10 minutes and then timing out. On checking the plan, we see that authorize phase it taking 3m+. Resident Ratio is 100%. Index is MOI. There are 400k docs in the bucket. The query returns about 2k docs.
SELECT P.X , Q.Y
FROM bucket1 P
INNER JOIN bucket1 Q
ON P.A = Q.A
WHERE P.__t=“BB” and Q.__t=“CC”;
It times out with the message 12008 Error performing bulk get operation.
There are only 2.5k docs for __t=“BB”.
And only 1k docs for __t=“CC”.
Looking at the name, authorize looks like a phase related to RBAC. The user is an admin and hence we are unable to understand why is it taking as much as 3m+?
Also, can somebody point to a link in documentation that explains different times (servTime, kernTime, etc.) and the phases?