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

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, 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

copy
icon/buttons/copy
> SHOW CLUSTER SETTING diagnostics.reporting.enabled;
+-------------------------------+
| diagnostics.reporting.enabled |
+-------------------------------+
|             true              |
+-------------------------------+
(1 row)

Showing the value of all cluster settings

copy
icon/buttons/copy
> 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                         |
...
+-------------------------------+---------------+------+--------------------------------------------------------+

See also



Yes No