Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: size in bytes of a table?
Date
Msg-id 12514.1108147414@sss.pgh.pa.us
Whole thread Raw
In response to size in bytes of a table?  (Mark Harrison <mh@pixar.com>)
List pgsql-general
Tree view 
Mark Harrison <mh@pixar.com> writes:
> 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)

> Exact numbers don't matter, I just want to present a feel
> for the amount of data we have.

Do a vacuum and then SELECT relname, relpages * 8K, reltuples FROM pg_class

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: size in bytes of a table?
Next
From: "Ignacio Colmenero"
Date:
Subject: ERROR: control reached end of function without RETURN