Vertica Queries (Prometheus)
2,899

Created 11/6/2023
Updated 11/10/2023
Revision 1
Grafana Version >=9.5.1

View details about queries that are currently running in the cluster. This dashboard visualizes the following data:

  • Total query request success and failure rate
  • Running and queued queries, by node and by resource pool
  • Completed and failed queries, by node and by resource pool
  • User query type and execution time per type

IMPORTANT: To access Prometheus metrics, Vertica requires that you configure the HTTPS service for certificate authentication.

Vertica dashboards

Vertica recommends running Vertica Queries (Prometheus) with other Vertica dashboards that use Prometheus as a data source:

Additional resources

These resources provide details about Vertica and Prometheus:

Available on GitHub.

Get Dashboard
Download
Copy to Clipboard
Source Grafana.com

Used Metrics 9

  • vertica_query_requests_succeeded_total

  • vertica_query_requests_processed_rows_total

  • vertica_query_requests_failed_total

  • vertica_resource_pool_running_query_count

  • vertica_queued_requests_total

  • vertica_query_requests_attempted_total

  • vertica_query_requests_time_ms_sum

  • vertica_query_requests_time_ms_count

  • vertica_query_requests_time_ms_bucket