System Catalogs / Statistics views
pg_stat_archiver
Read the PG 18 manualThe pg_stat_archiver view will always have a single row, containing data about the archiver process of the cluster.
Reading PG 18current·documented in 14 of 24 versions, 9.4 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 7
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 7
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
archived_count | bigint | Number of WAL files that have been successfully archived |
last_archived_wal | text | Name of the WAL file most recently successfully archived |
last_archived_time | timestamp with time zone | Time of the most recent successful archive operation |
failed_count | bigint | Number of failed attempts for archiving WAL files |
last_failed_wal | text | Name of the WAL file of the most recent failed archival operation |
last_failed_time | timestamp with time zone | Time of the most recent failed archival operation |
stats_reset | timestamp with time zone | Time at which these statistics were last reset |
Column history across versions
Definition snapshot: english-manuals:0e6f966406014e7d98e6072febd… · English manual source