Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEsqp-00AHiP-Ms for pgsql-general@arkaria.postgresql.org; Sat, 23 Nov 2024 16:19:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tEsqo-001ufO-CI for pgsql-general@arkaria.postgresql.org; Sat, 23 Nov 2024 16:19:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEsqm-001ufF-JR for pgsql-general@lists.postgresql.org; Sat, 23 Nov 2024 16:19:14 +0000 Received: from fhigh-b4-smtp.messagingengine.com ([202.12.124.155]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEsqi-003Svk-M6 for pgsql-general@postgresql.org; Sat, 23 Nov 2024 16:19:11 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.stl.internal (Postfix) with ESMTP id EDAA72540158; Sat, 23 Nov 2024 11:19:05 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Sat, 23 Nov 2024 11:19:06 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1732378745; x=1732465145; bh=JP7v/dcEhAXMm4+8kN8DqreVYaxaBp38/zhlhTJE3Qc=; b= igEmWvTaLxLEfNJrFLkTMEkDL9HuMW7uGtqFUpdPqR8hhyCKJac2EwZaMMPlNpS4 PxO5Do0YMeKtq5w+d70902G0AykY2Fk38iHgUnMLCJ153PzrbloGlaq42DxmQ0Eq QxzcqA3jylzWCVgdOs5sMfBKOlRsreRlgDVtcvvsXSn5jDakJ6xOh1tfFqBdTqlI QeQi1InHwiWUIqqqJ4IZmxGQSTLBrVduwdlOkhR9EzMOyPsGwsU+m9+xd/adFIWh +kBIafxNo4E6zW8OE8hGnJBEQRfTl1w8xngMPY7qIbM3EeFMQ/H/VqQCOWgRh1bI uyNElbad535t4VwGS5Kg7w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1732378745; x= 1732465145; bh=JP7v/dcEhAXMm4+8kN8DqreVYaxaBp38/zhlhTJE3Qc=; b=x I9lIf2+pNCFQIf4rvMeMUTcrIWHLPa7kxKvYmRtVc+aGavrnO4QYZxKpO5lM/Z5a jp+alzW3jbpvUyzrN/1Fxbi72jEDlLfVyiO4/ffeIyvFa3463dOMsnvHk7L0dQwG I299i7faDd9tY8mdFdTHYv8x9/xR7G+du7HAcbIixzOAVOuicUFnlcluwhmYsieL am5dtBze4kNoGczvgwbAji2aeiyCI0X6OFL9KS1OAhGErzr2k9KoMp+zXbLMrZhG /LALKlxp5AOwxc3zggdcFAb73M/G8hAwtEx19rYzt3PrkHjVGYlHv38Q9Y0S4RbO evzUwvcnjl5mEjzk7yw1w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrgedugdekiecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeen ucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrse grkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeefgeefieeutdfggfetgefg heekjeehteeileeigfetieekjedvieeviefgheevtdenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhl rghvvghrrdgtohhmpdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprh gtphhtthhopehssghouhhlrghnghgvrhdvleesghhmrghilhdrtghomhdprhgtphhtthho pehrrgihsehrohguohhnnhgvlhhlrdhivgdprhgtphhtthhopehpghhsqhhlqdhgvghnvg hrrghlsehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 23 Nov 2024 11:19:04 -0500 (EST) Message-ID: <793d8f62-fdfe-44d5-b11f-0da978743ccf@aklaver.com> Date: Sat, 23 Nov 2024 08:19:04 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? To: Steeve Boulanger , Ray O'Donnell Cc: pgsql-general References: <6a157286-5948-48ac-bc50-7bb4e65ee5e5@aklaver.com> <38725031-5e80-46ee-b403-a92107b24c39@aklaver.com> <1e2db3f5-00f4-4ec2-800f-46136c2fad59@aklaver.com> <1270021b-c5b5-4ca8-b48d-7dfb163bb6f7@aklaver.com> <9a0d0e80-13e1-421a-9d84-da000fe4433a@aklaver.com> <01020193592431ad-0fedca70-38e9-4fd0-bf49-f5bbf628c76e-000000@eu-west-1.amazonses.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 11/23/24 05:16, Steeve Boulanger wrote: >> Here (Ireland) we sometimes say "common-or-garden variety".... It means a normal, everyday variety. :-) > > I'm afraid that my Irish dialect is limited to "sláinte" only ;-) In > any case, thanks for taking the time to help with this issue. I'm > still investigating, but I think that calling the "ghostbusters" is > moving up the list now lol. I'm guessing shutting down Netdata did not stop the resets? You might try setting log_min_messages to info to see if that catches anything. > > > On Sat, Nov 23, 2024 at 7:09 AM Ray O'Donnell wrote: >> >> On 23/11/2024 13:06, Steeve Boulanger wrote: >> >> -- Adrian Klaver adrian.klaver@aklaver.com