Understanding sessions
The Sessions dashboard gives information about all the active client sessions within the CockroachDB cluster. In the following screenshot, you can see the Sessions dashboard showing an active session:
Figure 8.11 – Sessions dashboard showing an active session
The Sessions dashboard displays the following information:
- Session Duration: Amount of time for which the session is open
- Transaction Duration: Amount of time of the current active transaction, if any
- Statement Duration: Amount of time of the current, active SQL statement, if any
- Memory Usage: The current allocated memory for this session/maximum memory allocated during this session
- Statement: The SQL statement that's currently active
- Actions: Options to end an active query that is part of this session:
- Terminate Statement: Ends the SQL statement
- Terminate Session: Ends the session
In the next section, we will go over the Transactions...
