Getting Document Count & Size

Question

I understand that to obtain document count, we should be using the following query: "SELECT VALUE COUNT(1) FROM c" But unfortunately, the 'Retrieved document size' will return 0 instead of the actual document size involved from Query Metric

If I now tweak the query to: "SELECT c.id FROM c", No doubt it will return me all the Ids. But this will also produce accurate, e.g.) 6738 bytes for my case. However, the draw back of this is that it will increase the "Output document size" unnecessary, and might not be feasible if many document is involved just to compute document size by query.

Is there anyway we can get Number of Document and Total Size of Document without reading the document and storing the size manually one by one?

Or, how can we get partition item count & partition total size? So that we can analyze the data and to restrict tenant usage?

Answer 1

Based on your problem description, I tried it myself using Azure Cosmos DB Emulator. I haven't found the problem you described yet. It is recommended to check or try again to see if the problem can be solved.

My data:

Run query: SELECT VALUE COUNT(1) FROM c

You also can read this doucument, I think it useful to you.