| From: | "Lane Van Ingen" <lvaningen(at)esncc(dot)com> | 
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> | 
| Subject: | pgStatTuple | 
| Date: | 2006-02-24 22:03:58 | 
| Message-ID: | EKEMKEFLOMKDDLIALABIIEFECIAA.lvaningen@esncc.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
Hi all, I am using v. 8.0.1, using a Windows 2003 server platform.
I want to use pgStatTuple to analyze performance problems when visiting user
sites; it is a good tool. I know how to set it up; but I couldn't find an
interpretation of what it generates as a result, so I can be sure of
interpreting its output correctly and fully. The output is:
 table_len(integer)         in what size unit? pages?
 tuple_count(integer)       how many t
 tuple_len(integer)         length of average tuple size?
 tuple_percent (float)      ??
 dead_tuple_count(integer)  tuples that contain dead rcds that could be
freed
 dead_tuple_len (integer)   how much space (in bytes?) is dead
 dead_tuple_percent (float) % of dead space vs entire space for object
 free_space (integer)       how much space (in bytes?) is already allocated
and free
 free_percent (integer)     % of free space vs entire space for object
Can anyone help? May also require definition of 'tuple' when used in a
PostgreSQL sense, also. Thanks for any help you can give.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-02-24 23:13:10 | Re: pgStatTuple | 
| Previous Message | sandhya | 2006-02-24 14:31:34 | Multiplequeries |