STATEMENT_OUTCOMES
...
Records consolidated information about session-level statements, which can consist of more than one operation and might include retries. For example, inserting into a table with a column constraint includes an INSERT query and a constraint check. STATEMENT_OUTCOMES has one row for the statement, and the related QUERY_REQUESTS table has two rows.
This table tracks only statements that are executed within transactions. Many meta-functions do not automatically open transactions.
| Column Name | Data Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR | Name of the node that reported the requested information. |
| USER_NAME | VARCHAR | Name of the user who issued the query at the time Vertica recorded the session. |
| SESSION_ID | VARCHAR | Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused after the session ends. |
| TRANSACTION_ID | INTEGER | Identifier for the transaction within the session. Statements that are not executed within transactions are not recorded in this table. |
| STATEMENT_ID | INTEGER | Unique identifier for the statement. The combination of TRANSACTION_ID and STATEMENT_ID uniquely identifies a user query within a session. |
| REQUEST_TYPE | VARCHAR |
Type of the query request. Examples include, but are not limited to:
|
| REQUEST | VARCHAR | Query statement. |
| REQUEST_LABEL | VARCHAR | Label of the query, if any. |
| SEARCH_PATH | VARCHAR | Contents of the search path. |
| SUCCESS | BOOLEAN | Whether the statement succeeded. |
| ERROR | VARCHAR | If the statement did not succeed, the error message. |
| START_TIMESTAMP | TIMESTAMPTZ | Beginning of history interval. |
| END_TIMESTAMP | TIMESTAMPTZ | End of history interval. |
| REQUEST_DURATION | TIMESTAMPTZ | Statement execution time in days, hours, minutes, seconds, and milliseconds. This time includes all operations that make up the statement, including any retries. |
| REQUEST_DURATION_MS | INTEGER | Statement execution time in milliseconds. This time includes all operations that make up the statement, including any retries. |
| IS_EXECUTING | BOOLEAN | Whether the statement is currently running. |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.