PG_COMM_DELAY displays the communication library delay status for a node.
Table 1 PG_COMM_DELAY columns
Name
Type
Description
node_name
text
Node name
remote_name
Name of the peer node
remote_host
IP address of the peer node
stream_num
integer
Number of logical stream connections used by the current physical connection
min_delay
Minimum delay of the current physical connection within 1 minute, in microsecond
A negative result is invalid. Wait until the delay status is updated and query again.
average
Average delay of the current physical connection within 1 minute, in microsecond
max_delay
Maximum delay of the current physical connection within 1 minute, in microsecond