{"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":"861f4653d02c9697069cbf37784da38c5daeba259b6ae14aeaf935fb4002c52c","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":"english-manuals:02ecc490710d4df3d8c3f35809a18597a1f7875121694879e1a244b78fe9018c","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":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_progress_basebackup","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_progress_basebackup","SourceRevision":"english-manuals:02ecc490710d4df3d8c3f35809a18597a1f7875121694879e1a244b78fe9018c","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Process ID of a WAL sender process.","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"Current processing phase. See Table 27.48.","description_zh":"","documented":true,"documented_name":"phase","hidden":false,"name":"phase","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"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.","description_zh":"","documented":true,"documented_name":"backup_total","hidden":false,"name":"backup_total","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Amount of data streamed. This counter only advances when the phase is streaming database files or transferring wal files.","description_zh":"","documented":true,"documented_name":"backup_streamed","hidden":false,"name":"backup_streamed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"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},{"array_dimensions":0,"attnum":6,"description":"Number of tablespaces streamed. This counter only advances when the phase is streaming database files.","description_zh":"","documented":true,"documented_name":"tablespaces_streamed","hidden":false,"name":"tablespaces_streamed","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20}],"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":"","doc":{"anchor":"PG-STAT-PROGRESS-BASEBACKUP-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","slug":"18"},"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"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-PROGRESS-BASEBACKUP-VIEW","file":"progress-reporting.html","lang":"en","sha256":"a1f46d2b670502bfe75f1cf5192050ef2ef68202a8f928c4915abea0f4f71ae6","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_progress_basebackup","Summary":"每当像pg_basebackup这样的应用程序执行基础备份时，pg_stat_progress_basebackup视图将包含当前运行BASE_BACKUP复制命令和流式传输备份的每个WAL发送进程的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。","BodyHTML":"\u003cp\u003e每当像pg_basebackup这样的应用程序执行基础备份时，pg_stat_progress_basebackup视图将包含当前运行BASE_BACKUP复制命令和流式传输备份的每个WAL发送进程的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"fe0853b2c04b58a1fec02b0082311a1288766b9b884d517700c4d268119a263e","Payload":{"columns":[{"description_zh":"WAL 发送进程的进程 ID。","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"当前处理阶段。参见表 27.48。","name":"phase","type":"text","zh_from":"doc"},{"description_zh":"将被流式传输的数据总量。该值在streaming database files阶段开始时进行估算并报告。注意，这只是一个近似值，因为数据库可能会在streaming database files阶段期间发生变化，而 WAL 日志也可能在稍后的备份阶段被包含进来。一旦流式传输的数据量超过了估计的总大小，该值始终与backup_streamed相同。如果在pg_basebackup中禁用估算（也就是说，指定了--no-estimate-size选项），这为NULL。","name":"backup_total","type":"bigint","zh_from":"doc"},{"description_zh":"已流式传输的数据量。该计数器仅在streaming database files阶段或transferring wal files阶段递增。","name":"backup_streamed","type":"bigint","zh_from":"doc"},{"description_zh":"将要流式传输的表空间总数。","name":"tablespaces_total","type":"bigint","zh_from":"doc"},{"description_zh":"已流式传输的表空间数量。此计数器仅在streaming database files阶段递增。","name":"tablespaces_streamed","type":"bigint","zh_from":"doc"}],"description_zh":"每当像pg_basebackup这样的应用程序执行基础备份时，pg_stat_progress_basebackup视图将包含当前运行BASE_BACKUP复制命令和流式传输备份的每个WAL发送进程的一行。下面的表描述了将要报告的信息，并提供了关于如何解释它的信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}