Note:
Cockroach Labs supports the current stable release and two releases prior. Therefore, this version will no longer be supported after the Spring 2019 release.

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