RHey @vs! Thanks for reaching out - Let me loop in @adlerhurst who will be able to provide more context on this :gigipixel:
FHey would you mind sharing your connection pool settings?
And potentially the query details you get in the cockroach ui?
And potentially the query details you get in the cockroach ui?
FOK got it.
The query you stated above is kind of being done in all requests, so if that one is slow everything get slowed down.
Can you have a dump of Cockroach from that query in the analyzer?
Another way is to configure a cache which landed in 2.65.0
You could add an in memory cache (for the instance) and see if that gets better https://zitadel.com/docs/self-hosting/manage/cache#examples
The query you stated above is kind of being done in all requests, so if that one is slow everything get slowed down.
Can you have a dump of Cockroach from that query in the analyzer?
Another way is to configure a cache which landed in 2.65.0
You could add an in memory cache (for the instance) and see if that gets better https://zitadel.com/docs/self-hosting/manage/cache#examples