Hello,
I believe there are two different issues here:
- The low resident ratio on indexes
- The query not running with the “Request has exceeded memory quota” message.
For the low resident ratio on indexes:
In a node with multiple services the memory will be distributed out between the operating system and all the services on the node.
In your case you have a node with 32Gb of RAM. Of that 32Gb 20% is given to the OS. That will leave you with 25Gb.
The 25Gb is then divided between the three services (Query, Index and Search) each will be assigned 8.3Gb (25/3).
I see you have a number of indexes and I suspect you have gone over the memory quota for the index service which is why the resident ratio is low on some of your indexes.
The best practice for a production cluster is to have each service on a different nodes so all memory can be assigned to that one service. This would be the preferred option if you need to increase the resident ratio of your indexes.
For the “Request has exceeded memory quota” message:
Can you provide the query your trying to run, I wonder does it include the UNNEST clause?