Slow chain worker query

[MrYawe]

Hello,

We had this error today:

It seems due to a timeout of this chain worker query:

By looking at the AWS performance insight dashboard I can see that this query is quite slow, the avg latency/call is ~1261 ms and it takes a significant part of our writer workload.

We use oban 2.17.10 and oban_pro 1.4.9 with Aurora postgres 16.1.

[sorenone]

Hiya,

Would you share your chain config?

We’re updating the chain query, as we did for workflows and batches. It’ll be much faster.

In the meantime, try: vacuum analyze or rebuilding indexes.