Cookie Consent

RESET CLUSTER SETTING

On this page Carat arrow pointing down

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

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.
icon/buttons/copy
SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;
icon/buttons/copy
SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| false                                 |
+---------------------------------------+
(1 row)
icon/buttons/copy
RESET CLUSTER SETTING sql.metrics.statement_details.enabled;
icon/buttons/copy
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