Profiling parameters
The following table describes the profiling parameters for configuring Vertica. See Profiling database performance for more information on profiling queries.
Query the CONFIGURATION_PARAMETERS system table to determine what levels (node, session, user, database) are valid for a given parameter.
| Parameters | Description |
|---|---|
| GlobalEEProfiling |
Enables profiling for query execution runs in all sessions on all nodes. Default: 0 |
| GlobalQueryProfiling |
Enables query profiling for all sessions on all nodes. Default: 0 |
| GlobalSessionProfiling |
Enables session profiling for all sessions on all nodes. Default: 0 |
| SaveDCEEProfileThresholdUS |
Sets in microseconds the query duration threshold for saving profiling information to system tables QUERY_CONSUMPTION and EXECUTION_ENGINE_PROFILES. You can set this parameter to a maximum value of 2147483647 (231-1, or ~35.79 minutes). Default: 60000000 (60 seconds) |