I created a dashboard with 10-15 questions, and each question individually is pretty fast (1-5s). The problem is when I load my dashboard, it takes a large amount of time (1-2 min). It seems that the queries to the Postgres database are done in series, and some extra time is added.
I checked the resources on the Metabase app and Postgres database, and they are running well. In the logs of Metabase, I got:
- Connections App DB: 2/10 Threads Jetty: 2/50
- Postgres DB 16 connections: 1/4 (0 threads blocked)
I deployed Metabase with Kubernetes and its version is 0.45.1