Mark Harrison <mh@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
