DB Query at event causing hung

[Gani]

Hi,

We are facing DB hung because of a query on table events. Can you please suggest the table purging steps and also how we can fix this long running query. Below is the query.

Attached the query.

Thanks.