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 Overview.
| Metric | Description | Type |
|---|---|---|
| Duration | How long the query has been running | Number |
| End | Time that the query stopped running on Teradata Database | 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 |
| 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 |
| Req CPU | CPU seconds needed to run the query | Number |
| Req CPU Skew | (Teradata Database 15.10 and later) CPU skew for the current query | Percent |
| Req I/O | Disk I/Os performed to run the query | Number |
| Req I/O Skew | (Teradata Database 15.10 and later) I/O skew for the current query | Percent |
| Req Number | Number of the specific request | Number |
| Session ID | Unique session identifier | Number |
| 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 value of the highest spool utilized AMP 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 |
| 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 |