Re: AWS RDS "sessions" and pg_stat_activity

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: AWS RDS "sessions" and pg_stat_activity
Дата
Msg-id CAOC+FBWQL9W+GnasCN+1DX7J+BYEO4kH9Y65Z+o=FssMO2bpbQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: AWS RDS "sessions" and pg_stat_activity  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: AWS RDS "sessions" and pg_stat_activity  (kyle Hailey <kylelf@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: AWS RDS "sessions" and pg_stat_activity
Следующее
От: Cary Huang
Дата:
Сообщение: Re: SSL cert "not initialized" error with logical replication with 13.11