内容

pg_stat_progress_basebackup

一个进度报告视图，提供有关 pg_basebackup 操作进度的信息

pg_stat_progress_basebackup 是一个 进度报告视图，提供有关 pg_basebackup 操作进度的信息。

pg_stat_progress_basebackup 添加于 PostgreSQL 13。

按 PostgreSQL 版本定义

pg_stat_progress_basebackup (PostgreSQL 17)

          View "pg_catalog.pg_stat_progress_basebackup"
        Column        |  Type   | Collation | Nullable | Default 
----------------------+---------+-----------+----------+---------
 pid                  | integer |           |          | 
 phase                | text    |           |          | 
 backup_total         | bigint  |           |          | 
 backup_streamed      | bigint  |           |          | 
 tablespaces_total    | bigint  |           |          | 
 tablespaces_streamed | bigint  |           |          |

文档: pg_stat_progress_basebackup

pg_stat_progress_basebackup (PostgreSQL 16)

          View "pg_catalog.pg_stat_progress_basebackup"
        Column        |  Type   | Collation | Nullable | Default 
----------------------+---------+-----------+----------+---------
 pid                  | integer |           |          | 
 phase                | text    |           |          | 
 backup_total         | bigint  |           |          | 
 backup_streamed      | bigint  |           |          | 
 tablespaces_total    | bigint  |           |          | 
 tablespaces_streamed | bigint  |           |          |

文档: pg_stat_progress_basebackup

pg_stat_progress_basebackup (PostgreSQL 15)

          View "pg_catalog.pg_stat_progress_basebackup"
        Column        |  Type   | Collation | Nullable | Default 
----------------------+---------+-----------+----------+---------
 pid                  | integer |           |          | 
 phase                | text    |           |          | 
 backup_total         | bigint  |           |          | 
 backup_streamed      | bigint  |           |          | 
 tablespaces_total    | bigint  |           |          | 
 tablespaces_streamed | bigint  |           |          |

文档: pg_stat_progress_basebackup

pg_stat_progress_basebackup (PostgreSQL 14)

          View "pg_catalog.pg_stat_progress_basebackup"
        Column        |  Type   | Collation | Nullable | Default 
----------------------+---------+-----------+----------+---------
 pid                  | integer |           |          | 
 phase                | text    |           |          | 
 backup_total         | bigint  |           |          | 
 backup_streamed      | bigint  |           |          | 
 tablespaces_total    | bigint  |           |          | 
 tablespaces_streamed | bigint  |           |          |

文档: pg_stat_progress_basebackup

pg_stat_progress_basebackup (PostgreSQL 13)

          View "pg_catalog.pg_stat_progress_basebackup"
        Column        |  Type   | Collation | Nullable | Default 
----------------------+---------+-----------+----------+---------
 pid                  | integer |           |          | 
 phase                | text    |           |          | 
 backup_total         | bigint  |           |          | 
 backup_streamed      | bigint  |           |          | 
 tablespaces_total    | bigint  |           |          | 
 tablespaces_streamed | bigint  |           |          |

文档: pg_stat_progress_basebackup

更改历史记录

示例

pg_stat_progress_basebackup 的示例输出

postgres=# SELECT * FROM pg_stat_progress_basebackup \x\g\x
-[ RECORD 1 ]--------+-------------------------
pid                  | 29070
phase                | streaming database files
backup_total         | 2179629568
backup_streamed      | 945447936
tablespaces_total    | 1
tablespaces_streamed | 0

分类

备份，监控，进度报告视图，复制

另请参阅

pg_basebackup，progress_reporting

反馈

提交任何关于 "pg_stat_progress_basebackup" 的评论、建议或更正 此处。