{"Entry":{"collection":"catalog","key":"pg_stat_progress_basebackup","name":"pg_stat_progress_basebackup","aliases":[],"metadata":{"changed_in":["19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","order":false,"removed":[],"status":"added","to":"13","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.41.","name":"phase","to":"Current processing phase. See Table 28.43."}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 28.43.","name":"phase","to":"Current processing phase. See Table 28.45."}],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 28.45.","name":"phase","to":"Current processing phase. See Table 28.47."}],"from":"15","listing":[],"order":false,"removed":[],"status":"reworded","to":"16","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 28.47.","name":"phase","to":"Current processing phase. See Table 27.48."}],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":["backup_type"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.48.","name":"phase","to":"Current processing phase. See Table 27.53."}],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Current processing phase. See Table 27.53.","name":"phase","to":"Current processing phase. See Table 27.54."}],"from":"19","listing":[],"order":false,"removed":[],"status":"reworded","to":"20","types":[],"unlisted":[]}],"column_count":7,"content_hash":"b5fe79df875903e9e0e101fb7816653fea99f1fd3fa2a816e46edc95c7d7bc30","derived_content_hash":"1ee229763225c828d49e6c6761c0bfbc5e48bde0bec00739258efbcedd6c0640","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:6ac4d293e8bd0391adebd1eb8f0fe069efab5acee199e9ca6b5b53a234b36040","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"first_version":"13","imported_at":"2026-09-30T00:40:55.932937+08:00","kind":"progress","last_version":"20","name":"pg_stat_progress_basebackup","position":95,"present_in":["13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:6ac4d293e8bd0391adebd1eb8f0fe069efab5acee199e9ca6b5b53a234b36040","summary":"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.","summary_zh":"每当像 pg_basebackup 这样的应用程序执行基础备份时，pg_stat_progress_basebackup 视图将包含当前运行 BASE_BACKUP 复制命令和流式传输备份的每个 WAL 发送进程的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_basebackup","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_basebackup","SourceRevision":"catalog-bilingual-repair:6ac4d293e8bd0391adebd1eb8f0fe069efab5acee199e9ca6b5b53a234b36040","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of a WAL sender process.","description_zh":"WAL 发送进程的进程 ID。","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Current processing phase. See Table 27.48.","description_zh":"当前处理阶段。参见表 27.48。","documented":true,"documented_name":"phase","hidden":false,"name":"phase","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"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.","description_zh":"将被流式传输的数据总量。统计的是服务器端压缩之前的归档数据量。估算值在 streaming database files 阶段开始时报告。注意，这只是一个近似值，因为数据库可能会在 streaming database files 阶段期间发生变化，而 WAL 日志也可能在稍后的备份阶段被包含进来。一旦流式传输的数据量超过了估计的总大小，该值始终与 backup_streamed 相同。如果在 pg_basebackup 中禁用估算（也就是说，指定了 --no-estimate-size 选项），这为 NULL。","documented":true,"documented_name":"backup_total","hidden":false,"name":"backup_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"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.","description_zh":"已流式传输的数据量。统计的是服务器端压缩之前的归档数据量。该计数器仅在 streaming database files 阶段或 transferring wal files 阶段递增。","documented":true,"documented_name":"backup_streamed","hidden":false,"name":"backup_streamed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Total number of tablespaces that will be streamed.","description_zh":"将要流式传输的表空间总数。","documented":true,"documented_name":"tablespaces_total","hidden":false,"name":"tablespaces_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of tablespaces streamed. This counter only advances when the phase is streaming database files.","description_zh":"已流式传输的表空间数量。此计数器仅在 streaming database files 阶段递增。","documented":true,"documented_name":"tablespaces_streamed","hidden":false,"name":"tablespaces_streamed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"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.","description_zh":"每当像 pg_basebackup 这样的应用程序执行基础备份时，pg_stat_progress_basebackup 视图将包含当前运行 BASE_BACKUP 复制命令和流式传输备份的每个 WAL 发送进程的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。","description_zh_html":"\u003cp\u003e每当像 pg_basebackup 这样的应用程序执行基础备份时，pg_stat_progress_basebackup 视图将包含当前运行 BASE_BACKUP 复制命令和流式传输备份的每个 WAL 发送进程的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-PROGRESS-BASEBACKUP-VIEW\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.47. \u003ccode class=\"structname\"\u003epg_stat_progress_basebackup\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_progress_basebackup 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       WAL 发送进程的进程 ID。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ephase\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       当前处理阶段。参见\u003ca class=\"xref\" href=\"/zh/docs/18/progress-reporting.html#BASEBACKUP-PHASES\" title=\"表 27.48. 基础备份阶段\"\u003e表 27.48\u003c/a\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ebackup_total\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       将被流式传输的数据总量。统计的是服务器端压缩之前的归档数据量。估算值在 \u003ccode class=\"literal\"\u003estreaming database files\u003c/code\u003e 阶段开始时报告。注意，这只是一个近似值，因为数据库可能会在 \u003ccode class=\"literal\"\u003estreaming database files\u003c/code\u003e 阶段期间发生变化，而 WAL 日志也可能在稍后的备份阶段被包含进来。一旦流式传输的数据量超过了估计的总大小，该值始终与 \u003ccode class=\"structfield\"\u003ebackup_streamed\u003c/code\u003e 相同。如果在 \u003cspan class=\"application\"\u003epg_basebackup\u003c/span\u003e 中禁用估算（也就是说，指定了 \u003ccode class=\"literal\"\u003e--no-estimate-size\u003c/code\u003e 选项），这为 \u003ccode class=\"literal\"\u003eNULL\u003c/code\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ebackup_streamed\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       已流式传输的数据量。统计的是服务器端压缩之前的归档数据量。该计数器仅在 \u003ccode class=\"literal\"\u003estreaming database files\u003c/code\u003e 阶段或 \u003ccode class=\"literal\"\u003etransferring wal files\u003c/code\u003e 阶段递增。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etablespaces_total\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       将要流式传输的表空间总数。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003etablespaces_streamed\u003c/code\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       已流式传输的表空间数量。此计数器仅在 \u003ccode class=\"literal\"\u003estreaming database files\u003c/code\u003e 阶段递增。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-PROGRESS-BASEBACKUP-VIEW","file":"progress-reporting.html","lang":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","slug":"18"},"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"},"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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"progress-reporting.html","sha256":"59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:02ecc490710d4df3d8c3f35809a18597a1f7875121694879e1a244b78fe9018c","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-BASEBACKUP-VIEW","file":"progress-reporting.html","lang":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"progress-reporting.html","sha256":"59d508f5be60d650bf0ed9ec10531162651c9eb030752aec3874544e10c879e2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:02ecc490710d4df3d8c3f35809a18597a1f7875121694879e1a244b78fe9018c","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pid","phase","backup_total","backup_streamed","tablespaces_total","tablespaces_streamed"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_progress_basebackup","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_progress_basebackup","Summary":"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.","BodyHTML":"\u003cp\u003eWhenever 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.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:6ac4d293e8bd0391adebd1eb8f0fe069efab5acee199e9ca6b5b53a234b36040","ContentHash":"ea3ce947782358f61fa8ce17c9cdf69ac0800b17a147561dcbcdf37bd34d6488","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of a WAL sender process.","description_zh":"WAL 发送进程的进程 ID。","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Current processing phase. See Table 27.48.","description_zh":"当前处理阶段。参见表 27.48。","documented":true,"documented_name":"phase","hidden":false,"name":"phase","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"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.","description_zh":"将被流式传输的数据总量。统计的是服务器端压缩之前的归档数据量。估算值在 streaming database files 阶段开始时报告。注意，这只是一个近似值，因为数据库可能会在 streaming database files 阶段期间发生变化，而 WAL 日志也可能在稍后的备份阶段被包含进来。一旦流式传输的数据量超过了估计的总大小，该值始终与 backup_streamed 相同。如果在 pg_basebackup 中禁用估算（也就是说，指定了 --no-estimate-size 选项），这为 NULL。","documented":true,"documented_name":"backup_total","hidden":false,"name":"backup_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"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.","description_zh":"已流式传输的数据量。统计的是服务器端压缩之前的归档数据量。该计数器仅在 streaming database files 阶段或 transferring wal files 阶段递增。","documented":true,"documented_name":"backup_streamed","hidden":false,"name":"backup_streamed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Total number of tablespaces that will be streamed.","description_zh":"将要流式传输的表空间总数。","documented":true,"documented_name":"tablespaces_total","hidden":false,"name":"tablespaces_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"Number of tablespaces streamed. This counter only advances when the phase is streaming database files.","description_zh":"已流式传输的表空间数量。此计数器仅在 streaming database files 阶段递增。","documented":true,"documented_name":"tablespaces_streamed","hidden":false,"name":"tablespaces_streamed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20,"zh_from":"same-version-manual"}],"description":"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."}},"RequestedLocale":"en","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}