These views summarize statement activity, file I/O, and connections, grouped by user. By default, rows are sorted by descending total latency.
x$user_summary views have these
The client user name. Rows for which the
USERcolumn in the underlying Performance Schema table is
NULLare assumed to be for background threads and are reported with a host name of
The total number of statements for the user.
The total wait time of timed statements for the user.
The average wait time per timed statement for the user.
The total number of table scans for the user.
The total number of file I/O events for the user.
The total wait time of timed file I/O events for the user.
The current number of connections for the user.
The total number of connections for the user.
The number of distinct hosts from which connections for the user have originated.
The current amount of allocated memory for the user.
The total amount of allocated memory for the user.