SHOW SESSION STATUS
Show SingleStoreDB server status information for a session.
Syntax
SHOW SESSION STATUS [LIKE 'pattern' | WHERE expr]
Remarks
pattern
- SQL LIKE clauseexpr
- SQL WHERE clauseThis 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)