Add metrics useful to tune autovacuum

Description

Please show some info that tells us if autovacuum runs often enough:

  • How many transaction id's to the next wraparound

  • Table bloats (ideally, size of fastest growing tables... but i guess that size of the biggest tables is more doable?)

  • Visibility maps (pg_visibility?)

 

How to test

None

How to document

None

is blocked by

Smart Checklist

Activity

Lalit Choudhary October 1, 2020 at 2:36 PM

Hi Federico,

Thank you for the report.

 

Details

Assignee

Reporter

Priority

Components

Needs QA

Yes

Needs Doc

Yes

Smart Checklist

Created September 22, 2018 at 8:43 AM
Updated March 6, 2024 at 6:51 AM