Vertica Resource Management (Prometheus)
3,023

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

View details about user-defined and built-in resource pool usage. This dashboard visualizes the following data:

  • Pool configuration values
  • Per node pool usage activity and statistics
  • Per node disk storage state
  • Per node storage location performance

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

Vertica dashboards

Vertica recommends running Vertica Resource Management (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 23

  • vertica_resource_pool_planned_concurrency

  • vertica_resource_pool_max_concurrency

  • vertica_resource_pool_max_memory_size_kb

  • vertica_resource_pool_max_query_memory_size_kb

  • vertica_resource_pool_priority

  • vertica_resource_pool_runtime_priority_threshold

  • vertica_resource_pool_queue_timeout

  • vertica_resource_pool_running_query_count

  • vertica_resource_pool_general_memory_borrowed_kb

  • vertica_queued_requests_total_memory_kb

  • vertica_resource_pool_queueing_threshold_kb

  • vertica_resource_pool_memory_inuse_kb

  • vertica_resource_pool_query_budget_kb

  • vertica_resource_pool_memory_size_actual_kb

  • vertica_query_requests_time_ms_sum

  • vertica_query_requests_time_ms_count

  • vertica_resource_rejections_total

  • vertica_queued_requests_total

  • vertica_disk_storage_total_mb

  • vertica_disk_storage_used_mb

  • vertica_disk_storage_free_percent

  • vertica_disk_storage_throughput_mb_per_second

  • vertica_disk_storage_latency_seek_per_second