Postgres Pro
Downloads
Home   >   mailing lists

Re: Determining dead/unused space in a table? - Mailing list pgsql-general

From Tom Lane
Subject Re: Determining dead/unused space in a table?
Date
Msg-id 6823.1255881197@sss.pgh.pa.us
Whole thread Raw
In response to Determining dead/unused space in a table?  (David Spadea <david.spadea@gmail.com>)
List pgsql-general
Tree view 
David Spadea <david.spadea@gmail.com> writes:
> I'm looking to do some reporting on tablespace usage, and wanted to be able
> to determine how much of the space a table physically occupies is actually
> in use.

contrib/pgstattuple can help you with this.

            regards, tom lane

pgsql-general by date:

Previous
From: David Spadea
Date:
Subject: Determining dead/unused space in a table?
Next
From: Raymond O'Donnell
Date:
Subject: Re: How ad an increasing index to a query result?