Thread: Identify sessions and SQL's that are generating more write ahead logs
Identify sessions and SQL's that are generating more write ahead logs
From
Satalabaha Postgres
Date:
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
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
Re: Identify sessions and SQL's that are generating more write ahead logs
From
Satalabaha Postgres
Date:
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 availableOn 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