Re: pg_stat_statements, write activity

From: Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_stat_statements, write activity
Date: 2025-05-16 19:25:19
Message-ID: e100c2e0-1e30-4087-973d-d97a2e511dd7@cloud.gatewaynet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 16/5/25 20:10, Scott Ribe wrote:

> I would guess that shared_blks_dirtied in pg_stat_statements is basically the count of blocks which will be logged into WAL and written back during checkpoints. So then what is shared_blks_written? Or do I misunderstand shared_blks_dirtied???
My understanding is that dirtied will be eventually written, via
checkpoint or bg writer, so it's a matter of timing.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-05-16 19:37:26 Re: pg_stat_statements, write activity
Previous Message Scott Ribe 2025-05-16 17:10:15 pg_stat_statements, write activity