The Overview tab provides detailed information about key metrics for the selected session and its queries. The metric values provide a view of the query status on the system. Metrics that exceed defined thresholds are highlighted.
Query Information
Query Information | Description |
---|---|
State | Query state, such as active, blocked, terminate |
Time in State | How long the query has been in the current state, displayed as hh:mm:ss |
Total Duration | Total elapsed time it took for the query to execute once it was submitted |
Spool Space | Amount of spool space the query is using |
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. |
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. |
Temp Space | Amount of temp space the query is using |
Request CPU | Total CPU seconds needed to run the query, in seconds |
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. |
Request I/O | Total number of disk I/Os performed |
Request CPU Skew | CPU skew for the current query for Teradata Database 15.10 and later |
Request I/O Skew | I/O skew for the current query for Teradata Database 15.10 and later |
PJI | Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation |
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 |
Remote Data Imported | Total bytes imported from a remote server for this query for Teradata Database 15.0 and later |
Data Exported Remotely | Total bytes exported to a remote server for this query for Teradata Database 15.0 and later |
Snapshot Information
Snapshot Information | Description |
---|---|
CPU Use | Percent of available CPU seconds on the system used during the last sampling period |
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. |
Snapshot CPU Skew | CPU skew during the last sample |
Snapshot I/O Skew | I/O skew during the last sample |
Workload Information
Workload Information | Description |
---|---|
Name | Name of the workload where the query is actively running |
Method | Name of the workload management method in SLES 11. Available values are:
|
CPU Decay | Most severe level of CPU resource access restriction for queries in a Timeshare workload in SLES 11 |
CPU Exception Nodes | Number of nodes that exceeded the tactical CPU time exception criteria for the session in a Tactical workload in SLES 11 |
Classification Mode | How a query or session is assigned to a workload. Available values are:
This field is empty if this is not a DBC/SQL session or if Teradata Workload Management Category 3 is disabled. |
Virtual Partition | Name of the virtual partition in SLES 11 |
I/O Decay | Most severe level of I/O resource access restriction for queries in a Timeshare workload in SLES 11 |
I/O Exception Nodes | Number of nodes that exceeded the tactical I/O usage exception criteria for the session in a Tactical workload in SLES 11 |
Session Information
Session Information | Description |
---|---|
User | Name of the user that submitted the query |
Proxy Username | Name of the proxy user when a trusted session is used for Teradata Database 15.0 and later |
Account | Account of the user that submitted the query |
Source | Source details, such as application name, IP address, and host user name |
Partition | Partition in which the query is running |
Requests | Number of queries submitted by the session |