CLEAR_PROFILING

Clears from memory data for the specified profiling type.

Vertica stores profiled data in memory, so profiling can be memory intensive depending on how much data you collect.

Syntax

CLEAR_PROFILING( 'profiling-type' )

Parameters

profiling-type

The type of profiling data to clear:

  • session: Clears profiling for basic session parameters and lock time out data.
  • query: Clears profiling for general information about queries that ran, such as the query strings used and the duration of queries.
  • ee: Clears profiling for information about the execution run of each query.

Example

The following statement clears profiled data for queries:

=> SELECT CLEAR_PROFILING('query');

See Also