As discussed earlier, when the DATA_COLLECTOR
system table is queried, we are presented with a list of Data Collector components, their current retention policies, and statistics about how much data is retained and how much has been discarded. 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:
km=> \x Expanded display is on. km=> SELECT * FROM data_collector; -[ RECORD 1 ]----------+------------------------------------------------------------------------------------------------------------------- node_name | v_km_node0001 component | AllocationPoolStatistics table_name | dc_allocation_pool_statistics description | Information about global memory pools, which generally cannot be recovered without restart access_restricted | t in_db_log | f in_vertica_log ...