PG_COMM_RECV_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.

PG_COMM_RECV_STREAM displays the receiving stream status of all the communications libraries for a single DN.

**Table 1** PG_COMM_RECV_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.
recv_bytes	bigint	Total data volume received by the stream, in byte.
time	bigint	Current service life of the stream, in ms.
speed	bigint	Average receiving rate of the stream, in byte/s.
quota	bigint	Current communication quota of the stream, in byte.
buff_usize	bigint	Current size of the data cache of the stream, in byte.