Create and use wait events for read, write, and fsync operations. Previous commits, notably 53be0b1add7064ca5db3cd884302dfc3268d884e and 6f3bd98ebfc008cbd676da777bb0b2376c4c4bfa, made it possible to see from pg_stat_activity when a backend was stuck waiting for another backend, but it's also fairly common for a backend to be stuck waiting for an I/O. Add wait events for those operations, too.
Rushabh Lathia, with further hacking by me. Reviewed and tested by Michael Paquier, Amit Kapila, Rajkumar Raghuwanshi, and Rahila Syed. Discussion: http://postgr.es/m/CAGPqQf0LsYHXREPAZqYGVkDqHSyjf=KsD=k0gtvpauzythh...@mail.gmail.com Branch ------ master Details ------- http://git.postgresql.org/pg/commitdiff/249cf070e36721a65be74838c53acf8249faf935 Modified Files -------------- doc/src/sgml/monitoring.sgml | 271 ++++++++++++++++++++++++ src/backend/access/heap/rewriteheap.c | 17 +- src/backend/access/transam/slru.c | 12 ++ src/backend/access/transam/timeline.c | 11 + src/backend/access/transam/twophase.c | 9 + src/backend/access/transam/xlog.c | 31 +++ src/backend/access/transam/xlogutils.c | 3 + src/backend/postmaster/pgstat.c | 233 ++++++++++++++++++++ src/backend/replication/logical/reorderbuffer.c | 9 + src/backend/replication/logical/snapbuild.c | 14 ++ src/backend/replication/slot.c | 13 ++ src/backend/replication/walsender.c | 4 + src/backend/storage/file/buffile.c | 11 +- src/backend/storage/file/copydir.c | 7 +- src/backend/storage/file/fd.c | 28 ++- src/backend/storage/ipc/dsm_impl.c | 3 + src/backend/storage/smgr/md.c | 21 +- src/backend/utils/cache/relmapper.c | 7 + src/backend/utils/init/miscinit.c | 17 ++ src/include/pgstat.h | 78 +++++++ src/include/storage/fd.h | 12 +- 21 files changed, 782 insertions(+), 29 deletions(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers