GLOBAL_CONFIG_SETTINGS
GLOBAL_CONFIG_SETTINGS displays information about parameters of running databases on each node.
Table 1 GLOBAL_CONFIG_SETTINGS columns
Name | Type | Description |
---|
node_name | text | Database process name |
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-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 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. |
openGauss 2024-09-07 00:58:25