On Tue, 11 Oct 2022, 22:07 Sengottaiyan T, wrote:
> 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-cr
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
else that you are interested in studying.
2. Then grab all of your postgresql logs from AWS. I w
Hello,
Your problem is probably, too many active, concurrent connections. Get
it from here the db directly:
select datname, usename, application_name, substring(query, 1, 80)
query from pg_stat_activity where state in ('active','idle in
transaction');
Compare the number of rows returned wi
>
> 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
