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