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