Metrics available for monitoring and display are listed below. For a list of metric sources for some of the metrics listed below, see Metric Sources.
Metric | Description | Type |
---|---|---|
Account | Account from which a query was submitted | String |
Blocked Time | How long the query has been blocked | Number |
CPU Use | Available CPU seconds on the system used during the last sampling period | Percent |
Δ CPU | Total CPU usage time consumed, in seconds, since the last sample | Number |
Δ I/O | I/O count since the last sample | Number |
Duration | How long the query has been running | Number |
Host | Host ID or LAN ID associated with the PE that processed the login request for the session | Number |
Hot AMP Spool | Current spool value of the highest spool utilized AMP for the query for Teradata Database 16.0 and later. If no request is running on the session, no value displays. | Number |
Impact CPU | CPU impact on the system based on the highest utilized AMP. For Teradata Database 15.0 and earlier, calculated at the snapshot level; for Teradata Database 15.10 and later, calculated at the request level. | Number |
In State | How long the query has been in the current state | Number |
Partition | Partition in which the query is running | String |
PJI | Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation | Number |
Proxy Username | Name of the proxy user when a trusted session is used for Teradata Database 15.0 and later | String |
Query Band | Set of name-value pairs for the session or transaction | String |
Request CPU | CPU seconds needed to run the query | Number |
Request I/O | Disk I/Os performed to run the query | Number |
Request Count | Queries the session has executed | Number |
Request CPU Skew | CPU skew for the current query for Teradata Database 15.10 and later. | Percent |
Request I/O Skew | I/O skew for the current query for Teradata Database 15.10 and later. | Percent |
Session ID | Unique session identifier | Number |
Snapshot CPU Skew | CPU skew during the last sample | Percent |
Snapshot I/O Skew | I/O skew during the last sample | Percent |
Spool | Spool space the query requires, using a 1024 byte kilobyte as the base | Number |
Spool Skew | Current spool skew for the query for Teradata Database 16.0 and later. If no request is running on the session, no value displays. | Percent |
Start | Time that the query started running on Teradata Database | Number |
State | Text describing the current state of the query | String |
State Icon | Icon representing the current state of the query | Icon |
System | Full name of the system running the query | String |
Temp Space | Temp space used by the query, using a 1024 byte kilobyte as the base | Number |
Unnecessary I/O | All AMP I/O divided by all AMP CPU, displayed in milliseconds, to reveal large amounts of I/O occurring over a short period of time | Number |
Username | Name of the user who submitted the query | String |
Workload | Workload in which the query is running | String |