To determine running vertica queries do the following:
You should get output that looks like this:
--------------------------------------------------------------
node_name | #####
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 |