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 B19D63CCA8A for ; Fri, 17 Dec 2004 21:10:56 +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 67180-02 for ; Fri, 17 Dec 2004 21:10:50 +0000 (GMT) Received: from web53709.mail.yahoo.com (web53709.mail.yahoo.com [206.190.37.30]) by svr1.postgresql.org (Postfix) with SMTP id 921EE3CC780 for ; Fri, 17 Dec 2004 21:10:47 +0000 (GMT) Received: (qmail 33462 invoked by uid 60001); 17 Dec 2004 21:10:46 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Ai7eBKvSVz+tfZ/3fgoyzw4J8RB2IWNQoIjVaKPaU1+ei9shEGt369wOMDteCpLqjF4kcqcEhsZV0A3qMZ4JUTjWtpkgIUJHejaAFz9XLepBSHV3KDg/fpNVqMfN8iRsdxyIR0qWkV2DEAgygd2Hmqrddgyz3szJgsJbuzV+wkk= ; Message-ID: <20041217211046.33460.qmail@web53709.mail.yahoo.com> Received: from [140.252.3.127] by web53709.mail.yahoo.com via HTTP; Fri, 17 Dec 2004 13:10:46 PST Date: Fri, 17 Dec 2004 13:10:46 -0800 (PST) From: Stan Y Subject: Monitor CPU time per transaction? 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=1.04 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: * X-Archive-Number: 200412/239 X-Sequence-Number: 9614 Hi All, I notice that most stat Postgres provides are per table or per process. Is it possible to monitor CPU time per transaction and IO per transaction? If can't, is there any commercial capacity planning tools available? Thanks! __________________________________ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com