Re: pg_stat_statements, write activity - Mailing list pgsql-admin

From Achilleas Mantzios
Subject Re: pg_stat_statements, write activity
Date
Msg-id e100c2e0-1e30-4087-973d-d97a2e511dd7@cloud.gatewaynet.com
Whole thread Raw
In response to pg_stat_statements, write activity  (Scott Ribe <scott_ribe@elevated-dev.com>)
List 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
intoWAL 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@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>



pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: pg_stat_statements, write activity
Next
From: Laurenz Albe
Date:
Subject: Re: pg_stat_statements, write activity