Profiling Parameters

The following table describes the profiling parameters for configuring Vertica. See Profiling Database Performance for more information on profiling queries.

Parameters Description

GlobalEEProfiling

Enables profiling for query execution runs in all sessions on all nodes.

Default Value: 0

Example: 

ALTER DATABASE mydb SET GlobalEEProfiling = 1;

GlobalQueryProfiling

Enables query profiling for all sessions on all nodes.

Default Value: 0

Example: 

ALTER DATABASE mydb SET GlobalQueryProfiling = 1;

GlobalSessionProfiling

Enables session profiling for all sessions on all nodes.

Default Value: 0

Example: 

ALTER DATABASE mydb SET GlobalSessionProfiling = 1;