Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kLLkW-00037b-47 for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Sep 2020 07:33:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kLLkU-0001ET-SI for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Sep 2020 07:33:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kLLkU-0001EM-LG for pgsql-hackers@lists.postgresql.org; Thu, 24 Sep 2020 07:33:02 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kLLkO-0001o7-1R for pgsql-hackers@postgresql.org; Thu, 24 Sep 2020 07:33:01 +0000 Received: from oss.nttdata.com (localhost [127.0.0.1]) by oss.nttdata.com (Postfix) with ESMTP id C745D62345; Thu, 24 Sep 2020 16:32:51 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.102.3 at oss.nttdata.com MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Thu, 24 Sep 2020 16:32:51 +0900 From: Katsuragi Yuta To: legrand legrand Cc: pgsql-hackers@postgresql.org Subject: Re: [PATCH] Add features to pg_stat_statements In-Reply-To: <1600924523318-0.post@n3.nabble.com> References: <0d9f1107772cf5c3f954e985464c7298@oss.nttdata.com> <1600500942767-0.post@n3.nabble.com> <16a262a87492b4f4afc4c5010f8fa631@oss.nttdata.com> <1600924523318-0.post@n3.nabble.com> Message-ID: X-Sender: btkatsuragiyu@oss.nttdata.com User-Agent: Roundcube Webmail/1.1.9 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-09-24 14:15, legrand legrand wrote: > Hi, > Both are probably not needed. > I would prefer it accessible in a view live > > Event | date | victims > Eviction... > Reset... > Part reset ... > > As there are other needs to track reset times. Let me confirm one thing. Is the number of records of this view fixed to three? Or, will a new record be appended every time an event (Eviction or Reset or Part Reset) happens? Regards, Katsuragi Yuta