'How can I visualize the logical partition size distributions in a container

I have a Cosmos DB database and I like to inspect or the logical partition size distributions in a container as well is the item sizes in partitions.

How can I Visualize (preferably) or get a report of logical partition size distributions in a container as well is the item sizes in partitions?



Solution 1:[1]

Have you tried using Log Analytics / Diagnostics with PartitionKeyStatistics?

AzureDiagnostics 
| where ResourceProvider=="MICROSOFT.DOCUMENTDB" and Category=="PartitionKeyStatistics" 
| project SubscriptionId, regionName_s, databaseName_s, collectionname_s, partitionkey_s, sizeKb_s, ResourceId 

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Sajeetharan