17.00 - Example: Select from QryLogTDWMV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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