SHOW PROCESSLIST|V4.3.3| docs|Distributed Database

SHOW PROCESSLIST

Last Updated：2025-03-21 09:20:00 Updated

Purpose

You can use this statement to query the process list of the current tenant.

Note

Only the super administrator (root@proxysys) of OceanBase Database Proxy (ODP) can execute this statement to query the session information of all tenants in a cluster, and execute the KILL statement to terminate a session of any tenant in the cluster.
A user in the sys tenant of an OceanBase cluster can execute this statement to query the session information of all tenants in the current cluster, and execute the KILL statement to terminate any session in the current tenant.
Other normal users can perform operations only on sessions of the current user based on their privileges. By default, a normal user can only execute this statement to query the session information of the current user but cannot query the cluster information.

Syntax

SHOW [FULL] PROCESSLIST;

Parameters

Parameter Description

PROCESSLIST

Parameter	Description
PROCESSLIST	The brief process list. Options: `ID`: the ID of the process, namely, the client session ID of the current session. This ID is the unique identifier of the session in the client. `USER`: the user to which the session belongs. `HOST`: the IP address and port number of the client that initiates this session. If ODP is used to connect to the database, the IP address and port number of ODP are displayed here. `DB`: the name of the database accessed. `COMMAND`: the type of the command being executed, such as `Query` and `Sleep`. `TIME`: the execution time of the current command, in seconds. If the command is retried, the time is reset and recalculated. `STATE`: the status of the current session, such as `SLEEP` and `ACTIVE`. `INFO`: the command being executed. A maximum of 100 characters can be displayed and the exceeding part is discarded.
FULL PROCESSLIST	The complete process list, including the details of each process. Options: `ID`: the ID of the process, namely, the client session ID of the current session. This ID is the unique identifier of the session in the client. `USER`: the user to which the session belongs. `TENANT`: the name of the tenant that is accessed in the session. `HOST`: the IP address and port number of the client that initiates this session. If ODP is used to connect to the database, the IP address and port number of ODP are displayed here. `DB`: the name of the database accessed. `COMMAND`: the type of the command being executed, such as `Query` and `Sleep`. `TIME`: the execution time of the current command, in seconds. If the command is retried, the time is reset and recalculated. `STATE`: the status of the current session, such as `SLEEP` and `ACTIVE`. `INFO`: the command being executed. `IP`: the IP address of the server to which the session belongs, which is the IP address of the OBServer node. `PORT`: the SQL port number of the server to which the session belongs, which is the SQL port number of the OBServer node.

The brief process list. Options:

ID: the ID of the process, namely, the client session ID of the current session. This ID is the unique identifier of the session in the client.
USER: the user to which the session belongs.
HOST: the IP address and port number of the client that initiates this session. If ODP is used to connect to the database, the IP address and port number of ODP are displayed here.
DB: the name of the database accessed.
COMMAND: the type of the command being executed, such as Query and Sleep.
TIME: the execution time of the current command, in seconds. If the command is retried, the time is reset and recalculated.
STATE: the status of the current session, such as SLEEP and ACTIVE.
INFO: the command being executed. A maximum of 100 characters can be displayed and the exceeding part is discarded.

FULL PROCESSLIST

The complete process list, including the details of each process. Options:

ID: the ID of the process, namely, the client session ID of the current session. This ID is the unique identifier of the session in the client.
USER: the user to which the session belongs.
TENANT: the name of the tenant that is accessed in the session.
HOST: the IP address and port number of the client that initiates this session. If ODP is used to connect to the database, the IP address and port number of ODP are displayed here.
DB: the name of the database accessed.
COMMAND: the type of the command being executed, such as Query and Sleep.
TIME: the execution time of the current command, in seconds. If the command is retried, the time is reset and recalculated.
STATE: the status of the current session, such as SLEEP and ACTIVE.
INFO: the command being executed.
IP: the IP address of the server to which the session belongs, which is the IP address of the OBServer node.
PORT: the SQL port number of the server to which the session belongs, which is the SQL port number of the OBServer node.

Examples

Note

For more information about this statement, see Server session.

Use the SHOW PROCESSLIST statement

obclient [SYS]> SHOW PROCESSLIST;

The output is as follows:

+------------+------+----------------------+------+---------+------+--------+------------------+
| ID         | USER | HOST                 | DB   | COMMAND | TIME | STATE  | INFO             |
+------------+------+----------------------+------+---------+------+--------+------------------+
| 3221488068 | SYS  | 100.xx.xxx.xxx:18985 | SYS  | Sleep   |  298 | SLEEP  | NULL             |
| 3221488078 | SYS  | 100.xx.xxx.xxx:32489 | SYS  | Query   |    0 | ACTIVE | SHOW PROCESSLIST |
+------------+------+----------------------+------+---------+------+--------+------------------+

Use the SHOW FULL PROCESSLIST statement

obclient [SYS]> SHOW FULL PROCESSLIST;

The output is as follows:

+------------+------+-----------+----------------------+------+---------+------+--------+-----------------------+----------------+------+
| ID         | USER | TENANT    | HOST                 | DB   | COMMAND | TIME | STATE  | INFO                  | IP             | PORT |
+------------+------+-----------+----------------------+------+---------+------+--------+-----------------------+----------------+------+
| 3221488068 | SYS  | oracle001 | 100.xx.xxx.xxx:18985 | SYS  | Sleep   |  548 | SLEEP  | NULL                  | 172.xx.xxx.xxx | 2881 |
| 3221488078 | SYS  | oracle001 | 100.xx.xxx.xxx:32489 | SYS  | Query   |    0 | ACTIVE | SHOW FULL PROCESSLIST | 172.xx.xxx.xxx | 2881 |
+------------+------+-----------+----------------------+------+---------+------+--------+-----------------------+----------------+------+