Finding bloated indexes? - Mailing list pgsql-performance

From Dan Harris
Subject Finding bloated indexes?
Date
Msg-id 461FE1A4.70908@drivefaster.net
Whole thread Raw
Responses Re: Finding bloated indexes?  (Vivek Khera <vivek@khera.org>)
Re: Finding bloated indexes?  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-performance
Is there a pg_stat_* table or the like that will show how bloated an index is?
I am trying to squeeze some disk space and want to track down where the worst
offenders are before performing a global REINDEX on all tables, as the database
is rougly 400GB on disk and this takes a very long time to run.

I have been able to do this with tables, using a helpful view posted to this
list a few months back, but I'm not sure if I can get the same results on indexes.

Thanks

-Dan

pgsql-performance by date:

Previous
From: Carlos Moreno
Date:
Subject: Re: Question about memory allocations
Next
From: "Jan de Visser"
Date:
Subject: Re: Question about memory allocations