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. Under SESSION INFO, you can click a user or account to see all sessions for that user or account string.
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 | (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. |
| Spool Skew | (Teradata Database 16.0 and later) Current spool skew for the query. 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. (Teradata Database 15.0 and earlier) Calculated at the snapshot level. (Teradata Database 15.10 and later) Calculated at the request level. |
| Request I/O | Total number of disk I/Os performed |
| Request CPU Skew | (Teradata Database 15.10 and later) CPU skew for the current query |
| Request I/O Skew | (Teradata Database 15.10 and later) I/O skew for the current query |
| 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 | (Teradata Database 15.0 and later) Total bytes imported from a remote server for this query |
| Data Exported Remotely | (Teradata Database 15.0 and later) Total bytes exported to a remote server for this query |
Snapshot Information
| Snapshot Information | Description |
|---|---|
| CPU Use | Percent of available CPU seconds on the system used during the last sampling period |
| Impact CPU | (Teradata Database 15.0 and earlier) CPU impact on the system based on the highest utilized AMP |
| 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 | (Teradata Database 15.0 and later) Name of the proxy user when a trusted session is used |
| 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 |
| Request Admission Time | Timestamp when the query was admitted to the system |