17.05 - Net: Message Type Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
These columns subdivide all messages sent and received into the type of message, where:
  • Hash messages (Hash) are data sent to a destination through its primary or fallback hash value.
  • Processor messages (Proc) are data sent to a destination through a vproc ID.
  • Group messages (Group) are broadcasted messages to be received by members of a group.
  • Local messages (Local) are messages communicated locally within the node.
  • Channel messages (Chan) are data sent between vprocs through channel IDs for purposes of a private conversation to perform functions such as row redistribution, and so on.
  • Mailbox messages (Mbox) are data sent between vprocs through mailbox IDs for similar purposes as channel messages.

A duplicated accounting is done with two different perspectives, since Hash + Proc + Group + Local messages = Chan + MBox messages.

Column Name Mode Description Data Type
MsgChanReads count Number of channel messages read by this vproc. FLOAT
MsgChanWrites count Number of channel messages written by this vproc. FLOAT
MsgHashReads count Number of hash messages read by this vproc. FLOAT
MsgHashWrites count Number of hash messages written by this vproc. FLOAT
MsgGroupReads count Number of group messages read by this vproc. FLOAT
MsgGroupWrites count Number of group messages written by this vproc. FLOAT
MsgLocalReads count Number of local messages read by this vproc. FLOAT
MsgLocalWrites count Number of local messages written by this vproc. FLOAT
MsgProcReads count Number of processor messages read by this vproc. FLOAT
MsgProcWrites count Number of processor messages written by this vproc. FLOAT
MsgMboxReads count Number of mailbox messages read by this vproc. FLOAT
MsgMboxWrites count Number of mailbox messages written by this vproc. FLOAT