CLEAR_DATA_COLLECTOR

Clears all memory and disk records on the Data Collector tables and functions and resets collection statistics in the system table DATA_COLLECTOR. A superuser can clear Data Collector data for all components or specify an individual component

After you clear the Data Collector log, the information is no longer available for querying.

Syntax

CLEAR_DATA_COLLECTOR( [ 'component' ] )

Parameters

component

Clears memory and disk records for the specified component only. If you provide no argument, the function clears all Data Collector memory and disk records for all components.

For the current list of component names, query the system table DATA_COLLECTOR.

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 on all nodes:

=> SELECT clear_data_collector();
 clear_data_collector
----------------------
 CLEAR
(1 row)

See Also