Clemens Schwaighofer gullevek

I like code

gullevek / New New Index Bloat Query

Last active July 25, 2022 17:35 — forked from mbanck/New New Index Bloat Query

This version uses pg_stats and not pg_statistics so any user can use this query

	WITH btree_index_atts AS (
	SELECT nspname, relname, reltuples, relpages, indrelid, relam,
	regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
	indexrelid as index_oid
	FROM pg_index
	JOIN pg_class ON pg_class.oid=pg_index.indexrelid
	JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
	JOIN pg_am ON pg_class.relam = pg_am.oid
	WHERE pg_am.amname = 'btree'
	),