X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7550F9F9B01 for ; Thu, 25 May 2006 17:55:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 33092-03 for ; Thu, 25 May 2006 17:55:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id E89029F94EA for ; Thu, 25 May 2006 17:55:34 -0300 (ADT) Received: from [172.16.5.75] (64-132-13-2.static.twtelecom.net [64.132.13.2]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id DD04456408; Thu, 25 May 2006 15:55:32 -0500 (CDT) In-Reply-To: <9e4684ce0605242333o6b4e4c9drd111594655c323d5@mail.gmail.com> References: <684146607711D947A4E4C905326C5E392BFE8E@inbmdmx01.intradoemea.local> <9e4684ce0605242333o6b4e4c9drd111594655c323d5@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <70023FD5-F908-48E8-9EB9-037129FD1593@pervasive.com> Cc: "Meyer Marco" , pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: How to mesure transaction rate in Postgres Date: Thu, 25 May 2006 15:55:25 -0500 To: hubert depesz lubaczewski X-Mailer: Apple Mail (2.750) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/368 X-Sequence-Number: 21900 On May 25, 2006, at 1:33 AM, hubert depesz lubaczewski wrote: > On 5/23/06, Meyer Marco wrote: > I've been asked for the transaction rate we have on an installed > Postgres server. Where and how can I get this information. I could > not find anything in the documentation. I have root access to the > system. > > > this is definitelly not nice approach, but it works. Or just SELECT xact_commit + xact_rollback FROM pg_stat_database; -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461