]> granicus.if.org Git - postgresql/commit
Create and use wait events for read, write, and fsync operations.
authorRobert Haas <rhaas@postgresql.org>
Sat, 18 Mar 2017 11:43:01 +0000 (07:43 -0400)
committerRobert Haas <rhaas@postgresql.org>
Sat, 18 Mar 2017 11:43:01 +0000 (07:43 -0400)
commit249cf070e36721a65be74838c53acf8249faf935
treea2d6e4d443fff0466598ab7751fe7f4a443449ab
parent928250aef5f8363825acbf58540328089c26b0d4
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-VQ@mail.gmail.com
21 files changed:
doc/src/sgml/monitoring.sgml
src/backend/access/heap/rewriteheap.c
src/backend/access/transam/slru.c
src/backend/access/transam/timeline.c
src/backend/access/transam/twophase.c
src/backend/access/transam/xlog.c
src/backend/access/transam/xlogutils.c
src/backend/postmaster/pgstat.c
src/backend/replication/logical/reorderbuffer.c
src/backend/replication/logical/snapbuild.c
src/backend/replication/slot.c
src/backend/replication/walsender.c
src/backend/storage/file/buffile.c
src/backend/storage/file/copydir.c
src/backend/storage/file/fd.c
src/backend/storage/ipc/dsm_impl.c
src/backend/storage/smgr/md.c
src/backend/utils/cache/relmapper.c
src/backend/utils/init/miscinit.c
src/include/pgstat.h
src/include/storage/fd.h