On this page
Warning:
As of April 12, 2019, CockroachDB v1.1 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
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)