FW: [Todo item] Add entry creation timestamp column topg_stat_replication
От
MyungKyu LIM
Тема
FW: [Todo item] Add entry creation timestamp column topg_stat_replication
Дата
Msg-id
1459102727.630179.1533202431977.JavaMail.jboss@ep2ml404
Ответ на
Список
Дерево обсуждения
[Todo item] Add entry creation timestamp column topg_stat_replication MyungKyu LIM <myungkyu.lim@samsung.com>
FW: [Todo item] Add entry creation timestamp column topg_stat_replication MyungKyu LIM <myungkyu.lim@samsung.com>
Re: FW: [Todo item] Add entry creation timestamp column to pg_stat_replication Masahiko Sawada <sawada.mshk@gmail.com>
Re: [Todo item] Add entry creation timestamp column topg_stat_replication Laurenz Albe <laurenz.albe@cybertec.at>
RE: [Todo item] Add entry creation timestamp column topg_stat_replication MyungKyu LIM <myungkyu.lim@samsung.com>
RE: [Todo item] Add entry creation timestamp column topg_stat_replication MyungKyu LIM <myungkyu.lim@samsung.com>
Re: [Todo item] Add entry creation timestamp column to pg_stat_replication Surafel Temesgen <surafel3000@gmail.com>
RE: [Todo item] Add entry creation timestamp column topg_stat_replication "myungkyu.lim" <myungkyu.lim@samsung.com>
I changed field name from 'reply_time' to 'last_msg_send_time'. Because 'last_msg_send_time' is used in pg_stat_wal_receiver/pg_stat_subsctiption view. I think that field has the same meaning. test example> postgres=# select pid, last_msg_send_time from pg_stat_replication; -[ RECORD 1 ]------+------------------------------ pid | 12015 last_msg_send_time | 2018-08-02 18:02:49.233049+09 -[ RECORD 2 ]------+------------------------------ pid | 12084 last_msg_send_time | 2018-08-02 18:02:48.583256+09 I Attached new patch file : 0001-Implement-following-TODO-list-item-v2.patch Feedback and suggestion will be very welcome. Thanks! Best regards, Myungkyu, Lim --------- Original Message --------- Date : 2018-07-31 17:56 (GMT+9) Title : [Todo item] Add entry creation timestamp column to pg_stat_replication Hello hackers, I have worked on following todo list item. - Add entry creation timestamp column to pg_stat_replication http://archives.postgresql.org/pgsql-hackers/2011-08/msg00694.php This item looks like simple because necessary data was already exist. So, I wrote a prototype patch. test example> postgres=# select pid, reply_time from pg_stat_replication; -[ RECORD 1 ]----------------------------- pid | 4817 reply_time | 2018-07-31 12:00:53.911198+09 -[ RECORD 2 ]----------------------------- pid | 4819 reply_time | 2018-07-31 12:00:53.911154+09 Several candidates exist for the field name. - reply_timestamp - info_gen_timestamp - stats_reset - last_msg_send_time Feedback and suggestion will be very welcome. Thanks! Best regards, Myungkyu, Lim
В списке pgsql-hackers по дате отправления