We've just moved from 0.41.2 to 0.45.2, and some of our questions which used to return in a few seconds are now taking so long we mostly get 'Your question took too long' timeouts.
The affected queries all have the same structure:
- an underlying question written in SQL and returning a largeish dataset (<20,000 rows)
- multiple questions all based on the same underlying one, constructed in the GUI (using 'Explore results') and filtering/summarizing the first dataset
Viewing the (first 2000) results of the underlying question directly takes 4-5 seconds (also slower than 0.41.2, and direct db query takes 1.1s, but that's a separate topic).
My workaround is to convert all the secondary questions into native queries, but it's not ideal having to duplicate the complex underlying query!
I found Performance issue when using nested questions, which returns ~100k+ results · Issue #13572 · metabase/metabase · GitHub which sounds similar but was fixed before 0.41.2 - could there be a regression here?
Metabase 0.45.2 (Docker, in AWS ECS)
Postgres 13.7 (AWS RDS)
Thanks for your time!