SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_archiver
Read PG 18 manual ↗The pg_stat_archiver view will always have a single row, containing data about the archiver process of the cluster.
- Kind
- Statistics views
- Columns in this snapshot
- 7
- Definition source
- English manual
Columns 7
| 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
Version history 7
- PG 14 → 15changed
- PG 12 → 13changed
- PG 11 → 12changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6changed
- PG 9.4 → 9.5changed
- PG 9.3 → 9.4added
Definition snapshot: english-manuals:9c4b181d06622a41be6cfa0080c… · English manual source