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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
