Monitoring Data Collection Components

Query the V_MONITOR.DATA_COLLECTOR system table to get a list of Data Collector components, their current retention policies, and statistics about how much data is retained and how much has been discarded for various reasons. DATA_COLLECTOR also calculates the approximate collection rate, to aid in sizing calculations.

The following is a simple query that returns all the columns in this system table. See V_MONITOR.DATA_COLLECTOR in the SQL Reference Manual for additional details.

=> \xExpanded display is on.
=> SELECT * FROM data_collector;
-[ RECORD 1 ]----------+-------------------------------------------
node_name              | v_vmartdb_node0001
component              | AllocationPoolStatistics
table_name             | dc_allocation_pool_statistics
description            | Information about global memory pools, ...
in_db_log              | f
in_vertica_log         | f
memory_buffer_size_kb  | 64
disk_size_kb           | 256
record_too_big_errors  | 0
lost_buffers           | 0
lost_records           | 0
retired_files          | 120
retired_records        | 53196
current_memory_records | 0
current_disk_records   | 1454
current_memory_bytes   | 0
current_disk_bytes     | 214468
first_time             | 2011-05-26 12:25:52.001109-04
last_time              | 2011-05-26 12:31:55.002762-04
kb_per_day             | 49640.4151810525
-[ RECORD 2 ]----------+-------------------------------------------
...

Related Topics

V_MONITOR.DATA_COLLECTOR and Data Collector Functions in the SQL Reference Manual

Retaining Monitoring Information and How Vertica Calculates Database Size in this guide