Skip to main content
Version: 2.x

gp_settings

The gp_settings view is a cluster-wide view that displays the pg_settings information from every primary segment.

nametypereferencesdescription
gp_segment_idintegerUnique identifier of a segment (or coordinator) instance.
nametextRuntime configuration parameter name.
settingtextCurrent value of the parameter.
unittextImplicit unit of the parameter.
categorytextLogical group of the parameter.
short_desctextA brief description of the parameter.
extra_desctextAdditional, more detailed, description of the parameter.
contexttextContext required to set the parameter's value.
vartypetextParameter type (bool, enum, integer, real, or string)v
sourcetextSource of the current parameter value.v
min_valtextMinimum allowed value of the parameter (null for non-numeric values).
max_valtextMaximum allowed value of the parameter (null for non-numeric values).
enumvalstext[]Permitted values of an enum parameter (null for non-enum values).
boot_valtextParameter value assumed at server startup if the parameter is not otherwise set.
reset_valtextValue that RESET would reset the parameter to in the current session.
sourcefiletextConfiguration 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.
sourcelineintegerLine 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_restartbooleantrue if the value has been changed in the configuration file but needs a restart; otherwise false.