Database: td_metric_svc
The main table containing information about queries being logged.
| 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. |
| QueryID | DECIMAL(18,0) NOT NULL | -(18)9 | Returns a system-wide unique ID to identify the query. |
| UserID | BYTE(4) NOT NULL | X(8) | Returns the ID of the user. |
| AcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the user unexpanded logon account string. |
| ExpandAcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the expanded logon string of the user. |
| SessionID | INTEGER NOT NULL | --,---,---,--9 | Returns the unique identification number of the session. |
| LogicalHostID | SMALLINT NOT NULL | -(5)9 | Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
| RequestNum | INTEGER NOT NULL | --,---,---,--9 | Returns the client request number for all queries. |
| InternalRequestNum | INTEGER NOT NULL | --,---,---,--9 | Returns the internal request number used by the database system. |
| LogonDateTime | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the date and time that the session was logged on. |
| AcctStringTime | FLOAT | 99:99:99 | Returns the result from the &T code when the user has specified Account String Expansion (ASE). |
| AcctStringHour | SMALLINT | -(5)9 | Returns the result from the &H code when the user has specified Account String Expansion (ASE). |
| AcctStringDate | DATE | YYYY/MM/DD | Returns the result from the &D code when the user has specified Account String Expansion (ASE). |
| LogonSource | CHAR(128) LATIN NOT CASESPECIFIC | X(128) | Returns the logon source string text. |
| 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) UNICODE NOT CASESPECIFIC | X(45) | Returns the IP address of the client who submitted the query. |
| QueryBand | VARCHAR(12304) UNICODE NOT CASESPECIFIC | X(12304) | Returns the query band under which the request was submitted if it was submitted under a query band. |
| ProfileID | BYTE(4) | X(8) | Returns the unique number assigned to the cost profile instance in the system. |
| StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time the query is submitted. |
| FirstStepTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time the first step for this query is dispatched. |
| FirstRespTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the timestamp when the first response packet is sent to host. |
| LastStateChange | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time of the last state change through the Teradata dynamic workload management software. |
| NumSteps | SMALLINT | ---,--9 | Returns the total number of (level 1) steps for this query. |
| NumStepswPar | SMALLINT | ---,--9 | Returns the number of (level 1) steps with parallel steps. |
| MaxStepsInPar | SMALLINT | ---,--9 | Returns the maximum number of (level 2) steps done in parallel for this query. |
| NumResultRows | FLOAT | ----,---,---,---,--9 | Returns the total number of rows returned for the query. |
| TotalIOCount | FLOAT | ----,---,---,---,--9 | Returns the number of IOs from AMPs that were generated by the query. |
| AMPCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the total AMP CPU time in seconds used for query. |
| ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the total parser and dispatcher CPU time in seconds (with .001 resolution) used for the query. |
| UtilityByteCount | BIGINT | --,---,---,---,---,---,--9 | Returns the number of bytes transferred by client as part of FastLoad or MultiLoad job. |
| UtilityRowCount | FLOAT | ----,---,---,---,--9 | Returns the number of rows loaded by FastLoad or MultiLoad. |
| ErrorCode | INTEGER | --,---,---,--9 | Returns error code if the query caused a Parser syntax error. |
| ErrorText | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | Returns the text from the error if ErrorCode is not 0. |
| WarningOnly | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns warning code T for true if the error was reported while running TDWM in the warning mode. |
| DelayTime | FLOAT | ----,---,---,---,--9.999 | Returns the seconds a query was delayed by the Teradata dynamic workload management software. |
| AbortFlag | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns T (yes) if this query was aborted. |
| CacheFlag | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns blank if the query is not found in step cache. The possible values are T, G, S, and A. |
| StatementType | CHAR(20) LATIN NOT CASESPECIFIC | X(20) | Returns the type of statement in the request (a 20 character field is used to describe the statement). |
| QueryText | VARCHAR(10000) UNICODE NOT CASESPECIFIC | X(10000) | Returns the query text. The default size is 200 characters. |
| NumOfActiveAMPs | INTEGER | --,---,---,--9 | Returns the number of AMPS that were active for this query. |
| MaxAMPCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the CPU time in seconds (with .001 resolution) of the AMP with the highest CPU usage in the query. |
| MaxCPUAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with the highest CPU activity. |
| MinAmpCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the CPU time in seconds (with .001 resolution) of the AMP with the lowest CPU usage for the query.. |
| MaxAmpIO | FLOAT | ----,---,---,---,--9 | Returns the I/O count of the highest I/O used AMP in the query. |
| MaxIOAmpNumber | INTEGER | --,---,---,--9 | Returns the number of the AMP with the highest IO usage for this query. |
| MinAmpIO | FLOAT | ----,---,---,---,--9 | Returns the I/O count of the lowest I/O used AMP in the query. |
| SpoolUsage | BIGINT | --,---,---,---,---,---,--9 | Returns peak spool usage (bytes) of any step in the query (DataCollectAlg=3). Otherwise, number of bytes used for spool in the query. |
| WDID | INTEGER | --,---,---,--9 | Returns the workload definition (WD) number assigned to the query. |
| OpEnvID | INTEGER | --,---,---,--9 | Returns the ID of the operational environment currently activated by the Teradata dynamic workload management software. |
| SysConID | INTEGER | --,---,---,--9 | Returns the ID of the system condition currently activated by the Teradata dynamic workload management software. |
| LSN | INTEGER | --,---,---,--9 | Returns the Logon Sequence Number used for a load utility. |
| NoClassification | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns T(yes) if the query was not classified. |
| WDOverride | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns T(yes) if the WD was overridden by the user. |
| ResponseTimeMet | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns T (yes) if the query met service level goals. |
| ExceptionValue | INTEGER | --,---,---,--9 | Returns the type of Teradata dynamic workload management software exception occurred. |
| FinalWDID | INTEGER | --,---,---,--9 | Returns the workload definition in which the query completed execution. |
| TDWMEstMaxRows | FLOAT | ----,---,---,---,--9 | Returns the estimated maximum rows as generated by Optimizer. |
| TDWMEstLastRows | FLOAT | ----,---,---,---,--9 | Returns the estimated last step row number as generated by Optimizer. |
| TDWMEstTotalTime | FLOAT | ----,---,---,---,--9 | Returns the estimated total time in milliseconds as generated by Optimizer. The resolution of estimated time is .01 in views and .001 on disk. |
| TDWMAllAmpFlag | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns T (yes) if one of the steps in the query was an all-AMP step. |
| TDWMConfLevelUsed | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns the minimum confidence level that the Teradata dynamic workload management software is allowed to use in looking at estimated data. |
| TDWMRuleID | INTEGER | --,---,---,--9 | Returns rule identifier of the query. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the user who issued the query. |
| DefaultDatabase | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the current default database used in the query. |
| AMPCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized AMP CPU time in seconds for co-existence systems. |
| ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized parser CPU time in seconds (with .001 resolution) for co-existence systems. |
| MaxAMPCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized CPU time in seconds (with .001 resolution) of the AMP with maximum CPU usage in the query. |
| MaxCPUAmpNumberNorm | INTEGER | --,---,---,--9 | Returns the number of the AMP with the highest CPU activity. |
| MinAmpCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the normalized CPU Time in seconds (with .001 resolution) of the AMP with minimum CPU usage in the query. |
| EstResultRows | FLOAT | ----,---,---,---,--9 | Returns estimated number of rows returned by this query. |
| EstProcTime | FLOAT | ----,---,---,---,--9.999 | Returns the estimated processing time in seconds (with .001 resolution) from the Optimizer. |
| EstMaxRowCount | FLOAT | ----,---,---,---,--9 | Maximum of estimated row count for the steps in this query. |
| ProxyUser | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the proxy user. |
| ProxyRole | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the role name of a proxy connection. |
| StatementGroup | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the grouping the statement belongs to (DDL, DML, or SELECT). For a multiple-statement request, this value indicates the number of different statement types in the request. |
| SessionTemporalQualifier | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | Returns the session temporal qualifier in effect when the query is logged. |
| CalendarName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the active business calendar. |
| SessionWDID | INTEGER | --,---,---,--9 | Returns the workload ID class associated with the session. It determines the priority of the session when the TDWM workload classification is active. |
| DataCollectAlg | BYTEINT | -(3)9 | Returns CPU/IO collection algorithm used by DBQL. Possible values include: 1- Classic Algo|2- Use Algo 2|3- Use Algo 3. |
| ParserExpReq | FLOAT | ----,---,---,---,--9.999 | Returns the number of seconds the parser waited on an express request. |
| CallNestingLevel | BYTEINT | -(3)9 | Returns the level of nesting when running in stored procedures. |
| NumRequestCtx | BYTEINT | -(3)9 | Returns the number of request contexts associated with the session. |
| KeepFlag | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns value (Y) or (N) to indicate whether to keep the response parcel until the client responds that it is no longer needed. |
| QueryRedriven | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns value (Y) or (N) to indicate if the query was re-driven. |
| ReDriveKind | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Returns the type of reset protection with which the query was re-driven. (MN)-Memory, (DF)-Dictionary table Fallback responses, (DN)-Dictionary Table Non-fallback responses. |
| CPUDecayLevel | SMALLINT | ---,--9 | Returns the most severe decay level reached for CPU usage during the life of the request at node level. |
| IODecayLevel | SMALLINT | ---,--9 | Returns the most severe decay level reached for IO usage during the life of the request at node level. |
| TacticalCPUException | INTEGER | --,---,---,--9 | Returns the number of nodes that encountered a CPU exception. |
| TacticalIOException | INTEGER | --,---,---,--9 | Returns the number of nodes that encountered an I/O exception. |
| SeqRespTime | FLOAT | ----,---,---,---,--9.999 | Contains sum of the response time of all steps as if they had been run sequentially in units of seconds. |
| ReqIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total logical I/O usage in kilobytes. |
| ReqPhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the number of physical I/Os. |
| ReqPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes. |
| NumFragments | INTEGER | --,---,---,--9 | Returns the number of fragments in a IPE plan execution of request. |
| CheckpointNum | FLOAT | ----,---,---,---,--9 | Returns the checkpoint interval number for MLOADX. |
| UnityTime | FLOAT | ----,---,---,---,--9.999 | Returns the time in seconds the stored procedure request was being processed by Unity. |
| LockDelay | FLOAT | ----,---,---,---,--9.999 | Returns the maximum wait time to get a lock on object in centiseconds. |
| LastRespTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the last response Timestamp. |
| DisCPUTime | FLOAT | ----,---,---,---,--9.999 | Returns the CPU time in seconds used by the dispatcher. |
| Statements | INTEGER | --,---,---,--9 | Returns the Number of statements in the request. |
| DiscCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Returns the Normalized dispatcher CPU time in seconds. |
| TxnMode | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Returns the transaction mode of this query (ANSI, BTET). |
| RequestMode | CHAR(5) LATIN NOT CASESPECIFIC | X(5) | Returns the request mode of this query. |
| UtilityInfoAvailable | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns (Y) to Indication if a request also has utility information available in the DBQLUtilityTbl table. |
| UnitySQL | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns (Y) to indicates Unity requested the SQL be modified. This is set when Unity asks for Unity transaction table to be updated. |
| ThrottleBypassed | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns whether the request was only allowed to run due to the throttlebypass feature of TDWM. |
| DBQLStatus | INTEGER | --,---,---,--9 | Returns internal DBQL logging status. Zero indicates no status conditions (DataCollectAlg=3). |
| IterationCount | INTEGER | --,---,---,--9 | Returns the iteration count for data parcel associated with a request. |
| VHLogicalIO | FLOAT | ----,---,---,---,--9.999 | Returns the total number of Very Hot logical I/Os for the whole request. |
| VHPhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the total number of Very Hot Physical I/Os for the whole request. |
| VHLogicalIOKB | FLOAT | ----,---,---,---,--9.999 | Returns the total Very Hot logical I/Os in kilobytes for the whole request. |
| VHPhysIOKB | FLOAT | ----,---,---,---,--9.999 | Returns the total Very Hot Physical I/Os in kilobytes for the whole request. |
| TDWMEstMemUsage | FLOAT | ----,---,---,---,--9.999 | Returns the estimated memory usage in MBs for query. |
| MaxStepMemory | FLOAT | ----,---,---,---,--9.999 | Returns the maximum memory in MBs used by any one step in the request. |
| TotalServerByteCount | BIGINT | --,---,---,---,---,---,--9 | Total bytes sent and received from the foreign server. |
| ProxyUserID | BYTE(4) | X(8) | Returns the internal ID of the proxy user if the proxy user is a permanent user. |
| TxnUniq | BYTE(4) | X(8) | Returns the transaction Uniq portion used with ProcId. |
| LockLevel | VARCHAR(10) LATIN NOT CASESPECIFIC | X(10) | Returns the highest level lock associated with this request. |
| TTGranularity | VARCHAR(30) UNICODE NOT CASESPECIFIC NOT NULL | X(30) | Returns the Granularity of Transaction Time for the session specified by the most recent SET SESSION TTGranularity request or Session default. |
| ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the profile, if any, under which the user submitted the query. |
| WDName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the workload definition (WD) name assigned to the query. |
| FlexThrottle | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Flag 'T' indicates this query was released from the TDWM delay queue due to the Flex Throttle feature. |
| EstMaxStepTime | FLOAT | ----,---,---,---,--9.999 | The estimated maximum step time in seconds from the Optimizer. |
| ParamQuery | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Flag 'T' indicates the query is parameterized. |
| RemoteQuery | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Flag 'T' indicates a remote query has been submitted. |
| PersistentSpool | BIGINT | --,---,---,---,---,---,--9 | Persistent part of SpoolUsage. |
| MinRespHoldTime | FLOAT | ----,---,---,---,--9.999 | Seconds response was held to meet the minimum response time. |
| TotalFirstRespTime | FLOAT | ----,---,---,---,--9.999 | DelayTime + Execution Time + MinRespHoldTime (in seconds). |
| MaxOneMBRowSize | INTEGER | --,---,---,--9 | The actual size in bytes of the largest 1MB row in the set of rows returned for the query. |
| NumResultOneMBRows | FLOAT | ----,---,---,---,--9 | The number of 1MB rows (1MB > size > 64KB) in the set of rows returned for the query. |
| MaxNumMapAMPs | INTEGER | --,---,---,--9 | The number of AMPs in the largest contiguous map used by the request. |
| MinNumMapAMPs | INTEGER | --,---,---,--9 | The number of AMPs in the smallest contiguous map used by this request. |
| SysDefNumMapAMPs | INTEGER | --,---,---,--9 | Number of AMPs in the system-default map. |
| FeatureUsage | VARBYTE(256) | X(512) | This column logs the bitmap of features being used by the request. |
| ReqMaxSpool | BIGINT | --,---,---,---,---,---,--9 | Maximum spool usage by the request. |
| NumAMPsImpacted | INTEGER | --,---,---,--9 | Number of AMPs contributed to the ReqMaxSpool. |
| UsedIota | FLOAT | ----,---,---,---,--9.999 | Return IO Tokens used by the requests. |
| OpEnvName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDWM operating environment name associated with the OpEnvId. |
| SysConName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDWM System Health Condition name associated with the SysConId. |
| FinalWDName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the workload definition in which the query completed execution. |
| SessionWDName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDWM workload name used for parsing activity. |
| MapAmpsMapNo | INTEGER | --,---,---,--9 | MapNo with the maximum number of AMPs. |
| AutoDBAData | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Values indicate if the request contains AutoDBA Data. |
| UAFName | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | Name of an Analytic Function being run by EXECUTE FUNCTION. The default is NULL. |
| UnityQueryType | BYTEINT | -(3)9 | Indicates if it is a replayed SQL or CDA. |
| TacticalRequest | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | 'T' indicating that the request was tactical, NULL otherwise. |
| DefaultDBCacheUsed | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | 'T' indicating that default DB is used in the step cache, NULL otherwise. |
| ReqAWTTime | FLOAT | ----,---,---,---,--9.999 | AWT elapsed time in seconds for the request. |
| MaxReqAwtTime | FLOAT | ----,---,---,---,--9.999 | Max AWT elapsed time in seconds for the request. |
| MaxReqAWTTimeAmpNum | INTEGER | --,---,---,--9 | AMP number that had max AWTTime for the request. |
| MinReqAWTTime | FLOAT | ----,---,---,---,--9.999 | Min AWT elapsed time in seconds for the request. |
| UDFVMData | FLOAT | ----,---,---,---,--9.999 | UDF Virtual memory data size for the request. |
| UDFVMPeak | FLOAT | ----,---,---,---,--9.999 | UDF Virtual memory peak for the request. |
| TotalUDFMemUsage | FLOAT | ----,---,---,---,--9.999 | Total memory used by UDF for the request. |
| MaxReqUDFMemUsage | FLOAT | ----,---,---,---,--9.999 | Max memory used by UDF for the request. |
| MaxReqUDFMemUsageAmpNum | INTEGER | --,---,---,--9 | AMP number that had max memory used by UDF for this request. |
| PGRCTimeToGetPlan | FLOAT | ----,---,---,---,--9.999 | Time taken for communication between cache management threads and session thread to get plan from target PE when Partitioned Global Request Cache feature is ON. |
| NosRecordsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of records returned by a Native Object Store request. |
| NosRecordsSkipped | BIGINT | --,---,---,---,---,---,--9 | Number of records skipped by a Native Object Store request. |
| NosPhysReadIO | BIGINT | --,---,---,---,---,---,--9 | Total physical read IOs for Native Object Store files. |
| NosPhysReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of physical read IOs for Native Object Store files. |
| NosRecordsReturnedKB | FLOAT | ----,---,---,---,--9.999 | Total KB of records returned for Native Object Store files. |
| NosTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Total of the Native Object Store IO wait time for the request. |
| NosMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Max Native Object Store IO wait time for the request. |
| NosCPUTime | FLOAT | ----,---,---,---,--9.999 | CPU time for reading Native Object Store files for the request. This time is already included in other non-NOS CPU fields. |
| NosTables | INTEGER | --,---,---,--9 | Total number of Native Object Store tables accessed in the request. Access through READ_NOS does not increment this field, although it does increment the other NOS fields. |
| NosFiles | INTEGER | --,---,---,--9 | Number of Native Object Store file reads were attempted on by this request. |
| NosFilesSkipped | INTEGER | --,---,---,--9 | Number of Native Object Store files that were skipped. |
| StepCacheHash | INTEGER | --,---,---,--9 | Step cache hash value of this request if cached. |
| TDWMMSRCount | INTEGER | --,---,---,--9 | Statement count ignoring BT, ET, ParNull, ParMTmp. |
| DeferTime | FLOAT | ----,---,---,---,--9.999 | The number of seconds a query was deferred by workload management due to ARM rules. |
| DeferRuleID | INTEGER | --,---,---,--9 | TDWM Rule ID of one of the ARM rules which caused this request to be deferred. |
| TDWMAdmissionTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | The time when a request is admitted into the system by workload management (that is, after ARM processing). |
| StmtDMLRowCount | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Row count for DML (Update/Insert/Delete) statements. |
| UnityQueryForeignInfo | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Contains UnityForeignQueryID and UnityForeignSystemID. |
| NumJoinSteps | SMALLINT | ---,--9 | Returns the total number of join steps for this query. |
| NumSumSteps | SMALLINT | ---,--9 | Returns the total number of sum steps for this query. |
| PGRCTgtPENum | SMALLINT | ---,--9 | Returns the target PE number which holds the PSTEPS for this request when PGRC feature is ON. |
| NosPhysWriteIO | BIGINT | --,---,---,---,---,---,--9 | Total physical IOs were written for Native Object Store files for this request. |
| NosPhysWriteIOKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of physical IOs written for Native Object Store files for this request. |
| NosCacheReadIO | BIGINT | --,---,---,---,---,---,--9 | Total Cache Read IOs for Native Object Store files for this request. |
| NosCacheReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total Cache read IOs in KB for Native Object Store files for this request. |
| NosPhysDataReadIO | BIGINT | --,---,---,---,---,---,--9 | Total physical data read IOs for Native Object Store files for this request. |
| NosPhysDataReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total physical Data read IOs in KB for Native Object Store files for this request. |
| NosPrefetchReadIO | BIGINT | --,---,---,---,---,---,--9 | Total Read Ahead IOs for Native Object Store files for this request. |
| NosPrefetchReadIOKB | BIGINT | --,---,---,---,---,---,--9 | Total Read Ahead IOs in KB for Native Object Store files for this request. |
| NosFilesWritten | BIGINT | --,---,---,---,---,---,--9 | The number of file writes attempted by Native Object Store in this request. |
| NosFilesDeleted | BIGINT | --,---,---,---,---,---,--9 | The total number of files deleted for Native Object Store files for this request. |
| NosDeleteIO | BIGINT | --,---,---,---,---,---,--9 | Total IOs to delete for Native Object Store files for this request. |
| NosDeleteIOKB | BIGINT | --,---,---,---,---,---,--9 | Total IOs in KB to delete for Native Object Store files for this request. |
| NosNumDeleteSuccess | INTEGER | --,---,---,--9 | The number of files successfully deleted by Native Object Store for this request. |
| NosNumDeleteFailure | INTEGER | --,---,---,--9 | The number of failed file deletes by Native Object Store for this request. |
| ReqLocSpoolUsage | BIGINT | --,---,---,---,---,---,--9 | Total local spool usage for the request in bytes. |
| ReqPhysLocIO | FLOAT | ----,---,---,---,--9.999 | Total local physical IO count for the request. |
| ReqPhysLocIOKB | FLOAT | ----,---,---,---,--9.999 | Total local physical IO for the request in kilobytes. |
| ReqPeakAmpPrvMem | FLOAT | ----,---,---,---,--9.999 | Total peak private memory in MB based on requested size used by anyone AMP in the request. |
| ReqPeakAmpPrvMemAmpNum | INTEGER | --,---,---,--9 | AMP number that reported total peak private memory based on the requested size used in the request. |
| ReqPeakAmpShrMem | FLOAT | ----,---,---,---,--9.999 | Total peak shared memory in MB based on requested size used by anyone AMP in the request. |
| ReqPeakAmpShrMemAmpNum | INTEGER | --,---,---,--9 | AMP number that reported total peak shared memory based on the requested size used in the request. |
| TDWMEstMemResLimit | FLOAT | ----,---,---,---,--9.999 | Memory estimate (in megabytes) used for checking memory resource limit. |
| MaxPSFWDID | INTEGER | --,---,---,--9 | Maximum PSF WDID seen by this request. |
| MaxPSFWDIDAmpNum | INTEGER | --,---,---,--9 | Maximum PSF WDID AMP Number of this request. |
| HPTotalPipelines | INTEGER | --,---,---,--9 | The total number of steps in the plan that are being processed using the pipeline. |
| HPMaxPipelines | INTEGER | --,---,---,--9 | The maximum number of steps in a pipeline unit indicates that many AWTs are needed to process the query. |
| ParentQueryID | DECIMAL(18,0) | -(18)9 | Returns the Parent QueryId column contains the parent system generated query id for the given query. |
| NosSpCIsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Cis returned by a Native Object Store Spool request. |
| NosSpCIsReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of CIs returned for Native Object Store spool requests. |
| NosSpDBChunksReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Datablock chunks returned by a Native Object Store spool request. |
| NosSpDBChunksReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool datablock chunks returned by a Native Object Store spool request. |
| NosSpDBsReturned | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool Datablocks returned by a Native Object Store spool request. |
| NosSpDBsReturnedKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool datablocks returned by a Native Object Store spool request. |
| NosSpBlksFSGAcqs | BIGINT | --,---,---,---,---,---,--9 | Number of NOS spool datablocks read from FSG. |
| NosSpBlksFSGAcqsKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of the Number of NOS spool datablocks read from FSG. |
| NosSpTablesRead | INTEGER | --,---,---,--9 | Number of NOS Spool tables accessed. This value must be the same as the number of NOS Spool MIs requested. |
| NosSpCPUTime | FLOAT | ----,---,---,---,--9.999 | CPU time for reading Native Object Store spool blocks (MI, CI, DBChunks). Units of seconds. |
| NosSpMaxIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Max Native Object Store spool IO wait time for any individual IO. Units of seconds. Both read and write. |
| NosSpTotalIOWaitTime | FLOAT | ----,---,---,---,--9.999 | Total of the Native Object Store spool IO wait time across all steps. Units of seconds. Both read and write. |
| NosSpTablesWritten | INTEGER | --,---,---,--9 | Number of NOS spool tables written. This corresponds to the number of TMIs written. |
| NosSpCIsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS Spool CIs written. |
| NosSpCIsWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS Spool CIs written. |
| NosSpDBChunksWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS spool DB chunks written. |
| NosSpDBChunksWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool DB chunks written. |
| NosSpDBsWritten | BIGINT | --,---,---,---,---,---,--9 | Number of NOS DBs written. |
| NosSpDBsWrittenKB | BIGINT | --,---,---,---,---,---,--9 | Total KB of NOS spool DBs written. |
| OTFQuery | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Indicates OTF Query execution method. The possible values are ‘J' (Java) or 'N’ (Native) or NULL. |
Example: dbqlogV - SELECT
The following SELECT statement retrieves all rows that match the specified query ID from the dbqlogV view.
select * from td_metric_svc.dbqlogV where queryid = 307190925762023013;