X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EB8053A2193 for ; Tue, 4 Jan 2005 00:13:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01346-07 for ; Tue, 4 Jan 2005 00:13:44 +0000 (GMT) Received: from web53701.mail.yahoo.com (web53701.mail.yahoo.com [206.190.37.22]) by svr1.postgresql.org (Postfix) with SMTP id E70AF3A3C0E for ; Tue, 4 Jan 2005 00:13:46 +0000 (GMT) Received: (qmail 81977 invoked by uid 60001); 4 Jan 2005 00:13:45 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=0AtVkNuqD9o7/vG+4axbg5kknqeQnL9SZZ8y9tn/V12vbf5UBaH3xzqvhtyPEUWOCJEmZxzAtVPBiztephMOL3hH82KIThvciOJ/WtWyLUShvY73rTF7Jdkm222TUwjhgpOGdy2OicirVa17eGZibcz0lanbOjsgZqP3JpgXw3Q= ; Message-ID: <20050104001345.81975.qmail@web53701.mail.yahoo.com> Received: from [140.252.3.127] by web53701.mail.yahoo.com via HTTP; Mon, 03 Jan 2005 16:13:45 PST Date: Mon, 3 Jan 2005 16:13:45 -0800 (PST) From: Stan Y Subject: PostgreSQL's Statspack? To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.918 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200501/31 X-Sequence-Number: 9721 Besides the tables pg_stat_xxx, are there any stronger tools for PostgreSQL as the counterpart of Oracle's Statspack? Is it possible at all to trace and log the cpu and io cost for each committed transaction? Thanks a lot! -Stan __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com