On this page 
Warning:
CockroachDB v1.1 is no longer supported as of April 12, 2019. 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)
See Also
Was this helpful?
