Re: pg_stat_statements, write activity

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_stat_statements, write activity
Date: 2025-05-17 14:50:53
Message-ID: 4D3DD5A9-AB6C-4BE1-8F21-091B482C6B48@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On May 16, 2025, at 1:37 PM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> Sometimes, a backend writes a block to disk itself. This might happen if a lot
> of cache pressure, but usually it happens when the table is extended with new
> blocks.

Ah, that's the piece I was missing!

Do the written blocks get counted as dirty first, or only as written?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2025-05-19 00:20:20 PostgreSQL Load Testing
Previous Message Laurenz Albe 2025-05-16 19:37:26 Re: pg_stat_statements, write activity