git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Track shared buffer hits in pg_stat_io

author Andres Freund <andres@anarazel.de>

2023年3月31日 02:22:40 +0000 (19:22 -0700)

committer Andres Freund <andres@anarazel.de>

2023年3月31日 02:24:21 +0000 (19:24 -0700)

commit 8aaa04b32d790da595684de58ae4fc2db96becff

tree d9993491ee35f81fbf8be407a4ef76b486768ef0 tree

parent 6c3b697b19db6274da622cf0fe7a7ad32eeeced3 commit | diff

Track shared buffer hits in pg_stat_io

Among other things, this should make it easier to calculate a useful cache hit
ratio by excluding buffer reads via buffer access strategies. As buffer access
strategies reuse buffers (and thus evict the prior buffer contents), it is
normal to see reads on repeated scans of the same data.

Author: Melanie Plageman <melanieplageman@gmail.com>
Reviewed-by: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Discussion: https://postgr.es/m/CAAKRu_beMa9Hzih40%3DXPYqhDVz6tsgUGTrhZXRo%3Dunp%2Bszb%3DUA%40mail.gmail.com

12 files changed:

doc/src/sgml/monitoring.sgml diff | blob | blame | history

src/backend/catalog/system_views.sql diff | blob | blame | history

src/backend/storage/buffer/bufmgr.c diff | blob | blame | history

src/backend/storage/buffer/localbuf.c diff | blob | blame | history

src/backend/utils/activity/pgstat_io.c diff | blob | blame | history

src/backend/utils/adt/pgstatfuncs.c diff | blob | blame | history

src/include/catalog/pg_proc.dat diff | blob | blame | history

src/include/pgstat.h diff | blob | blame | history

src/include/storage/buf_internals.h diff | blob | blame | history

src/test/regress/expected/rules.out diff | blob | blame | history

src/test/regress/expected/stats.out diff | blob | blame | history

src/test/regress/sql/stats.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom