In a previous YugabyteDB Tip, we built a pure SQL function to export a table’s CREATE TABLE DDL directly from YugabyteDB system […]
Read More
How to Show Leader and Replica Counts Per Node in YugabyteDB Using Pure SQL
When working with YugabyteDB, it is often useful to see how tablets are distributed across nodes. Two especially helpful questions are: ● […]
Read MoreExploring Range Tablet Placement (and Which Split Point Created Each Tablet)
In a previous tip, we explored how yb_tablet_metadata makes it easy to see tablet leadership and replica placement across a YugabyteDB cluster. […]
Read MoreUse the YB_LOCAL_TABLETS Sytem View to Map Table Rows to their Tablets
We learned in the YugabyteDB Tip View Metadata for YSQL/YCQL/System Tablets on a Server about the new (in YugabyteDB 2024.1) system view yb_local_tablets. […]
Read More