Vertica Analytics Platform Version 9.2.x Documentation

Data Collector

A utility that collects and retains database monitoring information.

Data Collector works in conjunction Workload Analyzer, which intelligently monitors the performance of SQL queries and workloads and recommends tuning actions based on observations of the actual workload history.

Data Collector retains history of important system activities and records essential performance and resource utilization counters. You can use information retained by the Data Collector in the following ways:

  • As a reference for what actions users have taken
  • To locate performance bottlenecks
  • To identify potential improvements to Vertica configuration

Data Collector is on by default. If you need to change this behavior, see Data Collector Parameters in the Administrator's Guide. See also the SQL Reference Manual for information about data collection control functions.