Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bondn-0006aT-TS for pgsql-admin@arkaria.postgresql.org; Tue, 27 Sep 2016 08:21:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bondm-0003vQ-Q6 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Sep 2016 08:21:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bondl-0003ul-Vw for pgsql-admin@postgresql.org; Tue, 27 Sep 2016 08:21:26 +0000 Received: from mail4.neteven.com ([5.135.111.119]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bonde-0004v5-PD for pgsql-admin@postgresql.org; Tue, 27 Sep 2016 08:21:24 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail4.neteven.com (Postfix) with ESMTP id AF04914A11FE for ; Tue, 27 Sep 2016 10:21:15 +0200 (CEST) X-DKIM: OpenDKIM Filter v2.6.8 mail4.neteven.com AF04914A11FE DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=neteven.com; s=dkim; t=1474964475; bh=vMcKWSVX3WjK8MyWG208Hdpae4RhmVpg0BCnP+DIsDI=; h=To:From:Subject:Date:From; b=T2X19f0O8bUtmRZSOeCuBq0Qp2fL8XPZmm1fHkF2NJhMTXkgzPNpkou+PEwIrGdoS 7wDr8irdIEGHPTA6EynNfjElk3tWECfwMN/eiajwbar1ttM90ETBewFhnRxcTSrMxu Ys3xltE+E1rre7mP81bAwoIUapBmFcmZOHbk4/k/QnYcBCqFpyLaKsQqHr0anGzMaJ xAFUBgQwS4U1f1ooZOQ7whJcmc+iOBiyZ5wAa6jS79LE47YgbYMnrRoxYFSDTgm54v 1IVhFBgGuXWee+vPJqTtBGNCX78CH7xyuTGx5vapPUcTGJAezzY9HNwXXU/5HCqad2 uFf55yGKwSNWg== X-Virus-Scanned: Debian amavisd-new at mail4.neteven.com Received: from mail4.neteven.com ([127.0.0.1]) by localhost (mail4.neteven.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id kGDSI8VUEQHu for ; Tue, 27 Sep 2016 10:21:15 +0200 (CEST) To: "pgsql-admin@postgresql.org" From: Thomas SIMON Subject: Wrong stat on pg_stat_user_tables Message-ID: Date: Tue, 27 Sep 2016 10:20:59 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.3.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -4.8 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi all, I have strange behavior with a stat of pg_stat_user_tables (explained below), where number of live tuples is not the real number at all. (25M vs 111M) - select n_live_tup, last_autoanalyze from pg_stat_user_tables where relname = 'items' n_live_tup : 111 191 791 last_autoanalyze : 2016-09-27 04:03:35.09233+02 - select count (1) from items; count ---------- 25307071 I've comparated my 10 biggest tables, only this table gave me wrong results. Does anyone have an idea about it ? Thanks -- Thomas -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin