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

[Satalabaha Postgres <satalabaha.postgres@xxxxxxxxx>]

Thanks, I'll check it out. 

Regards,

Satalabha

On Thu, 13 Jul 2023 at 09:09, Keith <keith@xxxxxxxxxxx> wrote:

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@xxxxxxxxx> 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