Need select/insert/update/delete per sec metrics from vertica
We are looking to graph various vertica metrics and I've been scouring the vertica v_monitor.* and data collector tables all day looking for a good way to get the number of select and insert/update/delete commands run by the cluster per second. I have come up with nothing viable short of expensive queries using query_requests. If somebody could help out with this, I would really appreciate that. Thanks!