SESSION_MARS_STORE

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
INT Identifier assigned to the result set.
ROW_COUNT
INT Number of rows requested by the query.
REMAINING_ROW_COUNT
INT Number of rows that still need to be returned.
BYTES_USED
INT The number of bytes requested.