The Overview tab displays general information about the selected operation for a Teradata QueryGrid query session.
General
Metric |
Description |
Type |
Query ID |
ID of the query |
String |
Phase |
Phase of the operation |
String |
Duration |
Duration of the QueryGrid operation
|
Number |
Config version |
Requested version of the QueryGrid operation |
Number |
Link Name |
Name of the link used for this QueryGrid operation |
String |
Initiator Information
Metric |
Description |
Type |
System |
Name of the initiating system |
String |
Total nodes |
Number of nodes on the initiating system |
Number |
Total CPU |
Total CPU usage time consumed |
Number |
CPU skew |
CPU skew for the current query |
Number |
Data skew |
Ratio between the size of the data on the maximum node versus the average node |
Number |
Transfer Information
Metric |
Description |
Type |
Type |
Type of transfer performed |
String |
Rows |
Number of rows transferred |
Number |
Bytes |
Number of bytes transferred |
Number |
Rate |
Rate that data is transferred for the QueryGrid operation
|
Number |
Bottleneck |
Limiting factor for the QueryGrid operation |
String |
Compression ratio |
Uncompressed size divided by the compressed size |
Number |
Target Information
Metric |
Description |
Type |
System |
Name of the target system |
String |
Total nodes |
Number of nodes on the target system |
Number |
Total CPU |
Total CPU usage time consumed |
Number |
CPU skew |
CPU skew for the current query |
Number |
Data skew |
Ratio between the size of the data on the maximum node versus the average node |
Number |
Bridge Information
Metric |
Description |
Type |
Bridge |
Name of the bridge |
String |
Total Nodes |
Number of nodes on the target system |
Number |
Total CPU |
Total CPU usage time consumed |
Number |
CPU skew |
CPU skew for the current query |
Number |
Data skew |
Ratio between the size of the data on the maximum node versus the average node |
Number |
[Viewpoint V17.10.02.00 and Later] the bridge information for the QueryGrid Manager 2.18 and higher displays upto four bridges.