Feedback-ID: i0fe9450f:Fastmail
Date: Wed, 25 Mar 2026 11:07:08 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Yugo Nagata <nagata@sraoss.co.jp>
Cc: Sami Imseih <samimseih@gmail.com>,
	Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Track skipped tables during autovacuum and autoanalyze
Message-ID: <acNDTM20nJjDYZxq@paquier.xyz>
References: <20260324151133.7940a5c1f2ebd594d54da481@sraoss.co.jp>
 <CAA5RZ0snnePNW1NKGKh+NyJ1CY26T5F_6-tTq+BHWM2kj1fN1g@mail.gmail.com>
 <20260325012847.e026ba1860c07288efe3e97d@sraoss.co.jp>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="B7PL4xzPqBDusTYg"
Content-Disposition: inline
In-Reply-To: <20260325012847.e026ba1860c07288efe3e97d@sraoss.co.jp>
Archived-At: 
 <https://www.postgresql.org/message-id/acNDTM20nJjDYZxq%40paquier.xyz>
Precedence: bulk


--B7PL4xzPqBDusTYg
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 25, 2026 at 01:28:47AM +0900, Yugo Nagata wrote:
> Although the timestamps are overwritten on each skipped autovacuum or
> autoanalyze, they still indicate when the last attempt was made. This
> can help users confirm that autovacuum is actively attempting to run,
> and that the issue is due to repeated skips rather than inactivity.
>=20
> While counters can indicate overall activity, they do not reveal when
> the last skip occurred. With timestamps, users can immediately see the
> most recent attempt, even without a separate dashboard or historical
> tracking.
>=20
> Therefore, counters are useful for monitoring overall activity, but
> timestamps give additional, complementary information, so it seems
> worthwhile to include them too.

Hmm..  I can buy this argument for the timestamps, especially for
database with many relations of various sizes that could take a
various amount of time to process.  The timestamps could offer hints
about the time it takes between the skips, even if snapshots of the
stats data are not taken at a very aggressive frequency.

This is v20 material at this stage, of course..
--
Michael

--B7PL4xzPqBDusTYg
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnDQ0wACgkQnvQgOdby
QH1KDg/+P8WXdpKAT1JJ8J5j172Ht0usmA9WhqtP6Wg65zNpU7iODFcGYkMsQrvu
bbLeYRQGc+EAGGUa5IOIBDY+Wf+24yKFdlafBxJEl3N5SEfwkLTr10cTthHqfs65
Tq+laUJ3E9sVRTd6YoEfLeFCKgg//kkC/sD7B4SIkrTB7Ltw9lInhaPjnIkcNzMK
1FW73yDyJ0DRgFGMA+wPor2oaEHWx6xinSjl3wvDuZYDFGaoLFe/AcLSaDGMa3GY
LO50xJN6MiL+qic9YA780n9gjRKzna/4EwcDxzj8mzDxyEl1LKdgtmxQx8DYqkxK
OsaagcqxKHCgk3dd+vs3WoHTQY0gMEm4zyJTytlr7lwX7xwQEKPenNeQB6g1naOt
UYn3NMwySxKe8gD7yznwceUy7wrPLQKxnzhm03/QfgJk6duyWaojeqSb1ylkRn9K
CS3Lu5FL0a9+AnAP0r9F7ccAVnrpSYKDn/kTCAImAg2yMg1FpApBRYGdIIBUcDSG
e64FX1woLmqUvyIhXX/GOQThVOjPvYA4pyK6RU2BmgtlnsGvyzQIdWsqcBkLWk/o
CxYat/sWDNPbDtvWRMvF3t4Bxu4eLojiwrTSkufpmHXi9+mmzHQL9DzD/cP0XTKS
e3Oh3Og5BXQI7VqsewdweVTWmyeDofsl1O/5s6CgTm50r6RdTZc=
=7z/e
-----END PGP SIGNATURE-----

--B7PL4xzPqBDusTYg--