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

Utility status

Utility status contains two tables: Replication slot and Replication stat. Columns in the tables are described as follows:

Replication slot

Table 1 Columns in the Replication slot report

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 report

Column

Description

Thread Id

PID of the thread.

Usesys Id

User system ID.

Username

Username.

Application Name

Application name.

Client Addr

Client address.

Client Hostname

Client host name.

Client Port

Port of the client.

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.