CLEAR_PROFILING

Clears from memory data for the specified profiling type.

Note: 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');