SHOW PLACEMENT LABELS

April 22, 2026 ยท View on GitHub

SHOW PLACEMENT LABELS is used to summarize the labels and values that are available for Placement Rules.

Note:

This feature is not available on {{{ .starter }}} and {{{ .essential }}} instances.

Synopsis

ShowStmt ::=
    "SHOW" "PLACEMENT" "LABELS" ShowLikeOrWhere?

Examples

SHOW PLACEMENT LABELS;
+--------+----------------+
| Key    | Values         |
+--------+----------------+
| region | ["us-east-1"]  |
| zone   | ["us-east-1a"] |
+--------+----------------+
2 rows in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also