Sometimes a simple question gets surprisingly interesting in a distributed database: How many rows are in each shard? In YugabyteDB, the physical […]
Read More
Instantly Estimate Row Counts (Smart, Fast, and Composite-Key Aware)
Getting a row count in YugabyteDB seems simple: SELECT COUNT(*) FROM transfers; But in a distributed system, this is: ● A full-table […]
Read MoreVisualizing Tablet Distribution with Real Row Counts in YugabyteDB
TL;DR This tip introduces yb-topology-viewer, a lightweight demo application that helps you visualize how data is actually distributed across a YugabyteDB cluster […]
Read MoreFaster exact row counts in YugabyteDB using range sharding and tablet-level parallelism
Exact row counts are common in migrations, validation, and operational checks. In YugabyteDB, SELECT COUNT(*) is correct and already distributed, but it […]
Read More