On Fri, Jan 7, 2011 at 19:20, Simon Riggs <[email protected]> wrote: >> "pg_stat_replication" seems to be the most understandable name. > > Please go with whatever you think best for now. I'm sure people will ask > for different names later anyway. Let's get this committed soon, to > reduce later patch conflicts. Thanks. > > Please add sent_location, I will add others.
OK, I added a view named s "pg_stat_replication". The view is basically
based on Simon's patch, but I just skipped unused WalSnd entreis in
WalSndCtl rather than return NULLs. The applied patch attached.
I expect we will have two views for master and standby servers:
* pg_stat_replication
Activity of wal senders in master server.
* pg_stat_standby (not yet)
Activity of a wal receiver and a recovery process in standby servers.
I didn't use pg_stat_wal_sender/receiver as their names because standby
activity in slaves could contain not only a wal receiver but also a
recovery process.
--
Itagaki Takahiro
pg_stat_replication-20110107.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
