Account |
Account from which a query was submitted |
String |
Blocked Time |
How long the query has been blocked |
Number |
CPU Use |
Percent of 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 |
Entire query band string. Query bands are a set of name-value pairs defined by the user to tag sessions or transactions with an ID through a SQL interface. |
String |
Request CPU |
CPU seconds needed to run the query |
Number |
Request CPU Skew |
CPU skew for the current query. For Teradata Database 15.10 and later. |
Percent |
Request I/O |
Disk I/Os performed to run the query |
Number |
Request I/O Skew |
I/O skew for the current query. For Teradata Database 15.10 and later. |
Percent |
Request Count |
Number of queries the session has executed |
Number |
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 Icon |
Icon representing the current state of the query |
Icon |
State |
Text describing the current state of the query |
String |
Temp Space |
Temp space used by the query, using a 1024 byte kilobyte as the base |
Number |
Unnecessary I/O |
Ratio of I/O to CPU for the current query |
Number |
User |
Name of the user who submitted the query |
String |
Workload |
Workload in which the query is running |
String |