Introduced in YugabyteDB 2024.1.0, the YSQL yb_local_tablets view allows you to easily fetch the metadata for YSQL, YCQL, and system tablets of […]
Read MoreCreating Indexes on ARRAY Columns in YSQL
Secondary indexes boost database performance by enabling faster row retrieval. In YSQL you can create Unique, Partial, Covering, and Secondary Indexes with […]
Read MoreDisplay YugabyteDB Universe Cluster Configuration Details in HTML, JSON or Text Formats from the Command Line
The cluster configuration in YugabyteDB provides information about the current state of the cluster. It includes details about the replication settings, placement […]
Read MoreDisplay YSQL Database Size
The Postgres pg_database_size(name) built-in system function retunrs the disk space used by the database with the specified name. Although YugabyteDB is Postgres […]
Read MoreIdentify Unused YCQL Indexes
Yugabyte Cloud Query Language (YCQL) is a semi-relational SQL API that is best fit for internet-scale OLTP and HTAP applications needing massive […]
Read More