Re: AWS RDS "sessions" and pg_stat_activity

Their use of "sessions" is everywhere. AAS (average active session count) and all over the insights, including the activity bar. I'm just trying to map those back to exact things I can query myself from pg_stat_activity.

Little bit on it here https://aws.amazon.com/blogs/database/analyzing-amazon-rds-database-workload-with-performance-insights/

On Wed, Jun 21, 2023 at 9:29 AM Jeff Janes <jeff.janes@gmail.com> wrote:

On Wed, Jun 21, 2023 at 12:06 PM Wells Oliver <wells.oliver@gmail.com> wrote:

Just trying to get my head firmly around the RDS session number and associated performance/saturation. It says a session is any request waiting on a response from the server, so I am wondering if that's equivalent to selecting all from pg_stat_activity where state is active, and this would include all concurrent parallel workers, maintenance stuff, etc.

If you are referring to something in the RDS documentation or monitoring, could you provide a link to it, or an excerpt of it?

Cheers,

Jeff

--

Wells Oliver
wells.oliver@gmail.com