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.
| 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) |
Last Article: PG_STAT_USER_TABLES
Next Article: PG_STAT_SYS_INDEXES
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.