DATA_COLLECTOR
Shows the 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 approximate collection rate, to aid in sizing calculations.
Column Name | Data Type | Description |
---|---|---|
NODE_NAME |
VARCHAR |
The node name on which information is retained. |
COMPONENT |
VARCHAR |
The name of the component and its policy. |
TABLE_NAME |
VARCHAR |
The data collector (dc) table name for which information is listed. |
DESCRIPTION |
VARCHAR |
A short description about the component. |
IN_DB_LOG |
BOOLEAN |
Denotes if monitoring information is retained in the |
IN_VERTICA_LOG |
BOOLEAN |
Denotes if monitoring information is retained in the |
MEMORY_BUFFER_SIZE_KB |
INTEGER |
The size of the memory buffer in kilobytes. |
DISK_SIZE_KB |
INTEGER |
The on-disk size of the table in kilobytes. |
SET_INTERVAL |
BOOLEAN | A t (true) setting indicates time-based retention is set. |
INTERVAL_TIME_S |
INTERVAL | The time of retention expressed as an INTERVAL type. To turn time-based retention off, set the value to 0. |
RECORD_TOO_BIG_ERRORS |
INTEGER |
A number that increments by one each time an error is thrown because data did not fit in memory (based on the data collector retention policy). |
LOST_BUFFERS |
INTEGER |
The number of buffers lost. |
LOST_RECORDS |
INTEGER |
The number of records lost. |
RETIRED_FILES |
INTEGER |
The number of retired files. |
RETIRED_RECORDS |
INTEGER |
The number of retired records. |
CURRENT_MEMORY_RECORDS |
INTEGER |
The current number of rows in memory. |
CURRENT_DISK_RECORDS |
INTEGER |
The current number of rows stored on disk. |
CURRENT_MEMORY_BYTES |
INTEGER |
Total current memory used in kilobytes. |
CURRENT_DISK_BYTES |
INTEGER |
Total current disk space used in kilobytes. |
FIRST_TIME |
TIMESTAMP |
Timestamp of the first record. |
LAST_TIME |
TIMESTAMP |
Timestamp of the last record |
KB_PER_DAY |
FLOAT |
Total kilobytes used per day. |
Notes
- Data Collector is on by default. To turn it off, see Enabling and Disabling Data Collector
- You can configure monitoring information retention policies. See Data Collector Functions and Configuring Data Retention Policies for more information.
Examples
The following example shows how to return all component names and their descriptions. This is a useful query if you want to change the retention policy for a particular component and don't remember its name:
=> SELECT DISTINCT component, description FROM data_collector ORDER BY 1 ASC; component | description ----------------------------------+------------------------------------------------------------------- AllocationPoolStatistics | Information about global memory pools ... AllocationPoolStatisticsByDay | Information about global memory pools, ... (historical, by day) AllocationPoolStatisticsByHour | Information about global memory pools, ... (historical, by hour) AllocationPoolStatisticsByMinute | Information about global memory pools, ... (historical, by minute) AllocationPoolStatisticsBySecond | Information about global memory pools, ... (historical, by second) AnalyzeStatistics | History of statistics collection Backups | Monitoring successful backups CatalogInfo | Catalog statistics and history CatalogInfoByDay | Catalog statistics and history (historical, by day) CatalogInfoByHour | Catalog statistics and history (historical, by hour) CatalogInfoByMinute | Catalog statistics and history (historical, by minute) CatalogInfoBySecond | Catalog statistics and history (historical, by second) ClientServerMessages | Client-Server Messages (Front End to Back End Protocol) sent ConfigurationChanges | Changes to configuration parameters (vertica.conf) CpuAggregate | Aggregate CPU information CpuAggregateByDay | Aggregate CPU information (historical, by day) CpuAggregateByHour | Aggregate CPU information (historical, by hour) CpuAggregateByMinute | Aggregate CPU information (historical, by minute) CpuAggregateBySecond | Aggregate CPU information (historical, by second) CpuInfo | CPU information CpuInfoByDay | CPU information (historical, by day) CpuInfoByHour | CPU information (historical, by hour) CpuInfoByMinute | CPU information (historical, by minute) CpuInfoBySecond | CPU information (historical, by second) DeploymentsCompleted | History of designs deployed DesignsCompleted | History of designs executed DiskResourceRejections | Disk Resource Rejection Records Errors | History of all errors+warnings encountered ExecutionEngineEvents | History of important events during local planning and execution ExecutionEngineProfiles | History of EE profiles . . . (93 rows)
Related Topics
- Data Collector Functions
- Retaining Monitoring Information and How Vertica Calculates Database Size in the Administrator's Guide
- SET_DATA_COLLECTOR_TIME_POLICY
- SET_DATA_COLLECTOR_POLICY