SHOW_SERVER_STATUS

SHOW_SERVER_STATUS returns a list of active sessions across the cluster.

To list active statements on the current worker only, see SHOW_CONNECTIONS.

Syntax

The following is the correct syntax when showing your server status:

show_server_status_statement ::=
    SELECT SHOW_SERVER_STATUS()
    ;

Parameters

The Parameters section is not relevant for the SHOW_SERVER_STATUS statement.

Returns

The SHOW_SERVER_STATUS function returns a list of active sessions. If no sessions are active across the cluster, the result set will be empty.

The following table shows the SHOW_SERVER_STATUS result columns;

Result Columns

service

Statement Service Name

instance

Shows the worker ID.

connection_id

Shows the connection ID.

serverip

Shows the worker end-point IP.

serverport

Shows the worker end-point port.

database_name

Shows the statement’s database name.

user_name

Shows the username running the statement.

clientip

Shows the client IP.

statementid

Shows the statement ID.

statement

Shows the statement text.

statementstarttime

Shows the statement start timestamp.

statementstatus

Shows the statement status (see table below).

statementstatusstart

Shows the most recently updated timestamp.

The following table shows the statement status values:

Statement Status Values

Status

Description

Preparing

The statement is being prepared.

In queue

The statement is waiting for execution.

Initializing

The statement has entered execution checks.

Executing

The statement is executing.

Stopping

The statement is in the process of stopping.

Notes

This utility shows the active sessions. Some sessions may be actively connected, but not running any statements.

Example

Using SHOW_SERVER_STATUS to Get Statement IDs

The following example shows how to use the SHOW_SERVER_STATUS statement to get statement IDs:

t=> SELECT SHOW_SERVER_STATUS();
service | instanceid | connection_id | serverip      | serverport | database_name | user_name        | clientip      | statementid | statement                                                                                             | statementstarttime  | statementstatus | statementstatusstart
--------+------------+---------------+---------------+------------+---------------+------------------+---------------+-------------+-------------------------------------------------------------------------------------------------------+---------------------+-----------------+---------------------
sqream  | sqream_2   |  19           | 192.168.0.111 |       5000 | master        | etl              | 192.168.0.011 |2484923      | SELECT t1.account, t1.msisd from table a t1 join table b t2 on t1.id = t2.id where t1.msid='123123';  | 17-01-2022 16:19:31 | Executing       | 17-01-2022 16:19:32
sqream  | sqream_1   |  2            | 192.168.1.112 |       5000 | master        | etl              | 192.168.1.112 |2484924      | select show_server_status();                                                                          | 17-01-2022 16:19:39 | Executing       | 17-01-2022 16:19:39
sqream  | None       |  248          | 192.168.1.112 |       5007 | master        | maintenance_user | 192.168.1.112 |2484665      | select * from  sqream_catalog.tables;                                                                 | 17-01-2022 15:55:01 | In Queue        | 17-01-2022 15:55:02

The statement ID is 128, running on worker 192.168.1.91.

Permissions

The role must have the SUPERUSER permissions.