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' [, 'scope'] )

Parameters

profiling-type

The type of profiling data to clear:

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

Specifies at what scope to clear profiling on the specified data, one of the following:

  • local: Clear profiling data for the current session.
  • global: Clear profiling data across all database sessions.

Example

The following statement clears profiled data for queries:

=> SELECT CLEAR_PROFILING('query');

See Also