pg_stat_statements, write activity

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: pg_stat_statements, write activity
Date: 2025-05-16 17:10:15
Message-ID: 30BA99F7-F935-4020-B53B-0D70FFA7D205@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2025-05-16 19:25:19 Re: pg_stat_statements, write activity
Previous Message Laurenz Albe 2025-05-15 12:27:57 Re: Postgre's replica holding huge amount of WAL