Hi, there is a wierd behaviour regarding using of TOP 10 function. It didnt happen before, but when function is used, it looks like it starts to open access to database, but then never close it which looks like visualization is taking long time to actualize and it will timeout. So it never does, but it takes like 5min to finish the process. Is there any changes regarding this? Because we found it out after update.

Hello Markéta, I am not aware of any updates to how tops are calculated, but I can check further for you. Could you please provide more details about the function in question, i.e., send its definition over here, roughly on how many dashboards, workspaces it is being used, etc.? Also, please let us know the data source you are using and whether there has been a recent change in the volume of data.

This is the metric I am using: SELECT {metric/costs_vendors} WHERE TOP(10) IN (SELECT {metric/costs_vendors} BY {label/advertisers.name}) - there was just slightly more data, but I think from 250000 lines to 270000, we dont have problem with any other metrics or graphs, From our point of view, it looks like the database connection does not close while using TOP in a metric.

@Markéta Jedličková could you please also specify what database are you using with GoodData Cloud in this case? I think that will make it much easier for the engineers to replicate this potentially.

PostgreSQL

Thank you, I have sent you a DM to gather more details about your environement.

Thank you