CA Infrastructure Management, CA Performance Management - Usage and Administration
In the event of performance issues with vertica, how can I see the vertica queries currently running?
To determine running vertica queries do the following:
Log on to a vertica node
su - dradmin (or equivalent user)
#2 Connect to database
\x for expanded display
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;