Metrics available for monitoring and display are listed as following. For a list of metric sources for some of the metrics listed as following, see Metric Sources Overview.
| 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 | (Teradata Database 16.0 and later) Current spool value of the highest spool utilized AMP for the query. 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. (Teradata Database 15.0 and earlier) Calculated at the snapshot level. (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 | (Teradata Database 15.0 and later) Name of the proxy user when a trusted session is used | 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 | (Teradata Database 15.10 and later) CPU skew for the current query | Percent |
| Request I/O Skew | (Teradata Database 15.10 and later) I/O skew for the current query | 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 | (Teradata Database 16.0 and later) Current spool skew for the query. 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 |