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: | Raw Message | Whole Thread | 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 |