Message-ID: <c6b71dd5f6839962adef8b1481d9de348ccce661.camel@cybertec.at>
Subject: Re: autoanalyze did not run
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?UTF-8?Q?=D0=9E=D0=BB=D0=B5=D0=B3_?=
 =?UTF-8?Q?=D0=A1=D0=B0=D0=BC=D0=BE=D0=B9=D0=BB=D0=BE=D0=B2?=
	 <splarv@ya.ru>, Pgsql-admin <pgsql-admin@lists.postgresql.org>
Date: Mon, 26 Jan 2026 08:23:19 +0100
In-Reply-To: <0dce35ca-24fa-4234-99fe-071bd5725a32@ya.ru>
References: <0dce35ca-24fa-4234-99fe-071bd5725a32@ya.ru>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.2 (3.58.2-1.fc43) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/c6b71dd5f6839962adef8b1481d9de348ccce661.camel%40cybertec.at>
Precedence: bulk

On Mon, 2026-01-26 at 08:31 +0300, =D0=9E=D0=BB=D0=B5=D0=B3 =D0=A1=D0=B0=D0=
=BC=D0=BE=D0=B9=D0=BB=D0=BE=D0=B2 wrote:
> I try to investigate why autoanalyze did not run in time of our initial=
=20
> loading data. Yes, I know, running analyze manually is highly=20
> recommended in such case. But is must run automatically too.

You'd have to show more evidence that this is a bug, or provide a way
to reproduce the problem.

> select relid::regclass, n_live_tup, n_tup_ins, n_tup_upd,=20
> n_mod_since_analyze from pg_stat_user_tables as s join pg_class as c on=
=20
> (s.relid=3Dc.oid) where s.autoanalyze_count=3D0 and relkind=3D'r' and=20
> n_live_tup>0 limit 1;
> -[ RECORD 1 ]-------+----------
> relid=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| addresses
> n_live_tup=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | 13844405
> n_tup_ins=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 0
> n_tup_upd=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 0
> n_mod_since_analyze | 0
>=20
> PostgreSQL 17.7 (Debian 17.7-3.pgdg13+1) on x86_64-pc-linux-gnu,=20
> compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit (from PGDG)

Are you sure that you committed the transaction?

Is "track_activities" set to "on"?

Yours,
Laurenz Albe