We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


monitoring the count of requests per second — Vertica Forum

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.