SHOW CLUSTER SETTING

The SHOW CLUSTER SETTING statement candisplay the value of either one or all of thecluster settings. These can also be configuredvia 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

SHOWCLUSTERSETTINGvar_nameALLALLCLUSTERSETTINGS

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

ParameterDescription
any_nameThe name of the cluster setting (case-insensitive).

Examples

Showing the value of a single cluster setting

  1. > SHOW CLUSTER SETTING diagnostics.reporting.enabled;
  1. +-------------------------------+
  2. | diagnostics.reporting.enabled |
  3. +-------------------------------+
  4. |             true              |
  5. +-------------------------------+
  6. (1 row)

Showing the value of all cluster settings

  1. > SHOW ALL CLUSTER SETTINGS;
  1. +------------------------------------------------------+-----------+--------------+--------------------------------------------------------------------------+
  2. |                       variable                       |   value   | setting_type |                               description                                |
  3. +------------------------------------------------------+-----------+--------------+--------------------------------------------------------------------------+
  4. | cloudstorage.gs.default.key                          |           | s            | if set, JSON key to use during Google Cloud Storage operations           |
  5. | cloudstorage.http.custom_ca                          |           | s            | custom root CA (appended to system's default CAs) for verifying          |
  6. |                                                      |           |              | certificates when interacting with HTTPS storage                         |
  7. | cloudstorage.timeout                                 | 10m0s     | d            | the timeout for import/export storage operations                         |
  8. ...
  9. +-------------------------------+---------------+------+--------------------------------------------------------+

See also

Was this page helpful?
YesNo