16.20 - Example: Select from QryLogTDWMV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following SELECT statement retrieves the QryLogTDWMV view:

SELECT * from QryLogTDWMV;

The query returns the following result:

  ProcID  30718
  CollectTimeStamp 2013-12-16 16:35:27
           QueryID   307188518253277390
            UserID 00000104
          UserName TEST1
   DefaultDatabase TEST1
        AcctString SALES
         SessionID          1,007
     LogicalHostID    1
        RequestNum              5
InternalRequestNum              5
   LastStateChange 2013-12-16 08:50:32.960000
         DelayTime              ?
              WDID             12
           OpEnvID              1
          SysConID              1
               LSN              ?
  NoClassification
        WDOverride
   ResponseTimeMet
    ExceptionValue              ?
         FinalWDID             12
    TDWMEstMaxRows        1,170,869,760
   TDWMEstLastRows                    1
  TDWMEstTotalTime  2331.764361
   TDWMEstMemUsage                    4.375
    TDWMAllAmpFlag T
TDWMConfLevelUsed N
        TDWMRuleID              ?
    StatementGroup Select
       SessionWDID             12