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 More
Display 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 MoreANALYZE All Tables in the Current Database
In YSQL the ANALYZE command collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system […]
Read MoreRecover Recently Deleted Data Using Follower Reads
YugabyteDB is a transactional database that supports distributed transactions. A transaction is a sequence of operations performed as a single logical unit […]
Read More