processlist

The processlist view displays information about the operations currently being performed by the set of threads executing within the server. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.processlist columns
Name	Type	Description
ID	bigint	Identifier of the thread. If the GUC parameter enable_thread_pool is set to on and the backend is idle, the value is 0.
USER	varchar(32)	User who delivered the statement.
HOST	varchar(64)	Host name and port number of the client that issues the statement. This parameter is displayed only when you log in through a remote client. In other cases, the value is NULL.
DB	varchar(64)	Displays the name of the current M-compatible database.
COMMAND	varchar(16)	Type of the command executed in the client, or sleep if the session is idle. This column is not supported in the current version, and it is NULL.
TIME	integer	Duration that the thread has been in its current state, in seconds.
STATE	varchar(64)	Action, event, or state that indicates what the thread is doing. This column is not supported in the current version, and it is NULL.
INFO	longtext	Statement the thread is executing, or NULL if it is executing no statement.