Note
This view is available starting with V4.0.0.
Purpose
This view displays the list of all tablets in the current tenant and the log stream information to which each tablet belongs.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLET_ID | bigint(20) | NO | The ID of the tablet. |
| LS_ID | bigint(1) | NO | The ID of the log stream to which the tablet belongs. |
Sample query
Query the list of tablets in the sys tenant and display the first five entries.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TABLET_TO_LS LIMIT 5;
The query result is as follows:
+-----------+-------+
| TABLET_ID | LS_ID |
+-----------+-------+
| 1 | 1 |
| 100001 | 1 |
| 100002 | 1 |
| 100003 | 1 |
| 50003 | 1 |
+-----------+-------+
5 rows in set