Logged Queries and Suspect Queries Tabs Metrics - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
Metrics available for display are listed below.
Metric Description Type
Account Account of the user who submitted the query String
Active AMPs Number of AMPs involved in executing the query Number
AMP CPU Time Total number of CPU seconds consumed by AMPs in processing the query Number
App ID The ID of the application used to access the Teradata Database. Typically the App ID is the name and version of the Teradata Tool or Utility accessing Teradata Database. String
Burn Rate Percentage of the overall system capacity effectively consumed by the query during its execution Percent
Cache Flag The cache flag types are:
  • T: The flag is found in step cache
  • S: The query is a parameterized query and a specific plan is generated.
  • G: The query is a parameterized query and a generic plan is generated.
  • A: The query is a parameterized query and a specific always decision is taken. Each time a query is submitted, the USING values are considered and the query is parsed.
String
Client Address IP address of the client String
Client ID ID of the client that submitted the query String
CPU Skew CPU skew of the entire query Percent
Error Code Error code associated with the query String
Final Workload Name of the workload under which the query finished String
Flagged Denotes whether the query has been flagged for further analysis String
Gating Efficiency The percentage of the overall query duration spent executing versus being delayed. A value of 100 indicates that all time was spent executing. Percent
Impact CPU Impact of jobs on the system taking CPU skew into account. The value is equal to the highest CPU time in seconds consumed by any one AMP on behalf of a job or query multiplied by the number of AMPs. Number
I/O Skew I/O skew of the entire query Percent
Max AMP CPU Time The maximum CPU consumed by a single AMP while executing the query Number
Max AMP I/O The maximum IOs submitted by a single AMP while executing the query Number
Parser CPU Time Total amount of CPU seconds consumed by the parsing engine in processing the query Number
PJI Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation Number
Proc ID ID of the parsing engine that executed the query String
Query ID System-wide unique ID that identifies the query String
Row Count Number of result rows returned by the query Number
Spool Usage Amount of spool consumed by the query, using a 1024 byte kilobyte as the base Number
Start Time The time the query was submitted Number
Starting Workload Name of the workload under which the query started execution String
Statement Type SQL statement type the query used String
Step Count Number of steps in the query plan Number
Time Active Number of seconds the query spent executing. Excludes any time the query was delayed before being executed. Number
Time Delay Number of seconds the query was delayed before being executed Number
Total Duration Total elapsed time it took for the query to execute once it was submitted Number
Time Expansion Ratio of how long the query took to execute versus how long it could have ideally run. The larger the number, the more the execution time of the query was expanded. For example, a value of 8.8 means an expansion of 8.8 times the ideal execution time. Number
Total I/O Count Total number of I/O requests the query used Number
Unnecessary I/O All AMP I/O divided by all AMP CPU, displayed in milliseconds, to reveal large amounts of I/O occurring in proportion to the CPU consumed Number
Username Name of the user who submitted the query String