# pg_settings

> 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: pg_settings
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/system-catalogs/catalogs/pg_settings
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/system-catalogs/catalogs/pg_settings.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/system-catalogs/catalogs/pg_settings.adoc
description: The pg_settings displays the configuration settings for the current session.
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/system-catalogs/catalogs/pg_settings.md -->

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)Columns

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. |

## [](#examples)Examples

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

```sql
SELECT name, setting FROM pg_settings;
```

You get the following run-time configuration values.

```sql
     name      | setting
----------------+---------
 max_index_keys | 32
```