Execution events
To help you monitor your database system, Vertica logs significant events that affect database performance and functionality. Click View Execution Events to see information about the events that took place while the query was executing.
If the View Execution Events button is not enabled, click Profile to retrieve the profile data, including the execution events.
The arrows on the header of each column allow you to sort the table in ascending or descending order of that column.
The execution events are described in the following table.
| Event Characteristic | Details |
| Time | Clock time when the event took place. |
| Node Name | Name of the node for which information is listed. |
| Session ID | Identifier of the session for which profile information is captured. |
| User ID | Identifier of the user who initiated the query. |
| Request ID | Unique identifier of the query request in the user session. |
| Event Type | Type of event processed by the execution engine. For a list of events and their descriptions, see Initial process for improving query performance. |
| Event Description | Generic description of the event. |
| Operator Name |
Name of the Execution Engine component that generated the event. Examples include but are not limited to:
Values from the Operator name and Path ID columns let you tie a query event back to a particular operator in the query plan. If the event did not come from a specific operator, then this column is NULL. |
| Path ID | Unique identifier that Vertica assigns to a query operation or a path in a query plan. If the event did not come from a specific operator, this column is NULL. |
| Event OID | A unique ID that identifies the specific event. |
| Event Details | A brief description of the event and details pertinent to the specific situation. |
| Suggested Action | Recommended actions (if any) to improve query processing. |