# SHOW CLUSTER SETTING

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                         |
    ...
    +-------------------------------+---------------+------+--------------------------------------------------------+

## See also

- `SET CLUSTER SETTING`
- `RESET CLUSTER SETTING`
- Cluster settings
- `SHOW` (session variable)
- `SHOW COLUMNS`
- `SHOW CONSTRAINTS`
- `SHOW CREATE`
- `SHOW DATABASES`
- `SHOW GRANTS`
- `SHOW INDEX`
- `SHOW USERS`