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 |
---|---|---|
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 | 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 |
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 |
Req CPU | CPU seconds needed to run the query | Number |
Req CPU Skew | CPU skew for the current query. For Teradata Database 15.10 and later. | Percent |
Req I/O | Disk I/Os performed to run the query | Number |
Req I/O Skew | I/O skew for the current query. For Teradata Database 15.10 and later. | 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 | 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 |
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 |