Database: td_metric_svc
Contains the explain information in an unformatted string without line breaks.
| 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) | Returns the time that the query log was generated. |
| ParentReqStartTime | TIMESTAMP | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time when the parent request was submitted. |
| QueryID | DECIMAL | -(18)9 | Returns the QueryId column contains the generated query id for the given query. |
| ParentQueryID | DECIMAL | -(18)9 | Returns the parent system generated query id for this query. |
| ZoneID | BYTE(4) NOT NULL | X(8) | Returns the zone ID. |
| ExpRowNo | INTEGER NOT NULL | --,---,---,--9 | Returns row number if explain text is greater than 64KB and the system generates multiple rows. |
| ExplainText | VARCHAR(31000) UNICODE NOT CASESPECIFIC NOT NULL | X(31000) | Returns a full Explain Text segment. |
The view also contains ExtraFieldX columns that are reserved for future use.
Example: dbqlexplainV - SELECT
This SELECT statement retrieves the QueryID and ExplainText for a QueryID.
SELECT Queryid, Explaintext FROM td_metric_svc.dbqlexplainV WHERE Queryid = 201205134619838011;
The output from the SELECT statement (the ExplainText) does not contain any format; it is one long string.