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 More
Creating 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 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 MoreDisplay Queries that Internal Commands Generate
As you explore the ysqlsh interactive shell, it’s useful to know that you can view the SQL queries executed for each meta-command […]
Read MoreDetermining if a YugabyteDB Universe is Running a YSQL or YCQL Workload
The YugabyteDB Query Layer (YQL) serves as the main interface, enabling applications to interact through client drivers. This layer handles API-specific tasks, […]
Read More