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.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name. |
| pid | bigint | PID 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:
|
| 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:
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
