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

PGXC_COMM_SEND_STREAM

PGXC_COMM_SEND_STREAM displays the sending stream status of the communications libraries for all the DNs.

Table 1 PGXC_COMM_SEND_STREAM columns

Name

Type

Description

node_name

text

Node name.

local_tid

bigint

ID of the thread using this stream.

remote_name

text

Name of the peer node.

remote_tid

bigint

Peer thread ID.

idx

integer

Peer DN ID in the local DN.

sid

integer

Stream ID in the physical connection.

tcp_sock

integer

TCP socket used in the stream.

state

text

Status of the stream.

The options are as follows:

  • UNKNOWN: The connection status is unknown.
  • READY: The connection is ready.
  • RUN: The connection sends packets normally.
  • HOLD: The connection is waiting to send packets.
  • CLOSED: The connection is closed.
  • TO_CLOSED: The connection will be closed.

query_id

bigint

debug_query_id corresponding to the stream.

pn_id

integer

plan_node_id of the query executed by the stream.

send_smp

integer

smpid of the sender of the query executed by the stream.

recv_smp

integer

smpid of the receiver of the query executed by the stream.

send_bytes

bigint

Total data volume sent by the stream, in bytes.

time

bigint

Current service life of the stream, in ms.

speed

bigint

Average sending rate of the stream, in byte/s.

quota

bigint

Current communication quota of the stream, in byte.

wait_quota

bigint

Extra time generated when the stream waits the quota value, in ms.