Re: AWS RDS "sessions" and pg_stat_activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Didn't click your link so missed you were talking about my blog post.

I appreciate your interest in my blog post about Active Sessions, a topic I've devoted two decades to exploring. I rarely document my thoughts, but I recently put together the following post in a single evening. I acknowledge it could benefit from further refinement, so your feedback would be invaluable. If there are any aspects you believe need more elaboration or clarity, please don't hesitate to let me know.

A Comprehensive Guide to Understanding the AAS Metric in Databases

AAS is defined as the average number of concurrent active sessions in an database. To picture this, imagine each 'session' as an individual user process performing a specific task or executing a SQL query. The word 'active' is key here as it specifically refers to sessions that are doing something, not just connected to the database. When we say AAS, we are referring to the average number of these active sessions in a given time window.

On Wed, Jun 21, 2023 at 1:14 PM kyle Hailey <kylelf@xxxxxxxxx> wrote:

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?




[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux