Re: AWS RDS "sessions" and pg_stat_activity - Mailing list pgsql-admin

From Wells Oliver
Subject Re: AWS RDS "sessions" and pg_stat_activity
Date
Msg-id CAOC+FBWQL9W+GnasCN+1DX7J+BYEO4kH9Y65Z+o=FssMO2bpbQ@mail.gmail.com
Whole thread Raw
In response to Re: AWS RDS "sessions" and pg_stat_activity  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: AWS RDS "sessions" and pg_stat_activity
List pgsql-admin
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.


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


--

pgsql-admin by date:

Previous
From: Jeff Janes
Date:
Subject: Re: AWS RDS "sessions" and pg_stat_activity
Next
From: Cary Huang
Date:
Subject: Re: SSL cert "not initialized" error with logical replication with 13.11