Postgres Pro
Downloads
Home   >   mailing lists

Re: Identify sessions and SQL's that are generating more write ahead logs - Mailing list pgsql-admin

From Satalabaha Postgres
Subject Re: Identify sessions and SQL's that are generating more write ahead logs
Date
Msg-id CAJ_W8nZTC+H+d623vgLH=imCY4-1MdUaZWtv-fbO56cHRqQzsw@mail.gmail.com
Whole thread Raw
In response to Re: Identify sessions and SQL's that are generating more write ahead logs  (Keith <keith@keithf4.com>)
List pgsql-admin
Tree view
Thanks, I'll check it out. 
Regards,

Satalabha


On Thu, 13 Jul 2023 at 09:09, Keith <keith@keithf4.com> 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


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 by date:

Previous
From: Ilya Kosmodemiansky
Date:
Subject: Re: postgis Error during upgrade
Next
From: Erik Serrano
Date:
Subject: Is a PS - MSSQL Logical Replication Possible??