View YSQL/YCQL and tablet metadata with yb_local_tablets

Use the YugabyteDB yb_local_tablets view to see metadata about the YSQL and YCQL statements, and system tablets of a node.

This view is also present on <yb-tserver_ip>:9000/tablets in the form of a YSQL view, and can be joined with YCQL wait events in the yb_active_session_history view using the tablet ID. For example, see Detect a hot shard.

The columns of the yb_local_tablets view are described in the following table.

Column Type Description
tablet_id text 16 byte UUID of the tablet.
table_id text 16 byte UUID of the table which the tablet is part of.
table_type text Type of the table. Can be YSQL, YCQL, System, or Unknown.
namespace_name text Name of the database or the keyspace.
ysql_schema_name text YSQL schema name. Empty for YCQL, System, and Unknown table types.
table_name text Name of the table which the tablet is part of.
partition_key_start bytea Start key of the partition (inclusive).
partition_key_end bytea End key of the partition (exclusive).

Examples

Before you start

The examples will run on any YugabyteDB universe.
To create a universe, see Set up YugabyteDB universe.

Note that as this view is accessible via YSQL, run your examples using ysqlsh.

Describe the columns in the view

yugabyte=# \d yb_local_tablets
              View "pg_catalog.yb_local_tablets"
       Column        | Type  | Collation | Nullable | Default
---------------------+-------+-----------+----------+---------
 tablet_id           | text  |           |          |
 table_id            | text  |           |          |
 table_type          | text  |           |          |
 namespace_name      | text  |           |          |
 ysql_schema_name    | text  |           |          |
 table_name          | text  |           |          |
 partition_key_start | bytea |           |          |
 partition_key_end   | bytea |           |          |

Get basic information

This example includes a YCQL table, a hash-partitioned YSQL table, and a range-partitioned YSQL table.

yugabyte=# SELECT * FROM yb_local_tablets ORDER BY table_name, partition_key_start ASC NULLS FIRST;
            tablet_id             |             table_id             | table_type | namespace_name  | ysql_schema_name |       table_name        |  partition_key_start   |   partition_key_end
----------------------------------+----------------------------------+------------+-----------------+------------------+-------------------------+------------------------+------------------------
 230de13ea3f045c2bc817046c96bfb9e | db82083fb39e47b0976b99f3612fa144 | YCQL       | ybdemo_keyspace |                  | cassandrakeyvalue       |                        | \x8000
 cb8ef7044b094709870d421fccd568a4 | db82083fb39e47b0976b99f3612fa144 | YCQL       | ybdemo_keyspace |                  | cassandrakeyvalue       | \x8000                 |
 76010b63fc714389ab97b432d9db78ac | 000033c1000030008000000000004000 | YSQL       | postgres        | public           | postgresqlkeyvalue      |                        | \x8000
 a5913f11706c4d8a80d74b7001dfe157 | 000033c1000030008000000000004000 | YSQL       | postgres        | public           | postgresqlkeyvalue      | \x8000                 |
 110ae7c832e7418bbfb56222a3e6a7ca | 000033c3000030008000000000004006 | YSQL       | yugabyte        | public           | range_partitioned_table |                        | \x48800000015361000021
 746f84ac4a894b9c914fd4a89d5f89fc | 000033c3000030008000000000004006 | YSQL       | yugabyte        | public           | range_partitioned_table | \x48800000015361000021 | \x48800000025362000021
 f584ca3aa57e43278fd4b5042ab116be | 000033c3000030008000000000004006 | YSQL       | yugabyte        | public           | range_partitioned_table | \x48800000025362000021 | \x48800000035363000021
 6d566b767f0347879934338e1642f58e | 000033c3000030008000000000004006 | YSQL       | yugabyte        | public           | range_partitioned_table | \x48800000035363000021 |
 bc90fa993cc340458d7d4500213e5aed | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            |                        | \x2000
 d106f1c5039a4127bf1bee83c5c3fec8 | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \x2000                 | \x4000
 045af4a5aa744e1fb06e41f4af134ee0 | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \x4000                 | \x6000
 0f63fe4806824a4ab17b0fd9cf144b8a | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \x6000                 | \x8000
 a7251899b197456fbec72f7cc64cc7ad | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \x8000                 | \xa000
 46035a0bc4144f8ea372c93dc5d3a8b6 | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \xa000                 | \xc000
 1a13e5b16aa841608390c56e63deab20 | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \xc000                 | \xe000
 5b452227726444a78d1c84aaaf44f5c0 | 4c9c54fb3fcc47dcb29e58899afc5e21 | System     | system          |                  | transactions            | \xe000                 |