Does the metabase provide any way to monitor the performance (time, how heavy, etc) of the queries?
Yes, via the Audit functionality: https://www.metabase.com/docs/latest/enterprise-guide/audit.html
Otherwise you'll have to look in the application database yourself: Metabase Metadata SQL
Thanks! Audit is amazing but I'm using v0.40.1. I'm going to plan the uptade
@Helena Audit functionality is only part of the Pro/Enterprise editions. But you should upgrade no matter what.
Hi @flamber! I have another question: is there any easy way to tell which dashboards a question is on?
- I don't understand - where do I find the table report_dashboardcard?
I've never accessed the Metabase application database
I once struggled to take a better look into Metabase performance, and the best way to do that is to look into Metabase Aplications' database, which is the database where Metabase keeps its records.
Inside that database, there are some tables such as query_execution, where you can see how long a query takes to be executed, if it is saved into a card or was just a executed question. Once you get to know Metabase schema, which is quite easy to learn, you are good to go.
Important: pay attention on querying a production database. The best scenario here is to make a copy to query what you need to analyze about Metabase performance, so you don't compete with the platform.