pg_stat_progress_basebackup

A progress reporting view providing information on the progress of pg_basebackup operations

pg_stat_progress_basebackup is a progress reporting view view providing information on the progress of pg_basebackup operations.

pg_stat_progress_basebackup was added in PostgreSQL 13 (commit e65497df).

Definition by PostgreSQL version

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  |           |          |
    

Documentation: pg_stat_progress_basebackup

Change history

Examples

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

Categories

Backup, Monitoring, Progress reporting view, Replication

See also

pg_basebackup, progress_reporting