LOG_TABLES

Provides summary information about system tables that are being queried or accessed in your database.

Column Name Data Type Description
ISSUED_TIME VARCHAR The time at which the query was executed.
USER_NAME VARCHAR Name of the user who issued the query at the time Vertica recorded the session.
USER_ID INTEGER Numeric representation of the user who ran the query.
HOSTNAME VARCHAR The hostname, IP address, or URL of the database server.
SESSION_ID VARCHAR Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
AUDIT_TYPE VARCHAR

The type of operation for the audit, in this case, Table.

AUDIT_TAG_NAME VARCHAR The tag for the specific table.
REQUEST_TYPE VARCHAR

The type of query request. In this case, QUERY.

REQUEST_ID INTEGER Unique identifier of the query request in the user session.
SUBJECT VARCHAR The name of the table that was queried.
REQUEST VARCHAR Lists the query request.
SUCCESS VARCHAR Indicates whether or not the operation was successful.
CATEGORY VARCHAR The audit parent category, such as Managing_Config_Parameters.

Example

The following example queries the LOG_TABLES system table and shows only the most recent table for this user under the Managing_Config_Parameters category: 

=> SELECT * FROM log_tables limit 1;

--------------------------------------------------------------------------------------------------------
issued_time   | 2018-01-18 11:37:56.939267-05 
user_name     | dbadmin    
user_id       | 45035996273704962
hostname      |          
session_id    | v_vmart_node0001-236982:0x16
audit_type    | Table
audit_tag_name| vs_nodes 
request_type  | QUERY 
request_id    | 12
subject       |                 
request       | select oid,name,address,catalogpath,clientport,controlnode from v_internal.vs_nodes 
where name = 'v_vmart_node0001';
success       | t        
category      | Managing_Users_Privileges
(1 row)