Skip to content

Latest commit

 

History

History
72 lines (54 loc) · 1.93 KB

reset-cluster-setting.md

File metadata and controls

72 lines (54 loc) · 1.93 KB
title summary toc
RESET CLUSTER SETTING
The RESET CLUSTER SETTING statement resets a cluster setting to its default value for the client session.
true

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

{% include {{ page.version.version }}/sql/diagrams/reset_csetting.html %}

Parameters

Parameter Description
var_name The name of the cluster setting (case-insensitive).

Example

{{site.data.alerts.callout_success}}You can use SET CLUSTER SETTING .. TO DEFAULT to reset a cluster setting as well.{{site.data.alerts.end}}

{% include copy-clipboard.html %}

> SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;

{% include copy-clipboard.html %}

> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| false                                 |
+---------------------------------------+
(1 row)

{% include copy-clipboard.html %}

> RESET CLUSTER SETTING sql.metrics.statement_details.enabled;

{% include copy-clipboard.html %}

> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
+---------------------------------------+
| sql.metrics.statement_details.enabled |
+---------------------------------------+
| true                                  |
+---------------------------------------+
(1 row)

See also