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

PG_COMM_SEND_STREAM

PG_COMM_SEND_STREAM displays the sending stream status of all the communication libraries for a single DN.

Table 1 PG_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.

  • UNKNOWN: The logical connection status is unknown.
  • READY: The logical connection is ready.
  • RUN: The logical connection sends packets normally.
  • HOLD: The logical connection is waiting to send packets.
  • CLOSED: The logical connection is closed.
  • TO_CLOSED: The logical 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 life cycle of a stream. The unit is ms.

speed

bigint

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

quota

bigint

Current communication quota of the stream, in bytes.

wait_quota

bigint

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