DRAINING_STATUS

Returns the draining status of each node in a database.

Returns the draining status of each node in a database. The table also provides aggregate user session counts and information about the oldest user session connected to each node. For more information about the user sessions connected to a database, see SESSIONS.

Note

If you aren't a superuser, the OLDEST_SESSION columns contain only information about sessions for which you have privileges. Unprivileged users do not see session details, but they do see the node draining status and the user session aggregate count.

Column Name	Data Type	Description
`NODE_NAME`	VARCHAR	Name of the node for which information is listed.
`SUBCLUSTER_NAME`	VARCHAR	Name of the subcluster that contains the node.
`IS_DRAINING`	BOOLEAN	True if the node is draining; otherwise, false.
`COUNT_CLIENT_USER_SESSIONS`	INTEGER	Number of user client sessions connected to the node.
`OLDEST_SESSION_USER`	VARCHAR	Name of the user with the oldest live session connected to the node. NULL if no users are connected.
`OLDEST_SESSION_ID`	VARCHAR	Identifier associated with `OLDEST_SESSION_USER`. This is required to close or interrupt a session. NULL if no users are connected.
`OLDEST_SESSION_LOGIN_TIMESTAMP`	TIMESTAMP	Date and time the `OLDEST_SESSION_USER` logged into the database. NULL if no users are connected.