Can someone tell me how to read the query stats in cosmo db. I know that each item in cosmo have a hard limit of 2MB, however, the the retrieved document size here is more than 5 MB. So I am confused, is the the correct place to find out the size of an item. Because if it is then what about the hard limit of 2MB
Cosmo db query stats understand
Viewed 55
1 Answers
I think you have misunderstood the limits , the 2MB hard limit is for the document that you store.
However in this particular sample that you provided , the 5.7MB is the size of total documents that you retrieved. In this case there are 646 documents. You can see the exact definition from the metrics explained here.
Also, Response Size Quota per Page of Results (default is 4MB, for large query results - Cosmos DB will paginate results, and each page will be limited.
Related