Add log_autoanalyze_min_duration
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 15 Oct 2025 12:31:12 +0000 (14:31 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 15 Oct 2025 12:31:12 +0000 (14:31 +0200)
commitdd3ae378301f7e84c18f7a90f183c3cd4165c0da
tree6de83d42ae4be0d0d1c29ed6255cd48e7809cdbc
parent12609fbacb007698ec91101b6464436506518346
Add log_autoanalyze_min_duration

The log output functionality of log_autovacuum_min_duration applies to
both VACUUM and ANALYZE, so it is not possible to separate the VACUUM
and ANALYZE log output thresholds. Logs are likely to be output only for
VACUUM and not for ANALYZE.

Therefore, we decided to separate the threshold for log output of VACUUM
by autovacuum (log_autovacuum_min_duration) and the threshold for log
output of ANALYZE by autovacuum (log_autoanalyze_min_duration).

Author: Shinya Kato <shinya11.kato@gmail.com>
Reviewed-by: Kasahara Tatsuhito <kasaharatt@oss.nttdata.com>
Discussion: https://www.postgresql.org/message-id/flat/CAOzEurQtfV4MxJiWT-XDnimEeZAY+rgzVSLe8YsyEKhZcajzSA@mail.gmail.com
16 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/maintenance.sgml
doc/src/sgml/ref/create_table.sgml
src/backend/access/common/reloptions.c
src/backend/access/heap/vacuumlazy.c
src/backend/commands/analyze.c
src/backend/commands/vacuum.c
src/backend/postmaster/autovacuum.c
src/backend/utils/misc/guc_parameters.dat
src/backend/utils/misc/postgresql.conf.sample
src/bin/psql/tab-complete.in.c
src/include/commands/vacuum.h
src/include/postmaster/autovacuum.h
src/include/utils/rel.h
src/test/regress/pg_regress.c
src/tools/ci/pg_ci_base.conf