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 1nD41T-0004Ew-Ol for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jan 2022 12:37:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nD41S-0006OM-BC for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Jan 2022 12:37:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nD41S-0006OD-2Q for pgsql-hackers@lists.postgresql.org; Thu, 27 Jan 2022 12:37:06 +0000 Received: from mail-pg1-x535.google.com ([2607:f8b0:4864:20::535]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nD41P-0004da-DI for pgsql-hackers@lists.postgresql.org; Thu, 27 Jan 2022 12:37:05 +0000 Received: by mail-pg1-x535.google.com with SMTP id q75so2159040pgq.5 for ; Thu, 27 Jan 2022 04:37:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=9/T/v/bD4Bi8dqTVVKES73EiU819d/gK18pWrZtpFmE=; b=ASs6kKVa/Nun1VKrdeRxSzYoWBOoNzhdAKCKwihX2Ot/+mwpNeGSqfABdmQu0JAH78 n40/CUzxYNY1b71Pr5RRPoWjxnDDGSlS0bxgnG0++M0zUFXVNJR999F/0L3m9AWegZBD bnfycwyuoanoKIoWiCO1pe+76BSrO9Ty04vjPzLRLyVP4Sw5gFfEhHRPbEVvtaZWJWUN xJeWToBG/aSDyOgeZzbQRPzTJPHGc4c0/GbvVbYYhej8HNErdTxvdscrC/2l0VuFYLQ2 4uzc/VO2HWEZVSpkX5LC2peylWybyz/02qS8HkZ2e/2BFYRZKr7AhNNEh89arlnjhXGv upbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=9/T/v/bD4Bi8dqTVVKES73EiU819d/gK18pWrZtpFmE=; b=XXDKetTB+OsMn0ujX7bK6Ur8ZZa3pyIvwyj+ib2kxl1x8TD+lY3uR2UtALuSvANQCe n6YhyECHJ/jq8ZESPQlPhPcQALikhu9TxqFnKG5ZnPjoDCTAGSsv1Ns1sUko7FrXX0DF F7bUbnk/CRC+sOdZM1hmpy0mZ1qXe2D7AL6r1Zu4UsuGgxAKDWszIvgBWuny6TdbtO7A 1lawXmviFbTCgjLdHHsEeHCjP1vOkNIHjI5PEUtrvJ/GyP2RHIqzx3Pg+msbFLJA61jr jl8H/qzwfCfziHdmVi4tsfOdH2Gz2BlfK1qpFsdgWiMhpVkzXDbT/qQA4ChFLwGQW9yN m7zQ== X-Gm-Message-State: AOAM530y+l0QA1B58wOa3zNCJUiTygwY+dKdGlDT/mpaZ9t8lEt5O7sJ KioOA7cy0s12ERtj+ep+RWE= X-Google-Smtp-Source: ABdhPJxdthPfPVOpmCdDhO247InUwP4tYspXZyDU4WLQzHMvl8i5jeIrLIqHJ5ryO++eohf+miuyPw== X-Received: by 2002:a65:5543:: with SMTP id t3mr2653373pgr.180.1643287021011; Thu, 27 Jan 2022 04:37:01 -0800 (PST) Received: from jrouhaud (2001-b011-1005-be90-c0a9-c8fe-19d2-f392.dynamic-ip6.hinet.net. [2001:b011:1005:be90:c0a9:c8fe:19d2:f392]) by smtp.gmail.com with ESMTPSA id e2sm2395131pgr.52.2022.01.27.04.36.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 27 Jan 2022 04:37:00 -0800 (PST) Date: Thu, 27 Jan 2022 20:36:56 +0800 From: Julien Rouhaud To: Sergey Dudoladov Cc: PostgreSQL Hackers , Kuntal Ghosh , Rafia Sabih Subject: Re: Add connection active, idle time to pg_stat_activity Message-ID: <20220127123656.etovnhimr5sgp37f@jrouhaud> References: <20220125142245.w5ezlmpxeg47xz66@jrouhaud> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Thu, Jan 27, 2022 at 11:43:26AM +0100, Sergey Dudoladov wrote: > > Per agreement with Rafia I have reworked the patch in the past days. > The new version 6 is now ready for review. Great, thanks a lot Sergey! The cfbot is happy with this new version: https://cirrus-ci.com/github/postgresql-cfbot/postgresql/commitfest/36/3405