Horton

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

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Sami Imseih <samimseih@gmail.com>
Cc: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-01-28T00:59:50Z
Lists: pgsql-hackers 
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.
--
Michael

Commits

  1. Track per-relation cumulative time spent in [auto]vacuum and [auto]analyze