Monitorizing users

[aitor.m]

Hi!

I’ve been having some problems with Metabase’s overloading due to a lot of users using my queries and they overload my DDBB, so my question is:
Is there any way i can monitorize who is using my queries and the queries response time?

Thank you in advance

[flamber]

Hi @aitor.m

Which version of Metabase? And which datasource?
Have you activated cache in the settings?

There's an excellent thread with the most common statistic queries:

Metabase Metadata SQL

Metabase is lacking in some of the management information I’d like to see. Hopefully the queries below will help a few others build up a management dashboard too. In summary: List of Dashboards List of Questions List of Questions in each Dashboard List of Questions not in any Dashboard List of Users LIst of Users who have never logged in List of Dashboards viewed by each user and count of views Pretty much anything else you can dream up /* All dashboards */ SELECT rd.id, rd.name, rd.descript…

[jsf]

I don’t think Metabase is the correct place to implement this. But poor performing queries is a common problem. Your DBMS should provide tools to fix these problems. For instance, in MySQL/MariaDB, you can issue a SHOW PROCESSLIST command to see current running queries. There’s also a slow query log you can enable. As a general rule, make sure things your selecting on or grouping on are indexed in some manner.