Updated on 2024-06-03 GMT+08:00

PGXC_COMM_DELAY

PGXC_COMM_DELAY displays the communications library delay status for all DNs. Only the system administrator and monitoring administrator can view this view.

Table 1 PGXC_COMM_DELAY columns

Name

Type

Description

node_name

text

Node name.

remote_name

text

Name of the peer node.

remote_host

text

IP address of the peer node

stream_num

integer

Number of logical stream connections used by the current physical connection

min_delay

integer

Minimum delay of the current physical connection within 1 minute, in microsecond.

NOTE:

A negative result is invalid. Wait until the delay status is updated and query again.

average

integer

Average delay of the current physical connection within 1 minute, in microsecond.

max_delay

integer

Maximum delay of the current physical connection within 1 minute, in microsecond.