FLUSH_DATA_COLLECTOR
Waits until memory logs are moved to disk and then flushes the Data Collector, synchronizing the log with disk storage.
Syntax
FLUSH_DATA_COLLECTOR( [ 'component' ] )
Parameters
component |
Flushes data for the specified component. If you omit this argument, the function flushes data 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 flushes the Data Collector for the ResourceAcquisitions component:
=> SELECT flush_data_collector('ResourceAcquisitions'); flush_data_collector ---------------------- FLUSH (1 row)
The following command flushes data collection for all components:
=> SELECT flush_data_collector(); flush_data_collector ---------------------- FLUSH (1 row)