pg_stat_progress_basebackup

PostgreSQL documentation ↗Source definition ↗

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.

First seen PG 13Last seen PG 19Columns 6

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_progress_basebackup

COLUMN	TYPE	DESCRIPTION
`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.

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18
`pid`	–	–	–	–	–	–	–	–	–	–
`phase`	–	–	–	–	–	–	–	–	–	–
`backup_total`	–	–	–	–	–	–	–	–	–	–
`backup_streamed`	–	–	–	–	–	–	–	–	–	–
`tablespaces_total`	–	–	–	–	–	–	–	–	–	–
`tablespaces_streamed`	–	–	–	–	–	–	–	–	–	–
`backup_type`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

+ backup_type1 column description updates

PostgreSQL 17 ← 16

1 column description updates

PostgreSQL 16 ← 15

1 column description updates

PostgreSQL 15 ← 14

1 column description updates

PostgreSQL 14 ← 13

1 column description updates

PostgreSQL 13 ← 12Catalog added

+ pid+ phase+ backup_total+ backup_streamed+ tablespaces_total+ tablespaces_streamed

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.