[Todo item] Add entry creation timestamp column topg_stat_replication

Поиск
Список
Период
Сортировка
От MyungKyu LIM
Тема [Todo item] Add entry creation timestamp column topg_stat_replication
Дата
Msg-id 1657809367.407321.1533027417725.JavaMail.jboss@ep2ml404
обсуждение исходный текст
Ответы FW: [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  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: [Todo item] Add entry creation timestamp column to pg_stat_replication  (Surafel Temesgen <surafel3000@gmail.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Adding a note to protocol.sgml regarding CopyData
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] Restricting maximum keep segments by repslots