ENABLE_PROFILING

Enables for the current session collection of profiling data of the specified type. For detailed information, see Enabling Profiling in the Administrator's Guide.

Note: Vertica stores session and query profiling 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)

See Also