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

From: Satalabaha Postgres <satalabaha(dot)postgres(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Identify sessions and SQL's that are generating more write ahead logs
Date: 2023-07-13 01:46:42
Message-ID: CAJ_W8nakoNac+=tuwYc+iqObCpe5z97KEP==SSkO=1KE2s0Ynw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ed Sabol 2023-07-13 03:04:56 Re: pg_dump: WARNING: could not find operator
Previous Message Laurenz Albe 2023-07-12 06:26:02 Re: pg_dump: WARNING: could not find operator