SHOW CLUSTER SETTING

On this page Carat arrow pointing down
Warning:
CockroachDB v2.0 is no longer supported. For more details, see the Release Support Policy.

The SHOW CLUSTER SETTING statement can display the value of either one or all of the cluster settings. These can also be configured via SET CLUSTER SETTING.

Required Privileges Changed in v2.0

Only the root user can display cluster settings.

Synopsis

SHOW CLUSTER SETTING var_name ALL ALL CLUSTER SETTINGS
Note:
The SHOW statement for cluster settings is unrelated to the other SHOW statements: SHOW (session variable), SHOW CREATE TABLE, SHOW CREATE VIEW, SHOW USERS, SHOW DATABASES, SHOW COLUMNS, SHOW GRANTS, and SHOW CONSTRAINTS.

Parameters

Parameter Description
any_name The name of the cluster setting (case-insensitive).

Examples

Showing the Value of a Single Cluster Setting

> SHOW CLUSTER SETTING diagnostics.reporting.enabled;
+-------------------------------+
| diagnostics.reporting.enabled |
+-------------------------------+
| true                          |
+-------------------------------+
(1 row)
> SHOW CLUSTER SETTING sql.default.distsql;
+----------------------+
| sql.defaults.distsql |
+----------------------+
|                    1 |
+----------------------+
(1 row)

Showing the Value of All Cluster Settings

> SHOW ALL CLUSTER SETTINGS;
+-------------------------------+---------------+------+--------------------------------------------------------+
|          name                 | current_value | type | description                                            |
+-------------------------------+---------------+------+--------------------------------------------------------+
| diagnostics.reporting.enabled | true          | b    | enable reporting diagnostic metrics to cockroach labs  |
| ...                           | ...           | ...  | ...                                                    |
+-------------------------------+---------------+------+--------------------------------------------------------+
(24 rows)

See Also


Yes No
On this page

Yes No