PG_SETTINGS
PG_SETTINGS displays information about parameters of the running database.
| Name | 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, 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. |
Last Article: PG_SESSION_IOSTAT
Next Article: PG_SHADOW
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.