processlist

The processlist view displays information about the operations currently being performed by the set of threads executing within the server. For details, see Table 1. 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 a 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)	Name of the current M-compatible database.
COMMAND	varchar(16)	Type of the command the thread is executing on behalf of the client. The value is sleep if the thread is idle. This is not supported in this version, and the value 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 the value is NULL.
INFO	longtext	Statement the thread is executing, or NULL if it is executing no statement.