pgStatTuple

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux