Message-ID: <b44fea2a-a89d-43fc-baaf-f235e24383b4@ya.ru>
Date: Mon, 26 Jan 2026 18:43:19 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: autoanalyze did not run
To: depesz@depesz.com
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: <0dce35ca-24fa-4234-99fe-071bd5725a32@ya.ru>
 <aXdarCF6GaMdpX5o@depesz.com>
Content-Language: ru, en-US
From: =?UTF-8?B?0J7Qu9C10LMg0KHQsNC80L7QudC70L7Qsg==?= <splarv@ya.ru>
In-Reply-To: <aXdarCF6GaMdpX5o@depesz.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/b44fea2a-a89d-43fc-baaf-f235e24383b4%40ya.ru>
Precedence: bulk


26.01.2026 15:14, hubert depesz lubaczewski пишет:
> On Mon, Jan 26, 2026 at 08:31:24AM +0300, Олег Самойлов wrote:
>> What is exact criteria to launch autoanalyze?
> You might want to read
> https://www.depesz.com/2020/02/18/which-tables-should-be-auto-vacuumed-or-auto-analyzed-update/
>
> Best regards,
>
> depesz

Yep, thanks. I rechecked in source. Indeed, autoanalyze depend only on 
mod_since_analyze and anlthresh = (float4) anl_base_thresh + 
anl_scale_factor * reltuples;

https://github.com/postgres/postgres/blob/master/src/backend/postmaster/autovacuum.c#L2901

relation_needs_vacanalyze(Oid relid,
                           AutoVacOpts *relopts,
                           Form_pg_class classForm,
                           PgStat_StatTabEntry *tabentry,
                           int effective_multixact_freeze_max_age,
  /* output params below */
                           bool *dovacuum,
                           bool *doanalyze,
                           bool *wraparound)

And wrote such variables into
elog(DEBUG3, "%s: vac: %.0f (threshold %.0f), ins: (disabled), anl: %.0f 
(threshold %.0f)"