> ## Documentation Index > Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt > Use this file to discover all available pages before exploring further. # Sessions Page > [!NOTE] > > On a [secure cluster](https://docs.cockroachlabs.com/docs/stable/secure-a-cluster.md), you must be an [`admin` user](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization#admin-role) or a SQL user with the [`VIEWACTIVITY`](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization) or [`VIEWACTIVITYREDACTED`](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization) [system privilege](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges) (or the legacy `VIEWACTIVITY` [role option](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md)). Other users will see only their own sessions. Refer to [DB Console security](https://docs.cockroachlabs.com/docs/stable/ui-overview.md#db-console-security-considerations). The **Sessions** page provides information about open SQL sessions in your cluster, using data in the cluster's [`crdb_internal` system catalog](https://docs.cockroachlabs.com/docs/stable/monitoring-and-alerting#crdb_internal-system-catalog). To view it, click **SQL Activity**, then click **Sessions**. ## Sessions table Use the **Sessions** table to see active, idle, and closed sessions. A session is *active* if it has an open transaction (including implicit transactions, which are individual SQL statements), and *idle* if it has no open transaction. Active sessions consume hardware resources. A session is *closed* if it has closed the connection to CockroachDB. By default, the table is filtered to display active and idle sessions and to exclude closed sessions. ![Sessions Page](https://mintcdn.com/cockroachlabs/OOen9WAZoOzmgNIZ/images/v26.3/ui-sessions-page.png?fit=max\&auto=format\&n=OOen9WAZoOzmgNIZ\&q=85\&s=e7a850f1a77f3196a7f446ae7ee4e49d) To filter the sessions, click the **Filters** field. ![Session filter](https://mintcdn.com/cockroachlabs/6M4oBmgCef68NEHr/images/common/ui-session-filter.png?fit=max\&auto=format\&n=6M4oBmgCef68NEHr\&q=85\&s=4ec24f8d9c6b60e856b2bfb3b2bf6db6) * To filter by [application](https://docs.cockroachlabs.com/docs/stable/connection-parameters.md#additional-connection-parameters), select **Application Name** and choose one or more applications. * Queries from the SQL shell are displayed under the `$ cockroach` app. * If you have not set `application_name` in a client connection string, it appears as `unset`. * To filter by username or session status, select **User Name** or **Session Status** and check one or more checkboxes. * To filter by session duration, specify the session time and unit. Click **Columns** to select the columns to display in the table. The following properties are displayed for each session: | Column | Description | | - | - | | Session Start Time (UTC) | The timestamp at which the session started. | | Session Duration | The amount of time the session has been open. | | Session Active Duration | The amount of time transactions were executing while the session was open. | | Status | The status of the session: `Active`, `Idle`, or `Closed`. A session is `Active` if it has an open explicit or implicit transaction (individual SQL statement) with a statement that is actively running or waiting to acquire a lock. A session is `Idle` if it has no open transaction. A session is `Closed` if it has closed the connection to CockroachDB. | | Most Recent Statement | If more than one statement is executing, the most recent statement. If the session is Idle, the last statement. | | Statement Start Time (UTC) | The timestamp at which the statement started. | | Transaction Count | The number of transactions completed in the session. | | Memory Usage | Amount of memory currently allocated to the session followed by the maximum amount of memory the session has ever been allocated. | | Client IP Address | The IP address and port of the client that opened the session. | | User Name | The user that opened the session. | | Application Name | The application that ran the session. | | Default Isolation Level | The default [isolation level](https://docs.cockroachlabs.com/docs/stable/transactions.md#isolation-levels) for transactions in the session. | | Actions | Options to cancel the active statement and cancel the session. These require the `CANCELQUERY` [system privilege](https://docs.cockroachlabs.com/docs/stable/security-reference/authorization.md#supported-privileges) (or the legacy `CANCELQUERY` [role option](https://docs.cockroachlabs.com/docs/stable/alter-role.md#role-options). | * \*\*Cancel Statement:\*\* Ends the SQL statement. The session running this statement will receive an error. * \*\*Cancel Session:\*\* Ends the session. The client that holds this session will receive a "connection terminated" event. To view details of a session, click a **Session Start Time (UTC)** to display session details. ## Session Details If a session is idle, the **Transaction** and **Most Recent Statement** panels will display **No Active \[Transaction | Statement]**. ![Sessions Details Page](https://mintcdn.com/cockroachlabs/6M4oBmgCef68NEHr/images/common/ui-sessions-details-page.png?fit=max\&auto=format\&n=6M4oBmgCef68NEHr\&q=85\&s=457e6606ddd39d2fd5c72c873df72f02) The **Cancel statement** button ends the SQL statement. The session running this statement will receive an error. The **Cancel session** button ends the session. The client that holds this session will receive a "connection terminated" event. * **Session Details** * **Session Start Time** shows the timestamp at which the session started. \- **Gateway Node** shows the node ID and IP address/port of the [gateway](https://docs.cockroachlabs.com/docs/stable/architecture/life-of-a-distributed-transaction.md#gateway) node handling the client connection. * **Application Name** shows the name of the application connected to the session. * **Client IP Address** shows the IP address/port of the client that opened the session. * **Memory Usage** shows the amount of memory currently allocated to this session, followed by the maximum amount of memory this session has ever allocated. * **User Name** displays the name of the user that started the session. * **Transaction** displays the following information for an open transaction. * **Transaction Start Time** shows the timestamp at which the transaction started. * **Number of Statements Executed** shows the total number of SQL statements executed by the transaction. * **Number of Retries** shows the total number of [retries](https://docs.cockroachlabs.com/docs/stable/transactions.md#transaction-retries) for the transaction. * **Number of Automatic Retries** shows the total number of [automatic retries](https://docs.cockroachlabs.com/docs/stable/transactions.md#automatic-retries) run by CockroachDB for the transaction. * **Read Only?** shows whether the transaction is read-only. * **AS OF SYSTEM TIME?** shows whether the transaction uses [/docs/stable/performance-best-practices-overview#use-as-of-system-time-to-decrease-conflicts-with-long-running-queries](https://docs.cockroachlabs.com/docs/stable/performance-best-practices-overview.md#use-as-of-system-time-to-decrease-conflicts-with-long-running-queries) to return historical data. * **Priority** shows the [priority](https://docs.cockroachlabs.com/docs/stable/transactions.md#transaction-priorities) for the transaction. * **Memory Usage** shows the amount of memory currently allocated to this transaction, followed by the maximum amount of memory this transaction has ever allocated. * **Most Recent Statement** displays the following information for an active statement. * The SQL statement. * **Execution Start Time** is the timestamp at which the statement was run. * **Distributed Execution?** shows whether the statement uses [Distributed SQL (DistSQL)](https://docs.cockroachlabs.com/docs/stable/architecture/sql-layer.md#distsql) optimization. * **Most Recent Transaction Fingerprints Executed** A list of the most recent transaction fingerprint IDs, represented in hexadecimal, executed by this session. The fingerprint ID is a link to the [Transaction Details page](https://docs.cockroachlabs.com/docs/stable/ui-transactions-page.md#transaction-details-page) for the transaction. When you click the link, in order to fetch and render the transaction details, the global date range is changed to the session's start and end time. ### Closed session cache Details about closed sessions are stored in memory in a closed session cache. This cache is controlled by the following two [cluster settings](https://docs.cockroachlabs.com/docs/stable/cluster-settings.md#setting-sql-closed-session-cache-capacity): * [`sql.closed_session_cache.capacity`](https://docs.cockroachlabs.com/docs/stable/cluster-settings#setting-sql-closed-session-cache-capacity) is the maximum number of sessions in the cache and defaults to `1000`. Once this limit is reached, older sessions are deleted from the cache so newer sessions can be included. * [/docs/stable/cluster-settings#setting-sql-closed-session-cache-time-to-live](https://docs.cockroachlabs.com/docs/stable/cluster-settings.md#setting-sql-closed-session-cache-time-to-live) is the maximum time to live, in seconds, and defaults to `3600`. 60 minutes after a session is closed, it is deleted from the cache. If the **Session Details** page displays the message `Unable to find session` for a closed session, the details may no longer be available because they were removed from this cache according to the previously mentioned cluster settings. ## See also * [`SHOW SESSIONS`](https://docs.cockroachlabs.com/docs/stable/show-sessions) * [Statements page](https://docs.cockroachlabs.com/docs/stable/statements-page) * [SQL Statements](https://docs.cockroachlabs.com/docs/stable/sql-statements.md) * [Transactions](https://docs.cockroachlabs.com/docs/stable/transactions.md) * [Transaction Error Retry Reference](https://docs.cockroachlabs.com/docs/stable/transaction-retry-error-reference.md) * [Production Checklist](https://docs.cockroachlabs.com/docs/stable/recommended-production-settings.md#hardware)