Query count by user

Hello,

How to get the details of a query executed by a memsql user?. Looking for a log file or command or table which contains all the details about all queries executed by a user.

Thanks in advance

Outside of audit logging (SingleStoreDB Cloud · SingleStore Documentation), I don’t think we have a way of showing the queries executed by a particular user.

You can find historical statistics about queries executed via information_schema.plancache or show plancache (SingleStoreDB Cloud · SingleStore Documentation), but this won’t tell you which user(s) have run the query. You can see which users are running active queries via information_schema.processlist (while the query is running).