SHOW SESSION STATUS
On this page
Show SingleStoreDB 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 SingleStoreDB node (see Node Requirements for SingleStoreDB 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