16.20 - Example: Selecting All Columns from QryLogEventHisV - 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

Select all columns from QryLogEventHisV.

select * from dbc.QryLogEventHisV;

The query returns the following result:

ProcID     CollectTimeStamp                           EntryTS  EntryKind   EntryID  EntryType      EntryName    EventValue  LastValue Activity  ActivityId  ActivityName  ConfigId   SeqNo Spare1 Spare2 Spare3 FlexThrottleID  FlexThrottleSeqNo
------  -------------------------  --------------------------  ----------  -------  -----------  ------------  ----------  --------- --------  ----------  -------------- --------  ------ ------ ------ ------ --------------  -----------------
30718  2016-04-25 14:43:13.670000  2016-04-25 14:43:10.670000  EVENT             2  FLEX-CPU-PCT  FLEX-CPUT             1          1  INACTIVE           ?  ?              5,000       1    ?      ?       ?           ?            ?
30718  2016-04-25 14:38:32.660000  2016-04-25 14:38:28.560000  EXPRESSION        1  ?             FlexUDEExpress        ?          ?  ACTIVE             ?  ?              5,000       1    ?      ?       ?           ?            ?
30718  2016-04-25 14:43:38.630000  2016-04-25 14:43:35.610000  EXPRESSION        2  ?             FLEX-EXPR             ?          ?  INACTIVE           ?  ?              5,000       1    ?      ?       ?           ?            ?
30718  2016-04-25 14:41:38.250000  2016-04-25 14:41:35.230000  EXPRESSION        2  ?             FLEX-EXPR             ?          ?  ACTIVE             ?  ?              5,000       1    ?      ?       ?    307186992487951003  5
30718  2016-04-25 14:38:32.660000  2016-04-25 14:38:28.560000  EVENT             1  ?             FlexUDEEvent          ?          ?  EXPRESSION         1  FlexUDEExpress 5,000       2    ?      ?       ?           ?            ?