Identify root-cause for intermittent spikes

2022-10-11 Thread Sengottaiyan T
> > Hi All, > > I'm looking for suggestions: > > Environment: AWS PostgreSQL RDS instance - Version 14.3 > Operations support gets intermittent alerts from the monitoring tool > through AWS cloud watch metrics on Disk Queue Depth, CPU burst-credit & CPU > Utilization. > I would like to understand w

Re: Identify root-cause for intermittent spikes

2022-10-12 Thread Sengottaiyan T
th the number of vCPUs. If it's > more than double the number of vCPUs in your AWS instance class, then you > are cpu saturated. > > Regards, > > Michael Vitale > > > Sengottaiyan T wrote on 10/11/2022 7:06 AM: > > Hi All, >> >> I'm looking for su

Re: Identify root-cause for intermittent spikes

2022-10-12 Thread Sengottaiyan T
save} > done > ``` > 3. Then run pgbadger: > ``` ~/src/pgbadger/pgbadger -f rds postgresql* > ``` > 4. Open the `out.html` in your browser, and poke around. There is a ton > of stuff you can find in all the drop down menus about what was happening > in your database o

Re: Identify root-cause for intermittent spikes

2022-10-14 Thread Sengottaiyan T
Thanks, Depsez. Please suggest: Is there any open-source tool available for capturing such information? On Thu, Oct 13, 2022, 14:03 hubert depesz lubaczewski wrote: > On Wed, Oct 12, 2022 at 10:46:23PM +0530, Sengottaiyan T wrote: > > Thanks, Michael. > > > > Due to r

Need suggestion to set-up RDS alerts on GP3 volumes

2022-11-18 Thread Sengottaiyan T
Hi All, I'm looking for suggestions: What kind of metrics would be beneficial to monitor and alert on Postgres RDS while switching to GP3 volumes (from existing GP2 volumes)? - We see intermittent I/O (disk queue depth) alerts with the existing GP2 storage type and burst credit alerts. https://a