The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

monitoring the count of requests per second

maksmaks Community Edition User ✭
edited March 25 in General Discussion

Hello. Could you help me? I am now setting up monitoring of a vertica cluster and I want to monitor the total count of requests per second to the database and count of requests per second to a specific table. Unfortunately, I did not find a request with which this can be done. Please tell me how can I get this data

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    For total requests per second: have a look at v_monitor.query_requests
    For requests on a specific table: have a look at v_monitor.projection_usage

  • maksmaks Community Edition User ✭

    @Bryan_H thanks of lot

This discussion has been closed.