Cloud

pg_settings

The pg_settings displays the configuration settings for the current session. It mimics the pg_settings PostgreSQL system catalog.

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

To retrieve information from the pg_settings catalog, you can execute a query like:

SELECT name, setting FROM pg_settings;

You get the following run-time configuration values.

     name      | setting
----------------+---------
 max_index_keys | 32