RESET CLUSTER SETTING

The RESET statement resets a cluster setting to its default value for the client session..

Required privileges

Only members of the admin role can modify cluster settings. By default, the root user belongs to the admin role.

Synopsis

RESETCLUSTERSETTINGvar_name

Parameters

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

Example

Tip:
You can use SET CLUSTER SETTING .. TO DEFAULT to reset a cluster setting as well.

  1. > SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;
  1. > SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
  1. +---------------------------------------+
  2. | sql.metrics.statement_details.enabled |
  3. +---------------------------------------+
  4. | false                                 |
  5. +---------------------------------------+
  6. (1 row)
  1. > RESET CLUSTER SETTING sql.metrics.statement_details.enabled;
  1. > SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
  1. +---------------------------------------+
  2. | sql.metrics.statement_details.enabled |
  3. +---------------------------------------+
  4. | true                                  |
  5. +---------------------------------------+
  6. (1 row)

See also

Was this page helpful?
YesNo