size in bytes of a table?

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/

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