From: Lane Van Ingen <lvaningen@esncc.com>
To: pgsql-admin@postgresql.org
Subject: pgStatTuple
Date: Fri, 24 Feb 2006 17:03:58 -0500
Message-ID: <EKEMKEFLOMKDDLIALABIIEFECIAA.lvaningen@esncc.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: lvaningen@esncc.com
Subject: Re: pgStatTuple
In-Reply-To: <EKEMKEFLOMKDDLIALABIIEFECIAA.lvaningen@esncc.com>
References: <EKEMKEFLOMKDDLIALABIIEFECIAA.lvaningen@esncc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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