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

The pg_stat_statements extension has wal generation statistics for each query that it logs. Most SaaS PG providers should have that extension available

https://www.postgresql.org/docs/14/pgstatstatements.html

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