Skip to main content
Question

monitoring the count of requests per second

  • March 2, 2023
  • 2 replies
  • 8 views

maks
Forum|alt.badge.img+1
  • Participating Frequently

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

2 replies

Bryan_H
Forum|alt.badge.img+2
  • Participating Frequently
  • March 2, 2023

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


maks
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • March 3, 2023

@Bryan_H thanks of lot