17.10 - Example: Select from QryLogTDWMV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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