RESET CLUSTER SETTING

The RESET resets a 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

Parameters

Parameter	Description
var\_name	The name of the (case-insensitive).

Example

You can use 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