pg_stat_archiver
The pg_stat_archiver view will always have a single row, containing data about the archiver process of the cluster.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- archived_count, last_archived_wal, last_archived_time, failed_count, last_failed_wal, last_failed_time, stats_reset
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_stat_archiver view will always have a single row, containing data about the archiver process of the cluster.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| archived_count | bigint | Nullable | Number of WAL files that have been successfully archived |
| last_archived_wal | text | Nullable | Name of the WAL file most recently successfully archived |
| last_archived_time | timestamp with time zone | Nullable | Time of the most recent successful archive operation |
| failed_count | bigint | Nullable | Number of failed attempts for archiving WAL files |
| last_failed_wal | text | Nullable | Name of the WAL file of the most recent failed archival operation |
| last_failed_time | timestamp with time zone | Nullable | Time of the most recent failed archival operation |
| stats_reset | timestamp with time zone | Nullable | Time at which these statistics were last reset |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:756db891aa77b42919d6d3821838fd35c340d2f46ece495b7316ebac619c307f
Text language: en · catalog-bilingual-repair:756db891aa77b42919d6d3821838fd35c340d2f46ece495b7316ebac619c307f