How long does data stay in the data collector tables? It seems like it is less than two days
![Sad :(](./images/smilies/icon_e_sad.gif)
Moderator: NorbertKrupa
Code: Select all
=> SELECT DATA_COLLECTOR_HELP();
Usage Data Collector
The data collector retains history of important system activities.
This data can be used as a reference of what actions have been taken
by users, but it can also be used to locate performance bottlenecks,
or identify potential improvements to the Vertica configuration.
This data is queryable via Vertica system tables.
The list of data collector components, and some statistics, can be found using:
SELECT * FROM v_monitor.data_collector;
The amount of data retained can be controlled with:
set_data_collector_policy(<component>,
<memory retention (KB)>,
<disk retention (KB)>);
The current retention policy for a component can be queried with:
get_data_collector_policy(<component>);
Data on disk is kept in the "DataCollector" directory under the Vertica
catalog path. This directory also contains instructions on how to load
the monitoring data into another Vertica database.
Additional commands can be used to affect the data collection logs.
The log can be cleared with:
clear_data_collector([<optional component>]);
The log can be synchronized with the disk storage using:
flush_data_collector([<optional component>]);