Re: Vacuum timing in pg_stat_all_tables

Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

From: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: Magnus Hagander <magnus@hagander.net>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>, Michael Paquier <michael@paquier.xyz>, "Imseih (AWS), Sami" <simseih@amazon.com>

Date: 2025-03-12T10:52:57Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

doc: Mention cost-based delays for total_[auto]{vacuum,analyze}_time
- 92ee8a4df5b5 18.0 landed
Add cost-based vacuum delay time to progress views.
- bb8dff9995f2 18.0 cited

Attachments

v1-0001-Add-more-details-for-pg_stat_all_tables.patch (text/x-diff)

Hi,

On Tue, Mar 04, 2025 at 03:24:26PM +0000, Bertrand Drouvot wrote:
> Like "more stats are always nice" I think that "more explanations in the doc" are
> always nice, so I don't see any reason why not to add this extra explanation.

Attached an attempt to do so.

Note that it does not add extra explanation to "cost-based delay". If we feel the
need we could add a link to "<xref linkend="runtime-config-resource-vacuum-cost"/>"
like it has been done for delay_time in bb8dff9995f.

Regards,

-- 
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com