pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Table Size 3+ messages / 3 participants [nested] [flat]
* Table Size @ 2007-01-16 13:48 Gauri Kanekar <meetgaurikanekar@gmail.com> 2007-01-16 19:24 ` Re: Table Size Richard Huxton <dev@archonet.com> 0 siblings, 1 reply; 3+ messages in thread From: Gauri Kanekar @ 2007-01-16 13:48 UTC (permalink / raw) To: pgsql-performance Hi, Can anybody help me out to get following info of all the tables in a database. table_len tuple_count tuple_len tuple_percent dead_tuple_count dead_tuple_len dead_tuple_percent free_space free_percent Thanks Gauri ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Table Size 2007-01-16 13:48 Table Size Gauri Kanekar <meetgaurikanekar@gmail.com> @ 2007-01-16 19:24 ` Richard Huxton <dev@archonet.com> 2007-01-17 06:37 ` Re: Table Size Guillaume Lelarge <guillaume@lelarge.info> 0 siblings, 1 reply; 3+ messages in thread From: Richard Huxton @ 2007-01-16 19:24 UTC (permalink / raw) To: Gauri Kanekar <meetgaurikanekar@gmail.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Table Size 2007-01-16 13:48 Table Size Gauri Kanekar <meetgaurikanekar@gmail.com> 2007-01-16 19:24 ` Re: Table Size Richard Huxton <dev@archonet.com> @ 2007-01-17 06:37 ` Guillaume Lelarge <guillaume@lelarge.info> 0 siblings, 0 replies; 3+ messages in thread From: Guillaume Lelarge @ 2007-01-17 06:37 UTC (permalink / raw) To: Richard Huxton <dev@archonet.com>; +Cc: Gauri Kanekar <meetgaurikanekar@gmail.com>; pgsql-performance Richard Huxton a écrit : > 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_count is the number of live tuples. tuple_len is the length (in bytes) for all live tuples. >> tuple_percent > > 3. Or what this "percent" refers to. > tuple_percent is % of live tuple from all tuples in a table. >> 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 > Actually, these columns refer to the pgstattuple contrib module. This contrib module must be installed on the server (how you install it depends on your distro). Then, you have to create the functions on you database : psql -f /path/to/pgstattuple.sql your_database Right after that, you can query these columns : test=> \x Expanded display is on. test=> SELECT * FROM pgstattuple('pg_catalog.pg_proc'); -[ RECORD 1 ]------+------- table_len | 458752 tuple_count | 1470 tuple_len | 438896 tuple_percent | 95.67 dead_tuple_count | 11 dead_tuple_len | 3157 dead_tuple_percent | 0.69 free_space | 8932 free_percent | 1.95 Example from README.pgstattuple. Regards. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://docs.postgresqlfr.org/ --> ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-01-17 06:37 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-01-16 13:48 Table Size Gauri Kanekar <meetgaurikanekar@gmail.com> 2007-01-16 19:24 ` Richard Huxton <dev@archonet.com> 2007-01-17 06:37 ` Guillaume Lelarge <guillaume@lelarge.info>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox