[dashboard]Monitor Query on SuperSet Dashboard

[Asturias-sam]

Hello Team,

Is there any way to get the execution time of the queries on dashboard, so it will be helpful for performance analysis.
From SQLLAB we can get the execution time but for dashboards is it possible see the execution time for queries ?

[junlincc]

@Asturias-sam could you provide a use case? thanks

[Asturias-sam]

@junlincc
We have dashboard having various charts, we want to monitor Superset performance i.e latency between Superset and Our data sources in terms of query execution shouldn't be much.

[junlincc]

If your goal is to improve dashboard performance, I suggest that to checkout and enable async query first, docs can be found here If you feel like testing the feature, feel free to enable the GLOBAL_ASYNC_QUERIES feature flag. See the CONTRIBUTING.md documentation for details: https://github.com/apache/superset/blob/master/CONTRIBUTING.md#async-chart-queries

I'm still trying to understand the business value of this requested feature. I assume you wanna use it as an assessment indicator against other BI tools?

[Asturias-sam]

We want to manage the Dashboard Performance in Superset so it will help us to alert our team about slow performance and we can take the necessary steps to speed up our datasources.

[joaopmedeiros]

Im trying to the same thing and include errors..

[yitian-reevo]

Hi folks, callback from 2025, is there any updates for this topic?

My team is expecting the same thing, we build our reporting page based on SuperSet with 10+ charts and we would like to monitor the performance of each chart, e.g. the request time of superset api, the sql execution time for each query etc.