Re: Table Size - Mailing list pgsql-performance

Gauri Kanekar wrote:
> Hi,
>
> Can anybody help me out to get following info of all the tables in a
> database.

1. Have you read up on the information schema and system catalogues?
http://www.postgresql.org/docs/8.2/static/catalogs.html
http://www.postgresql.org/docs/8.2/static/catalogs.html


> table_len
> tuple_count
> tuple_len

2. Not sure what the difference is between "len" and "count" here.

> tuple_percent

3. Or what this "percent" refers to.

> dead_tuple_count
> dead_tuple_len
> dead_tuple_percent
> free_space
> free_percent

4. You might find some of the stats tables useful too:
http://www.postgresql.org/docs/8.2/static/monitoring-stats.html

--
   Richard Huxton
   Archonet Ltd