Skip to content

Add metric total_autovacuum_time #1227

Description

@konrad-erli

Proposal

Export new columns of pg_stat_user_tables, that were introduced in postgres 18:
total_vacuum_time, total_autovacuum_time, total_analyze_time, total_autoanalyze_time

Rate of total_autovacuum_time (over longer periods) shows how much vacuuming does a table require, shows if table is putting pressure on autovacuum system. Analyzing it helps tune autovacuum settings: number of threads, budgests/sleeps.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions