> ## Documentation Index > Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt > Use this file to discover all available pages before exploring further. # SHOW CLUSTER SETTING The `SHOW CLUSTER SETTING` [statement](/docs/stable/sql-statements.md) displays the values of [cluster settings](/docs/stable/cluster-settings.md). To configure cluster settings, use [`SET CLUSTER SETTING`](/docs/stable/set-cluster-setting). > [!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`. ## Details * To display the value of a specific cluster setting, use the following syntax: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW CLUSTER SETTING ; ``` * To display the values of *public* cluster settings (i.e., cluster settings that are documented and for which tuning is supported), use one of the following: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW CLUSTER SETTINGS; ``` ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW PUBLIC CLUSTER SETTINGS; ``` * To display the values of all cluster settings use one of the following: ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW ALL CLUSTER SETTINGS; ``` ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} SHOW CLUSTER SETTING ALL; ``` When you display all cluster settings, the table output includes a `public` column that denotes whether a setting is public or not. ## Required privileges To use the `SHOW CLUSTER SETTING` statement, a user must have one of the following attributes: * Be a member of the `admin` role (the `root` user belongs to the `admin` role by default). * Have the `MODIFYCLUSTERSETTING` [system-level privilege](/docs/stable/security-reference/authorization.md#privileges) granted. * Have the `VIEWCLUSTERSETTING` [system-level privilege](/docs/stable/security-reference/authorization.md#supported-privileges) (or the legacy `VIEWCLUSTERSETTING` [role option](/docs/stable/security-reference/authorization.md)) defined. * Have the `MODIFYSQLCLUSTERSETTING` [system-level privilege](/docs/stable/security-reference/authorization.md#privileges) granted. Users with this privilege are allowed to view only [`sql.defaults.*` cluster settings](/docs/stable/cluster-settings), not all cluster settings. ## Synopsis ![show\_cluster\_setting syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/show_cluster_setting.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=ba84d3bd1d558dbc9e4488c94d5b6d67) ## Parameters | Parameter | Description | | - | - | | `var_name` | The name of the [cluster setting](/docs/stable/cluster-settings.md) (case-insensitive). | | `ALL` | Display all cluster settings. | | `PUBLIC` | Display only the public cluster settings. By default, only public settings are listed by `SHOW CLUSTER SETTINGS`. `SHOW PUBLIC CLUSTER SETTINGS` and `SHOW CLUSTER SETTINGS` are equivalent. | ## Response When you query multiple cluster settings (e.g., with `SHOW CLUSTER SETTINGS`, or with `SHOW ALL CLUSTER SETTINGS`), the following fields are returned: | Field | Description | | - | - | | `variable` | The name of the cluster setting. | | `value` | The value of the cluster setting. | | `setting_type` | The type of the cluster setting. Possible values for `setting_type` include: | | `description` | A brief description of the cluster setting, including possible values. | | `public` | `true` if the cluster setting is public. This field is only included if all cluster settings are displayed. | | `default_value` | The default value of the cluster setting. | | `origin` | The origin of the current value of the cluster setting. Possible values for `origin` include: | ## Examples ### Show the value of a single cluster setting ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW CLUSTER SETTING diagnostics.reporting.enabled; ``` ``` diagnostics.reporting.enabled --------------------------------- true (1 row) ``` ### Show the values of all public cluster settings ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW CLUSTER SETTINGS; ``` ``` variable | value | setting_type | description -------------------------------------------------+-------+--------------+--------------------------------------------------------------------------------------------------------------- admission.kv.enabled | false | b | when true, work performed by the KV layer is subject to admission control admission.sql_kv_response.enabled | false | b | when true, work performed by the SQL layer when receiving a KV response is subject to admission control admission.sql_sql_response.enabled | false | b | when true, work performed by the SQL layer when receiving a DistSQL response is subject to admission control bulkio.stream_ingestion.minimum_flush_interval | 5s | d | the minimum timestamp between flushes; flushes may still occur if internal buffers fill up ... ``` ### Show the values of all cluster settings ```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}} > SHOW ALL CLUSTER SETTINGS; ``` ``` variable | value | setting_type | public | description --------------------------------------------------+-------+--------------+--------+-------------------------------------------------------------------------------------------------------------------------------------- admission.kv.enabled | false | b | true | when true, work performed by the KV layer is subject to admission control admission.kv_slot_adjuster.overload_threshold | 32 | i | false | when the number of runnable goroutines per CPU is greater than this threshold, the slot adjuster considers the cpu to be overloaded admission.l0_file_count_overload_threshold | 1000 | i | false | when the L0 file count exceeds this threshold, the store is considered overloaded admission.l0_sub_level_count_overload_threshold | 20 | i | false | when the L0 sub-level count exceeds this threshold, the store is considered overloaded ... ``` ## See also * [`SET CLUSTER SETTING`](/docs/stable/set-cluster-setting) * [`RESET CLUSTER SETTING`](/docs/stable/reset-cluster-setting) * [Cluster settings](/docs/stable/cluster-settings.md) * [`SHOW {session variable}`](/docs/stable/show-vars) * [`SHOW COLUMNS`](/docs/stable/show-columns) * [`SHOW CONSTRAINTS`](/docs/stable/show-constraints) * [`SHOW CREATE`](/docs/stable/show-create) * [`SHOW DATABASES`](/docs/stable/show-databases) * [`SHOW GRANTS`](/docs/stable/show-grants) * [`SHOW INDEX`](/docs/stable/show-index) * [`SHOW USERS`](/docs/stable/show-users) * [`SHOW DEFAULT SESSION VARIABLES FOR ROLE`](/docs/stable/show-default-session-variables-for-role)