X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 347E29DCA3D for ; Fri, 24 Feb 2006 18:00:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08345-02 for ; Fri, 24 Feb 2006 18:00:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from twmail.ESNCC.COM (static-66-173-159-28.t1.cavtel.net [66.173.159.28]) by postgresql.org (Postfix) with SMTP id 97AC39DCA35 for ; Fri, 24 Feb 2006 18:00:22 -0400 (AST) Received: from spawar2i8uvlb9 ([150.125.117.63]) by twmail.ESNCC.COM with Microsoft SMTPSVC(6.0.3790.1830); Fri, 24 Feb 2006 17:00:24 -0500 From: "Lane Van Ingen" To: Subject: pgStatTuple Date: Fri, 24 Feb 2006 17:03:58 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Importance: Normal X-OriginalArrivalTime: 24 Feb 2006 22:00:24.0511 (UTC) FILETIME=[B6B4C4F0:01C6398D] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.18 required=5 tests=[AWL=0.180] X-Spam-Score: 0.18 X-Spam-Level: X-Archive-Number: 200602/309 X-Sequence-Number: 20730 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.