Re: Identify sessions and SQL's that are generating more write ahead logs

Поиск
Список
Период
Сортировка
От Keith
Тема Re: Identify sessions and SQL's that are generating more write ahead logs
Дата
Msg-id CAHw75vtbm0jtUhgx1RVBO7mmzSjQPhs9EHB1R8jRA24N1sZQhw@mail.gmail.com
обсуждение исходный текст
Ответ на Identify sessions and SQL's that are generating more write ahead logs  (Satalabaha Postgres <satalabaha.postgres@gmail.com>)
Ответы Re: Identify sessions and SQL's that are generating more write ahead logs
Список pgsql-admin
Дерево обсуждения
The pg_stat_statements extension has wal generation statistics for each query that it logs. Most SaaS PG providers should have that extension available


On Wed, Jul 12, 2023 at 9:47 PM Satalabaha Postgres <satalabaha.postgres@gmail.com> wrote:
Hi All,

New to postgres and its working..

In postgres (version 14, cloud based), is there any way we can identify the sessions and the SQL's that are generating more WAL segments?

Regards,

Satalabha

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: pg_dump: WARNING: could not find operator
Следующее
От: "Edward J. Sabol"
Дата:
Сообщение: Re: pg_dump: WARNING: could not find operator