Clearing Profile Data

Vertica stores profiled data is in memory, so depending on how much data you collect, profiling could be a memory-intensive operation.

To clear profiled data from memory, use the SQL CLEAR_PROFILING() function and pass it an argument, as in the following command:

=> SELECT CLEAR_PROFILING( 'profiling-type' )

where profiling type can be one of the following:

Example

The following command clears profiling on query execution runs:

=> SELECT CLEAR_PROFILING('ee');
       CLEAR_PROFILING
-----------------------------
 GLOBAL EE Profiling Cleared
(1 row)