AWS RDS "sessions" and pg_stat_activity

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: AWS RDS "sessions" and pg_stat_activity
Date: 2023-06-21 16:06:05
Message-ID: CAOC+FBWE=vrLepeYjyzwDopN22o-fYMEFBR_ChNjuevc3qDt0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Appreciate any details.

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2023-06-21 16:29:02 Re: AWS RDS "sessions" and pg_stat_activity
Previous Message Bhasker Bathini 2023-06-21 15:57:15 Re: Why do i need to install set_user extension if i can directly grant all required privileges to user?