The Postgresql Database server is busy at from 9:AM- 10:30AM. it’s consumming High IO and even unable to ssh to the machine.
i’ve checked some of the possible causes:
- check any scheduled jobs.
- may be it’s peak hour,
- check what processes are consuming io, when you see high io usage on datadog. use:
I 've seen a process called
postgres: autovacuum~ processa lot of
Is there a mechanism to schedule
autovacuum process at night or any other way to stop running this process during working hours?