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_PLAN_PROFILES

QUERY_PROFILES

Query-specific information, such as query string and duration of execution, divided between two system tables:

  • QUERY_PLAN_PROFILES: Real-time status for each query plan path.
  • QUERY_PROFILES: Query information.

Execution engine

EXECUTION_ENGINE_PROFILES

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.