PG_STAT_REPLICATION

PG_STAT_REPLICATION displays information about log synchronization status, such as the locations of the sender sending logs and the receiver receiving logs.

Table 1 PG_STAT_REPLICATION columns

Name

Type

Description

pid

bigint

PID of the thread

usesysid

oid

User system ID

usename

name

Username

application_name

text

Application name

client_addr

inet

Client address.

client_hostname

text

Client name

client_port

integer

Client port number

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 duplication, synchronous duplication, or potential synchronization)