The following metrics can be displayed for active requests.
Metric | Description |
---|---|
Account | Account from which a query was submitted |
Blocked Time | How long the query has been blocked |
Snapshot CPU Skew | CPU skew during the last sample |
CPU Time | The amount of CPU processing time consumed by a query |
CPU Use | Percent of available CPU seconds on the system used during the last sampling period |
Δ CPU | Total CPU usage time consumed, in seconds, since the last sample |
Duration | How long the query has been running |
Host ID | Host ID or LAN ID associated with the PE that processed the login request for the session |
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. |
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. |
In State | How long the query has been in the current state |
Snapshot I/O Skew | I/O skew during the last sample |
Δ I/O | I/O count since the last sample |
Partition | Partition in which the query is running |
PJI | Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation |
Proxy Username | Name of the proxy user when a trusted session is used. Displayed only for Teradata Database 15.10 and later systems. |
Request CPU | CPU seconds needed to run the query |
Request Count | Number of queries the session has executed |
Request CPU Skew | CPU skew for the current query |
Request I/O | Disk I/Os performed to run the query |
Request I/O Skew | I/O skew for the current query |
Session ID | Unique session identifier |
Spool | Spool space the query requires |
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. |
Start | Time that the query started running on Teradata Database |
State | Text describing the current state of the query |
State Icon | Icon representing the current state of the query |
Temp Space | Temp space used by the query |
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 |
Username | Name of the user who submitted the query |
Virtual Partition | Name of the virtual partition to which the workload belongs, for a SLES 11 system |
Workload | Workload to which the query belongs |