System Catalogs / System views
pg_settings
Read the PG 18 manualThe view pg_settings provides access to run-time parameters of the server.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System views
- Columns in this snapshot
- 17
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 17
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
name | text | Run-time configuration parameter name |
setting | text | Current value of the parameter |
unit | text | Implicit unit of the parameter |
category | text | Logical group of the parameter |
short_desc | text | A brief description of the parameter |
extra_desc | text | Additional, more detailed, description of the parameter |
context | text | Context required to set the parameter's value (see below) |
vartype | text | Parameter type (bool, enum, integer, real, or string) |
source | text | Source of the current parameter value |
min_val | text | Minimum allowed value of the parameter (null for non-numeric values) |
max_val | text | Maximum allowed value of the parameter (null for non-numeric values) |
enumvals | text[] | Allowed values of an enum parameter (null for non-enum values) |
boot_val | text | Parameter value assumed at server startup if the parameter is not otherwise set |
reset_val | text | Value that RESET would reset the parameter to in the current session |
sourcefile | text | Configuration file the current value was set in (null for values set from sources other than configuration files, or when examined by a user who neither is a superuser nor has privileges of pg_read_all_settings); helpful when using include directives in configuration files |
sourceline | int4 | Line number within the configuration file the current value was set at (null for values set from sources other than configuration files, or when examined by a user who neither is a superuser nor has privileges of pg_read_all_settings). |
pending_restart | bool | true if the value has been changed in the configuration file but needs a restart; or false otherwise. |
Column history across versions
Version history 8
Definition snapshot: english-manuals:f7cab7b888c4a1c98810d03d05c… · English manual source