Re: AWS RDS "sessions" and pg_stat_activity

Поиск
Список
Период
Сортировка
От kyle Hailey
Тема Re: AWS RDS "sessions" and pg_stat_activity
Дата
Msg-id CADsdiQjOW-4Tx1JH-EPuMx8oCJ2=t84pN7qfq5kT-7OBexS26w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: AWS RDS "sessions" and pg_stat_activity  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: AWS RDS "sessions" and pg_stat_activity  (kyle Hailey <kylelf@gmail.com>)
Список pgsql-admin

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@gmail.com> 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@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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Poor performance due to parallel seq scan on indexed date field
Следующее
От: kyle Hailey
Дата:
Сообщение: Re: AWS RDS "sessions" and pg_stat_activity