PG_SETTINGS¶
PG_SETTINGS displays information about parameters of the running database.
Column | Type | Description |
---|---|---|
Name | Text | 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 | Brief description of the parameter |
extra_desc | Text | Detailed description of the parameter |
context | Text | Context of parameter values including internal, postmaster, sighup, backend, superuser, and user |
vartype | Text | Parameter type. It can be 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 data, the value of this column is null. |
max_val | Text | Maximum value of the parameter. If the parameter type is not numeric data, the value of this column is null. |
enumvals | Text[] | Valid values of an enum-typed 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. |