Session Metrics
The selection menu choice My Criteria or or My Criteria makes the following metrics available. For a list of metric sources for some of the metrics listed below, see Metric Sources.
or Metric | Description | Type |
---|---|---|
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 |
Account String and User Metrics
The selection menu choice By Account String or By User makes the following metrics available. For a list of metric sources for some of the metrics listed below, see Metric Sources.
Metric | Description | Type |
---|---|---|
Δ CPU | Total CPU usage time consumed, in seconds, since the last sample | Number |
Δ I/O | I/O count since the last sample | Number |
Δ Request Count | Total number of queries submitted by the user or account string since the last sample | Number |
Aborting Count | Queries that have been aborted and changes are being rolled back | Number |
Account | Account from which a query was submitted | String |
Active Count | Queries that are running | Number |
Blocked Count | Queries waiting for a lock held by another query | Number |
CPU Use | Available CPU seconds on the system used during the last sampling period | Percent |
Delayed Count | Queries in a delay queue waiting to run | Number |
Idle Count | Queries that are not running | 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 |
Parsing Count | Queries being parsed before running | Number |
Response Count | Queries that are returning results to the user | Number |
Spool | Current spool used by the request across all AMPs in bytes, using a 1024 byte kilobyte as the base | Number |
Total | Sessions for the user or account (total of active, aborting, blocked, idle, parsing, response, delayed, and unknown) | Number |
Unknown Count | Queries in an unknown state | Number |
Username | Name of the user that submitted the query | String |
Utility Metrics
The selection menu choice or By Type makes the following metrics available. For a list of metric sources for some of the metrics listed below, see Metric Sources.Metric | Description | Type |
---|---|---|
Δ CPU | Total CPU usage time consumed, in seconds, since the last sample | Number |
Active | Number of utilities of this utility type that are active | Number |
AMP CPU | Total AMP CPU-seconds consumed by the job | Number |
AMP I/O | I/O count across all AMPs for the job | Number |
Host | Host ID or LAN ID associated with the PE that processed the login request for the session | Number |
Limit | Current limit on the number of utilities of this type | Number |
LSN | Login sequence number for the job | Number |
Name | Utility names | String |
Sessions | Session count for the job | Number |
Username | Name of the user who submitted the query | String |
Utility | Utility in which the session is running | String |
Vproc Metrics
The selection menu choice By VProc makes the following metrics available.Metric | Description | Type |
---|---|---|
AMP ID | ID of the skewed AMP, limited to those AMPs with sessions that exceed the metric values that are set in the Skew tab in the Settings view | Number |
PE | PE ID | Number |
PE CPU | PE usage in CPU-seconds | Number |
Sessions |
|
Number |
Skewed CPU | CPU-seconds used by skewed sessions (sessions that exceed the skew threshold set in the Settings view) on an AMP This number is not the total CPU usage on an AMP
|
Number |
Blocker Metrics
The selection menu choice By Blocker makes the following metrics available by default. For a list of metric sources for some of the metrics listed below, see Metric Sources.
Metric | Description | Type |
---|---|---|
Session ID | Unique session identifier of the query that is blocking | Number |
Username | Name of the user that is running the query that holds the lock | String |
State Icon | Icon representing the current state of the query | Icon |
Blocking Type | Indicates the significance of the blocker. Available values are:
|
String |
Blocking Count | Total number of sessions that are either directly or indirectly blocked by this session | Number |
Blocking Time | Amount of elapsed time that this session has been blocking other sessions, displayed as d+hh:mm:ss | Number |
Blocking Impact |
|
Number |
Blocking Locks | A comma-separated list of the locks that are responsible for the blocking, for example: Granted write lock on table databaseName.tableName, Waiting on write lock on rowhash databaseName.tableName The information displays in the following order:
|
String |