17.00 - Example: Using QryLogSummaryV - 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 summary information of a session (if logging is initiated with “Replace Query Logging limit Summary = 10,15,20 IOCOUNT on all;”):

replace query logging limit summary = 10,15,20 IOCOUNT on all;

To see the rules:

select * from dbqlrulesv;

Result:

       UserName  All
        Account
ApplicationName
     TypeOfRule  Logging enabled
        Explain  F
         Object  F
            SQL  F
           Step  F
        XMLPlan  F
     StatsUsage  F
        Verbose  F
  DetailedStats  F
      NoColumns  F
        Summary  T
      Threshold  F
    ObjectUsage  F
          Param  F
   FeatureUsage  F
    UtilityInfo  F
       TextSize             200
   Summary//Low       10
            Med       15
           High       20
      LockDelay               0
        AlgMode     ?
TypeOfCriterion  IOCount
     DetailDiag               ?

The following SELECT statement retrieves the summary information of a session:

select * from QrylogSummaryV sample 1;

Result:

              ProcID   30718
    CollectTimeStamp  2016-11-04 12:45:35.460000
              UserID  00000100
          AcctString  DBC
       LogicalHostID       1
               AppID  DBCCONS
            ClientID  PTEUSER
          ClientAddr  10.25.176.76
           ProfileID  ?
           SessionID           1,386
          QueryCount               1
           ValueType  I
        QuerySeconds                     0.000
         AverageTime         .000
        TotalIOCount                     0
           AverageIO
          AMPCPUTime         .000
       AverageAmpCPU         .000
       ParserCPUTime         .004
    AverageParserCPU         .004
      AMPCPUTimeNorm         .000
   AverageAmpCPUNorm         .000
   ParserCPUTimeNorm         .253
AverageParserCPUNorm         .253
             LowHist                     0.000
            HighHist                    10.000
            UsedIota                     0.000
           ReqPhysIO                     0.000
         ReqPhysIOKB                     0.000
           StartTime  2016-11-04 12:38:20.390000
            StopTime  2016-11-04 12:38:20.390000
            UserName  DBC