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 |