Database: td_metric_svc
Stores information about queries that meet the criteria for a rule specifying the LIMIT SUMMARY or LIMIT THRESHOLD option.
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| Location | VARCHAR(2048) UNICODE CASESPECIFIC | X(2048) | Path to metric data objects. |
| path_component_id | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Operational group (primary cluster or compute cluster) ID. |
| path_collecttimestamp | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Timestamp of when collected the given metrics. |
| path_year | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The year in which the data was recorded in the table. |
| path_month | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The month in which the data was recorded in the table. |
| path_day | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The date on which the data was recorded in the table. |
| path_hour | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The hour at which the data was recorded in the table. |
| path_minute | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The minute at which the data was recorded in the table. |
| path_ver | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The version of Vantage software that was running on the operational group. |
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Returns the process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the DBQL summary cache was written. |
| UserID | BYTE(4) | X(8) | Returns the ID of the user. |
| ZoneID | BYTE(4) NOT NULL | X(8) | Returns the zone ID. |
| AcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the user unexpanded logon account string. |
| LogicalHostID | SMALLINT | -(5)9 | Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
| AppID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | Returns the application ID. |
| ClientID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | Returns the client ID. |
| ClientAddr | CHAR(45) LATIN NOT CASESPECIFIC | X(45) | Returns the IP address of the client who submitted the query. |
| ProfileID | BYTE(4) | X(8) | Returns the unique number assigned to the cost profile instance in the system. |
| SessionID | INTEGER NOT NULL | --,---,---,--9 | Returns the session identifier. |
| QueryCount | INTEGER NOT NULL | --,---,---,--9 | Returns the number of queries run in a 10-minute interval. Used with the "SUMMARY" or "THRESHOLD" SQL option only. |
| ValueType | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns the type that was used to determine the threshold from the following values. C = CPU seconds, I = IO count, S = Elapsed time in seconds. |
| QuerySeconds | FLOAT NOT NULL | ----,---,---,---,--9.999 | Returns the total number of seconds used by QueryCount. QuerySeconds can be used to get an average. |
| TotalIOCount | FLOAT | ----,---,---,---,--9 | Returns the number of IOs from AMPs that were generated by the query in summary mode. |
| AMPPCUTime | FLOAT | ----,---,---,---,--9.999 | Returns the total AMP CPU time in seconds used for query in summary mode. |
| ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the total parser and dispatcher CPU time in seconds (with .001 resolution) used for the query in summary mode. |
| AMPCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized AMP CPU time in seconds for co-existence systems in summary mode. |
| ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized parser CPU time in seconds (with .001 resolution) for co-existence systems in summary mode. |
| LowHist | FLOAT NOT NULL | ----,---,---,---,--9.999 | For SUMMARY option, lowest value specified as query execution differentiation. For THRESHOLD option, threshold specified by the user. |
| HighHist | FLOAT NOT NULL | ----,---,---,---,--9.999 | Returns the highest value specified as a query execution time differentiation. Used with the "SUMMARY" SQL option only. If THRESHOLD is used, HighHist is 0. |
| UsedIota | FLOAT | ----,---,---,---,--9.999 | Return IO Tokens used by the requests that are logged in summary mode. |
| ReqPhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the total number of Physical I/Os for the whole request in summary mode. |
| ResPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Returns the total Physical I/Os in kilobytes for the whole request in summary mode. |
| StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Records the timestamp of the first query included for this summary row. |
| StopTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Records the timestamp of the last query included for this summary row. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the userid, if any, under which the user submitted the query. |
| ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the profile, if any, under which the user submitted the query. |
| TotalIOKB | FLOAT | ----,---,---,---,--9.999 | Total I/Os in kilobytes used by the requests in summary mode during the collection period. |
Example: dbqlsummaryV - SELECT
The following SELECT statement retrieves the summary information of a session:
select * from td_metric_svc.dbqlsummaryV sample 1;
Result:
ProcID 30718
CollectTimeStamp 2016-11-04 12:45:35.460000
UserID 00000100
AcctString DBC
LogicalHostID 1
AppID DBCCONS
ClientID PTEUSER
ClientAddr 10.25.176.76
ProfileID ?
SessionID 1,386
QueryCount 1
ValueType I
QuerySeconds 0.000
TotalIOCount 0
AMPCPUTime .000
ParserCPUTime .004
AMPCPUTimeNorm .000
ParserCPUTimeNorm .253
LowHist 0.000
HighHist 10.000
UsedIota 0.000
ReqPhysIO 0.000
ReqPhysIOKB 0.000
StartTime 2016-11-04 12:38:20.390000
StopTime 2016-11-04 12:38:20.390000
UserName DBC