From: | "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> |
---|---|
To: | "Meyer Marco" <Marco(dot)Meyer(at)intradoemea(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How to mesure transaction rate in Postgres |
Date: | 2006-05-25 06:33:56 |
Message-ID: | 9e4684ce0605242333o6b4e4c9drd111594655c323d5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 5/23/06, Meyer Marco <Marco(dot)Meyer(at)intradoemea(dot)com> 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.
connect to database, and issue this command:
begin; create table not_previously_existsing(id int4); select xmin from
pg_class where relname = '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 you
can see how it grows.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
From | Date | Subject | |
---|---|---|---|
Next Message | Sriram Dandapani | 2006-05-25 06:49:37 | determining which operation is blocking another query |
Previous Message | Richard Broersma Jr | 2006-05-25 03:19:28 | Re: Connection from As400 |