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(dot)postgres(at)gmail(dot)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
>