> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# RESET CLUSTER SETTING

The `RESET` [statement](/docs/stable/sql-statements.md) resets a [cluster setting](/docs/stable/set-cluster-setting.md) 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\_csetting syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/reset_csetting.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=3cfee6f029b5e0eb35e8bacd5f37d105)

## Parameters

| Parameter | Description |
| - | - |
| `var_name` | The name of the [cluster setting](/docs/stable/cluster-settings.md) (case-insensitive). |

## Example

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SET CLUSTER SETTING sql.metrics.statement_details.enabled = false;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
```

```
  sql.metrics.statement_details.enabled
-----------------------------------------
                  false
(1 row)
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESET CLUSTER SETTING sql.metrics.statement_details.enabled;
```

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW CLUSTER SETTING sql.metrics.statement_details.enabled;
```

```
  sql.metrics.statement_details.enabled
-----------------------------------------
                  true
(1 row)
```

## See also

* [`SET CLUSTER SETTING`](/docs/stable/set-cluster-setting)
* [`SHOW CLUSTER SETTING`](/docs/stable/show-cluster-setting)
* [Cluster settings](/docs/stable/cluster-settings.md)