v.23.5New Feature
Add system.user_processes table and SHOW USER PROCESSES query for user-level memory info and ProfileEvents
Addsystem.user_processestable andSHOW USER PROCESSESquery to show memory info and ProfileEvents on user level. #50492 (János Benjamin Antal).
Why it matters
This feature provides a higher-level overview of resource consumption by user, allowing database administrators to monitor and diagnose memory usage and performance events per user. It simplifies tracking the impact of individual users on system resources.How to use it
Users can query the newsystem.user_processes table directly using a SELECT statement, or use the shorthand command SHOW USER PROCESSES to retrieve aggregated memory and ProfileEvents metrics for each user.