Re: POC: track vacuum/analyze cumulative time per relation

Hi!

On Mon, Jan 27, 2025 at 11:22:16AM -0600, Sami Imseih wrote:

I have put my hands on this patch, and at the end I think that we
should just do the attached, which is simpler and addresses your
use-case.  Note also that the end time is acquired while the entries
are not locked in the report routines, and some tweaks in the docs and
comments.

Thanks for the update. This LGTM.

Okidoki.  Done, then, with bumps for the catalog version and the stats
file version.

You might be interested in looking at my patch for collecting vacuum statistics? Same issue, but it collects more information about the vacuum procedure for relations and databases.

I mentioned it here [0] in the current thread.

[0] https://www.postgresql.org/message-id/Z4U3hkWuEgByhGgJ%40ip-10-97-1-34.eu-west-3.compute.internal

-- 
Regards,
Alena Rybakina
Postgres Professional