# SHOW SESSION STATUS

Show SingleStore Helios server status information for a session.

## Syntax

```

SHOW SESSION STATUS
[LIKE 'pattern' | WHERE expr]

```

## Remarks

* `pattern` - SQL LIKE clause
* `expr` - SQL WHERE clause
* See the [Permission Matrix](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

**Output**

See [System Status](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/system-status.md).

## Example

```

SHOW SESSION STATUS;
+-------------------------------------+-----------------+
| Variable_name                       | Value           |
+-------------------------------------+-----------------+
| Aborted_clients                     | 0               |
| Aborted_connects                    | 0               |
| Bytes_received                      | 125             |
| Bytes_sent                          | 234             |
| Connections                         | 10              |
| Max_used_connections                | 2               |
| Queries                             | 71              |
| Questions                           | 2               |
| Threads_connected                   | 2               |
| Threads_created                     | 9               |
| Threads_running                     | 1               |
| Uptime                              | 10958           |
| Seconds_until_expiration            | 2539529         |
| Query_compilations                  | 0               |
| Query_compilation_failures          | 0               |
| GCed_versions_last_sweep            | 0               |
| Average_garbage_collection_duration | 0 ms            |
| Total_server_memory                 | 81.6 (+81.6) MB |
| Alloc_variable_cached_buffers       | 0.0 MB          |
+-------------------------------------+-----------------+
19 rows in set (0.00 sec)

```

***

Modified at: January 11, 2023

Source: [/cloud/reference/sql-reference/show-commands/show-session-status/](https://docs.singlestore.com/cloud/reference/sql-reference/show-commands/show-session-status/)

(An index of the documentation is available at /llms.txt)