Expand my Community achievements bar.

SOLVED

Pre defined filter and performance issue

Avatar

Level 3

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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