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

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