CPU Usage by Query
I have OEM(Oracle Enterprise Manager) installed in Vertica databases, with this, i can check the activity in the servers. It seems like there a lot of activity (100% CPU utilization) in these servers.
Is there a query or a way to know which query was generating this high CPU? Looks like this happens last May 2016, i would like to know the culprit queries.
Thanks in advance.