Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gNCbo-0007Ba-D4 for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Nov 2018 08:02:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gNCbm-0002uC-G9 for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Nov 2018 08:02:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gNCbl-0002u5-AU for pgsql-hackers@lists.postgresql.org; Thu, 15 Nov 2018 08:02:38 +0000 Received: from mailout4.samsung.com ([203.254.224.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gNCbg-0003h7-GS for pgsql-hackers@postgresql.org; Thu, 15 Nov 2018 08:02:35 +0000 Received: from epcas4p4.samsung.com (unknown [182.195.41.34]) by mailout4.samsung.com (KnoxPortal) with ESMTP id 20181115080227epoutp04e4c66b1240e611fbbf79259de1bcda9a~nPW_n7NTv2349023490epoutp04X for ; Thu, 15 Nov 2018 08:02:27 +0000 (GMT) DKIM-Filter: OpenDKIM Filter v2.11.0 mailout4.samsung.com 20181115080227epoutp04e4c66b1240e611fbbf79259de1bcda9a~nPW_n7NTv2349023490epoutp04X DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=samsung.com; s=mail20170921; t=1542268947; bh=TR0RuHb/4ppz+ILy/dmkrjRXd1Mdw2nxxyM0R9/nP+U=; h=From:To:Cc:Subject:Date:References:From; b=Zx8QqrgJcwC6UH+Z3UoowfvZdMDeVOJYT0rhrW20BXEqH715M8Sskio4h3VjP4egy coek6FzHIijab3GN6VdKu4UoK10d2l1cDE70BpOUOtp8TpXdeujgPIxhkmHbsdubet acFXjsQGZmoOKSrbEjDxlixLXRW7amLJjpdeDT0k= Received: from epsmges4p1.samsung.com (unknown [182.195.42.33]) by epcas4p2.samsung.com (KnoxPortal) with ESMTP id 20181115080226epcas4p2780b32da917fad5716d1a5ea3ef3ef8a~nPW_VHMGw3139131391epcas4p21; Thu, 15 Nov 2018 08:02:26 +0000 (GMT) Received: from epcas4p2.samsung.com ( [182.195.41.32]) by epsmges4p1.samsung.com (EPCPMTA) with SMTP id B2.A8.03833.2182DEB5; Thu, 15 Nov 2018 17:02:26 +0900 (KST) Received: from epsmtrp1.samsung.com (unknown [182.195.40.13]) by epcas4p1.samsung.com (KnoxPortal) with ESMTPA id 20181115080226epcas4p1f81c51691d9f12f7fa94c198e84edb3a~nPW9noCbL0597405974epcas4p1R; Thu, 15 Nov 2018 08:02:26 +0000 (GMT) Received: from epsmgms1p2new.samsung.com (unknown [182.195.42.42]) by epsmtrp1.samsung.com (KnoxPortal) with ESMTP id 20181115080226epsmtrp1870d7f14d3f6f5f933d24d8daa949dcc~nPW9msjvX0626906269epsmtrp1D; Thu, 15 Nov 2018 08:02:26 +0000 (GMT) X-AuditID: b6c32a21-49dff70000000ef9-1b-5bed2812f0b3 Received: from epsmtip1.samsung.com ( [182.195.34.30]) by epsmgms1p2new.samsung.com (Symantec Messaging Gateway) with SMTP id 27.F3.03606.1182DEB5; Thu, 15 Nov 2018 17:02:25 +0900 (KST) Received: from lmkPC (ip-70-2-253-71.ftwttx.spcsdns.net [70.2.253.71]) by epsmtip1.samsung.com (KnoxPortal) with ESMTPA id 20181115080225epsmtip1e369dc5f79af3eb96ebb6cc6308880f5~nPW9Y8tMW2752927529epsmtip1b; Thu, 15 Nov 2018 08:02:25 +0000 (GMT) From: "myungkyu.lim" To: "'Masahiko Sawada'" Cc: "'PostgreSQL-development'" , , Subject: RE: [Todo item] Add entry creation timestamp column to pg_stat_replication Date: Thu, 15 Nov 2018 17:02:31 +0900 Message-ID: <007701d47cb9$8f414380$adc3ca80$@samsung.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Content-Language: ko Thread-Index: AdR8uYxuJXGtndK0SNaTOACWdE2Xyg== X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFuplleLIzCtJLcpLzFFi42LZdlhTQVdI4220wc8+Q4ufb88wWdzd18Zs cWfHdDaL9l0LmR1YPHbOusvucWHfNHaPvi2rGAOYo7hsUlJzMstSi/TtErgypu0+yFhwgrXi xDvzBsYTLF2MnBwSAiYSa898ALOFBJYySpxc69LFyAVkf2KU+Pr9OQuE841RYu7zCexdjBxg Heu/c0HE9zJKvPo4FaroN6PEwj9HWEFGsQnoS1zfAWGLANkfN+5hBLGZBYolpp3cAGYLC4RK 9K5fBmazCKhKXD//EszmFbCUeN08gx3CFpQ4OfMJC0SvtsSyha+ZIc5WkNhx9jXUTBGJ2Z1t zCDHiQjoSfyfrQZyj4TAEjaJK4t7mCDqXSQ+N69khbCFJV4d38IOYUtJvOxvg7LLJe523GWE sCskGjr7oOL6ErMXtLGCzGcW0JRYv0sfYi2fxJzug0yQMOGV6GgTgjDVJB6c54ZolJFY+WsL G4TtIfGv/S0bJJxjJRYseMYygVFhFpIfZyH5cRaSv2Yh7F3AyLKKUSy1oDg3PbXYpMBQrzgx t7g0L10vOT93EyM4kWgp7mC8tsD7EKMAB6MSD+8JqzfRQqyJZcWVuYcYJTiYlUR4F9QAhXhT EiurUovy44tKc1KLDzFKc7AoifNWSM6NFhJITyxJzU5NLUgtgskycXBKNTBq/mHctKGunzHy et7GQ2cNtwWofY/d9cWmLP0qZxEDq1Cr4mw/s8z57L2L99Qr/xO/zFJqqcr5Kdj+zXU+2202 1o+aOuwOZzR6Rdgu+3fy5VKtCUs3sCebX/P1DDjjMsOAy53p9o8Fb0IcvTZF28r3PFhrdc7p 1Kff7bFNMkb7JP0/qUpp6CqxFGckGmoxFxUnAgDge+E5IAMAAA== X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFrrLLMWRmVeSWpSXmKPExsWy7bCSnK6gxttog7/brC1+vj3DZHF3Xxuz xZ0d09ks2nctZHZg8dg56y67x4V909g9+rasYgxgjuKySUnNySxLLdK3S+DKeNN5h7ngBGvF nnfNjA2MJ1i6GDk4JARMJNZ/5+pi5OIQEtjNKHFs4SbGLkZOoLiMRM+9G8wQNcISM29JQNT8 ZJRYs/keG0gNm4C+xPUdR1hBbBEg++PGPWC9zAKlEpO63oLFhQWCJXbebgKLswioSlw//xLM 5hWwlHjdPIMdwhaUODnzCQtEr7ZE78NWRhh72cLXzBD3KEjsOPsaKi4iMbuzDew2EQE9if+z 1SYwCs5CMmkWkkmzkEyahaR7ASPLKkbJ1ILi3PTcYsMCo7zUcr3ixNzi0rx0veT83E2M4EDX 0trBeOJE/CFGAQ5GJR7eE1ZvooVYE8uKK3MPMUpwMCuJ8C6oAQrxpiRWVqUW5ccXleakFh9i lOZgURLnlc8/FikkkJ5YkpqdmlqQWgSTZeLglGpgbFw/9xcT187H7e859ruJT3uo271K3/P3 nF2Lk1IPOJRfTVM6qicq2yWUw962/0X0wSf/QqzWNa35sUp2s9G95E4Hn+yw4GNxxjIV3gHL fi87a+wiU5sZUHjfICLsZFb/tzv2N36e+nRoT0Ry39I3oi/Yu2W37aoMn3x104eKp3t0q6q+ LFmYpMRSnJFoqMVcVJwIAJz+8HxwAgAA X-CMS-MailID: 20181115080226epcas4p1f81c51691d9f12f7fa94c198e84edb3a X-Msg-Generator: CA Content-Type: text/plain; charset="utf-8" CMS-TYPE: 104P X-CMS-RootMailID: 20181115080226epcas4p1f81c51691d9f12f7fa94c198e84edb3a References: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi. >> 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_sub= sctiption view. >> I think that field has the same meaning. > >I got confused by the field name. If we have 'last_msg_send_time' >field in pg_stat_replciation which has information of wal senders >users would think it as a time when the wal sender sent a message last >time. However values of the fields actually shows a time when the wal >receiver sent a reply message last time. So perhaps >'last_reply_send_time' would be more clear. Good point. 'last_reply_send_time' is better. How about just 'reply_time'? Best regards, Myungkyu, Lim