Re: POC: track vacuum/analyze cumulative time per relation - Mailing list pgsql-hackers

From Alena Rybakina
Subject Re: POC: track vacuum/analyze cumulative time per relation
Date
Msg-id b2be6254-c977-4329-b62f-c35ba8772641@postgrespro.ru
Whole thread Raw
In response to Re: POC: track vacuum/analyze cumulative time per relation  (Bertrand Drouvot <bertranddrouvot.pg@gmail.com>)
List pgsql-hackers

Hi!

On 28.01.2025 03:59, Michael Paquier wrote:
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

pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Restrict publishing of partitioned table with a foreign table as partition
Next
From: Peter Eisentraut
Date:
Subject: Re: NOT ENFORCED constraint feature