[Todo item] Add entry creation timestamp column to pg_stat_replication

From: MyungKyu LIM <myungkyu(dot)lim(at)samsung(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: [Todo item] Add entry creation timestamp column to pg_stat_replication
Date: 2018-07-31 08:56:57
Message-ID: 1657809367.407321.1533027417725.JavaMail.jboss@ep2ml404
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
0001-Implement-following-TODO-list-item.patch application/octet-stream 7.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2018-07-31 09:11:21 Re: [HACKERS] Restricting maximum keep segments by repslots
Previous Message Tatsuo Ishii 2018-07-31 08:03:19 Re: Adding a note to protocol.sgml regarding CopyData