Profiling Categories
Vertica divides profiling data into three categories and captures this information in several system tables. You can query those tables for specific performance information, as shown in the following table:
Profiling Category | System Tables | Description of Profiled Data |
---|---|---|
Session | SESSION_PROFILES
|
General information about query execution on each node during the current session. For example, you can find out how many statements ran successfully and unsuccessfully, how many locks were granted and deadlocks encountered, and so on. |
Queries |
Query-specific information, such as query string and duration of execution, divided between two system tables:
|
|
Execution engine | Information on execution engine performance. |
Note: If execution engine profiling is disabled, Vertica saves no data in EXECUTION_ENGINE_PROFILES
. However, if query and session profiling is disabled, Vertica saves some data in QUERY_PROFILES
, QUERY_PLAN_PROFILES
, and SESSION_PROFILES
.
For each category, you can enable profiling globally, for the entire database, or only for the current session. For more information, see Enabling and Disabling Profiling.