{"Entry":{"collection":"catalog","key":"pg_settings","name":"pg_settings","aliases":[],"metadata":{"changed_in":["8.0","8.2","8.4","9.5"],"changes":[{"added":["category","short_desc","extra_desc"],"attributes":[],"description_changed":false,"descriptions":[],"from":"7.4","listing":[],"order":false,"removed":[],"status":"changed","to":"8.0","types":[],"unlisted":[]},{"added":["unit"],"attributes":[],"description_changed":false,"descriptions":[{"from":"logical group of the parameter","name":"category","to":"Logical group of the parameter"},{"from":"context required to set the parameter's value","name":"context","to":"Context required to set the parameter's value"},{"from":"additional, more detailed, information about the parameter","name":"extra_desc","to":"Additional, more detailed, information about the parameter"},{"from":"maximum allowed value of the parameter (NULL for nonnumeric values)","name":"max_val","to":"Maximum allowed value of the parameter (NULL for non-numeric values)"},{"from":"minimum allowed value of the parameter (NULL for nonnumeric values)","name":"min_val","to":"Minimum allowed value of the parameter (NULL for non-numeric values)"},{"from":"run-time configuration parameter name","name":"name","to":"Run-time configuration parameter name"},{"from":"current value of the parameter","name":"setting","to":"Current value of the parameter"},{"from":"a brief description of the parameter","name":"short_desc","to":"A brief description of the parameter"},{"from":"source of the current parameter value","name":"source","to":"Source of the current parameter value"},{"from":"parameter type (bool, integer, real, or string)","name":"vartype","to":"Parameter type (bool, integer, real, or string)"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"changed","to":"8.2","types":[],"unlisted":[]},{"added":["enumvals","boot_val","reset_val","sourcefile","sourceline"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Additional, more detailed, information about the parameter","name":"extra_desc","to":"Additional, more detailed, description of the parameter"},{"from":"Parameter type (bool, integer, real, or string)","name":"vartype","to":"Parameter type (bool, enum, integer, real, or string)"}],"from":"8.3","listing":[],"order":false,"removed":[],"status":"changed","to":"8.4","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Allowed values of an enum parameter (NULL for non-enum values)","name":"enumvals","to":"Allowed values of an enum parameter (null for non-enum values)"},{"from":"Maximum allowed value of the parameter (NULL for non-numeric values)","name":"max_val","to":"Maximum allowed value of the parameter (null for non-numeric values)"},{"from":"Minimum allowed value of the parameter (NULL for non-numeric values)","name":"min_val","to":"Minimum allowed value of the parameter (null for non-numeric values)"},{"from":"Configuration file the current value was set in (NULL for values set from sources other than configuration files, or when examined by a non-superuser). Helpful when using configuration include directives","name":"sourcefile","to":"Configuration file the current value was set in (null for values set from sources other than configuration files, or when examined by a non-superuser); helpful when using include directives in configuration files"},{"from":"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 non-superuser)","name":"sourceline","to":"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 non-superuser)"}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Context required to set the parameter's value","name":"context","to":"Context required to set the parameter's value (see below)"}],"from":"9.0","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.1","types":[],"unlisted":[]},{"added":["pending_restart"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.5","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Configuration file the current value was set in (null for values set from sources other than configuration files, or when examined by a non-superuser); helpful when using include directives in configuration files","name":"sourcefile","to":"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"},{"from":"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 non-superuser)","name":"sourceline","to":"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)."}],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"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","name":"sourcefile","to":"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 neither is a superuser nor has privileges of pg_read_all_settings); helpful when using include directives in configuration files"},{"from":"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).","name":"sourceline","to":"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 neither is a superuser nor has privileges of pg_read_all_settings)."}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]}],"column_count":17,"content_hash":"5f87210671486ba871743de84bc5780562351348652d023e624ce42d64c293fe","first_version":"7.4","imported_at":"2026-09-30T00:40:55.80636+08:00","kind":"view","last_version":"20","name":"pg_settings","position":74,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:f7cab7b888c4a1c98810d03d05c3b5e6c3ef7969ddec351f5561ffc2cb45b0f4","summary":"The view pg_settings provides access to run-time parameters of the server.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_settings","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_settings","SourceRevision":"english-manuals:f7cab7b888c4a1c98810d03d05c3b5e6c3ef7969ddec351f5561ffc2cb45b0f4","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Run-time configuration parameter name","description_zh":"","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":2,"description":"Current value of the parameter","description_zh":"","documented":true,"documented_name":"setting","hidden":false,"name":"setting","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"Implicit unit of the parameter","description_zh":"","documented":true,"documented_name":"unit","hidden":false,"name":"unit","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":4,"description":"Logical group of the parameter","description_zh":"","documented":true,"documented_name":"category","hidden":false,"name":"category","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":5,"description":"A brief description of the parameter","description_zh":"","documented":true,"documented_name":"short_desc","hidden":false,"name":"short_desc","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":6,"description":"Additional, more detailed, description of the parameter","description_zh":"","documented":true,"documented_name":"extra_desc","hidden":false,"name":"extra_desc","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":7,"description":"Context required to set the parameter's value (see below)","description_zh":"","documented":true,"documented_name":"context","hidden":false,"name":"context","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":8,"description":"Parameter type (bool, enum, integer, real, or string)","description_zh":"","documented":true,"documented_name":"vartype","hidden":false,"name":"vartype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":9,"description":"Source of the current parameter value","description_zh":"","documented":true,"documented_name":"source","hidden":false,"name":"source","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":10,"description":"Minimum allowed value of the parameter (null for non-numeric values)","description_zh":"","documented":true,"documented_name":"min_val","hidden":false,"name":"min_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":11,"description":"Maximum allowed value of the parameter (null for non-numeric values)","description_zh":"","documented":true,"documented_name":"max_val","hidden":false,"name":"max_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":12,"description":"Allowed values of an enum parameter (null for non-enum values)","description_zh":"","documented":true,"documented_name":"enumvals","hidden":false,"name":"enumvals","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009},{"array_dimensions":0,"attnum":13,"description":"Parameter value assumed at server startup if the parameter is not otherwise set","description_zh":"","documented":true,"documented_name":"boot_val","hidden":false,"name":"boot_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":14,"description":"Value that RESET would reset the parameter to in the current session","description_zh":"","documented":true,"documented_name":"reset_val","hidden":false,"name":"reset_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":15,"description":"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 neither is a superuser nor has privileges of pg_read_all_settings); helpful when using include directives in configuration files","description_zh":"","documented":true,"documented_name":"sourcefile","hidden":false,"name":"sourcefile","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":16,"description":"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 neither is a superuser nor has privileges of pg_read_all_settings).","description_zh":"","documented":true,"documented_name":"sourceline","hidden":false,"name":"sourceline","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":17,"description":"true if the value has been changed in the configuration file but needs a restart; or false otherwise.","description_zh":"","documented":true,"documented_name":"pending_restart","hidden":false,"name":"pending_restart","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16}],"description":"The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the SHOW and SET commands. It also provides access to some facts about each parameter that are not directly available from SHOW, such as minimum and maximum values.","description_zh":"","doc":{"anchor":"id-1.10.5.29.4","file":"view-pg-settings.html","lang":"en","sha256":"6769a87cdfc49f4b624ad6140895013fa85797190ef37fcf91acb5f04baeee16","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","setting","unit","category","short_desc","extra_desc","context","vartype","source","min_val","max_val","enumvals","boot_val","reset_val","sourcefile","sourceline","pending_restart"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.29.4","file":"view-pg-settings.html","lang":"en","sha256":"6769a87cdfc49f4b624ad6140895013fa85797190ef37fcf91acb5f04baeee16","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["name","setting","unit","category","short_desc","extra_desc","context","vartype","source","min_val","max_val","enumvals","boot_val","reset_val","sourcefile","sourceline","pending_restart"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_settings","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_settings","Summary":"视图pg_settings提供对服务器运行时参数的访问。它实质上是SHOW和SET命令的替代接口。它还提供了一些关于每个参数的事实，这些事实无法直接从SHOW中获取，例如最小值和最大值。","BodyHTML":"\u003cp\u003e视图pg_settings提供对服务器运行时参数的访问。它实质上是SHOW和SET命令的替代接口。它还提供了一些关于每个参数的事实，这些事实无法直接从SHOW中获取，例如最小值和最大值。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"3b66fb2cb238e6e6f74d24cb2c87347bec7503502f13fe747cc39d8a878845f2","Payload":{"columns":[{"description_zh":"运行时配置参数名","name":"name","type":"text","zh_from":"doc"},{"description_zh":"参数的当前值","name":"setting","type":"text","zh_from":"doc"},{"description_zh":"参数的隐含单位","name":"unit","type":"text","zh_from":"doc"},{"description_zh":"参数的逻辑组","name":"category","type":"text","zh_from":"doc"},{"description_zh":"参数的简短描述","name":"short_desc","type":"text","zh_from":"doc"},{"description_zh":"关于该参数的附加详细描述","name":"extra_desc","type":"text","zh_from":"doc"},{"description_zh":"设置参数值所需的上下文（见下文）","name":"context","type":"text","zh_from":"doc"},{"description_zh":"参数类型（bool，enum，integer，real，或 string）","name":"vartype","type":"text","zh_from":"doc"},{"description_zh":"当前参数值的来源","name":"source","type":"text","zh_from":"doc"},{"description_zh":"参数的最小允许值（对非数值参数为 NULL）","name":"min_val","type":"text","zh_from":"doc"},{"description_zh":"参数的最大允许值（对非数值参数为 NULL）","name":"max_val","type":"text","zh_from":"doc"},{"description_zh":"枚举参数的允许值（对非枚举参数为 NULL）","name":"enumvals","type":"text[]","zh_from":"doc"},{"description_zh":"如果该参数未以其他方式设置，则为服务器启动时假定的参数值","name":"boot_val","type":"text","zh_from":"doc"},{"description_zh":"在当前会话中，RESET 会将此参数重置到这个值","name":"reset_val","type":"text","zh_from":"doc"},{"description_zh":"设置当前值的配置文件（对于来自配置文件以外来源的值，或者由既不是超级用户也没有 pg_read_all_settings 角色权限的用户查看时，为 NULL）；在配置文件中使用 include 指令时这很有帮助","name":"sourcefile","type":"text","zh_from":"doc"},{"description_zh":"设置当前值的配置文件行号（对于来自配置文件以外来源的值，或者查看者既非超级用户、也不具有 pg_read_all_settings 角色权限时，为 NULL）。","name":"sourceline","type":"integer","zh_from":"doc"},{"description_zh":"如果配置文件中修改了该值但需要重启，则为true，否则为false","name":"pending_restart","type":"boolean","zh_from":"doc"}],"description_zh":"视图pg_settings提供对服务器运行时参数的访问。它实质上是SHOW和SET命令的替代接口。它还提供了一些关于每个参数的事实，这些事实无法直接从SHOW中获取，例如最小值和最大值。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}