Skip site navigation (1) Skip section navigation (2)

Re: Finding bloated indexes?

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Dan Harris" <fbsd(at)drivefaster(dot)net>
Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Finding bloated indexes?
Date: 2007-04-14 08:27:25
Message-ID: 1176539246.3635.317.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, 2007-04-13 at 14:01 -0600, Dan Harris wrote:
> 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.

Use pgstatindex in contrib/pgstattuple

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com



In response to

pgsql-performance by date

Next:From: Dann CorbitDate: 2007-04-14 09:04:24
Subject: Re: choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Previous:From: Simon RiggsDate: 2007-04-14 08:24:07
Subject: Re: choose_bitmap_and again (was Re: [PERFORM] StrangelyVariable Query Performance)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group