We love metabase. But sometimes the UI is mysteriously and frustratingly slow. As far as we know/see there isn’t obvious resourcing problems (our DB is cloud hosted and well resourced), and our instance hosting metabase doesn’t appear to CPU bound in any way.
So how do we figure out why it’s so slow!?
We’re currently using 0.17.2, using the official docker image.
Here’s a sample of APIs that see this slowness (by watching the Chrome inspector’s network view)
/api/dashboard?f=all - consistently ~40 secs
/api/activity - consistently ~30 secs
/api/database?include_tables=true&include_cards=true - usually ~1-2secs, sometimes 40secs.
These make the UI horribly unresponsive. The dashboard api seems to be called quite regularly.
I’m happy to get my hands dirty and help diagnose this … it’s gonna make life MUCH better for our users and hopefully make some significant improvement to metabase product.
I presume you’re running 0.27.2 (otherwise I think you should upgrade)
For comparison I just ran /api/dashboard?f=all and /api/activity and they were both well below 1 sec. That’s with the H2 default Metabase internal db and less than 10 dashboards (what db do you use? - and how many dashboards do you have?)
The core devs are currently looking perf of another api:
It has mention of a debug line in the log with db calls. Maybe useful for you?
Other than that in your shoes I think I would try to spin up a local Metabase + MySQL clone to try to isolate if it’s an environment issue and it would also enable you to test with a 0.28.0-RC version.