HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

REPLICATION_STAT

REPLICATION_STAT describes information about log synchronization status, such as the locations where the sender sends logs and where the receiver receives logs.

Table 1 REPLICATION_STAT columns

Name Type Description
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 duplication, synchronous duplication, or potential synchronization)
Copyright © 2011-2024 www.enmotech.com All rights reserved.