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 1nMBNN-0007eg-Tc for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Feb 2022 16:17:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nMBNM-0000se-Gr for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Feb 2022 16:17:24 +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 1nMBNK-0000sT-Up for pgsql-hackers@lists.postgresql.org; Mon, 21 Feb 2022 16:17:24 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMBNH-0005ER-Vt for pgsql-hackers@postgresql.org; Mon, 21 Feb 2022 16:17:21 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 99FED3201F85; Mon, 21 Feb 2022 11:17:17 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Mon, 21 Feb 2022 11:17:18 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm3; bh=kkPPVzYomfJAPM4bQ2Z2/El2PsS/k0lIsf5Uww uZUEw=; b=ljxFDmt61KXx1ykiNwegeXGetb16DGU93BmTWuFihxhav0hkFH/YZ3 Ed7S9nzVUTP+I3K8ReskivdkvZx7/c/A31yk8gcDOjGSEUQ3A0zy1BbVEqUB/DFr LxdamXoFOR49NgRA5qQfI4W8of38NgQ5J2Zin0P1+PoTmJCoxjVGzfax2yREl6ia WXi3Giw9K8wnE8t+ApBdpQWEpN/5lv9jJBdAR1BpsC3IehMpbkSb+8JHTK9fXafQ F2/9cdNRkWDimltM1ghPQIwiOtEZWRMHPSa+AKSDMIlJomIXFObJIogfayTJMLJ1 lObLGq4qOScdVYVCd4p7Nfai2DtvagFw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=kkPPVzYomfJAPM4bQ 2Z2/El2PsS/k0lIsf5UwwuZUEw=; b=VZYt/XpIfD7bwBh1KEmw6BWLCnfbJ2EfF FzrSsINPFEltvQS142ZD3oOrd3auOYkmnqo2y+4aWf60/Le8ljZpD6tvAyZ6PEyR n92Sr9jPezx1iDTD0WXdxUcU8jdPD1jDJMUSNZ55mgf6+viAYMW50ItzfaIPFuE5 E8TRO1voJwqEYo4u6urnfNqBT56ypN4nCaS3BfvGltxr/AUo6RJ1F6xxcDArCGvq uXOfLFJlY/Uih3y841Ys1M1HhnRVdJ6CXp3nLh86WphL5YeQaneFN79uG9xOYDkk b/WZ6bq6pkl+4ZvxN8FyJMSBoMb93LJbLsbP9BIdJoyAYrdpMH2fQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrkeeigdekhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughrvghs ucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrfgrth htvghrnhepudekhfekleeugeevteehleffffejgeelueduleeffeeutdelffeujeffhfeu ffdunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprg hnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 21 Feb 2022 11:17:16 -0500 (EST) Date: Mon, 21 Feb 2022 08:17:15 -0800 From: Andres Freund To: Amit Kapila Cc: Masahiko Sawada , "David G. Johnston" , pgsql-hackers Subject: Re: Design of pg_stat_subscription_workers vs pgstats Message-ID: <20220221161715.647j6s65b4nn7owp@alap3.anarazel.de> References: <20220218203255.d3evl6qi2n6gxy6b@alap3.anarazel.de> <20220219160203.y5w2ktc2utthn7pe@alap3.anarazel.de> <20220221053453.lo6fzmji23ennvgj@alap3.anarazel.de> <20220221074806.nyhdberpuwbcbudp@alap3.anarazel.de> 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 2022-02-21 14:49:01 +0530, Amit Kapila wrote: > On Mon, Feb 21, 2022 at 1:18 PM Andres Freund wrote: > > > * stats_reset (Time at which these statistics were last reset) > > > > > > The view name could be pg_stat_subscription_lrep, > > > pg_stat_logical_replication, or something on those lines. > > > > pg_stat_subscription_stats :) > Having *stat* two times in the name sounds slightly odd to me but let > us see what others think. One more option could be > pg_stat_subscription_replication. It was a joke, making light of our bad naming in pg_stat_*, not a serious suggestion... Greetings, Andres Freund