LOG_QUERIES

Provides summary information about some queries related to authentication and security run 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, Query.

AUDIT_TAG_NAME VARCHAR The tag for the specific query.
REQUEST_TYPE VARCHAR

The type of query request. Examples include, but are not limited to:

  • QUERY
  • DDL
  • LOAD
  • UTILITY
  • TRANSACTION
  • PREPARE
  • EXECUTE
  • SET
  • SHOW
REQUEST_ID INTEGER The ID of the query request.
SUBJECT VARCHAR The subject of the query.
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_Users_Privileges.

Example

The following example queries the LOG_QUERIES system table and shows only the most recent query for this user under the Managing_Users_Privileges category:

=> SELECT * FROM log_queries limit 1;
---------------------------------------------------------------------------
issued_time   | 2018-01-22 10:36:55.634349-05 
user_name     | dbadmin    
user_id       | 45035996273704962
hostname      |          
session_id    | v_vmart_node0001-237210:0x37e1d 
audit_type    | Query
audit_tag_name| REVOKE ROLE 
request_type  | DDL 
request_id    | 2
subject       |                 
request       | revoke all privileges from Joe;
success       | f        
category      | Managing_Users_Privileges
(1 row)