sql-statement-show-placement-labels.md

title	summary
SHOW PLACEMENT LABELS	The usage of SHOW PLACEMENT LABELS in TiDB.

SHOW PLACEMENT LABELS

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

Note:

This feature is not available on TiDB Cloud Serverless clusters.

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

• Placement Rules in SQL
• SHOW PLACEMENT
• CREATE PLACEMENT POLICY