Re: pg_stat_statements, write activity

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: pg_stat_statements, write activity
Дата
Msg-id e100c2e0-1e30-4087-973d-d97a2e511dd7@cloud.gatewaynet.com
обсуждение исходный текст
Ответ на pg_stat_statements, write activity  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список 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 по дате отправления: