Re: size in bytes of a table? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: size in bytes of a table?
Date
Msg-id 20050211184144.GA32427@winnie.fuhr.org
Whole thread Raw
In response to size in bytes of a table?  (Mark Harrison <mh@pixar.com>)
List pgsql-general
On Fri, Feb 11, 2005 at 10:20:47AM -0800, Mark Harrison wrote:

> I'd like to present some statistics on our database tables,
> showing the number of rows and approximate amount of data
> in bytes, e.g. something like this from one of our other
> databases:
>
> tasks  (546916 Kb,62018 rows)

Take a look at contrib/dbsize and contrib/pgstattuple.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: NosyMan
Date:
Subject: test datatype for ANY
Next
From: Tom Lane
Date:
Subject: Re: size in bytes of a table?