monitoring the count of requests per second

maksmaks Community Edition User ✭
edited March 2023 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.