SESSION_MARS_STORE

Shows Multiple Active Result Sets (MARS) storage information.

Shows Multiple Active Result Sets (MARS) storage information.

Column Name Data Type Description
NODE_NAME VARCHAR Name of the node that is reporting the requested information.
SESSION_ID VARCHAR Identifier of the Vertica session. This identifier is unique within the cluster for the current session but can be reused in a subsequent session.
USER_NAME VARCHAR The username used to create the connection.
RESULTSET_ID INTEGER Identifier assigned to the result set.
ROW_COUNT INTEGER Number of rows requested by the query.
REMAINING_ROW_COUNT INTEGER Number of rows that still need to be returned.
BYTES_USED INTEGER The number of bytes requested.