pg_stat_all_tables.last_autoanalyze

Description

Last time at which this table was analyzed by the autovacuum daemon

View

pg_stat_all_tables

Field

last_autoanalyze

SQL type

timestamp with time zone

Units named in the field definition

Not specified

Reset observation

No stats_reset field is documented for this view

Usage

SELECT last_autoanalyze FROM pg_catalog.pg_stat_all_tables;

View semantics

The pg_stat_all_tables view will contain one row for each table in the current database (including TOAST tables), showing statistics about accesses to that specific table. The pg_stat_user_tables and pg_stat_sys_tables views contain the same information, but filtered to only show user and system tables respectively.

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 last_autoanalyze FROM pg_catalog.pg_stat_all_tables;

Related entries

• pg_stat_all_tables columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 17 → 18: unchanged.

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_all_tables.analyze_count
• pg_stat_all_tables.autoanalyze_count
• pg_stat_all_tables.autovacuum_count
• pg_stat_all_tables.idx_scan
• pg_stat_all_tables.idx_tup_fetch
• pg_stat_all_tables.last_analyze
• pg_stat_all_tables.last_autovacuum
• pg_stat_all_tables.last_idx_scan
• pg_stat_all_tables.last_seq_scan
• pg_stat_all_tables.last_vacuum
• pg_stat_all_tables.n_dead_tup
• pg_stat_all_tables.n_ins_since_vacuum