CLEAR_DATA_COLLECTOR
Clears all memory and disk records from Data Collector tables and logs, and resets collection statistics in system table DATA_COLLECTOR.
Syntax
CLEAR_DATA_COLLECTOR( [ 'component' ] )
Parameters
component |
Clears memory and disk records for the specified component. If you provide no argument, the function clears memory and disk records for all components. Query system table DATA_COLLECTOR for component names. For example: => SELECT DISTINCT component, description FROM data_collector WHERE component ilike '%Depot%' ORDER BY component; component | description ----------------+------------------------------- DepotEvictions | Files evicted from the Depot DepotFetches | Files fetched to the Depot DepotUploads | Files Uploaded from the Depot (3 rows) |
Privileges
Superuser
Examples
The following command clears memory and disk records for the ResourceAcquisitions component:
=> SELECT clear_data_collector('ResourceAcquisitions'); clear_data_collector ---------------------- CLEAR (1 row)
The following command clears data collection for all components:
=> SELECT clear_data_collector(); clear_data_collector ---------------------- CLEAR (1 row)