gp_settings
The gp_settings
view is a cluster-wide view that displays the pg_settings
information from every primary segment.
name | type | references | description |
---|---|---|---|
gp_segment_id | integer | Unique identifier of a segment (or coordinator) instance. | |
name | text | Runtime configuration 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 | A brief description of the parameter. | |
extra_desc | text | Additional, more detailed, description of the parameter. | |
context | text | Context required to set the parameter's value. | |
vartype | text | Parameter type (bool, enum, integer, real, or string)v | |
source | text | Source of the current parameter value.v | |
min_val | text | Minimum allowed value of the parameter (null for non-numeric values). | |
max_val | text | Maximum allowed value of the parameter (null for non-numeric values). | |
enumvals | text[] | Permitted values of an enum parameter (null for non-enum values). | |
boot_val | text | Parameter value assumed at server startup if the parameter is not otherwise set. | |
reset_val | text | Value that RESET would reset the parameter to in the current session. | |
sourcefile | text | Configuration file the current value was set in (null for values set from sources other than configuration files, or when examined by a user who is neither a superuser or a member of pg_read_all_settings ); helpful when using include directives in configuration files. | |
sourceline | integer | Line number within the configuration file the current value was set at (null for values set from sources other than configuration files, or when examined by a user who is neither a superuser or a member of pg_read_all_settings). | |
pending_restart | boolean | true if the value has been changed in the configuration file but needs a restart; otherwise false . |