Postgres Pro
Downloads
Home   >   mailing lists

[Todo item] Add entry creation timestamp column topg_stat_replication - Mailing list pgsql-hackers

From MyungKyu LIM
Subject [Todo item] Add entry creation timestamp column topg_stat_replication
Date
Msg-id 1657809367.407321.1533027417725.JavaMail.jboss@ep2ml404
Whole thread Raw
Responses 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>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Adding a note to protocol.sgml regarding CopyData
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Restricting maximum keep segments by repslots