Indexer 100% cpu at random different nodes

Found this article and started trying to figure out what was happening, after improving some queries and changed some index the issue looks solve. So I guess this was a performance issue related to index in one of the nodes.