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 1njiKY-0005rn-3l for pgsql-admin@arkaria.postgresql.org; Wed, 27 Apr 2022 14:07:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1njiKW-0007RO-Kg for pgsql-admin@arkaria.postgresql.org; Wed, 27 Apr 2022 14:07:44 +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 1njiKW-0007RE-8M for pgsql-admin@lists.postgresql.org; Wed, 27 Apr 2022 14:07:44 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1njiKT-0001xa-W9 for pgsql-admin@lists.postgresql.org; Wed, 27 Apr 2022 14:07:43 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id f38so3606651ybi.3 for ; Wed, 27 Apr 2022 07:07:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=61E6IUIkBVskrIKWA3zKGnYLwaNjav6RB0y0EULYW9g=; b=J7ypjwDWpivFf2ZNMRpJ8HxoqbNhbpPd8+kTq4R05bC+bcJM44X2AYQdIbB1zi976S vLxxelXayV2Bjgz4yTGm1XKTgwXt1m12onItoOf4f5M6vvBS49sYQ2Ba5kjgrTPwKP9Z 1Ln2cst/Xyp32mF1zWcOl+ncVU4D2w41AS3LGgnHvJYtF71VSbs9dY+iarJh/9vNql1t GypGK1X72k48rdY66lAQ9YabG9VEVBA4Ihg86tyLarZ4WccBTfGtpozCxiD2lt+u9v1U p+m2kP9Xuh9d3cB5CwA0GhRAXCQy27kLol8i/cDa53LGZlHqHw6ELVPR8IIDpfZN/U2w QJzw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=61E6IUIkBVskrIKWA3zKGnYLwaNjav6RB0y0EULYW9g=; b=uxrZawl0NFtGyLwzi/vq3Sp3YP9DyUdcCBUptIUVJnsn0qzocQPSR6dz0b29cPvZdb Xz4sDelb9muZAnOo2CMjwe+dWW71cZnuoWOY1+LstjQumAyeaKb8k4WP92m5tEk+WNIY TqmAwHaJtQBqk16Ov6V6ezfaJADRITUKfCdltdtn+7ZvVV87R+QPctgUsDO5msUyXeq5 bitLwZHyoPgGSC1XPTR+V7rG9pfvZUrQbhQzWFqX10xrDDdfgWYRbwPz83A5UVOOx8P3 vFaroa/rsskNN/RpcugRq2B9qnhIMRX4VRBYSkal6KXc4wMbIlPy1sOFwEa5pJwAT491 VR3A== X-Gm-Message-State: AOAM531F9U51yt1SDjfev9dCIfaDI9h8YLbZZBGrWIrTVwMxGIec4/4K 1rrcLhxndIj3EjOFzARONetNlbPM7rSZqywlrw== X-Google-Smtp-Source: ABdhPJx8uxo2h7PphIqAjcLKzsG1XwmU4aa3wlQZL4DJ/UXGufIxXDbq4mIpt/9EKMRLIqICBjl4tYHm6h49SQLYMM0= X-Received: by 2002:a05:6902:693:b0:648:48de:bd8c with SMTP id i19-20020a056902069300b0064848debd8cmr16910019ybt.215.1651068461072; Wed, 27 Apr 2022 07:07:41 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jeff Janes Date: Wed, 27 Apr 2022 10:07:30 -0400 Message-ID: Subject: Re: Postgres Stale Statistics To: Nikhil Shetty Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000001f439e05dda35581" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001f439e05dda35581 Content-Type: text/plain; charset="UTF-8" On Wed, Apr 27, 2022 at 7:09 AM Nikhil Shetty wrote: > 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 > collector is not responding > > > Postgresql version - 11.7 > > > Any other option to resolve this? > If it is always present (not just when IO is overwhelmed) maybe it has an internal firewall blocking UDP on 127.0.0.1. Cheers, Jeff > --0000000000001f439e05dda35581 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable --0000000000001f439e05dda35581--