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 4268B3CCA2B for ; Fri, 17 Dec 2004 21:14:31 +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 68535-02 for ; Fri, 17 Dec 2004 21:14:23 +0000 (GMT) Received: from web53704.mail.yahoo.com (web53704.mail.yahoo.com [206.190.37.25]) by svr1.postgresql.org (Postfix) with SMTP id EF0D93CC9A0 for ; Fri, 17 Dec 2004 21:14:22 +0000 (GMT) Received: (qmail 47720 invoked by uid 60001); 17 Dec 2004 21:14:21 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=fwvFQYQfekUJuXYUKY1sbwC7C7IeujJ/J989yAETLf5/g7nCblNKMhxfVG+eqz6UyLGAlewGWS2jo6+dscXmTeMMDjXMYelFl5MzVbjRLDu8oElR+eL/WHWaPbAV5Q5FeEbyE8+HwHKY9dlOfGMixRf0HtEd2mL51Kd9GCG2ldw= ; Message-ID: <20041217211421.47718.qmail@web53704.mail.yahoo.com> Received: from [140.252.3.127] by web53704.mail.yahoo.com via HTTP; Fri, 17 Dec 2004 13:14:21 PST Date: Fri, 17 Dec 2004 13:14:21 -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.01 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: * X-Archive-Number: 200412/227 X-Sequence-Number: 9602 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!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250