# SET and SHOW

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: SET and SHOW
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-statements/set-show
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-statements/set-show.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-statements/set-show.adoc
description: The SET statement configures session options. The SHOW statement displays their current values.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-statements/set-show.md -->

The `SET` statement configures session options. The `SHOW` statement displays their current values.

## [](#syntax)Syntax

`SET` statement:

```sql
SET <option> TO <value>;
```

> 📝 **NOTE**
>
> The `SET` statement accepts both `TO` and `=` as the assignment operator.
>
> For options that accept boolean values, `<value>` can be `ON` (true) or `OFF` (false).

`SHOW` statement:

```sql
SHOW <option>;
```

Available options:

-   `extra_float_digits`: Number of extra digits displayed after the decimal point in floating-point numbers.

-   `application_name`: Custom name for the application.

-   `timezone`: Time zone used for date and time functions.

-   `client_min_messages`: Minimum message level sent to the client. Valid values: `DEBUG5`, `DEBUG4`, `DEBUG3`, `DEBUG2`, `DEBUG1`, `LOG`, `NOTICE`, `WARNING`, and `ERROR`.

-   `search_path`: Namespaces in which Redpanda SQL looks for tables.

-   `oxla.enable_fast_math`: Enables math optimizations that trade precision for speed using faster, less accurate functions.


## [](#examples)Examples

### [](#set-statement)SET statement

#### [](#extra_float_digits)extra_float_digits

To change the number of displayed digits for floating-point values, run the query:

```sql
SET extra_float_digits TO 2;
```

```sql
SHOW extra_float_digits;
```

```sql
 extra_float_digits
--------------------
 2
```

#### [](#client_min_messages)client_min_messages

To change the minimum client message level:

```sql
SET client_min_messages TO 'WARNING';
```

```sql
SHOW client_min_messages;
```

```sql
 client_min_messages
---------------------
 warning
```

#### [](#oxla-enable_fast_math)oxla.enable_fast_math

To enable fast math optimizations:

```sql
SET oxla.enable_fast_math = ON;
```

```sql
SHOW oxla.enable_fast_math;
```

```sql
 oxla_enable_fast_math
-----------------------
 1
(1 row)
```

### [](#show-statement)SHOW statement

#### [](#timezone)timezone

To display the current timezone setting, run:

```sql
SHOW timezone;
```

```sql
 timezone
----------
 Etc/UTC
```

#### [](#search_path)search_path

To display the current search path, run:

```sql
SHOW search_path;
```

```sql
 search_path
-------------
 public
```

#### [](#oxla-enable_fast_math-2)oxla.enable_fast_math

To check the status of fast math optimizations, run:

```sql
SHOW oxla.enable_fast_math;
```

```sql
 oxla_enable_fast_math
-----------------------
 0
(1 row)
```