To see vertica queries currently running

book

Article ID: 192241

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration

Issue/Introduction

In the event of performance issues with vertica, how can I see the vertica queries currently running?

Environment

CAPM 3.x

Resolution

To determine running vertica queries do the following:

  1. Log on to a vertica node
  2. su - dradmin (or equivalent user)
  3. cd /opt/vertica/bin
  4. ./adminTools
  5. #2 Connect to database
  6. \x for expanded display
  7. Run the following query: select node_name, user_name, request_type, request, request_label, memory_acquired_mb, error_count, start_timestamp, end_timestamp, error_count from query_requests where is_executing='t'  order by start_timestamp desc;
You should get output that looks like this:

--------------------------------------------------------------
node_name          | v_drdata_node0001
user_name          | dradmin
request_type       | QUERY
request            | select node_name, user_name, request_type, request, request_label, memory_acquired_mb, error_count, start_timestamp, end_timestamp, error_count from query_requests where is_executing='t'  order by start_timestamp desc;
request_label      |
memory_acquired_mb | 100
error_count        |
start_timestamp    | 2020-06-04 07:50:12.254002-04
end_timestamp      |
error_count        |