Managing Query Profile Data
Vertica retains data for queries until the storage quota for the table is exceeded, when it automatically purges the oldest queries to make room for new ones. You can clear profiled data by manually calling one of the following functions:
-
CLEAR_PROFILING() clears profiled data from memory. For example, the following command clears profiling for general query-run information, such as the query strings used and the duration of queries.
=> SELECT CLEAR_PROFILING('query');
- CLEAR_DATA_COLLECTOR() clears all memory and disk records on the Data Collector tables and functions and resets collection statistics in the V_MONITOR.DATA_COLLECTOR system table.
- FLUSH_DATA_COLLECTOR() waits until memory logs are moved to disk and then flushes the Data Collector, synchronizing the DataCollector log with the disk storage.
Configuring data retention policies
Vertica retains the historical data it gathers based on retention policies, which a superuser can configure. See Retaining Monitoring Information.