> ## 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](https://docs.cockroachlabs.com/docs/v24.2/sql-statements) resets a [cluster setting](https://docs.cockroachlabs.com/docs/v24.2/set-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\_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](https://docs.cockroachlabs.com/docs/v24.2/cluster-settings) (case-insensitive). |

## Example

> [!TIP]
>
> You can use `SET CLUSTER SETTING .. TO DEFAULT` to reset a cluster setting as well.

```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`](https://docs.cockroachlabs.com/docs/v24.2/set-cluster-setting)
* [`SHOW CLUSTER SETTING`](https://docs.cockroachlabs.com/docs/v24.2/show-cluster-setting)
* [Cluster settings](https://docs.cockroachlabs.com/docs/v24.2/cluster-settings)