跳转到主要内容
← 目录图谱 / pg_stat_progress_basebackup

PROGRESS REPORT · 进度报告

pg_stat_progress_basebackup

PostgreSQL 官方文档 ↗源码定义 ↗

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.

首次收录 PG 13最近收录 PG 19当前字段 6
9.09.19.29.39.49.59.610111213141516171819β3

已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗

字段结构 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.

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

字段演化矩阵

悬停查看字段类型
存在新增 / 类型或属性变化移除
字段 / COLUMN9.09.19.29.39.49.59.610111213141516171819
pid – – – – – – – – – –
phase – – – – – – – – – –
backup_total – – – – – – – – – –
backup_streamed – – – – – – – – – –
tablespaces_total – – – – – – – – – –
tablespaces_streamed – – – – – – – – – –
backup_type – – – – – – – – – – – – – – – –

9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

演化时间线

相邻大版本的变化

PostgreSQL 19 ← 18

+ backup_type1 处字段说明更新

PostgreSQL 17 ← 16

1 处字段说明更新

PostgreSQL 16 ← 15

1 处字段说明更新

PostgreSQL 15 ← 14

1 处字段说明更新

PostgreSQL 14 ← 13

1 处字段说明更新

PostgreSQL 13 ← 12新增目录

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

比较任意两个版本

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。