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 1quHae-00HRMZ-9C for pgsql-admin@arkaria.postgresql.org; Sat, 21 Oct 2023 19:24:52 +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 1quHaa-005vtJ-CL for pgsql-admin@arkaria.postgresql.org; Sat, 21 Oct 2023 19:24:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1quHaZ-005vtB-Ep for pgsql-admin@lists.postgresql.org; Sat, 21 Oct 2023 19:24:48 +0000 Received: from mail-bl0gcc02on20731.outbound.protection.outlook.com ([2a01:111:f400:7d05::731] helo=GCC02-BL0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1quHaU-001dAk-Ic for pgsql-admin@postgresql.org; Sat, 21 Oct 2023 19:24:46 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=DfPq5IH2Eah5SBiM5Fr/iEoH2icWj/MqeI0s7Sos/6Zwn6ZRAOiDZCEkfwODNmvTnBCmDmY5Hzii4en2TVPPI87k49bpEEmq9guw/zlaNq5JrhWwuUDLNZS9fisVulNMSxmrOIQSR4q8dc+H6VQyXCcevu490qFCHZ0TUqNY7g/FOPXr2WPVXNT5ko5OE+n8N443OkFRTtpYNW0ucvWcHYP68JP7KADLXWfdwUNNdVqwSKCjEEjYf6DPJB4N6zsSpdjLC2sZQLaxLlRZaN5W0KprjsbjFLg+3LHzX+zosYzsHL3EhM5A4GVbAVGqpaG9j+aowEQx3a3Kk+qaFv+lGg== 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=X8kS8IAUOy5KbA8g+K8YSNKIcP2+vuLaRYKsYxQ9QO8=; b=Wd8XNBK5QO1YreokdhjLtwVXOh2LKkGgtBYvqBVjRcdO/ZLYCCXgf2lxBP98NPNX6Mq1xLEhRY8gcgPv+dd5rlGTmoYNzAxIATgEB2xVvwQav8L0mYWHObrh+RTOoH8WBviE7Ygm0LaYr8gNs3m1ncMSJpAvS97NVKsJHsBUSnId6/zGAnLFO7JwV7TrimIA5vT2yhH3QOkP2nNbTc5RdOnYx1pTadr09nNJmAfO+RHFBjX2N8U2WPBE6gGRbjBKeJHwc16uM2syxKG5s6LcTVx11BwOxv9AfklUU+C4x9E7XmTIFiKu/0u4o+IsYeHYwqsGASpcugQXBz0vbVQ5Tg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fnal.gov; dmarc=pass action=none header.from=fnal.gov; dkim=pass header.d=fnal.gov; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fnal.gov; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=X8kS8IAUOy5KbA8g+K8YSNKIcP2+vuLaRYKsYxQ9QO8=; b=Ci3NhdsHFUmgXJbaz9/b7baPw/+GUxKujFsuZxgH3GWGDlfDB65fbL+gwOIkztR3qVyAdzHTlj3MP4v4j76qEMFCLOQKkJSfU7RLP0bLcH21xxZclGl8N5NmXZZDmSuUyp5mQ2ZToVDNAI4m9cCMyphQ7t2NKcmwH/b2E3ZQXs8YbvZpZZMDZmMgun7kIpAHiv8qL9ruUgvv05L7Q0VSUDeQI3X5XJXUoAoqHKie7+PYPupa6Vszj/2qhVYSnEeT3y6dv+H5j1Q+btZDgcozcDt7oeHprN7OS1hyzTFdIVDeBVxg8IPnihSoKpcIABsuPoCXeozJVkZFzVJ6nF+mmQ== Received: from DM8PR09MB6677.namprd09.prod.outlook.com (2603:10b6:5:2ee::12) by BLAPR09MB7283.namprd09.prod.outlook.com (2603:10b6:208:2a8::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6907.26; Sat, 21 Oct 2023 19:24:34 +0000 Received: from DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::c68c:f3f6:717e:1eda]) by DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::c68c:f3f6:717e:1eda%3]) with mapi id 15.20.6907.025; Sat, 21 Oct 2023 19:24:34 +0000 From: Murthy Nunna To: "pgsql-admin@postgresql.org" Subject: autovacuum query Thread-Topic: autovacuum query Thread-Index: AdoEU9efhaNRl0y6SSWL58J3/oPTbQ== Date: Sat, 21 Oct 2023 19:24:34 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fnal.gov; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM8PR09MB6677:EE_|BLAPR09MB7283:EE_ x-ms-office365-filtering-correlation-id: f61d7b91-ccc9-4f25-bd28-08dbd26b5bb4 x-fermilab-sender-location: inside x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: ScvGCsxgViVsv/M1YD0kU32AydVeyn+vVwChtQNlLON6cVcnkDPhvNXRJlu91Pgm8a8fyKG865vsusrTeRI0QprrEaS+noSt4V/f7gONvGjoJ8mTk9qgCBANvXkjcWlqt0YCSlOVpU6g8I4ujA/nySBxGdN0PmvvBp7eiBrKlFuCgWQJO0zkAJjQRgHIC4yUti23H/4T1mQB1SY9HM6CCqhDX1FrJOiCaHx/Gh/Kz8sXMRt8iyxZAdM5OgUOjKd7IRcfO58r8IJ1CQH14oJd7Hd9sOL8n5oxa2/c416n7KfVIsuLuLdkK5ZP0YjVZBeVkdjhbK6p0iBjBMoWU9aUxUhx5hrfx9nJTfyUYJhOD7kGzx/+ub6FcqUq/ERBxCHzn+peYyGp1i3OMeh2+Ubd++aGT/9speKi56ITBmiyw+MJzTQlFslaunFnhWIK10fjlGsqR20LJQ6P85Y9VaQRGIeDOuzb92V/Hf2ZV7/9UqBikrWBUKUG1ABQ5jdQVDMvsPlHcCNCg+5gEbpxdjAW0dsNVrGtgcAX55cddBCf/6RBXLWbPPrUn+8fxqmX8ZtkWZrOIvSzvncaSFXihzMaiyXbpBk0xBYEu+Mnd4i7A2pBJlEKCW+Ip9wRU65tOSTB x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DM8PR09MB6677.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366004)(230922051799003)(451199024)(1800799009)(186009)(9686003)(55016003)(8676002)(66446008)(66476007)(76116006)(66946007)(6916009)(66556008)(9326002)(558084003)(71200400001)(508600001)(33656002)(64756008)(86362001)(7696005)(5660300002)(2906002)(38100700002)(52536014)(122000001)(3480700007)(6506007)(8936002)(7116003)(26005)(82960400001)(38070700009);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?dvxK0LG7a5qRycacDxp04FD4Ym1JRI0G0a8XcDDoSe560RSLw746IWQn2lLv?= =?us-ascii?Q?FdauOyguhemdJv5Wv8I1gxTDdfPDC9CXGhG1R58J9Snfl0oGsEHrZoaZ6EXd?= =?us-ascii?Q?8fBH8/SDnKsj/klxddq8yK1K8vxaqvSvrDaFFzulmG/iiBVaVf9HlbnmX9kI?= =?us-ascii?Q?kW5bpUfRFPXMmBnOmh+sWMlMA7dL1SOKmW86WbsS/pEzq4CT+F7pwKIH1WkT?= =?us-ascii?Q?SIKQq0iIZRQtmYkFuk1AxTiAFkZlyojmi4k6wxNMkPRLOxuMB1fE+cs3hL04?= =?us-ascii?Q?4ZRdX78Il2AGhAxINEm5v3hYFaFhb7BUIOyk6HO+KJ+eNbWkT3B4NrhGEnrU?= =?us-ascii?Q?zaVbLHAbZHFnx0hliBRm1cVUD0s8Qr/74BqO+ATCEDy83ClQz2H9TmKbw3c3?= =?us-ascii?Q?43rJ3DggNagWni2r2Ju9+XeocdZECdkP0gRvwX0FN+s6cFiDdp7U5QWfB+EZ?= =?us-ascii?Q?wnLsrP6uXqCcy9+1/hcS9ZJozu7f9nh/YPQJPK3zV1jrY1tYFIaaYhWhzEHb?= =?us-ascii?Q?HvidGjENb9TAGNuDU3n1l0yXDBT/kpvGTD3sV9fT4y7HpIx+os+gpLUKbMRe?= =?us-ascii?Q?C2pl9xIP3ZNklsA67FyRmpP6k1pZadwJ8I8xYwCM5MiiNYvTAguZ9Xgo3THo?= =?us-ascii?Q?5mF2mB/RZGFiOpYsPkAEwNDF4Bdk9VHZBoAk+S0/y2A9bEvI2G/xJfj3yEqp?= =?us-ascii?Q?amum0Pf7uzaQlj8ia5/LrNRFBiO1yorh9f3Bs9+aNETs0Pf0wbMedzIxoo1R?= =?us-ascii?Q?rFCffk2FYsQVuihdq6M8zuPOqlVbDHV9TbxuYCS7z3xpMnGjhjqi3IpgAldX?= =?us-ascii?Q?rQBWgI+pcAGR1ToD4M9QpSaRVD86MvHFUgSvwdi12vTPDHZdAv6dP2/rRJQ+?= =?us-ascii?Q?onv3Dm98ELNouGC+UtrutyJ1msqdLsvMlDifAb+cHEY4r+P7l9fGwRwYBZqz?= =?us-ascii?Q?OD0ElmdM8ieMkeTudISA337itUn+ENMCDu9cXNXVN55Y3sEnrkgCiifczB4e?= =?us-ascii?Q?j6/pfoD37/uTAyykKGkNhNVb+bTeM3yHHJUBAOv+Q+2WAMOKHBsZiuJ0NZK8?= =?us-ascii?Q?Rldj2xdDAmvRyVi32PZ4/zpjAPlmjRHHvQaAwD5DNukCIC/6GxwWGiY2UlJS?= =?us-ascii?Q?mK5SVhOCK8Rkv49qoefgJruCe8mJ5GHZCxYeIGyUez21/4CpGdMqFTWkhhOF?= =?us-ascii?Q?4lAFoMHPpFaHo4zM0tjyyJkt7c6p7uQIVIHUUMbeJSE/7ejc6xgS9Q3KCipa?= =?us-ascii?Q?dvxIDUF8KIDdfJ2G7zipaLpmZcnN7PuuRQML9nh7nks6Sp0KVF+ju4GcIBxK?= =?us-ascii?Q?Lqens1ZZVAxlN5cbmqMy/mvrdJqThozuVfRINBym05/tgCEB0W/VLbZApdDS?= =?us-ascii?Q?MxK9ka3033GxktcV6AWb7YmLzwLDeh/pLes5dxx99GS26vzTNRM5ihZBOd36?= =?us-ascii?Q?gUhFYACX9wzk6ZOMsQHH/kMx10cpDazYztgItw3jBwcynCFJoeZCCA6ZtcuR?= =?us-ascii?Q?c9UBThXsualo25u2TarLi1ljJ3WPQfJFpW0Nf4VLJM2b5q0AQULE5JWhIjej?= =?us-ascii?Q?xo3RUkAeFgb7asuAHXtLWiHmpXND33dUwBQ6+lP1?= Content-Type: multipart/alternative; boundary="_000_DM8PR09MB667700A517F82F4FB91AF261B8DAADM8PR09MB6677namp_" MIME-Version: 1.0 X-OriginatorOrg: fnal.gov X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DM8PR09MB6677.namprd09.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: f61d7b91-ccc9-4f25-bd28-08dbd26b5bb4 X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Oct 2023 19:24:34.4639 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a X-MS-Exchange-Transport-CrossTenantHeadersStamped: BLAPR09MB7283 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DM8PR09MB667700A517F82F4FB91AF261B8DAADM8PR09MB6677namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I am wondering if anybody has query to list tables that will become eligibl= e for autovacuum in next cycle of autovacuum. Thanks. --_000_DM8PR09MB667700A517F82F4FB91AF261B8DAADM8PR09MB6677namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am wondering if a= nybody has query to list tables that will become eligible for autovacuum in= next cycle of autovacuum.

 

Thanks.<= /span>

--_000_DM8PR09MB667700A517F82F4FB91AF261B8DAADM8PR09MB6677namp_--