ENABLE_PROFILING

Enables profiling 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

ENABLE_PROFILING( 'profiling-type' )

Parameters

profiling-type

The type of profiling data to enable:

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

Example

The following statement enables profiling on query execution runs:

=> SELECT ENABLE_PROFILING('ee');
   ENABLE_PROFILING
----------------------
 EE Profiling Enabled
(1 row)