DISABLE_PROFILING

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

Syntax

DISABLE_PROFILING( 'profiling-type' )

Parameters

profiling-type

The type of profiling data to disable:

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

Example

The following statement disables profiling on query execution runs:

=> SELECT DISABLE_PROFILING('ee');
   DISABLE_PROFILING
-----------------------
 EE Profiling Disabled
(1 row)

See Also