CLEAR_PROFILING
Clears from memory data for the specified profiling type.
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.This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
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.
-
Examples
The following statement clears profiled data for queries:
=> SELECT CLEAR_PROFILING('query');