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