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.
Metric | Description | Type |
---|---|---|
Total Duration | How long the query has run, displayed as hh :mm :ss | Number |
User | Name of the user that submitted the query | Character |
Account | Account of the user that submitted the query | Character |
Req Number | Number of I/O operations the query performed | 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 |
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. | Percentage |
Req CPU | Total CPU usage time, in seconds, consumed by the query | Number |
Impact CPU | CPU impact on the system based on the highest utilized AMP for Teradata Database 15.10 and later. Calculated at the request level. | Number |
Req I/O | Number of I/O operations the query performed | Number |
Req CPU Skew | CPU skew for the current query for Teradata Database 15.10 and later | Percentage |
Req I/O Skew | I/O skew for the current query for Teradata Database 15.10 and later | Percentage |
Req Max Spool | Amount of spool space the query requires | Number |
Source | Source details, such as application name, IP address, and host user name | Character |