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

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    ?      ?       ?           ?            ?