pg_stat_user_tables.total_autovacuum_time

Description

Total time this table has been vacuumed by the autovacuum daemon, in milliseconds. (This includes the time spent sleeping due to cost-based delays.)

View

pg_stat_user_tables

Field

total_autovacuum_time

SQL type

double precision

Units named in the field definition

milliseconds

Reset observation

No stats_reset field is documented for this view

Usage

SELECT total_autovacuum_time FROM pg_catalog.pg_stat_user_tables;

View semantics

Same as pg_stat_all_tables, except that only user tables are shown.

Collection and reset context

Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.

Inspect this field

Example query; no execution result or measured value is asserted.

SELECT total_autovacuum_time FROM pg_catalog.pg_stat_user_tables;

Related entries

• pg_stat_user_tables columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 17 → 18: added.

--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1 +1,8 @@
-Not recorded in this version
+{
+  "field": "total_autovacuum_time",
+  "sql_type": "double precision",
+  "units_mentioned": [
+    "milliseconds"
+  ],
+  "view": "pg_stat_user_tables"
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_user_tables.analyze_count
• pg_stat_user_tables.autoanalyze_count
• pg_stat_user_tables.autovacuum_count
• pg_stat_user_tables.idx_scan
• pg_stat_user_tables.idx_tup_fetch
• pg_stat_user_tables.last_analyze
• pg_stat_user_tables.last_autoanalyze
• pg_stat_user_tables.last_autovacuum
• pg_stat_user_tables.last_idx_scan
• pg_stat_user_tables.last_seq_scan
• pg_stat_user_tables.last_vacuum
• pg_stat_user_tables.n_dead_tup