Is it possible to, either before executing or immediately afterwards, understand the RPU/WPU impact (cost) of a single query?
Azure MongoDB has
getLastRequestStatistics but this command does not exist on Atlas instances.
From reading other topics on the forum it does seem there is a theme of not entirely understanding how RPU is calculated, or indeed how and when to optimise for it. If the response returned to clients using SDKs included the cost it would allow us to shorten the development cycle.
My first usage of Mongo Atlas Serverless resulted in a $60 bill because of a missing index, I wish it was easiest to spot this during development rather than once it hit production under full load. The cost isn’t important, but the lack of tooling and quicker visibility can make this risky business. I’m currently considering alternative options.