Overview
Displays the MemTable and SSTable information for each partition under all tenants on all OBServer nodes.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Server IP Address |
| SVR_PORT | bigint(20) | NO | Server Port Number |
| TABLE_TYPE | varchar(20) | NO | Table type |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| TABLET_ID | bigint(20) | NO | Data Shard ID |
| START_LOG_SCN | bigint(20) unsigned | NO | Left Boundary of Log Timestamp Range for Data in This Table |
| END_LOG_SCN | bigint(20) unsigned | NO | Right Boundary of Log Timestamp Range for Data in This Table |
| SIZE | bigint(20) | NO | Disk usage, in bytes |
| REF | bigint(20) | NO | The count of references to this table. Unit: number |
| UPPER_TRANS_VERSION | bigint(20) unsigned | NO | Maximum Transaction Version Number of a Committed Transaction |
| IS_ACTIVE | varchar(3) | NO | Whether it is an active MemTable |
| CONTAIN_UNCOMMITTED_ROW | varchar(3) | NO | Whether the table contains uncommitted transaction rows:
|
Sample query
In the sys tenant, view the MemTable and SSTable information of partition 1001 in the log stream with ID 1001 for the tenant with ID 1002 on all OBServer nodes.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_SSTABLES WHERE TENANT_ID=1002 AND LS_ID=1001;
The query result is as follows:
+----------------+----------+------------------+-----------+-------+-----------+---------------------+---------------------+---------+------+---------------------+-----------+-------------------------+
| SVR_IP | SVR_PORT | TABLE_TYPE | TENANT_ID | LS_ID | TABLET_ID | START_LOG_SCN | END_LOG_SCN | SIZE | REF | UPPER_TRANS_VERSION | IS_ACTIVE | CONTAIN_UNCOMMITTED_ROW |
+----------------+----------+------------------+-----------+-------+-----------+---------------------+---------------------+---------+------+---------------------+-----------+-------------------------+
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200032 | 0 | 1743357601718033000 | 380 | 0 | 1743155516647021000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MINOR | 1002 | 1001 | 49402 | 1 | 1743155746972459000 | 3244 | 0 | 4096 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | TX_DATA_MEMTABLE | 1002 | 1001 | 49402 | 1743155746972459000 | 4611686018427387903 | 1048576 | 3 | 0 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200037 | 0 | 1743357601718033000 | 0 | 0 | 1743357601718033000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200015 | 0 | 1743357601718033000 | 411 | 0 | 1742957323483246000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200031 | 0 | 1743357601718033000 | 380 | 0 | 1743155516647021000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200007 | 0 | 1743357601718033000 | 643 | 0 | 1742541257735502000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200014 | 0 | 1743357601718033000 | 411 | 0 | 1742957323483246000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200030 | 0 | 1743357601718033000 | 380 | 0 | 1743155516647021000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200021 | 0 | 1743357601718033000 | 389 | 0 | 1743155475021424000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200016 | 0 | 1743357601718033000 | 411 | 0 | 1742957323483246000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200020 | 0 | 1743357601718033000 | 380 | 0 | 1743155475021424000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200038 | 0 | 1743357601718033000 | 0 | 0 | 1743357601718033000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200005 | 0 | 1743357601718033000 | 643 | 0 | 1742541257735502000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200036 | 0 | 1743357601718033000 | 0 | 0 | 1743357601718033000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200012 | 0 | 1743357601718033000 | 0 | 0 | 1743357601718033000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200018 | 0 | 1743357601718033000 | 384 | 0 | 1743152704981127000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200013 | 0 | 1743357601718033000 | 406 | 0 | 1742957323483246000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 49401 | 0 | 1 | 0 | 0 | 1 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | TX_CTX_MEMTABLE | 1002 | 1001 | 49401 | 1 | 2 | 0 | 2 | 0 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200004 | 0 | 1743357601718033000 | 961 | 0 | 1742541257735502000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200033 | 0 | 1743357601718033000 | 0 | 0 | 1743357601718033000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 49403 | 0 | 1 | 0 | 0 | 1 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | LOCK_MEMTABLE | 1002 | 1001 | 49403 | 1 | 2 | 0 | 3 | 0 | YES | YES |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200002 | 0 | 1743357601718033000 | 933 | 0 | 1742541257735502000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200019 | 0 | 1743357601718033000 | 0 | 0 | 1743357601718033000 | NO | NO |
| 11.xxx.xxx.xxx | 28825 | MAJOR | 1002 | 1001 | 200003 | 0 | 1743357601718033000 | 774 | 0 | 1742541257735502000 | NO | NO |
+----------------+----------+------------------+-----------+-------+-----------+---------------------+---------------------+---------+------+---------------------+-----------+-------------------------+
27 rows in set