PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_settings

Read PG 18 manual ↗

The view pg_settings provides access to run-time parameters of the server.

Kind: System views
Columns in this snapshot: 17
Definition source: English manual

Columns 17

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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`name`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`setting`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`unit`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`category`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`short_desc`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extra_desc`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`context`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`vartype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`source`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`min_val`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`max_val`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`enumvals`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`boot_val`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`reset_val`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`sourcefile`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`sourceline`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`pending_restart`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 4

Definition snapshot: english-manuals:3a060e9f1e9c40bd765fb66ca08… · English manual source