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
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных