We’re having serious problems to be able to visualize our Dashboards, it just won’t load the dashboards after 5 minutes of trying to refresh several times part of the Dashboard is loaded and the rest ends with an error:
Even though it says there’s a problem connecting to the database, we have check the connection and everything looks ok, we have other processes connected to the DB and we don’t have any downtime.
On previous Looker’s downtime this is the common error we get.
Hey @Yaxkin , I would first try to run the same query directly on your postgres, and see if it is slow as well to discard the posisiblity of the slowness coming from the database. Then, I would try to create a new database connection and test in a new dashboard, and see if I get the same issue. if in both cases you dont see any slowness, then maybe there are too many tiles on your dashboard. Postgres can be pretty slow when you run many queries (one tile is one query on the database) at the same time. Have you considered Bigquery? it has a free tier of 1tb per month, and can handle large amount of data. You could stream the data form postgres to bigquery using datastream which doesnt require any coding knowledge
