SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_basebackup
Read PG 18 manual ↗Whenever an application like pg_basebackup is taking a base backup, the pg_stat_progress_basebackup view will contain a row for each WAL sender process that is currently running the BASE_BACKUP replication command and streaming the backup.
- Kind
- Progress reporting
- Columns in this snapshot
- 6
- Definition source
- English manual
Columns 6
| Column | Type | Description / reference |
|---|---|---|
pid | integer | Process ID of a WAL sender process. |
phase | text | Current processing phase. See Table 27.48. |
backup_total | bigint | Total amount of data that will be streamed. This is estimated and reported as of the beginning of streaming database files phase. Note that this is only an approximation since the database may change during streaming database files phase and WAL log may be included in the backup later. This is always the same value as backup_streamed once the amount of data streamed exceeds the estimated total size. If the estimation is disabled in pg_basebackup (i.e., --no-estimate-size option is specified), this is NULL. |
backup_streamed | bigint | Amount of data streamed. This counter only advances when the phase is streaming database files or transferring wal files. |
tablespaces_total | bigint | Total number of tablespaces that will be streamed. |
tablespaces_streamed | bigint | Number of tablespaces streamed. This counter only advances when the phase is streaming database files. |
Column history across versions
Version history 7
- PG 19 → 20changed
- PG 18 → 19changed
- PG 16 → 17changed
- PG 15 → 16changed
- PG 14 → 15changed
- PG 13 → 14changed
- PG 12 → 13added
Definition snapshot: english-manuals:f996849ff31a0d61ccdf2c60b66… · English manual source