[P2] Add Container/Database Statistics command

[sajeetharan]

Feature Request

Priority: P2 (Medium)

Description

CosmosDB Shell's settings command shows limited account info but doesn't expose container/database statistics like storage size, RU consumption, document count, or partition key distribution.

Comparable Features in Other Shells

• mongosh: db.stats(), db.collection.stats(), db.serverStatus()
• sqlcmd: sp_spaceused, system views

Proposed Behavior

Add a stats command:

• stats — Show current container/database statistics
• Display: document count, storage size (data + index), provisioned/consumed RUs
• Show partition key distribution and hot partition detection
• Show top partition keys by storage

Example Usage

cd /MyDatabase/MyContainer
stats
stats --partitions
stats --detailed

[tnaum-ms]

Full ack, this is a natural fit for a shell. The Cosmos DB control and data plane already expose everything you would need: container/database properties, provisioned and consumed RUs, storage size, document counts, and partition key statistics. Wrapping that into a clean stats command is mostly a UX question.

Partition key distribution would be the most valuable addition. That is the metric users actually reach for when diagnosing hot partitions, and having it one command away in the shell would save a lot of trips to the portal.