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