PG_SETTINGS

PG_SETTINGS displays information about parameters of the running database.

Table 1 PG_SETTINGS columns

Name	Type	Description
name	text	Parameter name
setting	text	Current parameter value
unit	text	Implicit unit of the parameter
category	text	Logical group of the parameter
short_desc	text	Brief description of the parameter
extra_desc	text	Detailed description of the parameter
context	text	Context required to set the parameter value, including internal, postmaster, sighup, backend, superuser, and user
vartype	text	Parameter type, including bool, enum, integer, real, or string
source	text	Method of assigning the parameter value
min_val	text	Minimum value of the parameter. If the parameter type is not numeric, the value of this column is null.
max_val	text	Maximum value of the parameter. If the parameter type is not numeric, the value of this column is null.
enumvals	text[]	Valid values of an enum-type parameter. If the parameter type is not enum, the value of this column is null.
boot_val	text	Default parameter value used upon the database startup
reset_val	text	Default parameter value used upon the database reset
sourcefile	text	Configuration file used to set parameter values. If parameter values are not configured using the configuration file, the value of this column is null.
sourceline	integer	Row number of the configuration file for setting parameter values. If parameter values are not configured using the configuration file, the value of this column is null.