The SHOW CLUSTER SETTING statement displays the values of cluster settings.
To configure cluster settings, use SET CLUSTER SETTING.
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:
SHOW CLUSTER SETTING <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:
SHOW CLUSTER SETTINGS;SHOW PUBLIC CLUSTER SETTINGS;To display the values of all cluster settings use one of the following:
SHOW ALL CLUSTER SETTINGS;SHOW CLUSTER SETTING ALL;When you display all cluster settings, the table output includes a
publiccolumn 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
adminrole (therootuser belongs to theadminrole by default). - Have the
VIEWCLUSTERSETTINGsystem-level privilege (or the legacyVIEWCLUSTERSETTINGrole option) defined. - Have the
MODIFYCLUSTERSETTINGsystem-level privilege granted.
New in 22.2.7:
The cluster setting sql.auth.modify_cluster_setting_applies_to_all.enabled affects what users with the MODIFYCLUSTERSETTING privilege are able to view:
- If set to
true(the default), users are able to view all cluster settings. - If set to
false, users are allowed to view onlysql.defaults.*cluster settings, not all cluster settings.
Synopsis
Parameters
| Parameter | Description |
|---|---|
var_name |
The name of the cluster setting (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 only if all cluster settings are displayed. |
Examples
Show the value of a single cluster setting
> SHOW CLUSTER SETTING diagnostics.reporting.enabled;
diagnostics.reporting.enabled
---------------------------------
true
(1 row)
Show the values of all public cluster settings
> 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
> 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 SETTINGRESET CLUSTER SETTING- Cluster settings
SHOW {session variable}SHOW COLUMNSSHOW CONSTRAINTSSHOW CREATESHOW DATABASESSHOW GRANTSSHOW INDEXSHOW USERS
Was this helpful?
