Problem Statement/Rationale

We're experiencing some severe slowness on a production database.

We think it could be related to some unoptimized queries.

We'd like the support to help us finding some queries improvement.

Please be sure to attach relevant logs with any sensitive data redacted.

Steps to Reproduce

You could replicate the issue by implementing the same amount of logical operation as in the current queries,.

Expected Results

The queries should cause slowness on the entire system.

Actual Results

As said, we observed some severe slowness while these queries are running.

Additional Notes

We'd like to know if we could get some queries improvement or if we should evaluate a  server ram increase (or setting the cacheSize parameter, since only about the 50% of memory is being used)