{"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":"eb735a2a87d845b3e802ea33a19a23a69e13711ff8ff9cb21a6ac05f569a3976","derived_content_hash":"36d2c7ac4d7938887c008958ccd592bbe1e0e937954b45f42622ad66712db7d4","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":"catalog-bilingual-repair:bfe6db6dd45a4cd42bfa3939bba2d3669e998f86e4d403843dd31f6d8b4db30f","summary":"The view pg_settings provides access to run-time parameters of the server.","summary_zh":"视图 pg_settings 提供对服务器运行时参数的访问。它实质上是 SHOW 和 SET 命令的替代接口。它还提供了一些关于每个参数的事实，这些事实无法直接从 SHOW 中获取，例如最小值和最大值。"}},"Definition":{"Collection":"catalog","Key":"pg_settings","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_settings","SourceRevision":"catalog-bilingual-repair:bfe6db6dd45a4cd42bfa3939bba2d3669e998f86e4d403843dd31f6d8b4db30f","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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Parameter type (bool, enum, integer, real, or string)","description_zh":"参数类型（bool，enum，integer，real，或 string）","documented":true,"documented_name":"vartype","hidden":false,"name":"vartype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Minimum allowed value of the parameter (null for non-numeric values)","description_zh":"参数的最小允许值（对非数值参数为 NULL）","documented":true,"documented_name":"min_val","hidden":false,"name":"min_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Maximum allowed value of the parameter (null for non-numeric values)","description_zh":"参数的最大允许值（对非数值参数为 NULL）","documented":true,"documented_name":"max_val","hidden":false,"name":"max_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Allowed values of an enum parameter (null for non-enum values)","description_zh":"枚举参数的允许值（对非枚举参数为 NULL）","documented":true,"documented_name":"enumvals","hidden":false,"name":"enumvals","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Value that RESET would reset the parameter to in the current session","description_zh":"在当前会话中，RESET 会将此参数重置到这个值","documented":true,"documented_name":"reset_val","hidden":false,"name":"reset_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"设置当前值的配置文件（对于来自配置文件以外来源的值，或者由既不是超级用户也没有 pg_read_all_settings 角色权限的用户查看时，为 NULL）；在配置文件中使用 include 指令时这很有帮助","documented":true,"documented_name":"sourcefile","hidden":false,"name":"sourcefile","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"设置当前值的配置文件行号（对于来自配置文件以外来源的值，或者查看者既非超级用户、也不具有 pg_read_all_settings 角色权限时，为 NULL）。","documented":true,"documented_name":"sourceline","hidden":false,"name":"sourceline","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"如果配置文件中修改了该值但需要重启，则为 true，否则为 false","documented":true,"documented_name":"pending_restart","hidden":false,"name":"pending_restart","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"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":"视图 pg_settings 提供对服务器运行时参数的访问。它实质上是 SHOW 和 SET 命令的替代接口。它还提供了一些关于每个参数的事实，这些事实无法直接从 SHOW 中获取，例如最小值和最大值。","description_zh_html":"\u003cp\u003e视图 pg_settings 提供对服务器运行时参数的访问。它实质上是 SHOW 和 SET 命令的替代接口。它还提供了一些关于每个参数的事实，这些事实无法直接从 SHOW 中获取，例如最小值和最大值。\u003c/p\u003e","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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-settings.html","sha256":"930a98c7b733d6bf2b12d710404837701a800a92d95fd94db50526978d0591ac","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:f7cab7b888c4a1c98810d03d05c3b5e6c3ef7969ddec351f5561ffc2cb45b0f4","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.29.4","file":"view-pg-settings.html","lang":"en","sha256":"6769a87cdfc49f4b624ad6140895013fa85797190ef37fcf91acb5f04baeee16","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-settings.html","sha256":"930a98c7b733d6bf2b12d710404837701a800a92d95fd94db50526978d0591ac","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:f7cab7b888c4a1c98810d03d05c3b5e6c3ef7969ddec351f5561ffc2cb45b0f4","version":"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":"center","Version":"18","Locale":"en","Title":"pg_settings","Summary":"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.","BodyHTML":"\u003cp\u003eThe 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:bfe6db6dd45a4cd42bfa3939bba2d3669e998f86e4d403843dd31f6d8b4db30f","ContentHash":"54d4ac7d989e5dd81512f370074b3ea9998437232a7b7c1ef56da3cbff5175a2","Payload":{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Parameter type (bool, enum, integer, real, or string)","description_zh":"参数类型（bool，enum，integer，real，或 string）","documented":true,"documented_name":"vartype","hidden":false,"name":"vartype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Minimum allowed value of the parameter (null for non-numeric values)","description_zh":"参数的最小允许值（对非数值参数为 NULL）","documented":true,"documented_name":"min_val","hidden":false,"name":"min_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":11,"description":"Maximum allowed value of the parameter (null for non-numeric values)","description_zh":"参数的最大允许值（对非数值参数为 NULL）","documented":true,"documented_name":"max_val","hidden":false,"name":"max_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":12,"description":"Allowed values of an enum parameter (null for non-enum values)","description_zh":"枚举参数的允许值（对非枚举参数为 NULL）","documented":true,"documented_name":"enumvals","hidden":false,"name":"enumvals","not_null":false,"references":"","type":"text[]","type_modifier":-1,"type_oid":1009,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":14,"description":"Value that RESET would reset the parameter to in the current session","description_zh":"在当前会话中，RESET 会将此参数重置到这个值","documented":true,"documented_name":"reset_val","hidden":false,"name":"reset_val","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"设置当前值的配置文件（对于来自配置文件以外来源的值，或者由既不是超级用户也没有 pg_read_all_settings 角色权限的用户查看时，为 NULL）；在配置文件中使用 include 指令时这很有帮助","documented":true,"documented_name":"sourcefile","hidden":false,"name":"sourcefile","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"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":"设置当前值的配置文件行号（对于来自配置文件以外来源的值，或者查看者既非超级用户、也不具有 pg_read_all_settings 角色权限时，为 NULL）。","documented":true,"documented_name":"sourceline","hidden":false,"name":"sourceline","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"如果配置文件中修改了该值但需要重启，则为 true，否则为 false","documented":true,"documented_name":"pending_restart","hidden":false,"name":"pending_restart","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"}],"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."}},"RequestedLocale":"en","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}