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
