Vertica enables you to check last query executed by specific user.

Query

select user_name,
       node_name,
       request_type,
       request,
       start_timestamp,
       end_timestamp,
       request_duration_ms as duration_ms,
       success
from v_monitor.query_requests q
where user_name = 'Fred'
order by start_timestamp desc;

Columns

• user_name - name of user who executed query
• node_name - name of node in which query was executed
• request_type - type of executed statement
  • QUERY
  • DDL
  • LOAD
  • UTILITY
  • TRANSACTION
  • PREPARE
  • EXECUTE
  • SET
  • SHOW
• request - query text
• start_timestamp - start time of query
• end_timestamp - end time of query
• duration_ms - duration of the query in miliseconds
• success - indicate if query executed successfully

Rows

• One row represents one query executed by specific user
• Scope of rows: latest queries of specified user
• Ordered by start time of the query

Sample results