| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Gauri Kanekar <meetgaurikanekar(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Table Size |
| Date: | 2007-01-16 19:24:32 |
| Message-ID: | 45AD2670.7050509@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Haile | 2007-01-16 21:23:00 | PG8.2.1 choosing slow seqscan over idx scan |
| Previous Message | Chris Browne | 2007-01-16 16:10:29 | Re: Caching in PostgreSQL |