Thread: Active session Sampling in Cloud versions of PostgresSQL

Active session Sampling in Cloud versions of PostgresSQL

From
Satalabaha Postgres
Date:
Hi Listers,

Would like to know if we already have any active session sample scripts that can be used to analyze performance concerns in cloud versions of Postgres, that would be great. Although it appears that AWS and Azure, for instance, have performance insights, I am seeking for something that allows us to query and analyze the data as needed.




Regards,

Satalabha

Re: Active session Sampling in Cloud versions of PostgresSQL

From
Bart Jonk
Date:
I'm using pgbadger in combination with AWS RDS postgres. 

To my satisfaction, I also use this script to fetch the logs: 

Cheers,
Bart



On Sun, 22 Jan 2023 at 06:34, Satalabaha Postgres <satalabaha.postgres@gmail.com> wrote:
Hi Listers,

Would like to know if we already have any active session sample scripts that can be used to analyze performance concerns in cloud versions of Postgres, that would be great. Although it appears that AWS and Azure, for instance, have performance insights, I am seeking for something that allows us to query and analyze the data as needed.




Regards,

Satalabha