17.00 - Example: Using QryLogStepsV - 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 one sample row from the QryLogStepsV view:

select * from QryLogStepsV sample 1;

The query returns the following result:

                              ProcID   30718
      CollectTimeStamp  2016-11-04 12:11:52.250000
               QueryID    307180509041677206
           StepLev1Num        5
           StepLev2Num        7
              StepName  CTRts
         StepStartTime  2016-11-04 12:11:52.130000
          StepStopTime  2016-11-04 12:11:52.130000
           ElapsedTime      0:00:00.000000
           EstProcTime                     0.000
            EstCPUCost           0.000
               CPUTime           0.000
               IOcount                     0
           EstRowCount                     0
       EstRowCountSkew                     ?
  EstRowCountSkewMatch                     ?
              RowCount                     1
             RowCount2                     ?
             RowCount3                     ?
       NumOfActiveAMPs               1
         MaxAmpCPUTime           0.000
       MaxCPUAmpNumber               ?
         MinAmpCPUTime           0.000
              MaxAmpIO                    14
        MaxIOAmpNumber               1
              MinAmpIO                     0
            SpoolUsage                           0
           MaxAMPSpool                           0
     MaxSpoolAmpNumber               ?
           MinAMPSpool                           0
                StepWD              13
                   LSN               ?
        UtilityTableID  ?
     RowsWComprColumns                     0
             EstIOCost           0.000
            EstNetCost           0.000
             EstHRCost           0.000
           CPUtimeNorm           0.000
     MaxAmpCPUTimeNorm           0.000
   MaxCPUAmpNumberNorm               ?
     MinAmpCPUTimeNorm           0.000
 NumCombinedPartitions                           ?
           NumContexts               ?