Pre defined filter and performance issue

[rbiri]

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?

[Shubham_Goyal__ · Accepted solution]

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