Re: Identify root-cause for intermittent spikes

2022-10-12 Thread Sengottaiyan T
Thanks, Rick - I will give it a try. On Wed, Oct 12, 2022 at 6:12 AM Rick Otten wrote: > I like to use pgbadger to collect data on what is happening in RDS > instances. You have to turn up a bunch of logging in RDS: > > 1. Turn on connection logging, duration logging, lock_waits, and anything >

Re: Identify root-cause for intermittent spikes

2022-10-12 Thread Sengottaiyan T
Thanks, Michael. Due to reactive nature of the intermittent alerts, Is there any table which stores the historical information / periodic snapshots captured from the pg_stat_activity view? On Tue, Oct 11, 2022 at 5:18 PM MichaelDBA wrote: > Hello, > > Your problem is probably, too many active,