Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Looker slow load time

Hi,

We are facing a very slow load time from Looker service (old Datastudio).  Our client's reports take so long to load that Looker, most of the time, cannot display the data on the report page. It is affecting negatively our clients.

It started to slow down in the mid of April and this month it is almost impossible to load the reports. We already clear the errors that we found on BigQuery logs, including some jobs that were stuck in the loop as I previously mention in this post: https://www.googlecloudcommunity.com/gc/Data-Analytics/Bigquery-error-causes-infinite-retries/td-p/5...

pedro_curto_0-1683890091670.png

 

Unfortunately, we could not resolve this issue and the only error that appears in the BigQuery logs is when the Looker did not present the data in the report (like a timeout):

pedro_curto_0-1683882876907.png

 

Some important considerations:

- We did not change the reports or the dataset's structure in these 2 months.

- The report is filtered by data and  the data field is Partitioned by Day

- Before this problem, the report was very fast to load

Can you investigate this issue or any insights that could help us?

Best regards,

Pedro Curto



 

 

 

 

4 1 1,398
1 REPLY 1

Good day @pedro_curto ,

I highly recommend that you reach out to Google Cloud Support for this inquiry, as engineers has better visibility and access to your logs and API usage. You can use this link to reach out to Google Cloud Support: https://cloud.google.com/support

Thank you for being part of Google Cloud Community