SHOW SESSION STATUS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Show SingleStore server status information for a session.
Syntax
SHOW SESSION STATUS
[LIKE 'pattern' | WHERE expr]
Remarks
-
pattern
- SQL LIKE clause -
expr
- SQL WHERE clause -
This command can be run on any SingleStore node (see Node Requirements for SingleStore Commands).
-
See the Permission Matrix for the required permission.
Output
See System Status.
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)
Last modified: January 11, 2023