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.