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!


  • Options

    Yes query_requests or query_profiles you can find the information but it is true that can have slow performance. What many customer do to accomplish the same, they have a cron job and move this results to other table that they use for dashboard. 
    Hope this helps, 


  • Options
    Thank you for your reply. Yes, that's pretty much our solution now .. we just run the query every five minutes. Too bad vertica doesn't automatically capture that metric.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file