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 00D369FA176 for ; Thu, 25 May 2006 03:34:04 -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 17876-07 for ; Thu, 25 May 2006 03:33:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.194]) by postgresql.org (Postfix) with ESMTP id F17B79F9F8F for ; Thu, 25 May 2006 03:33:57 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 18so1737910nzp for ; Wed, 24 May 2006 23:33:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=W3F7tY0a26rOwwfha26giIcub/MP7lihyfitBl9jFov5GT8Wb2rlu3m0PTYw8CdkigbxBZTC8HAmO3DGtw4WzMMYsn5IWA+dCNx4a2O4KUZZ7YRSeNb+gkUGdEG1wFSHSgimFqramGtXheAuKvL4ricGX1reePEelabtEsPhXpw= Received: by 10.64.152.19 with SMTP id z19mr3856666qbd; Wed, 24 May 2006 23:33:56 -0700 (PDT) Received: by 10.65.61.6 with HTTP; Wed, 24 May 2006 23:33:56 -0700 (PDT) Message-ID: <9e4684ce0605242333o6b4e4c9drd111594655c323d5@mail.gmail.com> Date: Thu, 25 May 2006 08:33:56 +0200 From: "hubert depesz lubaczewski" To: "Meyer Marco" Subject: Re: How to mesure transaction rate in Postgres Cc: pgsql-admin@postgresql.org In-Reply-To: <684146607711D947A4E4C905326C5E392BFE8E@inbmdmx01.intradoemea.local> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25718_19889347.1148538836428" References: <684146607711D947A4E4C905326C5E392BFE8E@inbmdmx01.intradoemea.local> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/347 X-Sequence-Number: 21879 ------=_Part_25718_19889347.1148538836428 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 anythi= ng > in the documentation. I have root access to the system. > this is definitelly not nice approach, but it works. connect to database, and issue this command: begin; create table not_previously_existsing(id int4); select xmin from pg_class where relname =3D 'not_previously_existsing'; rollback; returned value is id of the transaction that created the table. repeat this command every so often (mrtg does that every 5 minutes), and yo= u can see how it grows. depesz --=20 http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_25718_19889347.1148538836428 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 5/23/06, Meyer Marco <Marco.Meyer@intradoemea.com> wrote= :

I've been aske= d for the transaction rate we have on an installed Postgres server. Where a= nd how can I get this information. I could not find anything in the documen= tation. I have root access to the system.


this is definitelly no= t nice approach, but it works.
connect to database, and issue this comma= nd:
begin; create table not_previously_existsing(id int4); select xmin f= rom pg_class where relname =3D 'not_previously_existsing'; rollback;

returned value is id of the transaction that created the table.
= repeat this command every so often (mrtg does that every 5 minutes), and yo= u can see how it grows.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_25718_19889347.1148538836428--