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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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?



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux