PGXC_COMM_DELAY

PGXC_COMM_DELAY displays the communication library delay status for all the DNs.

Table 1 PGXC_COMM_DELAY columns

Column

Type

Description

node_name

Text

Node name

remote_name

Text

Name of the peer node with the maximum connection latency.

remote_host

Text

IP address of the peer

stream_num

Integer

Number of logical stream connections used by the current physical connection

min_delay

Integer

Minimum delay of the current physical connection. The unit is microsecond.

average

Integer

Average delay of the current physical connection. The unit is microsecond.

max_delay

Integer

Maximum delay of the current physical connection. The unit is microsecond.

Note

If its value is -1, the latency detection has timed out. In this case, re-establish the connection between nodes and then perform the query.