Help Center > > Developer Guide> System Catalogs and System Views> System Views> PG_STAT_REPLICATION

PG_STAT_REPLICATION

Updated at: Jul 15, 2020 GMT+08:00

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

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel