session - connection to database
active session - session that has an SQL currently running
On Wed, Jun 21, 2023 at 9:33 AM Wells Oliver <wells.oliver@xxxxxxxxx> wrote:
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@xxxxxxxxx> wrote:On Wed, Jun 21, 2023 at 12:06 PM Wells Oliver <wells.oliver@xxxxxxxxx> 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@xxxxxxxxx
