On this page 
Warning:
As of November 10, 2018, CockroachDB v1.0 is no longer supported. For more details, refer to 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
No privileges are required to display the cluster settings.
Synopsis
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 |
See the description of cluster settings. |
The variable name is 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
SET CLUSTER SETTING- Cluster settings
SHOW(session variable)SHOW COLUMNSSHOW CONSTRAINTSSHOW CREATE TABLESHOW CREATE VIEWSHOW DATABASESSHOW GRANTSSHOW INDEXSHOW USERS
Was this helpful?
