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:
session
—Clears profiling basic session parameters and lock time out dataquery
—Clears profiling for general information about queries that ran, such as the query strings used and the duration of queriesee
—Clears profiling for query execution runs
Example
The following command clears profiling on query execution runs:
=> SELECT CLEAR_PROFILING('ee'); CLEAR_PROFILING ----------------------------- GLOBAL EE Profiling Cleared (1 row)