• EnglishEspañol日本語한국어Português
  • Log inStart now

Vertica integration

Our Vertica integration monitors the performance of your data storage.

After setting up our Vertica integration, we give you a dashboard for your Vertica metrics.

Install the infrastructure agent

You can install the infrastructure agent two different ways:

Use nri-flex to capture metrics

Flex comes bundled with the New Relic infrastructure agent. You need to configure nri-flex for Vertica and create a flex configuration file.

Follow these steps:

  1. Create a file named vertica-flex-config.yml in this path:

  2. Update the file vertica-flex-config.yml with these configurations:

    • EVENT_TYPE: You can consider EVENT_TYPE as a New Relic database table that you can query using NRQL.
    • COMMAND: This contains the command which is used to print metrics on the terminal.

    Once your configuration file is updated, it will look like below:

- name: nri-flex
name: VerticaFlex
- database: vertica
db_conn: 'vertica://dbadmin:vertica@'
open: true
db_async: true # process queries async
- name: VerticaFindCitiesDetails
run: SELECT * FROM cities;
- name: VerticaDiskSpaceUsedByTables
run: SELECT projection_schema, anchor_table_name, to_char(sum(used_bytes)/1024/1024/1024,'999,999.99') as disk_space_used_gb FROM projection_storage
GROUP by projection_schema, anchor_table_name ORDER by disk_space_used_gb desc limit 50;
- name: VerticaFreeDiskSpace
run: SELECT to_char(sum(disk_space_free_mb)/1024,'999,999,999') AS disk_space_free_gb, to_char(sum(disk_space_used_mb)/1024,'999,999,999') AS disk_space_used_gb FROM disk_storage;
- name: VerticaUserInformation
run: SELECT user_name, is_super_user, resource_pool, memory_cap_kb, temp_space_cap_kb, run_time_cap FROM users;
- name: VerticaUserDetails
run: SELECT * FROM user_sessions;
- name: VerticaQueriesByUser
run: SELECT * FROM query_profiles WHERE user_name ILIKE '%dbadmin%';
- name: VerticaUserRolesInformation
run: SELECT * FROM roles;
- name: VerticaResourcePoolAssignments
run: SELECT user_name, resource_pool FROM users;
- name: VerticaTableInfo
run: SELECT table_name, is_flextable, is_temp_table, is_system_table, count(*) FROM tables GROUP by 1,2,3,4;
- name: VerticaActiveEvents
run: SELECT * FROM active_events WHERE event_problem_description NOT ILIKE '%state to UP';
- name: VerticaDiskStorage
run: SELECT node_name, storage_path, storage_usage, storage_status, disk_space_free_percent FROM disk_storage;
- name: VerticaLongRunningQueries
run: SELECT query_duration_us/1000000/60 AS query_duration_mins, table_name, user_name, processed_row_count AS rows_processed, substr(query,0,70) FROM query_profiles ORDER BY query_duration_us DESC LIMIT 250;
- name: VerticaLicenseConsumption
- name: VerticaAudit
run: SELECT AUDIT('');

Forward your Vertica logs to New Relic

You can use our log forwarding to forward Vertica logs to New Relic.

On Linux machines, your can find your log file named logging.yml in this path:


After creating the log file, add the following script to the logging.yml file:

- name: vertica.log
file: /home/dbadmin/vdb/v_vdb_node0001_catalog/vertica.log
logtype: vertica_log

Restart the New Relic infrastructure agent

Before you can start reading your data, use the instructions in our infrastructure agent docs to restart your infrastructure agent.

sudo systemctl restart newrelic-infra.service

In couple of minutes, your application will send metrics to one.newrelic.com.

Find your data

You can choose our pre-built dashboard template named Vertica to monitor your Vertica application metrics. Follow these steps to use our pre-built dashboard template:

  1. From one.newrelic.com, go to the + Add data page.
  2. Click on Dashboards.
  3. In the search bar, type vertica.
  4. The Vertica dashboard should appear. Click on it to install it.

Your Vertica dashboard is considered a custom dashboard and can be found in the Dashboards UI. For docs on using and editing dashboards, see our dashboard docs.

Here's a NRQL query to search database user information for data points like user name, resource pool, memory cap, temporary space cap, and run time cap.

SELECT user_name, is_super_user, resource_pool, memory_cap_kb, temp_space_cap_kb, run_time_cap
FROM VerticaUserInformation;

What's next?

To learn more about building NRQL queries and generating dashboards, check out these docs:

  • Introduction to the query builder to create basic and advanced queries.
  • Introduction to dashboards to customize your dashboard and carry out different actions.
  • Manage your dashboard to adjust your display mode, or to add more content to your dashboard.
Copyright © 2024 New Relic Inc.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.