ENABLE_PROFILING

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

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: Enable profiling for basic session parameters and lock time out data.
  • query: Enable profiling for general information about queries that ran, such as the query strings used and the duration of queries.
  • ee: Enable 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