On this page
Warning:
As of October 30, 2020, CockroachDB v19.1 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
Only members of the admin
role can display cluster settings. By default, the root
user belongs to the admin
role.
Synopsis
Note:
The SHOW
statement for cluster settings is unrelated to the other SHOW
statements: SHOW (session variable)
, SHOW CREATE
, 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)
Showing the value of all cluster settings
> SHOW ALL CLUSTER SETTINGS;
+------------------------------------------------------+-----------+--------------+--------------------------------------------------------------------------+
| variable | value | setting_type | description |
+------------------------------------------------------+-----------+--------------+--------------------------------------------------------------------------+
| cloudstorage.gs.default.key | | s | if set, JSON key to use during Google Cloud Storage operations |
| cloudstorage.http.custom_ca | | s | custom root CA (appended to system's default CAs) for verifying |
| | | | certificates when interacting with HTTPS storage |
| cloudstorage.timeout | 10m0s | d | the timeout for import/export storage operations |
...
+-------------------------------+---------------+------+--------------------------------------------------------+