Updated on 2024-05-07 GMT+08:00

GLOBAL_REPLICATION_STAT

GLOBAL_REPLICATION_STAT displays information about log synchronization status on each node, such as the locations where the sender sends logs and where the receiver receives logs.

Table 1 GLOBAL_REPLICATION_STAT columns

Name

Type

Description

node_name

name

Node name

pid

bigint

Process ID of the thread

usesysid

oid

User system ID

usename

name

Username

application_name

text

Program name

client_addr

inet

Client address

client_hostname

text

Client name

client_port

integer

Port of the client

backend_start

timestamp with time zone

Start time of the program

state

text

Log replication state (catch-up or consistent streaming)

sender_sent_location

text

Location where the sender sends logs

receiver_write_location

text

Location where the receiver writes logs

receiver_flush_location

text

Location where the receiver flushes logs

receiver_replay_location

text

Location where the receiver replays logs

sync_priority

integer

Priority of synchronous duplication (0 indicates asynchronization.)

sync_state

text

Synchronization state:
  • Asynchronous replication
  • Synchronous replication
  • Potential synchronization