pg_stat_progress_basebackup
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. The tables below describe the information that will be reported and provide information about how to interpret it.
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
- progress
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- pid, phase, backup_total, backup_streamed, tablespaces_total, tablespaces_streamed
- runtime verified
- false
- source
- english-manual
Definition PG 18
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. The tables below describe the information that will be reported and provide information about how to interpret it.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| pid | integer | Nullable | Process ID of a WAL sender process. |
| phase | text | Nullable | Current processing phase. See Table 27.48. |
| backup_total | bigint | Nullable | Total amount of data that will be streamed. This counts archive data before any server-side compression. The estimate is reported as of the beginning of the 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 | Nullable | Amount of data streamed. This counts archive data before any server-side compression. This counter only advances when the phase is streaming database files or transferring wal files. |
| tablespaces_total | bigint | Nullable | Total number of tablespaces that will be streamed. |
| tablespaces_streamed | bigint | Nullable | Number of tablespaces streamed. This counter only advances when the phase is streaming database files. |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","version":"18.7"},{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0ab33caa1959f857312f1a866b2b0f0afde18c3fd85db5d957eefa1b7a2e441f","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:6ac4d293e8bd0391adebd1eb8f0fe069efab5acee199e9ca6b5b53a234b36040
Text language: en · catalog-bilingual-repair:6ac4d293e8bd0391adebd1eb8f0fe069efab5acee199e9ca6b5b53a234b36040