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 1sg5En-00FBxO-Qx for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Aug 2024 16:28:09 +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 1sg5Em-000Hpy-1J for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Aug 2024 16:28:08 +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 1sg5El-000Hpq-Nu for pgsql-hackers@lists.postgresql.org; Mon, 19 Aug 2024 16:28:08 +0000 Received: from forward101b.mail.yandex.net ([178.154.239.148]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sg5Ei-000TUW-HT for pgsql-hackers@postgresql.org; Mon, 19 Aug 2024 16:28:07 +0000 Received: from mail-nwsmtp-smtp-production-main-92.myt.yp-c.yandex.net (mail-nwsmtp-smtp-production-main-92.myt.yp-c.yandex.net [IPv6:2a02:6b8:c12:2306:0:640:cefc:0]) by forward101b.mail.yandex.net (Yandex) with ESMTPS id 9DEC4608E1; Mon, 19 Aug 2024 19:28:04 +0300 (MSK) Received: by mail-nwsmtp-smtp-production-main-92.myt.yp-c.yandex.net (smtp/Yandex) with ESMTPSA id 0SPJ1gqOiW20-6tvrfgCx; Mon, 19 Aug 2024 19:28:03 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=tantorlabs.com; s=mail; t=1724084884; bh=YYUO9qy3VS7LAXHa9o4pm1BZuTCUIlRCw2Sb/r64xLY=; h=From:In-Reply-To:Cc:Date:References:To:Subject:Message-ID; b=HGFPdiO8hoOUCfVcQcX81gwFKvFOYw3uKm0cZT0v0oadCDGAGVy+ciLYWRLg/n1X4 SQm9ufxZS6yWHf1DFpjaMuG6Fb5rbdha6RluX09o0kR2FR1KvRuzoijFN1pR/FYqBn VbG8oRT6BrMRckdBwaB3T3uMOopQxpboCYiAaE6o= Authentication-Results: mail-nwsmtp-smtp-production-main-92.myt.yp-c.yandex.net; dkim=pass header.i=@tantorlabs.com Message-ID: <092adec6-4eae-4bd4-bd0d-473a9df1282b@tantorlabs.com> Date: Mon, 19 Aug 2024 19:28:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Vacuum statistics To: Alena Rybakina Cc: Andrei Zubkov , Alena Rybakina , pgsql-hackers , a.lepikhov@postgrespro.ru, jian he References: <53c47c2d-72a5-44f2-900c-9973b2af1808@tantorlabs.com> <4a902cea-54fb-41b5-b208-b84731a5f577@postgrespro.ru> Content-Language: en-US From: Ilia Evdokimov 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 Are you certain that all tables are included in `pg_stat_vacuum_tables`? I'm asking because of the following: SELECT count(*) FROM pg_stat_all_tables ;  count -------    108 (1 row) SELECT count(*) FROM pg_stat_vacuum_tables ;  count -------     20 (1 row) -- Regards, Ilia Evdokimov, Tantor Labs LCC.