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 1njh4F-0001Jh-KK for pgsql-admin@arkaria.postgresql.org; Wed, 27 Apr 2022 12:46:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1njh4E-0002DF-Cz for pgsql-admin@arkaria.postgresql.org; Wed, 27 Apr 2022 12:46:50 +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 1njh4D-0002Cn-Ov for pgsql-admin@lists.postgresql.org; Wed, 27 Apr 2022 12:46:50 +0000 Received: from mx0a-001b2d01.pphosted.com ([148.163.156.1]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njh4A-0001Ef-Nf for pgsql-admin@lists.postgresql.org; Wed, 27 Apr 2022 12:46:48 +0000 Received: from pps.filterd (m0187473.ppops.net [127.0.0.1]) by mx0a-001b2d01.pphosted.com (8.17.1.5/8.17.1.5) with ESMTP id 23RCi88b023898 for ; Wed, 27 Apr 2022 12:46:45 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ibm.com; h=from : to : date : message-id : references : in-reply-to : content-type : mime-version : subject; s=pp1; bh=NlAJHcG8XLSoLJbWkoUqIDCvffReSpQVu7g1B3xA/jE=; b=Zso29FHztpfdCIQVEflbHH8bAE/wCmgeMskIra9d4Ki8wj4ytWJ/LeELv1hmqEV++IET lO2ikDCKqwGtyt/GmSP8tdge8rfjkwj2gMYqPHTtV+HATcrih+qRNeSAJsRPFmyTFID6 EKqfA8RGpcM4xgHETkDEIr7nR8fkYAzJWIOA5qLSONIFCf8thEzTFBIucBfLuBwBOKXA KZDkWv0gUjbIBsdNNAA73EMMVYPmAXYV8wHZJBMjXt60kzOUPBlJZhqR82ImYNdPJ/zE vzmPtFmkptwd1wDKorSR7YTUS91lU6N7T5/Kg7TndoEcqHC7TeOKB88xjAw1eSpJr0gb dw== Received: from pps.reinject (localhost [127.0.0.1]) by mx0a-001b2d01.pphosted.com (PPS) with ESMTPS id 3fpuk937wd-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Wed, 27 Apr 2022 12:46:45 +0000 Received: from m0187473.ppops.net (m0187473.ppops.net [127.0.0.1]) by pps.reinject (8.17.1.5/8.17.1.5) with ESMTP id 23RCi84g023883 for ; Wed, 27 Apr 2022 12:46:44 GMT Received: from nam10-mw2-obe.outbound.protection.outlook.com (mail-mw2nam10lp2105.outbound.protection.outlook.com [104.47.55.105]) by mx0a-001b2d01.pphosted.com (PPS) with ESMTPS id 3fpuk937w3-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Wed, 27 Apr 2022 12:46:44 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=K5rGhyB9q+PzngxInBXf7JAMUoGNTn2JuDm/XlTSNUxTTtqMUovBHbEG23jhCAmDDx2PeI3Y/22Cr1eiOyNmeWHgguam4Wr15zAIMUDexA0nFojSjW6BQ7Xruh9Ez8z2c4LpB2q2dC3vn9haDvflms9hZKPanlgOfO5z5cVm3dWdwVtEjnvipee+3rNwaRLzeaeZqOmRWU8bnhJBxh6m5J8QyUDblF15ns3HJK1rvXkZofgOkWbHZuyx62FTmu+mTReGg+xaPqRikCa5kbfIF9vCn/5GwUs4YUcfs5uaL8ZYtQD4ziVMRannKydtNvh/NwFXhwS+joXWgPaXIZJmgw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=NlAJHcG8XLSoLJbWkoUqIDCvffReSpQVu7g1B3xA/jE=; b=Nf/MoPd0IkcY9/Syx2hvxH73ZPfwGSGwYIae0zQE5/lzMly1/6BsO8fWfe78D9lOGDuEtAao/8ruJc8VxG62wKtsUWf1UqXUAtW/V95dCNv32Tq5PTljmTc70U/0leh+S9qPjh8LIR0oQv+Fmbz4nfzoFMmCyAg7IugogrOBuJXSCI2o09XTHkw22nqG4eD5o0epW6yxFzrF1XmSy+h1PNyZOC4eLqq76Mg7Li01myQwEYxh5td+qmhK4gitJUPpNq5fyBjbNbra+1BZ4Mmvjz9bWNcTv0Nul3hUmcFA2zu4JifPRqQSuLMVWGQvsRZ9FZ4NToupTzT9hFco5LD1kA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=pt.ibm.com; dmarc=pass action=none header.from=pt.ibm.com; dkim=pass header.d=pt.ibm.com; arc=none Received: from SA0PR15MB3856.namprd15.prod.outlook.com (2603:10b6:806:86::7) by DM6PR15MB2268.namprd15.prod.outlook.com (2603:10b6:5:89::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5186.21; Wed, 27 Apr 2022 12:46:43 +0000 Received: from SA0PR15MB3856.namprd15.prod.outlook.com ([fe80::1008:6e19:2ccc:82c4]) by SA0PR15MB3856.namprd15.prod.outlook.com ([fe80::1008:6e19:2ccc:82c4%6]) with mapi id 15.20.5206.013; Wed, 27 Apr 2022 12:46:43 +0000 From: Adelino Silva To: Nikhil Shetty , Pgsql-admin Thread-Topic: [EXTERNAL] Postgres Stale Statistics Thread-Index: AQHYWidFFwkGrY098UasHhqtlHR+EK0Ds257 Date: Wed, 27 Apr 2022 12:46:43 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: b5d37f66-6cde-4575-e39f-08da284bfb54 x-ms-traffictypediagnostic: DM6PR15MB2268:EE_ x-microsoft-antispam-prvs: x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: oiXfddUprQV4HHnZ4Fa49Va66Uu8tYd8oSIUHM4AR+6V8+I9n0zBo704EuRK6hkclleAFihhikjcrnEAGWjGuM8TVJfcSoDRwyb8RwwlaauomP7dJVNazNRI1TdKs1QbjfvJwpkA9OyisawLGEGtIy3rJgvc1Q7gyYYN01Ofygae+2Q4mtcS6wAeibjBPDD+vT/L7lT1/AC/TZWnlazKVmtM/XhqjTdm++QkY3zrxoeIbCqWgtIEWmiL/Jwxo2u4+4bzZrSVBGXQPmKOawUV54aByrlu8nFpKypQuzWrYAWmvXj7wX4ji1oI2/g0591GGTWdCCsGm4Jdo6+dt5S5rynqDo8l++EcuQwrr2q3sinEJFo3KYHbMKr49rNxjRaWhbIdNvBuKz3iriT5dbwTKeRTvgtiCM7OWwh4IfW66GI1edIvUIXzYGfvXObstCqcSv+roMZI8UNDVY4cEiVPHnhG00zmBkTcu6wU6j0/Ic2xDnbG8bTfuPMAfMtkzhytnWWfeoukgnzBvIIc3DHTNrdMRHw4v7jJ9DYcltTwKiyQXkIBaUKWqSapdrbGTprhXe1Zd2/Zwr2p/BiEN8s5zPVCiav6aEVBVTG7jOBKX5Emqb0VXVi3U5ADZ99Tb9OctLRE/HfeCTU7Mgj8dwhx9miHwFItdIMiZ/mdR7aFmtQ6Hpu+dZj8Vb3IvVqqzYoNCl9K6AV3oGICk16jg39ia9QLb68huGTC+uSjFeVXTZwp8nnj+jDfjCUaIlj50e/SD6u4zQMHwijL3Q5+pQSoo5+UaxA0amsxp8v7YFU7LiY= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SA0PR15MB3856.namprd15.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(366004)(19627405001)(110136005)(55016003)(122000001)(5660300002)(38100700002)(7696005)(8936002)(166002)(15974865002)(316002)(52536014)(33656002)(38070700005)(966005)(44832011)(66556008)(64756008)(66446008)(9686003)(186003)(6506007)(66476007)(53546011)(8676002)(508600001)(71200400001)(83380400001)(40265005)(76116006)(86362001)(2906002)(66946007)(91956017);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 2 x-ms-exchange-antispam-messagedata-0: =?Windows-1252?Q?ge07jy8wK6V8VytkjlL/LV9RlG5VGnfz6mmM9LRUcM1yI8hce4dHtHoE?= =?Windows-1252?Q?5V1KF/takmt14aMS7pE7HsC5YWGKQhF8IU89xPtOfpJa2HrL4qkx+pzZ?= =?Windows-1252?Q?BIG57UHP0+zbEl9vBG2gDoNxDFSLRG3zI4DTvgI5GTA9Ipf2dXkgB8oR?= =?Windows-1252?Q?GA6lxefFvYTAd4LOs7rw2QjN/412pKNcuD8vGoG2V1Qe44tmMrEwiuif?= =?Windows-1252?Q?oCI3bQcnwuyjKqLPJp2uTfCtcirAhIMBdMjzDU3F2Quo4LTgB2MxNX8G?= =?Windows-1252?Q?nI16c/9Rp0uhecD5ONo63T8oZDK/I77elHEqjTHpolbQJON+eY/y2FlM?= =?Windows-1252?Q?MNAoJD6nlI/I2so8ZA2r7k7DOz1rA+yG51cpT2RQ5P0BLojsbw+gT5Qy?= =?Windows-1252?Q?IcRHOB3nexjB2FkMLkaQ0kXeO4Ve5wx93RjzamO+e+XjVRjkWNrkzH8M?= =?Windows-1252?Q?EI0Gq/5Lw+keNrC7axWOAOXDVsDaNOafH95OVwsP5ksUtfol3vV6OWIL?= =?Windows-1252?Q?XdTH03Zy5VtE+2a0MHQ5FHIdN6l9UXNzVkyVoc31QDR8MNlqkqOIKBFq?= =?Windows-1252?Q?/l3ICfOrNN78R4gsdJs0Qsso8/OgytxUOWFofXEH3f/GCuxmhMmPd9G0?= =?Windows-1252?Q?zChoF8LOvdqSv/IpdLt2KTgnvLwuNlDzNwCCPf7DNJJ+zIA1zdTz/HrZ?= =?Windows-1252?Q?bYrR4VUQ3JuseGlSoCa9txFZyLqESZAbLP1Gy1KMZ97Lf0UEuK/LtMk7?= =?Windows-1252?Q?KmJd9LkgcVSQmyC5qHC+3vE8UKmf2+fK69Un03bEnEFYWNVbZULhWfs0?= =?Windows-1252?Q?tQ1qmrRjY8VmnEVIKq1eORVY3bntFFj9KBFfnyqCX2OZC6GvhOqQ69gL?= =?Windows-1252?Q?1ptBUTd0cS2Vym4dtJl090GBYo6K2PO++T4tMcQ101sJ6F8RzI3o6jaq?= =?Windows-1252?Q?e8/Agbjq6PUAOKJ2dYSAKLAMBprPbyGJpU5p9vkB5UCGOmg/02KEiAQp?= =?Windows-1252?Q?MbeRGTXwBkUHRV+VNSgtF4Re6jAvJSj/QRV5NXMR5LBhuvq1GakyxA2P?= =?Windows-1252?Q?pzUr5HIkKq3BuYvlIcg793y4vsgGc6+gG8d0MLkh1XRYJSoH41mWUC/x?= =?Windows-1252?Q?nRJHJQU40UQ2IrZ6g/WCacDo0Q41iNFQ9xUBjjsa7TztvCtYCjVCdtgJ?= =?Windows-1252?Q?TAKr0ianCeipzZ2KtHoqPI2RxiRLKtcSSO5uQpbRpYyJWmBsmvEQ5ZvB?= =?Windows-1252?Q?2C+rndQ82kFBMtKayC5oiYMPAmEPYmJe37BBJsOlkgxaBOU+2WBgaalY?= =?Windows-1252?Q?1oZj57udWFIQlBQBaiISFKoXQG/xSHMIEEZSlVx0VMFa1r8EmdMnG5Uz?= =?Windows-1252?Q?IP2lKxuXR47LjGiCPyHYLVLokZCAwrsu9mTOt/Gu5uda4uCGeTiQLrbc?= =?Windows-1252?Q?hiJ8VAZDNluKgw3Th2qFzpdggaDQU7QleNG/1L6B4+0AEemPQgt92BzC?= =?Windows-1252?Q?/sFNU7LqyfIE7ENGN+V854AgDAIx3D9tCbAscrveH2B0BRTCFVGnom/x?= =?Windows-1252?Q?g4Mr9JqgolHhK2nDE8RQOzrXuDPzf9F52UR8o1V/xPVja/z1jytJCV5K?= =?Windows-1252?Q?veIqcxxOlyqbbTbFX71Dx5C9QS6lnOBFESjTf/e6ei1GHKxooI/TU5Ep?= =?Windows-1252?Q?mxSwW1y+nw40s2aMrq+EkBXLA9wBcB5hL/1HvqtwQzLplHbQdyFGr0Me?= =?Windows-1252?Q?1Yps8xGPDuQROoHIt4wB/dTUsDeQ/fh63UwFp5uef8ALLcpLzduSiJGU?= =?Windows-1252?Q?rsR2KWNLap1w/SZXFz9MrOa4n76nacwCsjilWGFA0rY1ZP/RhtB4a1KW?= =?Windows-1252?Q?XZcOaFUtG3RKOp7IR0yDEMhHOmUK44cy+IsGMyUgYcrNzs7chFMlsRnv?= =?Windows-1252?Q?k9x1CGpT?= x-ms-exchange-antispam-messagedata-1: MQ6MNFVOtKVS9g== Content-Type: multipart/alternative; boundary="_000_SA0PR15MB3856E1C18660DE3F01942DAED2FA9SA0PR15MB3856namp_" X-OriginatorOrg: PT.ibm.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SA0PR15MB3856.namprd15.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: b5d37f66-6cde-4575-e39f-08da284bfb54 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Apr 2022 12:46:43.0336 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: fcf67057-50c9-4ad4-98f3-ffca64add9e9 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: TwqqOgKF0CR2mYWk5wYRgLX9n3tat7hTWqhYn+2xAT1iPCgQFAkXpk7srzDCwqiv4LFJuEF6DbkS9bqdFXj1QOXPkAsxupE4XDU84w+BMkA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM6PR15MB2268 X-Proofpoint-ORIG-GUID: yVMIIvXoXjDA8LdkK0fwESp3EO5Bb4Xv X-Proofpoint-GUID: WJPgqRF-q7foQi037wnzjhBNhBnkazjT X-Proofpoint-UnRewURL: 0 URL was un-rewritten MIME-Version: 1.0 Subject: Re: Postgres Stale Statistics X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.205,Aquarius:18.0.858,Hydra:6.0.486,FMLib:17.11.64.514 definitions=2022-04-27_04,2022-04-27_01,2022-02-23_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 malwarescore=0 mlxscore=0 spamscore=0 bulkscore=0 suspectscore=0 clxscore=1011 mlxlogscore=999 impostorscore=0 adultscore=0 phishscore=0 priorityscore=1501 lowpriorityscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2202240000 definitions=main-2204270082 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SA0PR15MB3856E1C18660DE3F01942DAED2FA9SA0PR15MB3856namp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi, Found this thread that explains the warning. using stale statistics instead of current ones because stats collector is n= ot responding https://www.postgresql.org/message-id/1457523467.24545.43.camel@2ndquadrant= .com [https://www.postgresql.org/media-archives/img/about/press/elephant.png] PostgreSQL: Re: using stale statistics instead of current ones because stat= s collector is not responding Hi, On Tue, 2016-03-08 at 16:18 -0800, Tory M Blue wrote: > No hits on the = intratubes on this. > =85 www.postgresql.org Regards, Adelino Silva ________________________________ From: Nikhil Shetty Sent: Wednesday, April 27, 2022 12:08 PM To: Pgsql-admin Subject: [EXTERNAL] Postgres Stale Statistics Hi, We are getting below WARNING on one of the standby instances. Not sure = what caused it but to resolve it we tried restarting the database instances= but it is still not working WARNING - using stale statistics instead of cu= rrent ones because ZjQcmQRYFpfptBannerStart This Message Is From an External Sender This message came from outside your organization. ZjQcmQRYFpfptBannerEnd Hi, We are getting below WARNING on one of the standby instances. Not sure what= caused it but to resolve it we tried restarting the database instances but= it is still not working WARNING - using stale statistics instead of current ones because stats coll= ector is not responding Postgresql version - 11.7 Any other option to resolve this? We are thinking of building the standby a= gain but what if the WARNING is for a primary database instance and a resta= rt won't solve it? Thanks and Regards, Nikhil --_000_SA0PR15MB3856E1C18660DE3F01942DAED2FA9SA0PR15MB3856namp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi,

Found this thread that explains the warning.

using stale statistics instead of current ones because stats collector is n= ot responding

3D""
Hi, On Tue, 2016-03-08 at 16:18 -0800, Tory M Blue wrote: > No hits on t= he intratubes on this. > =85
www.postgresql.org


Regards,

Adelino Silva

From: Nikhil Shetty <nik= hil.dba04@gmail.com>
Sent: Wednesday, April 27, 2022 12:08 PM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Postgres Stale Statistics
 
Hi, We are getting below WARNING on one of the standby instances.= Not sure what caused it but to resolve it we tried restarting the database= instances but it is still not working WARNING - using stale statistics ins= tead of current ones because
ZjQcmQRYFpfptBannerStart
This Message Is From an External Sender
This message came from outside your organization.
 
ZjQcmQRYFpfptBannerEnd
Hi,

We are getting below WARNING on one of the standby instances. Not= sure what caused it but to resolve it we tried restarting the database ins= tances but it is still not working


WARNING - using stale statistics instead of current ones because stats coll= ector is not responding


Postgresql version - 11.7


Any other option to resolve this? We are thinking of building the standby a= gain but what if the WARNING is for a primary database instance and a resta= rt won't solve it?


Thanks and Regards,

Nikhil

--_000_SA0PR15MB3856E1C18660DE3F01942DAED2FA9SA0PR15MB3856namp_--