{"Entry":{"collection":"relopts","key":"table-log-autovacuum-min-duration","name":"log_autovacuum_min_duration","aliases":["table.log_autovacuum_min_duration"],"metadata":{"aliases":["table.log_autovacuum_min_duration"],"category":"Tables and materialized views","content_hash":"b6b222d18e8b23c2f9f863ce74f7ff4766a57c25d51d5c9457daad45c8560a05","derived_content_hash":"890509f19394e020ee11c65267c7581990bfe3ac2711837f7befd011431b311f","imported_at":"2026-09-30T17:44:22.249557+08:00","name":"log_autovacuum_min_duration","name_zh":"log_autovacuum_min_duration","repair_provenance":{"original_source_revision":"","receipt_sha256":"5335d209c03bf4a25b8b042dc124b26475645673611122265681ee076b98b670","repair":"wiki-repair-20261023"},"slug":"table-log-autovacuum-min-duration","source_rev":"wiki-repair-20261023:693e5d73e8429e2cccad5995b9b3827cce1ddc91df85696b42be1fdaab906424","summary":"Per-table value for log_autovacuum_min_duration parameter."}},"Definition":{"Collection":"relopts","Key":"table-log-autovacuum-min-duration","SourceDatabase":"center","Version":"18","SourceTable":"relopt","SourceKey":"table-log-autovacuum-min-duration","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","Facts":{"description":["Per-table value for log_autovacuum_min_duration parameter."],"description_zh":"log_autovacuum_min_duration 参数的每表取值。","description_zh_html":"\u003cp\u003e\n\u003ca class=\"xref\" href=\"/zh/docs/18/runtime-config-logging.html#GUC-LOG-AUTOVACUUM-MIN-DURATION\"\u003elog_autovacuum_min_duration\u003c/a\u003e 参数的每表取值。\n     \u003c/p\u003e\u003ch3\u003e相关全局参数\u003c/h3\u003e\u003cp\u003e\n        当自动清理执行的操作运行时间至少达到指定时间时，就会记录该操作。将此设置为零会记录所有自动清理操作。\u003ccode class=\"literal\"\u003e-1\u003c/code\u003e 会禁用记录自动清理操作。如果未指定单位，则将其视为毫秒。例如，如果将其设置为 \u003ccode class=\"literal\"\u003e250ms\u003c/code\u003e，则所有运行时间为 250ms 或更长的自动清理和分析都将被记录。此外，当此参数设置为任何非 \u003ccode class=\"literal\"\u003e-1\u003c/code\u003e 值时，如果由于冲突锁或关系被并发删除而跳过自动清理操作，则会记录消息。默认值为 \u003ccode class=\"literal\"\u003e10min\u003c/code\u003e。启用此参数可帮助跟踪自动清理活动。此参数只能在 \u003ccode class=\"filename\"\u003epostgresql.conf\u003c/code\u003e 文件或服务器命令行中设置；但可以通过更改表存储参数来覆盖对单个表的设置。\n       \u003c/p\u003e","facts":[{"label":"Applies to","value":"Tables and materialized views"},{"label":"Value type","value":"integer"}],"related":[{"label":"Global parameter log_autovacuum_min_duration","url":"/wiki/guc/log_autovacuum_min_duration/?v=18"},{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sections":[{"paragraphs":["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."],"title":"Scope"},{"paragraphs":["The WITH clause can specify storage parameters for tables, and for indexes associated with a UNIQUE , PRIMARY KEY , or EXCLUDE constraint. Storage parameters for indexes are documented in CREATE INDEX . The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with toast. , which controls the behavior of the table's secondary TOAST table, if any (see Section 66.2 for more information about TOAST). If a table parameter value is set and the equivalent toast. parameter is not, the TOAST table will use the table's parameter value. Specifying these parameters for partitioned tables is not supported, but you may specify them for individual leaf partitions."],"title":"Common table storage rules"},{"paragraphs":["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters in the CREATE TABLE documentation for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."],"title":"Materialized views"},{"paragraphs":["The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.","Causes each action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs all autovacuum actions. -1 disables logging autovacuum actions. If this value is specified without units, it is taken as milliseconds. For example, if you set this to 250ms then all automatic vacuums and analyzes that run 250ms or longer will be logged. In addition, when this parameter is set to any value other than -1 , a message will be logged if an autovacuum action is skipped due to a conflicting lock or a concurrently dropped relation. The default is 10min . Enabling this parameter can be helpful in tracking autovacuum activity. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters."],"title":"Related global parameter: log_autovacuum_min_duration"}],"signature":"WITH (log_autovacuum_min_duration = value)","sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#RELOPTION-LOG-AUTOVACUUM-MIN-DURATION"},{"label":"Related global parameter: log_autovacuum_min_duration","path":"runtime-config-logging.html","sha256":"93c48c522a72fca19705c4c91a71e951eae653662008eee2e4a9a74a11127fde","url":"/docs/18/runtime-config-logging.html#GUC-LOG-AUTOVACUUM-MIN-DURATION"},{"label":"PostgreSQL 18 English manual","path":"sql-creatematerializedview.html","sha256":"bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18","url":"/docs/18/sql-creatematerializedview.html"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-createtable.html","sha256":"c044586c69b191e0f39966b25811a0c70f12fe2bf5e7f640501e53d76ca8f775"},{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/runtime-config-logging.html","sha256":"a322f5293f10e348b5fc5dca98fdb6af52462723a215b8701c3b9d933e2933b4"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"Local English manual 18.6","revision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744"},"sources":[{"label":"PostgreSQL 18 English manual","path":"sql-createtable.html","sha256":"b4d703391fe1102d0e02bd6769bef928513eb7a5542f38f7448fc77fe69e0d5b","url":"/docs/18/sql-createtable.html#RELOPTION-LOG-AUTOVACUUM-MIN-DURATION"},{"label":"Related global parameter: log_autovacuum_min_duration","path":"runtime-config-logging.html","sha256":"93c48c522a72fca19705c4c91a71e951eae653662008eee2e4a9a74a11127fde","url":"/docs/18/runtime-config-logging.html#GUC-LOG-AUTOVACUUM-MIN-DURATION"},{"label":"PostgreSQL 18 English manual","path":"sql-creatematerializedview.html","sha256":"bd8a6710c9f133afee191eb0ec345ef8c54bb54db2242621d8cb683c783a8b18","url":"/docs/18/sql-creatematerializedview.html"}]},"MeasuredEvidence":{}},"Text":{"Collection":"relopts","Key":"table-log-autovacuum-min-duration","SourceDatabase":"center","Version":"18","Locale":"en","Title":"log_autovacuum_min_duration","Summary":"Per-table value for log_autovacuum_min_duration parameter.","BodyHTML":"\u003cp\u003ePer-table value for log_autovacuum_min_duration parameter.\u003c/p\u003e","SourceRevision":"eb6c2292fdf28e1b4635ab478eec3919411cdf4a6c07553387870e26201f3744","ContentHash":"b9d146d77155d628694c5b36395e8fa663a284ac1bb0a69dd34eacfabb828eda","Payload":{"description":["Per-table value for log_autovacuum_min_duration parameter."],"related":[{"label":"Global parameter log_autovacuum_min_duration","url":"/wiki/guc/log_autovacuum_min_duration/?v=18"},{"label":"CREATE TABLE","url":"/wiki/sql/create-table/?v=18"}],"sections":[{"paragraphs":["This relation-level setting applies to the table or materialized view. Any corresponding global parameter has a separate entry."],"title":"Scope"},{"paragraphs":["The WITH clause can specify storage parameters for tables, and for indexes associated with a UNIQUE , PRIMARY KEY , or EXCLUDE constraint. Storage parameters for indexes are documented in CREATE INDEX . The storage parameters currently available for tables are listed below. For many of these parameters, as shown, there is an additional parameter with the same name prefixed with toast. , which controls the behavior of the table's secondary TOAST table, if any (see Section 66.2 for more information about TOAST). If a table parameter value is set and the equivalent toast. parameter is not, the TOAST table will use the table's parameter value. Specifying these parameters for partitioned tables is not supported, but you may specify them for individual leaf partitions."],"title":"Common table storage rules"},{"paragraphs":["This clause specifies optional storage parameters for the new materialized view; see Storage Parameters in the CREATE TABLE documentation for more information. All parameters supported for CREATE TABLE are also supported for CREATE MATERIALIZED VIEW . See CREATE TABLE for more information."],"title":"Materialized views"},{"paragraphs":["The following same-version GUC definition explains its purpose and units. Global defaults and activation rules describe the GUC; the relation-option override rules remain those above.","Causes each action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs all autovacuum actions. -1 disables logging autovacuum actions. If this value is specified without units, it is taken as milliseconds. For example, if you set this to 250ms then all automatic vacuums and analyzes that run 250ms or longer will be logged. In addition, when this parameter is set to any value other than -1 , a message will be logged if an autovacuum action is skipped due to a conflicting lock or a concurrently dropped relation. The default is 10min . Enabling this parameter can be helpful in tracking autovacuum activity. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters."],"title":"Related global parameter: log_autovacuum_min_duration"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}