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

# pg_settings

## Overview

The `pg_settings` displays the configuration settings for the current session. It mimics the [pg\_settings](https://www.postgresql.org/docs/current/catalog-pg-db-role-setting.html) PostgreSQL system catalog.

## Columns

<Note>This table is designed for compatibility with tools that require PostgreSQL system tables, so it mostly has dummy data. Please note that not all columns in `pg_settings` are applicable to every type of relation.</Note>

The following columns are available for querying in `pg_settings`:

| Column            | Type   | Description                                                      |
| ----------------- | ------ | ---------------------------------------------------------------- |
| `name`            | `text` | This column represents the run-time configuration parameter name |
| `setting`         | `text` | This column represents the current value of the parameter        |
| `unit`            | `text` | *Unused*.                                                        |
| `category`        | `text` | *Unused*.                                                        |
| `short_desc`      | `text` | *Unused*.                                                        |
| `extra_desc`      | `text` | *Unused*.                                                        |
| `context`         | `text` | *Unused*.                                                        |
| `vartype`         | `text` | *Unused*.                                                        |
| `source`          | `text` | *Unused*.                                                        |
| `min_val`         | `text` | *Unused*.                                                        |
| `max_val`         | `text` | *Unused*.                                                        |
| `enumvals`        | `text` | *Unused*.                                                        |
| `boot_val`        | `text` | *Unused*.                                                        |
| `reset_val`       | `text` | *Unused*.                                                        |
| `sourcefile`      | `text` | *Unused*.                                                        |
| `sourceline`      | `int`  | *Unused*.                                                        |
| `pending_restart` | `bool` | *Unused*.                                                        |

## Example

To retrieve information from the pg\_settings catalog, you can execute a query like:

```sql theme={null}
SELECT name, setting FROM pg_settings;
```

You will get the run-time configuration values as shown below.

```sql theme={null}
     name      | setting 
----------------+---------
 max_index_keys | 32
```