gp_stat_archiver
The gp_stat_archiver view contains data about the WAL archiver process of the cluster. It displays one row per segment.
| column | type | references | description |
|---|---|---|---|
archived_count | bigint | Number of WAL files that have been successfully archived. | |
last_archived_wal | text | Name of the last WAL file successfully archived. | |
last_archived_time | timestamp with time zone | Time of the last 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 last failed archival operation. | |
last_failed_time | timestamp with time zone | Time of the last failed archival operation. | |
stats_reset | timestamp with time zone | Time at which these statistics were last reset. | |
gp_segment_id | int | The id of the segment to which the data being archived belongs. |
Note As this is not a
pg_catalogview, you must run the following command to make this view available:
CREATE EXTENSION gp_pitr;