Hello
When we running our campaign workflow, there is a split where the pre-defined filters query supposed to run usually it take 10 mn max but for some reason nowadays it takes 1 to 2 hours to run.
I am not sure how to start the investigation, not sure if its related with pre defined filer or something else who affecting these.
Any hints?
Hi @rbiri,
There can be many reasons for your query with pre-defined filters taking long, some of these you can look into are:
- If the data in that particular table where you applying the pre-defined has recently increased via some import and that is now increasing the time to execute the query.
-There is some long-running query in the backend that might be creating a load on the table these days, now this should be looked at by your DB admin (backend team)
-The pre-defined filter query you have applied on the columns of the table is not indexed, so, try defining an index on those columns.
-There is an increase in bloat on the concerned table, for this you can ask your Db admin to run a Partial or Full Vacuum on it.
Br,
Shubham
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.