Query performance

Get Help
1

Hi! :grin:
Does the metabase provide any way to monitor the performance (time, how heavy, etc) of the queries?

2

Hi @Helena
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

1 Like
3

Thanks! Audit is amazing :star_struck: but I'm using v0.40.1. I'm going to plan the uptade :wink:

4

@Helena Audit functionality is only part of the Pro/Enterprise editions. But you should upgrade no matter what.

1 Like
5

Hi @flamber! I have another question: is there any easy way to tell which dashboards a question is on?

6

@Helena You would look in the table report_dashboardcard to find the question ID in card_id
https://github.com/metabase/metabase/issues/13975 - upvote by clicking :+1: on the first post

7
  1. I don't understand - where do I find the table report_dashboardcard?
  2. Upvoted!
8

@Helena In the Metabase application database. Metabase Metadata SQL

9

I've never accessed the Metabase application database :thinking:

10

Hi Helena!
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.

1 Like