On 16/5/25 20:10, Scott Ribe wrote:
My understanding is that dirtied will be eventually written, via checkpoint or bg writer, so it's a matter of timing.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???
-- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx https://www.linkedin.com/in/scottribe/
