Postgres Pro
Downloads
Home   >   mailing lists

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

From Keith
Subject Re: Identify sessions and SQL's that are generating more write ahead logs
Date
Msg-id CAHw75vtbm0jtUhgx1RVBO7mmzSjQPhs9EHB1R8jRA24N1sZQhw@mail.gmail.com
Whole thread Raw
In response to Identify sessions and SQL's that are generating more write ahead logs  (Satalabaha Postgres <satalabaha.postgres@gmail.com>)
Responses Re: Identify sessions and SQL's that are generating more write ahead logs
List pgsql-admin
Tree view
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: Ron
Date:
Subject: Re: pg_dump: WARNING: could not find operator
Next
From: "Edward J. Sabol"
Date:
Subject: Re: pg_dump: WARNING: could not find operator