Hello Guys
We are using prefect self hosted on kubernetes, version - 2.7.1
We are facing a issue where our postgres database is getting under heavy load
The major query which we are able to see is
Copy code
SELECT concurrency_limit.id, concurrency_limit.created, concurrency_limit.updated, concurrency_limit.tag, concurrency_limit.concurrency_limit, concurrency_limit.active_slots FROM concurrency_limit WHERE concurrency_limit.tag IN ($1::varchar) ORDER BY concurrency_limit.tag FOR UPDATE
It is using almost 2 AAS on AWS RDS
RDS configuration
m7g.4xlarge
Can someone help me to understand why exactly it is so high and is there any parameter I can use to reduce this ?
Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.