Updated on 2023-10-23 GMT+08:00

Utility status

The Utility status report consists of two tables, namely, Replication slot and Replication stat. Columns in the tables are described as follows:

Replication slot

Table 1 Columns in the Replication slot table

Column

Description

Slot Name

Replication node name

Slot Type

Type of the replication node

DB Name

Name of the database on the replication node

Active

Replication node status

Xmin

Transaction ID of the replication node

Restart Lsn

Xlog file information on the replication node

Dummy Standby

Replication node as a dummy standby

Replication stat

Table 2 Columns in the Replication stat table

Column

Description

Thread Id

PID of the thread

Usesys Id

User system ID

Usename

Username

Application Name

Application name

Client Addr

Client address

Client Hostname

Client host name

Client Port

Client port

Backend Start

Start time of an application

State

Log replication status

Sender Sent Location

Location where the sender sends logs

Receiver Write Location

Location where the receiver writes logs

Receiver Flush Location

Location where the receiver flushes logs

Receiver Replay Location

Location where the receiver replays logs

Sync Priority

Synchronization priority

Sync State

Synchronization status