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

PGXC_COMM_STATUS

PGXC_COMM_STATUS displays the communications library status for all the DNs.

Table 1 PGXC_COMM_STATUS columns

Name

Type

Description

node_name

text

Node name.

rxpck_rate

integer

Receiving rate of the communications library on the node, in byte/s.

txpck_rate

integer

Sending rate of the communications library on a node, in bytes/s.

rxkbyte_rate

bigint

Receiving rate of the communications library on the bigint node, in KB/s.

txkbyte_rate

bigint

Sending rate of the communications library on the bigint node, in KB/s.

buffer

bigint

Cache size of the cmailbox.

memkbyte_libcomm

bigint

Communication memory size of the libcomm process, in bytes.

memkbyte_libpq

bigint

Communication memory size of the libpq process in bytes.

used_pm

integer

Real-time usage of the postmaster thread

used_sflow

integer

Real-time usage of the gs_sender_flow_controller thread

used_rflow

integer

Real-time usage of the gs_receiver_flow_controller thread

used_rloop

integer

Highest real-time usage among multiple gs_receivers_loop threads

stream

integer

Total number of used logical connections.