PG_SETTINGS
PG_SETTINGS displays information about parameters of the running database.
| Name | Type | Description |
|---|---|---|
| name | text | Parameter name. |
| setting | text | Current parameter value. |
| unit | text | 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
