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 dbLog file.

IN_VERTICA_LOG

BOOLEAN

Denotes if monitoring information is retained in the vertica.log file.

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

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