Updated on 2024-06-03 GMT+08:00

CONFIG_SETTINGS

CONFIG_SETTINGS displays information about parameters of the running database, as described in Table 1.

Table 1 CONFIG_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

Maximum value of the parameter. If the parameter type is not numeric, the value of this column is null.

max_val

text

Minimum 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 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 in the configuration file for setting parameter values. If parameter values are not configured using the configuration file, the value of this column is null.