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/