---
title: "gp_settings"
source: https://cloudberry.apache.org/docs/sys-catalogs/sys-views/gp-settings
---

# 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`.|