Optimizer events
To help you monitor your database system, Vertica logs significant events that affect database performance and functionality.Click View Optimizer Events to see a table of the events that took place while the optimizer was planning the query.
To help you monitor your database system, Vertica logs significant events that affect database performance and functionality.Click View Optimizer Events to see a table of the events that took place while the optimizer was planning the query.
If the View Optimizer Events button is not enabled, click Profile to retrieve the profile data, including the optimizer events.
The arrows on the header of each column allow you to sort the table in ascending or descending order of that column.
The following types of optimizer events may appear in the 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 optimizer. |
| Event Description | Generic description of the event. |
| 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. |