Vertica

Vertica is an advanced, high-performance analytical database management software designed for use in data warehousing and large-scale data analytics. Known for its speed, scalability, and ability to handle massive volumes of data,

Vertica stands out in its ability to perform complex queries at lightning speed. It employs a columnar storage architecture, which significantly optimizes query performance and storage efficiency, making it particularly effective for read-intensive tasks like data analysis and business intelligence.

Vertica's architecture is designed to leverage the capabilities of modern hardware, providing high throughput and concurrency. This makes it an ideal solution for enterprises that require real-time analytics on large datasets.

Integrating Vertica with groundcover

To start accessing granular insights, just follow these 2 super easy steps:

Step 1: Enable Custom Metrics

Follow our quick guide on how to enable scraping custom metrics on groundcover.

Step 2: Import dashboard using Grafana ID

In the groundcover platform, go to Dashboards -> New -> Import.

In the box titled "Import via grafana.com", enter one of the following dashboard IDs, then click "Load".

IDNameDescriptionMore Info

16615

Vertica Performance Dashboard

Performance metrics for Vertica.

19917

Vertica Overview (Prometheus)

View the overall state of your cluster. This dashboard is designed to be the landing page for Vertica Grafana dashboards.

19914

Vertica Depot (Prometheus)

Monitors database depot usage.

19915

Vertica Queries (Prometheus)

View details about queries that are currently running in the cluster.

19916

Vertica Resource Management (Prometheus)

View details about user-defined and built-in resource pool usage.

That's it!

You can now see the imported dashboard in your list of Dashboards and start using it immediately.

You can repeat this action to load as many of these dashboards as you like.

If you import more than one of these dashboards, you may find it useful to create a Vertica Dashboards Folder in groundcover.

Last updated