Find last query executed by specific user in Vertica

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

sample results

0
There are no comments. Click here to write the first comment.