RESET CLUSTER SETTING

On this page Carat arrow pointing down
Warning:
As of October 4, 2019, CockroachDB v2.0 is no longer supported. For more details, refer to the Release Support Policy.

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

Required Privileges

Only the root user can modify cluster settings.

Synopsis

RESET CLUSTER SETTING var_name

Parameters

Parameter Description
var_name The name of the cluster setting (case-insensitive).

Example

Tip:
You can use SET CLUSTER SETTING .. TO DEFAULT to reset a cluster setting as well.
> SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| false                                 |
+---------------------------------------+
(1 row)
> RESET CLUSTER SETTING sql.metrics.statement_details.enabled;
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| true                                  |
+---------------------------------------+
(1 row)

See Also


Yes No
On this page

Yes No