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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lATmK-000449-Tz
	for pgsql-admin@arkaria.postgresql.org; Fri, 12 Feb 2021 08:26:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lATmJ-0001cZ-QD
	for pgsql-admin@arkaria.postgresql.org; Fri, 12 Feb 2021 08:26:15 +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 <vas@sibptus.ru>)
	id 1lATmJ-0001cS-Gz
	for pgsql-admin@lists.postgresql.org; Fri, 12 Feb 2021 08:26:15 +0000
Received: from admin.sibptus.ru ([2001:19f0:5001:21dc::10])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vas@sibptus.ru>)
	id 1lATmG-0003sU-4R
	for pgsql-admin@lists.postgresql.org; Fri, 12 Feb 2021 08:26:14 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=sibptus.ru;
	s=20181118; h=Message-ID:Subject:To:From:Date:In-Reply-To;
	bh=WZzuy33c1mrRnKhiSH4PfkEK1rHOsPGjwHrzKY3ZhNI=; b=EAil/99bqSFOXgLYMWwmoL8xnt
	N5c+igEMpkP2O5D1+GAZaz189yyywMedSFFIp/cPeq0NBYeBPjjcbTlaGfOUlBvlKmuxoY625jale
	amgqJKsTdAPie0QawdhfiDUr0/0j0O0lQdWZtQUybe8MyT4PVkXUOK+t3j4bCT2zi6X0=;
Received: from vas by admin.sibptus.ru with local (Exim 4.94 (FreeBSD))
	(envelope-from <vas@sibptus.ru>)
	id 1lATmC-000MgO-RX
	for pgsql-admin@lists.postgresql.org; Fri, 12 Feb 2021 15:26:08 +0700
Date: Fri, 12 Feb 2021 15:26:08 +0700
From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Subject: index bloat estimation
Message-ID: <YCY7oPIXobbY8oPu@admin.sibptus.ru>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-PGP-Key: http://admin.sibptus.ru/~vas/
X-PGP-Fingerprint: 10E3 1171 1273 E007 C2E9  3532 0DA4 F259 9B5E C634
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Dear Colleagues,

What queries do you use to estimate index and table bloat?

I've researched some on the Net and found multiple scripts mentioned in
https://wiki.postgresql.org/wiki/Index_Maintenance#Index_Bloat, also
in https://github.com/pgexperts/pgx_scripts etc. 

Most of the stuff I've looked at is pretty old, much seems unsupported.
What is the current best practice?

I'd be grateful if you could share your personal favourite ways of
estimating bloat.

-- 
Victor Sudakov,  VAS4-RIPE, VAS47-RIPN
2:5005/49@fidonet http://vas.tomsk.ru/