Skip to content

Add metric total_autovacuum_time #1227

@konrad-erli

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

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions