Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PG_COMM_DELAY
Updated on 2024-09-02 GMT+08:00
View PDF
Share

PG_COMM_DELAY

PG_COMM_DELAY displays the communication library delay status for a single DN.

Table 1 PG_COMM_DELAY columns

Name

Type

Description

node_name

text

Node name

remote_name

text

Name of the node with the maximum latency in connecting to the peer end.

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.
Parent topic: System Views